ORA-00904: "DIMENSION_NAME": Invalid Identifier on FEM_CHECK_BR_DIS_MBRS_PKG After Upgrade to R12
Last updated on JULY 20, 2015
Applies to:
Oracle Enterprise Performance Foundation - Version 12.0.0 to 12.1.1Information 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