Last updated on JULY 31, 2017
Applies to:Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.0 and later
Oracle Financial Services Profitability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Enterprise Financial Performance Analytics (EFPA) 8.0.2, when you run FN_MGMT_REP_MGMT_LEDGER to move data from FSI_D_MANAGEMENT_LEDGER to FCT_MGMT_REPORTING, the batch fails with the following ORA-00904 and ORA-00942 errors in FSI_MESSAGE_LOG:
Starting FCT_MGMT_REPORTING load
Fatal error occured :ORA-00904: "FINANCIAL_ELEM_ID": invalid identifier
Dropping Temporary table
"ORA-00942: table or view does not existORA-00904: "FINANCIAL_ELEM_ID": invalid identifier"
You do not understand why this error occurs for the dimension column.
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