My Oracle Support Banner

FN_MGMT_REP_MGMT_LEDGER DT to Load FCT_MGMT_REPORTING From FSI_D_MGMT_LEDGER Does Not Load if Data is Not Last Day of the Month (Doc ID 2547004.1)

Last updated on SEPTEMBER 16, 2019

Applies to:

Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Business Intelligence Enterprise Edition (OBIEE)
Oracle Financial Services Enterprise Financial Performance Analytics (EFPA/PFTBI) previously known as Oracle Financial Services Profitability Analytics


On EFPA 8.0.5, it appears that the OOTB PFT/EFPA Data Transformation (DT) function/procedure called FN_MGMT_REP_MGMT_LEDGER (see profitability run chart for EFPA solution), is not loading data from the FSI_D_MANAGEMENT_LEDGER to FCT_MANAGEMENT_REPORTING if there is no monthly data present in the Management Ledger (ML) table with FIC_MIS_DATE as not EXACTLY the Last Day of the month.

Say for example: for the month of Mar-2019 -> Last Day of Month = 31-MAR-19, which falls on a Sunday per calendar and not a business day, whereas given FSI_D_MGMT_LEDGER table has data loaded for - "29-MAR-19", which is the last business day of the month in the Client's source data.

The function does not fail, but the intended functionality of loading the data to FCT_MGMT_REPORTING is getting lost for those months of data in the ML table where the FIC_MIS_DATE is not exactly the last calendar day of the month.
This is a valid scenario where the source systems can source data with as_of_date as on a Business Day only.

The issue can be reproduced at will with the following steps:


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

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