Entering Receipts For Different Operating Units Error - ORA-01403 (Doc ID 1994699.1)

Last updated on AUGUST 25, 2017

Applies to:

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

Symptoms

After entering cash application on a receipt for one operating unit, try to enter a new receipt from a different operating unit
and the system is choosing the application of the previous receipt and the following error occurs.

Errors:
ORA-01403: no data found
FRM-40735: PRE-RECORD trigger raised unhandled exception ORA-01403


Steps to Reproduce

Responsibility:  Receivables
Navigation:    Receipts > Receipts
Open receipts form and enter cash application on a receipt for one operating unit and save
Next click new record from the menu and enter a new receipt from a different operating unit and click Apply

Due to this issue, users cannot enter receipt as required.
To overcome they have to go back to the main menu after each receipt and this is time consuming.

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