ORA-01400: Cannot Insert NULL into BALANCE_TYPE_CD Running Fsi_Util.Migrate_User_Acc_Tables (Doc ID 1457107.1)

Last updated on MAY 20, 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>');
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-01400: cannot insert NULL into ("<atomic>"."LEDGER_STAT"."BALANCE_TYPE_CD")
ORA-06512: at line 1

BALANCE_TYPE_CD does not exist on LEDGER_STAT in the source OFSA 4.5 environment.  According to the Migration User Guide, the migration process should populate this column with 500 on the target environment:

"BALANCE_TYPE_CD: LEDGER_STAT balance_type_cd will receive a default value of 500:"Legacy Migration"."

The migration process should not be trying to insert a null value into this 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