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 JULY 24, 2017

Applies to:

Oracle Receivables - Version 12.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Form:ARXRWMAI.FMB - Receipts


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

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