'ORA-00904: "FINANCIAL_ELEM_ID": invalid identifier' Error Running FN_MGMT_REP_MGMT_LEDGER (Doc ID 2290118.1)

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)

Symptoms

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.

Cause

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