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

Last updated on JULY 18, 2016

Applies to:

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

This document was previously published as Customer Connection Solution 201047557


"""""reviewed for currency August 2012"""""
***Checked for relevance on 27-Jan-2014***


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

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