My Oracle Support Banner

Customer Merge: Receipts Fail With FRM-40735 ORA-01403 After Customer Merge Has Been Run With Delete Option (Doc ID 1113803.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Receivables - Version 11.5.10.2 and later
Information in this document applies to any platform.
ARXRWMAI - Receipts
Customer Merge


Symptoms

Attempting to open a receipt after executing Customers Merge and receive the following error:

FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403

Responsibility:  Receivables Manager
Navigation:  Receipts > Receipts
Pick two customers: Cust A, Cust B
Create receipt for Cust A, put it on on-account for the same customer Cust A.

Navigation:  Customers > Merge
Merge Cust A into Cust B, with check box "Delete After Merge" checked.

Navigation:  Receipts > Receipts
Query Receipt placed on-account in step one
Receipt header has Cust B on it as expected however, ar_receivable_applications.on_acct_cust_id and site_use_id are pointing to source customer Cust A in the above case.

Cause

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

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