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!