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 MARCH 27, 2017

Applies to:

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

Symptoms

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.

ERROR
-----------------------
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.

Cause

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