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
Oracle Enterprise Performance Foundation - Version 12.0.0 to 12.1.1 Information in this document applies to any platform.
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:
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!