ORA-00904: "DIMENSION_NAME": Invalid Identifier on FEM_CHECK_BR_DIS_MBRS_PKG After Upgrade to R12 (Doc ID 1160463.1)

Last updated on MARCH 26, 2019

Applies to:

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

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