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:Oracle Financial Services Funds Transfer Pricing - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Enterprise Performance Management (EPM)
On FTP 18.104.22.168.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:
Source data in v6 and v8 are identical (allowing for the obvious differences between Ledger Stat and Management Ledger).
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