My Oracle Support Banner

Transactions Workbench: Not Able To Create AR Transaction Error FRM-40735: ON-INSERT trigger raised unhandled exception ORA-00911 (Doc ID 1555750.1)

Last updated on JUNE 15, 2023

Applies to:

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


Not able to create an Invoice or Credit Memo using custom or standard responsibility (Receivables Manager), the following error occurs.

FRM-40735: ON INSERT trigger raised unhandled exception ORA-00911

Steps to Reproduce:
Responsibility:  Receivables
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.




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.