Error Inserting REV_APP_USER_PREFERENCES Executing Package FSI_UTIL.MIGRATE_USER_FOLDER_TBLS

(Doc ID 1448743.1)

Last updated on APRIL 11, 2012

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version: 7.2.8 and later   [Release: 7 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
OFSA 4.5 Migration

Symptoms

When attempting to run fsi_util.migrate_user_folder_tbls as part of data migration from OFSA 4.5 to OFSAA 5.2, the following error occurs.

Error
Error while Inserting into REV_APP_USER_PREFERENCES
Rollback Initiated ....................
ERROR While Executing Target Table Migration : Users And Folders -->

Procedure MIGRATE_USER_FOLDER_TBLS Executed with ERRORS
*** Errors Details ***
Table Name :- 'REV_APP_USER_PREFERENCES'
Oracle Error Message :- ORA-01438: value larger than specified precision allowed for this column

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