Receipts Workbench Error: When Applying An On-Account Receipt to a Transaction Errors are Raised: ORA-01403 No Data Found FRM-40735 (Doc ID 1324551.1)

Last updated on MAY 20, 2024

Applies to:

Symptoms

When attempting to apply an on-account receipt to a transaction, the following errors are raised:

ORA-01403: no data found
FRM-40735: POST_QUERY trigger raised unhandled exception ORA-01403.

Steps to Reproduce:

1. Responsibility: Receivables Manager
   Navigation: Receipts > Batches
2. Create a batch with type = Manual Quick, containing one receipt with Application type = On Account
3. Save and run Post Quickcash to post the batch.
4. Navigation: Receipts > Receipts
5. Query the receipt created in step 2, notice that the Customer Number, which is a required field is blank.
6. Uncheck the Apply check box, then check it again
7. Save the Receipt
8. Requery the same receipt and Click on the Apply button, the errors listed above are raised.
9. Note, the same error can also happen for Receipts created manually via the Receipts form.

Or another symptom for this error is:
The On-account application exists in the back-end tables, but cannot be viewed in the Applications screen. This causes confusion to users as balance shows an On-Account Activity, but the details of the On-account applications are not displayed on the form.

Cause

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