My Oracle Support Banner

How to Enable the EFPA MGMT_REPORTING_MGMT_LEDGER_TRM Function to Delete Only Rows Loaded from the Same Reporting Date (Doc ID 2298180.1)

Last updated on MARCH 25, 2019

Applies to:

Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.0 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


Currently, it appears that the function : MGMT_REPORTING_MGMT_LEDGER_TRM which is used to load the data from FSI_D_MANAGEMENT_LEDGER (Management Ledger)to FCT_MGMT_REPORTING table deletes all the data for the given reporting date execution.

FCT_MGMT_REPORTING table is a shared table among other solution teams and deleting all the data of other solutions for the same reporting date execution will be a major issue.

What parameters to give to have the function to delete only the management ledger data which was loaded earlier for the same reporting date keeping any other data intact in the table?


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.