My Oracle Support Banner

ORA-12899: Value Too Large for Column "CONFIG"."ETLLOADHISTORY"."V_BATCH_ID" (Doc ID 2450606.1)

Last updated on SEPTEMBER 26, 2018

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.6 to 8.0.6 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Table to Table (T2T)
Data Mapping

Symptoms

On OFSAA 8.0.6, Batch created successfully in batch maintenance screens, however, no error is thrown when batch name exceeds allowable length.  

Later results in error writing to ETLLOADHISTORY because of exceeded length. See error below. 

ERROR

[SEVERE][BACKEND][OFSAA][LIBICC] 
LIBDB: Error Msg :-> ORA-12899: value too large for column 
"CONFIG"."ETLLOADHISTORY"."V_BATCH_ID" (actual: 64, maximum: 55) 

[SEVERE][BACKEND][OFSAA][T2TCPP] 
ClsUDBConnect::executeInsertQuery, Error, unable to execute the insert query. 
ERROR Message: ORA-12899: value too large for column 
"CONFIG"."ETLLOADHISTORY"."V_BATCH_ID" (actual: 64, maximum: 55) 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.