ORA-00904: "DATA_SOURCE": Invalid Identifier Running Fsi_util.migrate_user_acc_tables for OFSAA Migration (Doc ID 1572192.1)

Last updated on JULY 28, 2013

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Oracle Financial Data Manager - Version 4.5 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Applications (OFSA)

Symptoms

When migrating instrument table data from Oracle Financial Services Applications (OFSA) 4.5 to Oracle Financial Services Analytical Applications (OFSAA) 7.3, from a source table like CONSUMER_LOAN or COMMERCIAL_LOAN to a target table like FSI_D_LOAN_CONTRACTS, you get an error running fsi_util.migrate_user_acc_tables on the step "FSI_STAGING_TO_TARGET.migrate_user_Acc_tables".  The following ORA-00904 error is listed in the Status.txt file:

*** Errors Details ***
 
Table Name :- 'CONSUMER_LOAN'
 
Oracle Error Message :- ORA-00904: "DATA_SOURCE": invalid identifier
 
Suggested Solution (Please Contact OFFS Support):
=================================================
 
Please check the structure of the Table Name :- 'CONSUMER_LOAN'. A column (See Error Message) is missing.

You receive similar errors for BANK_CODE and BRANCH_CODE.

The error prevents the instrument table from being migrated from OFSA 4.5 into the OFSAA 7.3 database.

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