'ORA-00904: "SET_OF_BOOKS_CD": Invalid Identifier' Running Fsi_Util.Migrate_User_Acc_Tables (Doc ID 1457109.1)

Last updated on MAY 16, 2012

Applies to:

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

Symptoms

For the Oracle Financial Services Applications (OFSA) 4.5 to Oracle Financial Services Analytical Applications (OFSAA) 5.2.2 migration, you get the following error in the Unix console when running fsi_util.migrate_user_acc_tables for LEDGER_STAT:

SQL> exec fsi_util.migrate_user_acc_tables('LEDGER_STAT', 'LEDGER_STAT' , '<dblink>');
Table Migration : Account Table --> LEDGER_STAT Started

*******************************************

Error while Inserting into LEDGER_STAT


Rollback Initiated ....................
ERROR While Executing Table Migration : Account Table -->
BEGIN fsi_util.migrate_user_acc_tables('LEDGER_STAT', 'LEDGER_STAT' , '<dblink>' ); END;

*
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "<atomic>.FSI_UTIL", line 681
ORA-06512: at "<atomic>.FSI_UTIL", line 314
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "<atomic>.FSI_STAGGING_TO_TARGET", line 1846
ORA-00904: "SET_OF_BOOKS_CD": invalid identifier
ORA-06512: at line 1

You expect migrate_user_acc_tables to handle the SET_OF_BOOKS_CD column without error.  SET_OF_BOOKS_CD is a standard column on the LEDGER_STAT table in OFSA 4.5.39.  The SET_OF_BOOKS_CD column is removed from LEDGER_STAT in OFSAA 5.2.  The procedure migrate_user_acc_tables should account for this change in the LEDGER_STAT table. It should not expect SET_OF_BOOKS_CD to exist on the OFSAA LEDGER_STAT table.

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