Data Load from STG_GL_DATA to FSI_D_MANAGEMENT_LEDGER Fails to Populate FSI_DATA_IDENTITY
Last updated on FEBRUARY 13, 2018
Applies to:
Oracle Financial Services Profitability Management - Version 8.0.0 to 8.0.4 [Release 8]Oracle Financial Services Asset Liability Management - Version 8.0.0 to 8.0.4 [Release 8]
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 to 8.0.4 [Release 8]
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 to 8.0.4 [Release 8]
Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.0 to 8.0.4 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Symptoms
For Oracle Financial Services Profitability Management (PFT) 8.0, when you use the Data Mapping T2T_MANAGEMENT_LEDGER to load data from STG_GL_DATA to FSI_D_MANAGEMENT_LEDGER, no row is inserted into FSI_DATA_IDENTITY for the load. (The LEDGER_STAT data loader does insert a row into FSI_DATA_IDENTITY.)
As a result of this design, when you use FN_MGMT_REP_MGMT_LEDGER to load data from FSI_D_MANAGEMENT_LEDGER to FCT_MGMT_REPORTING, no data is loaded because the program expects a row to exist in FSI_DATA_IDENTITY for the Management Ledger load.
The program mgmt_reporting_mgmt_ledger_trm contains SQL like the following:
V_SQL_BS := V_SQL_BS || ' WITH UNION_DATA AS ( select * from IOT_FCT_MGMT_REPORTING where IDENTITY_CODE in ( select identity_code from FSI_DATA_IDENTITY where source_type=0 )
Since T2T_MANAGEMENT_LEDGER does not populate FSI_DATA_IDENTITY, the subsequent load into FCT_MGMT_REPORTING fails.
Cause
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