Campus Solutions Bundle 35 Error - ORA-12899: Value Too Large For Column when importing Message Catalog data (upd912350_msg.dat) (Doc ID 1942211.1)

Last updated on NOVEMBER 08, 2016

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 and later
Information in this document applies to any platform.

Symptoms

The following error is returned when importing Message Catalog Definitions as part of the application of CS 9 Bundle #35 / Patch ID 19357125:


Importing PSMSGCATDEFN
SQL Error. Error Position: 119 Return: 12899 - ORA-12899: value too large for column "SYSADM"."PSMSGCATDEFN"."MESSAGE_TEXT" (actual: 104, maximum: 100)
INSERT INTO PSMSGCATDEFN (MESSAGE_SET_NBR, MESSAGE_NBR, MESSAGE_TEXT, MSG_SEVERITY, LAST_UPDATE_DTTM) VALUES (:1, :2, :3, :4, TO_TIMESTAMP(:5,'YYYY-MM-DD-HH24.MI.SS.FF'))
Error: Unable to insert row 119
Error: SQL execute error for PSMSGCATDEFN
Ended: Mon Oct 20 11:29:45 2014
Unsuccessful completion

 
The issue can be reproduced with the following steps:
1. Apply bunde 35 with upd912350_msg.dat and notice the error in the script.

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