Last updated on JULY 28, 2017
Applies to:Oracle Financial Services Enterprise Financial Performance Analytics - Version 6.1.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Financial Performance Analytics (EFPA/PFTBI) previously known as Oracle Financial Services Profitability Analytics
On PFTBI / EFPA 6.1.1, after running the fn_mgmt_reporting_trm to populate the FCT_MGMT_REPORTING table, some records where the GL Accounts (Operating Expenses) that have a Credit balance. i.e. have set a GL Account (800001 - Allocations Out) that holds the credit entries from a Profitability Allocation run for Operating Expenses are missing. Whereas all GL Accounts with a Debit balance from the allocation effect appear normally in the FCT_MGMT_REPORTING table, these rows are not populated at all (in other words we only see the 'one side entries' of the Profitability allocations). This GL Account exists in the DIM_GL_ACCOUNT table. This GL Account is related to FE 457. All other positive balance GL Accounts related to this FE 457 (Non Interest Expenses) are populating FCT_MGMT_REPORTING table correctly.
FCT_MGMT_REPORTING table is not being populated with the Credit / Negative Balances.
Expect all LEDGER_STAT income statement balances to transfer to the FCT_MGMT_REPORTING table regardless if the are greater than 0.
The issue can be reproduced at will with the following steps:
1. Run the fn_mgmt_reporting_trm function to populate the FCT_MGMT_REPORTING table
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms