My Oracle Support Banner

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 JUNE 21, 2023

Applies to:

Oracle Receivables - Version 12.2.5 and later
Information in this document applies to any platform.
Form:ARXRWMAI.FMB - Receipts


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



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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?

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