My Oracle Support Banner

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

Last updated on DECEMBER 03, 2019

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.