'Error:ORA-00904: "CONSOLIDATION_CODE": invalid identifier' Running Migration Import (Doc ID 2258484.1)

Last updated on MAY 01, 2017

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When running the 6.1 to 8.0 Oracle Financial Services Profitability Management (PFT) migration script import_into_target.sh, the following ORA-00904 error is output to the import_into_target.log:

[2017.03.27 - 10:13:28 AM EDT] Executing file:/app/ofsaaiofs/PFT_Migration/21223631/scripts/extract/atomic/fsi_m_allocation_rule.sql

MERGE INTO FSI_M_ALLOCATION_RULE TAB
 USING (
 SELECT NULL VARIABLE_RULE
,235966 ALLOCATION_SYS_ID
,200 ALLOCATION_TYPE_CD
,235938 SOURCE_SYS_ID
, 'C' FACTOR_OPERATOR_TYPE
, NULL FACTOR_OPERATOR_ACCR_BASIS
, '*' FACTOR_OPERATOR_CONSTANT
,1 FACTOR_CONSTANT
, NULL FACTOR_ACCRUAL_BASIS_CD
, NULL ALLOCATION_OPERATOR
, NULL DRIVER_SYS_ID
,235939 ASSIGNMENT_SYS_ID
, 'C' NO_OFFSET_FLAG
,235960 OFFSET_SYS_ID
, NULL CONSOLIDATION_CODE
, 'R' OUTPUT_OPTION_CD FROM DUAL ) PROXY
 ON (TAB.ALLOCATION_SYS_ID = PROXY.ALLOCATION_SYS_ID)
 WHEN MATCHED THEN UPDATE SET TAB.VARIABLE_RULE = PROXY.VARIABLE_RULE
 , TAB.ALLOCATION_TYPE_CD = PROXY.ALLOCATION_TYPE_CD
 , TAB.SOURCE_SYS_ID = PROXY.SOURCE_SYS_ID
 , TAB.FACTOR_OPERATOR_TYPE = PROXY.FACTOR_OPERATOR_TYPE
 , TAB.FACTOR_OPERATOR_ACCR_BASIS = PROXY.FACTOR_OPERATOR_ACCR_BASIS
 , TAB.FACTOR_OPERATOR_CONSTANT = PROXY.FACTOR_OPERATOR_CONSTANT
 , TAB.FACTOR_CONSTANT = PROXY.FACTOR_CONSTANT
 , TAB.FACTOR_ACCRUAL_BASIS_CD = PROXY.FACTOR_ACCRUAL_BASIS_CD
 , TAB.ALLOCATION_OPERATOR = PROXY.ALLOCATION_OPERATOR
 , TAB.DRIVER_SYS_ID = PROXY.DRIVER_SYS_ID
 , TAB.ASSIGNMENT_SYS_ID = PROXY.ASSIGNMENT_SYS_ID
 , TAB.NO_OFFSET_FLAG = PROXY.NO_OFFSET_FLAG
 , TAB.OFFSET_SYS_ID = PROXY.OFFSET_SYS_ID
 , TAB.CONSOLIDATION_CODE = PROXY.CONSOLIDATION_CODE
 , TAB.OUTPUT_OPTION_CD = PROXY.OUTPUT_OPTION_CD
 WHEN NOT MATCHED THEN INSERT (VARIABLE_RULE
 , ALLOCATION_SYS_ID
 , ALLOCATION_TYPE_CD
 , SOURCE_SYS_ID
 , FACTOR_OPERATOR_TYPE
 , FACTOR_OPERATOR_ACCR_BASIS
 , FACTOR_OPERATOR_CONSTANT
 , FACTOR_CONSTANT
 , FACTOR_ACCRUAL_BASIS_CD
 , ALLOCATION_OPERATOR
 , DRIVER_SYS_ID
 , ASSIGNMENT_SYS_ID
 , NO_OFFSET_FLAG
 , OFFSET_SYS_ID
 , CONSOLIDATION_CODE
 , OUTPUT_OPTION_CD) VALUES (PROXY.VARIABLE_RULE
 , PROXY.ALLOCATION_SYS_ID
 , PROXY.ALLOCATION_TYPE_CD
 , PROXY.SOURCE_SYS_ID
 , PROXY.FACTOR_OPERATOR_TYPE
 , PROXY.FACTOR_OPERATOR_ACCR_BASIS
 , PROXY.FACTOR_OPERATOR_CONSTANT
 , PROXY.FACTOR_CONSTANT
 , PROXY.FACTOR_ACCRUAL_BASIS_CD
 , PROXY.ALLOCATION_OPERATOR
 , PROXY.DRIVER_SYS_ID
 , PROXY.ASSIGNMENT_SYS_ID
 , PROXY.NO_OFFSET_FLAG
 , PROXY.OFFSET_SYS_ID
 , PROXY.CONSOLIDATION_CODE
 , PROXY.OUTPUT_OPTION_CD)'
Error:ORA-00904: "CONSOLIDATION_CODE": invalid identifier


CONSOLIDATION_CODE does not exist on FSI_M_ALLOCATION_RULE in either 6.1 or 8.0.  The code should not be referencing the column.

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