In CS 9.2, Empty Record PS_EOPC_DEFN Causes ORA-01407 When Running UPD25166992.DMS

(Doc ID 2302486.1)

Last updated on AUGUST 31, 2017

Applies to:

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

Symptoms

When trying to apply Campus Solutions Update Image 6 to a Campus Solutions database that is on CS 9.2 Update Image 4, along with upgrading PeopleTools from PT 8.53.15 to PT 8.55.14, the same error that is described in Bug 26225668 is encountered and the PS_EOPC_DEFN table is empty:

ERROR
-----------------------
ORA-01407


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

1. Apply CS 9.2 Update Image 4.
2. Upgrade PeopleTools from PT 8.53.15 to PT 8.55.14.
3. When applying Image 6, run UPD25166992.DMS.

BUSINESS IMPACT
----------------------------
The issue has the following business impact:

Due to this issue, user cannot successfully apply CS 9.2 Image 6.

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