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

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

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