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 SEPTEMBER 13, 2017

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
Reporting

Goal

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?

Solution

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