Account Consolidation Error: ORA-00904: "FCA1"."Customer": Invalid Identifier
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.
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:
- Go to Profitability Manager
- Go to "Business Rule" → "Customer" → "Account Consolidation"
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:
- Go to Profitability Manager Administrator
- Go to "Administration" → "Column Population Template"
As a result of the error, no rows are moved from the account table to FEM_CUSTOMER_PROFIT.
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