When Trying to Run CS 9.0 Bundle 31 UPD898732_11.DMS, Get Error ORA-01400 on PT 8.54 (Doc ID 1932409.1)

Last updated on AUGUST 08, 2017

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR  
-------------------------
While applying CS 9.0.BUNDLE 31 to PT 8.54, when running UPD898732_11.DMS the following error occurs:

ERROR
-----------------------
Importing  PTAI_CONTEXT
SQL Error. Error Position: 0  Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_PTAI_CONTEXT"."PTAI_PARAM_TYPE")
INSERT INTO PS_PTAI_CONTEXT  (PTAI_LIST_ID, FIELDNAME, RECNAME, PTAI_KEY_LABEL, PTAI_KEY_VALUE, PTAI_CTX_KEY, PTAI_CTX_VISBL) VALUES (:1, :2, :3, :4, :5, :6, :7)
SQL Error. Error Position: 0  Return: 0 -
Error: SQL unable to commit transaction for PTAI_CONTEXT

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply bundle 31 using PT 8.54.03 and get the error on UPD898732_11.DMS


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete applying bundle 31

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