My Oracle Support Banner

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

Last updated on MARCH 14, 2019

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)


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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.