MIGRATE_DIMENSION With Error ORA-06502 Running Migration Scripts to Upgrade OFSA 4.5.39 to OFSAA 6.0 (Doc ID 1556130.1)

Last updated on MAY 24, 2013

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.2.1 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) - Version 4.5.39
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.3
Migration Scripts

Symptoms

On Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) 7.3.2.1, while running upgrade script from OFSA 4.5.39 to OFSAA 6.0, the following error occurs:

ERROR
Table Name :- ''
Oracle Error Message :- ORA-06502: PL/SQL: numeric or value error
Suggested Solution (Please Contact OFFS Support):
=================================================
Please check the structure of the Table Name :- ''. A column in this table is having a size smaller than expected.

STEPS
The issue can be reproduced at will with the following steps:

1 .fsi_util.migrate_user_folder_tbls('ofsconfig','ofsa45'); -- success
2. fsi_util.migrate_dimension ('ofsa45'); -- failed

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