Receipts Workbench: Upgraded Receipts from 11i to R12 Are Missing UNAPP Row in the RECEIVABLE_APPLICATIONS_ALL Causing Imbalanced Accounting for Closed Receipts
Last updated on AUGUST 24, 2016
Applies to:Oracle Receivables - Version 126.96.36.199 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.
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