My Oracle Support Banner

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

Last updated on FEBRUARY 19, 2019

Applies to:

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


On : 12.1.3 version, General Issues

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.

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

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.

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.




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.