Receipts Workbench Issue: Datafix: Wrong Account Is Being Used In The Debit Memo Reversal

(Doc ID 2044107.1)

Last updated on JANUARY 14, 2016

Applies to:

Oracle Receivables - Version 12 and later
Information in this document applies to any platform.


When reversing some automatic receipts using a debit memo reversal, the Rev account for
DM defaults from the confirmed process ( not remittance process as should be). This way the
journals are unbalanced.

Debit memo reversal for the receipt is having incorrect CCID.
It is not having CCID of the current_record_flag = 'Y' record.

The record with the current_record_flag = 'Y' is not having max(CRH_ID) in the
cash_receipt_history Table. As a result when Receipt has been REVERSED using Debit
memo reversal, the CCID of the REV record of DM is stamped with incorrect CCID.

Fix Approach
a. Undo accounting has to be done for the distributions .
b. CCID has to be corrected for the REV record.


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