ORA-12899: Value Too Large for Column "REV_TAB_COLUMNS"."IS_INHERITED" Error on Model Upload (Doc ID 2017966.1)

Last updated on DECEMBER 15, 2015

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.5 to 7.3.5.1.0 [Release 7.0 to 7]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) Infrastructure 7.3.5 or 7.3.5.1, when running a data model upload, you get the following error in the model upload log from /<ftpshare>/<infodom>/logs:

----------------------------------------------
OBJECT REGISTRATION STARTED AS PART OF MODEL UPLOAD AT Tue May 26 18:32:53 CEST 2015
----------------------------------------------
Error while executing the query Failed Executing Batch: error occurred during batching: ORA-12899: value too large for column "<atomic>"."REV_TAB_COLUMNS"."IS_INHERITED" (actual: 4, maximum: 1)

Object Registration Failed.
Object Registration Failed.
java.lang.Exception: Error while Executing queries for Object Registration----------------------------------------------
OBJECT REGISTRATION COMPLETED AT Tue May 26 18:33:52 CEST 2015
----------------------------------------------

As a result of the error, the table updates and changes are not registered in the OFSAA metadata tables.

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