Receipts Workbench: Upgraded Receipts from 11i to R12 Are Missing UNAPP Row in the RECEIVABLE_APPLICATIONS_ALL Causing Imbalanced Accounting for Closed Receipts (Doc ID 1618109.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Receivables - Version 11.5.10.2 to 12.2.3 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.

Symptoms

Receipts were created and posted to General Ledger (GL) in Release 11i and upgraded to R12.
However, the UNAPP row is not present in RECEIVABLE_APPLICATIONS_ALL for the Cash / UNID, although is marked posted to GL in Release 11i.

Due to this, the receipt is showing as fully applied, but the sum(amount_applied)<>0 for status=UNAPP for the receipt in RECEIVABLE_APPLICATIONS_ALL.

1)  Data was incorrectly created in Release 11i, and then upgraded to R12.   
2)  This issue is no longer reproducible in Release 12. So, a datafix is needed to create the missing UNAPP row in RECEIVABLE_APPLICATIONS_ALL and the corresponding distributions and marked them as posted as corresponding pairing CRH/UNID record which was already posted.

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