Bank Statements and Reconciliation Error: Creating a Miscellaneous Receipt Raises Error: MISC_RECEIPTS_EVENT.insert_row procedure raised unhandled exception

(Doc ID 1490479.1)

Last updated on SEPTEMBER 29, 2017

Applies to:

Oracle Receivables - Version 12.1.2 and later
Information in this document applies to any platform.


Attempting to create Miscellaneous Receipts with a different organization within an organization (form not closed) and receive the following error:

Error occurs:
MISC_RECEIPTS_EVENT.insert_row procedure raised unhandled exception

Click Details:
FRM-40735: ON-INSERT trigger raised unhandled exception ORA-28115

Responsibility: Cash Management
Navigation:  Bank Statement > Bank Statements and Reconciliation
Select Bank account number
Review > Lines
Select line > Create Miscellaneous
Enter Activity > Create

Issue happens randomly.

NOTE:  Bank Statement with statement number lower than 30 digits (<Note 1089493.1>)


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms