Account Consolidation Error: ORA-00904: "FCA1"."Customer": Invalid Identifier (Doc ID 377548.1)

Last updated on NOVEMBER 26, 2008

Applies to:

Oracle Profitability Manager - Version: 11.5.10
Oracle Enterprise Performance Foundation - Version: 11.5.10
This problem can occur on any platform.

Symptoms

In Profitability Manager, when running an Account Relationship Consolidation rule, the rule fails with the following error:

ORA-00904: "FCA1"."CUSTOMER": invalid identifier
Multi-Processing Framework Exception.

Navigation to rule:

You have already created a Column Population Template for use in the Account Consolidation Rule.  The source table is the account table being consolidated and the target table is FEM_CUSTOMER_PROFIT.

Navigation to Column Population Template:

As a result of the error, no rows are moved from the account table to FEM_CUSTOMER_PROFIT.

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