Monday, 19 June 2017

FRM-40735 POST-QUERY Trigger raised unhandled exception ORA-06502

http://receivablesar.blogspot.com/2017/06/frm-40735-post-query-trigger-raised.html

When you try to query that bank account, nothing is returned.
This happens after adding a new bank to your Receipt Method
The error message is :

FRM-40735 POST-QUERY Trigger raised unhandled exception ORA-06502

To reproduce this issue,
Using your Receivables responsibility
Navigate to Setup / Receipts / Receipt Classes
Query your receipt class and receipt method.
Click on Bank Accounts button.

If there is more than one bank account, you may see one bank account, but
cannot see the newly added bank account.

-------------------------------------------------------------------------------

Issue is happening because the size of the BANK_BRANCH_NAME field is larger
than supported. The Bank Branch Name can only be 60 characters long.
In this case, the customers bank branch was in Arabic language and was taking more
than the supported number of bytes.

To resolve this issue, change the bank branch name to a new value that is equal to
or less than 60 characters

----------------------------------------------------------------------------

In my case Account Name Length was 71. So I minimized and the Issue got Resoved

No comments:

Post a Comment