Transactions Workbench Issue: Datafix: Initial UNAPP Row Missing In The Receivable Applications Table After Upgrade (Doc ID 2083400.1)

Last updated on DECEMBER 06, 2015

Applies to:

Oracle Receivables - Version 12 and later
Information in this document applies to any platform.

Symptoms

Issue:
======
Unable to close the period.
Unposted item report showing the receipts.
Upgrade is not completed due to missing initial UNAPP for the record.
.
Analysis:
=======
There are 2 cases identified.
Case 1 :  
========

Upgrade is not completed due to missing initial unapp for the record.

The receipt is created in 11i.
Then the application is done which is posted and the details of the application are captured in the XLA Tables.
and then Upgraded.
This receipt create event is marked as unposted.

Case 2 :
========
Receipt is reversed  in R12 and posted to SLA, and having the same pattern of case 1.

For both the cases, the initial UNAPP record details are missing in the ar_receivable_applications Table and the ar_distributions table.

.
Fix Approach:
============
Case 1 :  
========
Create Unapp row and corresponding ARD for UNAPP/CRH, and then run the standalone upgrade script for these receipts.

Case 2 :
========
Create Unapp row and corresponding ARD for UNAPP/CRH, and then run the standalone upgrade script for these receipts.
Undo account reverse event, and repost the data.

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