Transactions Workbench: Partial Adjustments - AR Summary Table Is Not In Sync With AR Transaction Summary Tables (Doc ID 1494295.1)

Last updated on AUGUST 01, 2016

Applies to:

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

Symptoms

Partial Adjustment on a delinquent invoice not updating the PAST_DUE_INV_VALUE column in AR_TRX_BAL_SUMMARY table. 

Adjustments not updating AR_TRX_BAL_SIMMARY.PAST_DUE_INV_VALUE column

AR_TRX_BAL_SUMMARY table is used by Advanced Collections and Credit Management program. This table maintains various balances for each customer/site. This table is populated initially by Refresh Summary Program and the the profile option "AR: Allow Refresh Summary Tables" is set to Yes at Receivable applications level. After that point, this table is updated using Workflow Business events during the following  activities:

- Transactions
- Receipts
- Adjustments

This issue is primarily related to the following table and column:  AR_TRX_BAL_SIMMARY.PAST_DUE_INV_VALUE

There are two columns in this table OP_INVOICES_VALUE and PAST_DUE_INV_VALUE. Both these columns should be updated when entering the above activities. But PAST_DUE_INV_VALUE is not being updated for Adjustments alone.

No issues with OP_INVOICES_VALUES.PAST_DUE_INV amount is not affected/changed in the AR.AR_TRX_BAL_SUMMARY after applying the adjustment for an over due invoice. Only OP_INVOICES_VALUE is changed in the AR_TRX_BAL_SUMMARY table. Both receipts and adjustments should effect past due invoices.

Again the issue is only when creating adjustments, the amount in AR_TRX_BAL_SIMMARY.PAST_DUE_INV_VALUE column is not being updated. This will effect customer business as IEX (Advanced Collections) and  OCM (Credit Management) would be showing wrong past due amounts. 

Cause

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