My Oracle Support Banner

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:

Oracle Enterprise Performance Foundation - Version 12.0.0 to 12.1.1
Information in this document applies to any platform.

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

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
References


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