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.


On : 8.55 version, Database-Oracle

PeopleTools 8.55.15
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 at line 32:
ORA-12899: value too large for column "SYSADM"."PSYPSOPRDEFN"."OPRDEFNDESC"
(actual: 31, maximum: 30)

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




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