ORA-12899 Value too Large on Insert to FSI_IRC_RATE_TERMS_T.INTEREST_RATE_TERM_MULT (Doc ID 1062989.1)

Last updated on MAY 23, 2013

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.1 and later
Information in this document applies to any platform.
***Checked for Relevance on 23-May-2013***



Symptoms

When attempting to run migration of common tables, the following error occurs.

Error:

Procedure MIGRATE_COMMON_TBLS Executed with ERRORS
*** Errors Details *** 
Table Name : FSI_IRC_RATE_TERMS_T
 
Oracle Error Message : ORA-12899: value too large for column FSI_IRC_RATE_TERMS_T.INTEREST_RATE_TERM_MULT (actual: 3, maximum: 1)
 
Steps:
1. Completed all pre-requisites for migration.
2. Ran Migration of Common Tables.
SQL> SET SERVEROUTPUT ON
SQL> Exec FSI_UTIL.migrate_common_tbls (<g_dblink>)
3. Receive an error in Error.log when trying to migrate OFSA_IRC_RATE_TERMS table, specifically on INTEREST_RATE_TERM_MULT column.

Changes

Run migration from OFSA 4.5 to OFSAA 7.x

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