E-UPG: ORA-12899: Value Too Large For Column While Doing PeopleTools Upgrade
(Doc ID 2322354.1)
Last updated on DECEMBER 17, 2019
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.55 and laterInformation 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
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 |
Changes |
Cause |
Solution |
References |