FTP Ledger Migration Missing Unpriced Accounts After Upgrade from 6.1.x to 8.1.x (Doc ID 2809430.1)

Last updated on SEPTEMBER 29, 2021

Applies to:

Symptoms

On FTP 8.1.0.1.0, there appears to be an issue with the management ledger unpriced account FTP methodology which does not appear to be working like it does in version 6.1.x.

Based on debugging internally, the issue appears to be due to the following:

1. ZML_UNPRICED table is populated from Ledger data where there is match on Ledger product_id to the SOURCE_PROD_CD that is in FSI_M_TP_UNPRICED_ACCT_DTL. This means that the GL_ACCOUNT_ID field in ZML_UNPRICED is based on the records where product_id matches SOURCE_PROD_CD.

2. Data is inserted to Ledger based on a match of the product_id in ZML_UNPRICED and Ledger data (PRODUCT_ID value goes back to the FSI_M_TP_UNPRICED_ACCT_DTL) and the GL_ACCOUNT_ID in Ledger and ZML_Unpriced. However, the GL_ACCOUNT_ID that is in ZML_UNPRICED is based on the gl_account_id value in Ledger where product_id is the SOURCE_PROD_CD.

3. In scenarios where data exists in Ledger for all the SOURCE_PROD_CD and corresponding PRODUCT_IDs AND when all those products have a matching GL_ACCOUNT_ID, data is being inserted because a match is found. For scenarios in which the record with the match PRODUCT_ID does not have the same GL_ACCOUNT_ID as those records where product_id=SOURCE_PROD_CD no matches are found and therefore no data is inserted to Ledger.

Correct dimensions are selected in the FTP Process for Migration:

GL_ACCOUNT_ID
PRODUCT_ID
ORG_UNIT_ID

Source data in v6 and v8 are identical (allowing for the obvious differences between Ledger Stat and Management Ledger).

Changes

Cause

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