R12: Business Events: OP_CREDIT_MEMOS_VALUE Column In AR_TRX_BAL_SUMMARY Table Is Added For Payments Against Credit Memos (Doc ID 1533128.1)

Last updated on AUGUST 24, 2016

Applies to:

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

Symptoms

OP_CREDIT_MEMOS_VALUE column in AR_TRX_BAL_SUMMARY is populated wrong through business event if a credit memo is paid

For example:
Credit Memo open amount -125 in OP_CREDIT_MEMOS_VALUE
After receipt application the amount is -250 instead of 0.00.

If the credit memo is applied to an invoice the column has the correct value.

The issue does not exist if you run AR: Refresh Summary Table. After this OP_CREDIT_MEMOS_VALUE column in AR_TRX_BAL_SUMMARY is populated correct.

 

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