Data Load from STG_GL_DATA to FSI_D_MANAGEMENT_LEDGER Fails to Populate FSI_DATA_IDENTITY

(Doc ID 2359347.1)

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