My Oracle Support Banner

Transactions Workbench Issue: Datafix: Upgraded PSA Transactions Are Not Having Complete MFAR Distributions In SLA (Doc ID 2021814.1)

Last updated on OCTOBER 29, 2018

Applies to:

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

Symptoms

Issue:
=====
Datafix:Upgraded PSA Transactions Are Not Having Complete MFAR Distributions In SLA.

MFAR upgraded transactions are not properly upgraded .
For the transaction, the Distributions are balanced in RA_CUST_TRX_LINE_GL_DIST_ALL Table.
Where as the the data in SLA for upgraded PSA transaction, there are no records created for description -> 'MFAR UPGRADE CREATE MFAR RECEIVABLES' in xla_ae_lines.

i..e, No records are created for description -> 'MFAR UPGRADE CREATE MFAR RECEIVABLES' in xla_ae_lines for upgraded MFAR transactions.

Fix Approach:
============
Distributions have to be deleted and recreated for the MFAR records in xla_Ae_lines and xla_distribution_links.

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!


In this Document
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 5. Identify Possible Data Corruption
 Still Have Questions?
References

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