My Oracle Support Banner

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 MARCH 09, 2019

Applies to:

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


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.


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

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