My Oracle Support Banner

Credit Management Issue: AR_TRX_BAL_SUMMARY Is Not Correct After Updating Customer On A Receipt (Doc ID 1529368.1)

Last updated on JULY 13, 2020

Applies to:

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


When changing the customer on a receipt the data in AR_TRX_BAL_SUMMARY is incorrect for the original customer

Steps to Reproduce:
1. Create a receipt on customer A.
2. This will show the receipt in table AR_TRX_BAL_SUMMARY for following fields : LAST_PAYMENT_AMOUNT LAST_PAYMENT_DATE LAST_PAYMENT_NUMBER
3. Change the customer to B for the receipt.
4. The details in AR_TRX_BAL_SUMMARY will show the receipt on both customer A and B.




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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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