My Oracle Support Banner

E-ORA: ORA-12899: value too large for column (Doc ID 656182.1)

Last updated on OCTOBER 15, 2021

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.1 and later
Information in this document applies to any platform.

Symptoms

 
The customer wants to install CRM 9.0 with PeopleTools 8.48 and when he tries to import the German language specific data from the file crgera.db, he receives the following error:

Started:  Thu Feb 08 17:24:41 2007
Data Mover Release: 8.48.07
Database: CRMDEMO (ENG)
Input file: D:\PT8.48\data\crgera.db (ENG)
Importing  PSXLATITEMLANG
SQL error. Stmt #: 0  Error Position: 151  Return: 12899 - ORA-12899: value too large for column "SYSADM"."PSXLATITEMLANG"."XLATSHORTNAME" (actual: 11, maximum: 10)
INSERT INTO PSXLATITEMLANG  (FIELDNAME, FIELDVALUE, EFFDT, LANGUAGE_CD, XLATLONGNAME, XLATSHORTNAME) VALUES (:1, :2, TO_DATE(:3,'YYYY-MM-DD'), :4, :5, :6)
Error: Unable to insert row 9
Error: SQL execute error for PSXLATITEMLANG
Ended: Thu Feb 08 17:27:08 2007
Unsuccessful completion

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!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.