My Oracle Support Banner

When removing a Customer from a Receipt various AR_TRX_BAL_SUMMARY Table Columns are Updated Incorrectly. (Doc ID 2723562.1)

Last updated on OCTOBER 27, 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 or is reversed.   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.  If you reverse the receipt, the original row created when the receipt was originally created will remain in the table causing a balance issue when the balance is used in either Advanced Collections or Credit Management.

Additionally, all these updates to the Receipt are causing an incorrect value to be added to the UNRESOLVED_CASH_VALUE and negative values in the PAST_DUE_INV_VALUE And PAST_DUE_INV_INST_COUNT columns

 

STEPS TO REPRODUCE
==================
Check the balance for a customer in AR_TRX_BAL_SUMMARY -
     The easiest way to see this is to create a Receipt in a different currency, so you can see the other row in the summary table.

-Create a Receipt in EUR (or any other currency that is not the functional)
-Run Refresh AR Transaction Summary Tables, or confirm a business event was fired when the receipt was created.

Check the AR_TRX_BAL_SUMMARY table and you will now see 2 rows on the table for this same cust_account_id. One for each currency.

Now remove the Customer name from the Receipt
Post to GL
Run the Refresh AR Transaction Summary Tables

Check the AR_TRX_BAL_SUMMARY table and you will see that 2 rows still exist for this cust_account_id.

On the same receipt, assign to another customer and save
Post to GL
Run the Refresh AR Transaction Summary Tables

Check the AR_TRX_BAL_SUMMARY table and you will see 2 rows on the table for this same cust_account_id.
The EUR row should have been removed since the Receipt is no longer assigned to this cust_account_id.

The same happens if you reverse the receipt instead of just changing the owner.

 

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.