After Removing Customer from Receipt AR_TRX_BAL_SUMMARY Not Updated Properly (Doc ID 2691551.1)

Last updated on JULY 16, 2020

Applies to:

Symptoms

The AR_TRX_BAL_SUMMARY table is not updated properly when a receipt changes owners.  The unresolved_cash for the original receipt owner doubles instead of zeroing out.

If you remove the Customer from a Receipt, the row for the cust_account_id that was originally created remains on the AR_TRX_BAL_SUMMARY table and causes an incorrect balance for the customer.
Even after you assign a new Customer on the Receipt, the cust_account_id is still from the original customer.

Cause

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