ORA-00904: "DIMENSION_NAME": Invalid Identifier on FEM_CHECK_BR_DIS_MBRS_PKG After Upgrade to R12

(Doc ID 1160463.1)

Last updated on JULY 20, 2015

Applies to:

Oracle Enterprise Performance Foundation - Version 12.0.0 to 12.1.1
Information in this document applies to any platform.
Checked for relevance on 20-Jul-2015.

Symptoms

After upgrading the Oracle E-Business Suite from 11i to R12, the Enterprise Performance Foundation (FEM) package FEM_CHECK_BR_DIS_MBRS_PKG is invalid.  The following error occurs when you try to recompile the package:

SQL> alter package FEM_CHECK_BR_DIS_MBRS_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY FEM_CHECK_BR_DIS_MBRS_PKG:

LINE/COL ERROR
-------- -------------------------------------------------------
2386/5 PL/SQL: SQL Statement ignored
2409/25 PL/SQL: ORA-00904: "DIMENSION_NAME": invalid identifier

The FEM_CHECK_BR_DIS_MBRS_PKG package is used by the Disabled Members report available in the "Enterprise Performance Foundation Administrator" responsibility.  Users will not be able to use this report until the package is valid.

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