My Oracle Support Banner

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

Last updated on MAY 31, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.