OFSA 4.5 to OFSAA 6.0 MIGRATE_RESULT_TBLS Migration Fails With ORA-00904 'FSI_O_RESULT_MASTER'. A column (See Error Message) is missing Errors (Doc ID 1570820.1)

Last updated on JANUARY 23, 2015

Applies to:

Oracle Financial Services Asset Liability Management - Version 6.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Applications (OFSA) - Version 4.5
Migration Scripts

Symptoms

On running the OFSA 4.5 to OFSAA 6.0 migration scripts for the ALM output tables, the 'fsi_util.migrate_result_tbls' is failing with the following errors:

ERROR
Migrating FSI_O_RESULT_MASTER data from staging to final home
DEBUG: The SQL is : insert into FSI_O_RESULT_MASTER( RESULT_SYS_ID, ORG_UNIT_ID,GL_ACCOUNT_ID,COMMON_COA_ID,TRANSACTION_ID ,PRODUCT_ID ,CONVEXITY,CUR_DEFER_BAL_C,CUR_INTR_REC_ACCR,CUR_NET_PAR_BAL,CUR_NET_RATE_W,CUR_PAR_BAL,CUR_TRANSFER_RATE,CUR_WARM,DURATION,FINANCIAL_ROLLUP,ISO_CURRENCY_CD, MARKET_VALUE,NEW_GROSS_BALANCE,NEW_NET_BALANCE,RESULT_TYPE_CD,SCENARIO_NUM,START_DATE_INDEX,YTM,AVERAGE_LIFE ,MODIFIED_DURATION , LEG_TYPE ) select RESULT_SYS_ID,ORG_UNIT_ID,GL_ACCOUNT_ID,COMMON_COA_ID,TRANSACTION_ID,PRODUCT_ID,CONVEXITY,CUR_DEFER_BAL_C,CUR_INTR_REC_ACCR,CUR_NET_PAR_BAL,CUR_NET_RATE_W,CUR_PAR_BAL,CUR_TRANSFER_RATE,CUR_WARM,DURATION,FINANCIAL_ROLLUP,ISO_CURRENCY_CD,MARKET_VALUE,NEW_GROSS_BALANCE , NEW_NET_BALANCE,RESULT_TYPE_CD,SCENARIO_NUM,START_DATE_INDEX,NULL,NULL,NULL ,0 FROM OFSA_RESULT_MASTER@ofsa45
Error while Inserting in Table: FSI_O_RESULT_MASTER
The Procedure FSI_STAGING_TO_TARGET.migrate_result_tables has failed in the checkpoint Block :6
Please check the code below checkpoint: 6 for error

Last Procedure Executed :- MIGRATE_RESULT_TBLS

Time of Procedure Execution : 11-JUL-2013 01:07:00

Procedure MIGRATE_RESULT_TBLS Executed with ERRORS

*** Errors Details ***

Table Name :- 'FSI_O_RESULT_MASTER'

Oracle Error Message :- ORA-00904: "TRANSACTION_ID": invalid identifier

Suggested Solution (Please Contact OFFS Support):
=================================================

Please check the structure of the Table Name :- 'FSI_O_RESULT_MASTER'. A column (See Error Message) is missing.


The issue can be reproduced at will with the following steps:
1. Run the fsi_util.migrate_result_tbls migration script

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