Transactions Workbench: Not Able To Create AR Transaction Error FRM-40735: ON INSERT trigger raised unhandled exception ORA-00911
Last updated on MARCH 27, 2017
Applies to:Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Transactions Related
Not able to create an Invoice or Credit Memo in using custom or standard responsibility (Receivables Manager), the following error occurs.
FRM-40735: ON INSERT trigger raised unhandled exception ORA-00911
Steps to Reproduce:
Navigation: Transactions > Transactions
Create a Transaction
Click Line Items
Button is greyed out > Error occurs
The Transaction Type List of Values (LOV) shows the same Transaction Type multiple times (two times or more).
Issue is happening for all Operating Units.
The database is showing that the Transaction is getting saved, but do not appear when queried from the form.
Find that the CUST_TRX_TYPE_ID stamped in table RA_CUSTOMER_TRX_ALL is wrong.
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