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

Last updated on JUNE 21, 2023

Applies to:

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

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