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

Last updated on JANUARY 14, 2016

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 table.

ANALYSIS
=========
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 table.

Fix Approach
============
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.

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