E-UPG: ORA-12899: Value Too Large For Column While Doing PeopleTools Upgrade

(Doc ID 2322354.1)

Last updated on NOVEMBER 09, 2017

Applies to:

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

Symptoms

On : 8.55 version, Database-Oracle

PeopleTools 8.55.15
Oracle 12.1.0.2
Linux 6
 
During upgrade from PeopleTools 8.53.14 to PTs 8.55.15, running PeopleTools 8.55 release script REL855nDBTSFIX.sql on PSOPRDEFN table which error out



ERROR
-----------------------
ERROR at line 32:
ORA-12899: value too large for column "SYSADM"."PSYPSOPRDEFN"."OPRDEFNDESC"
(actual: 31, maximum: 30)




STEPS:
-------------
The issue can be reproduced at will with the following steps:


1. Upgrade from PeopleTools 8.53.14 to PeopleTools 8.55.15
2. Run step 'Updating PeopleTools System Table'
3. Run REL855nDBTSFIX.sql



Changes

 

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