My Oracle Support Banner

AR_S_00079 Datafix: Receipts With Clearing Date Earlier Than Remitted Date (Doc ID 2043778.1)

Last updated on SEPTEMBER 21, 2021

Applies to:

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

Symptoms

Issue:
======
On 12.1.3, there are receipts whose trx_date and the gl_date of the CLEARED record is prior to the trx_date and the gl_date of the REMITTED record in the AR_CASH_RECEIPT_HISTORY_ALL table.


Fix Approach
============
Case 1:  Receipt is not yet posted, or it is posted in an old GL period which can no longer be re-opened.

a) Correct the trx_date of the CLEARED record in the ar_cash_receipt_history Table.


Case 2:
Receipt is posted, and the GL period can be re-opened

a) Undo accounting has to be done for the receipts.            
b) Correct the trx_date and the gl_date of the CLEARED record in the ar_cash_receipt_history Table.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
 Still Have Questions?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.