Datafix - MISSING GL_SL_LINK _ID IN THE XLA_AE_LINES ,GL_JE_LINES TABLES prior to R12 upgrade (Doc ID 1565264.1)

Last updated on OCTOBER 13, 2017

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Cost Maintenance

There are two issues:
1. The cost Management data is not upgraded to SLA which includes Purchasing and Inventory data. Ran "Upgrade Historical Subledger Transaction Accounting " process which upgraded most of the data to SLA.
2. The WIP and MTL records do not have GL_SL_LINK_ID populated. 

Need to have the GL drilldown working on R12 upgrade subledger transactions with GL_SL_LINK_ID properly populated.

The issue can be reproduced at will with the following steps:
1. Run "Upgrade Historical Subledger Transaction Accounting " process.



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