Value For UNRESOLVED_CASH_VALUE Is Not Calculated Correctly When Applying Invoices To Receipts. (Doc ID 2017441.1)

Last updated on JULY 31, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, General Issues

ACTUAL BEHAVIOR
---------------
Value for UNRESOLVED_CASH_VALUE is not calculated correctly when applying invoices to receipts. As per the code the value in this column is sum of unapplied cash and credits.

When cash is applied, the business events add the amount to UNRESOLVED_CASH_VALUE instead of subtract.


EXPECTED BEHAVIOR
-----------------------
Value in this column UNRESOLVED_CASH_VALUE should be reduced when you apply invoices to a cash receipt.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Find a customer for whom you have open/unapplied receipt balance available. Verify the amount in column UNRESOLVED_CASH_VALUE in table AR_TRX_BAL_SUMMARY table. The value is going to be equal to unapplied cash and credits. Lets say the amount is 1150.

2. Now go ahead and create a new receipt for 1000 and do not apply it to and invoices. The value for UNRESOLVED_CASH_VALUE will go up to 2150. THIS IS CORRECT.

3. Now apply the receipt to an invoice for 1000. The value for UNRESOLVED_CASH_VALUE will go up to 3150, when in fact it should go back to 1150.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Customer want to use the balance in UNRESOLVED_CASH_VALUE to display available cash balance for customer. Must run Refresh AR Transactions Summary Tables to ensure an accurate balance, not real time, for this column.

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