My Oracle Support Banner

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

Last updated on JULY 16, 2020

Applies to:

Oracle Credit Management - Version 12.1.3 and later
Information in this document applies to any platform.

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

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.