Credit Management Issue: AR_TRX_BAL_SUMMARY Is Not Correct After Updating Customer On A Receipt

(Doc ID 1529368.1)

Last updated on MARCH 02, 2018

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.


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