Transactions Workbench: Creating a Credit Transaction Receives Error - FRM-40735: ON-COMMIT Trigger Error ORA-01403 (Doc ID 1494956.1)

Last updated on JULY 31, 2017

Applies to:

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

Symptoms

Attempting to create a Credit Transaction on an Invoice and going to the "credit lines" button, afterwards, when try to save the page the following error occurs:

FRM-40735: ON-COMMIT Trigger Error ORA-01403

Afterwards, when completing the transaction the document sequence number is not copied to the transaction number field.

When system option is set to "When Completed" all works fine.

But customer would like to make use of the "When saved" functionality.

When not saving the credit memo before you complete it, document number does not get copied.
When you incomplete and complete the transaction again, document number is copied.

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