E-CA: Apply PRP to PUM Image Failed With "...ORA-00942: table or view does not exist Failed SQL stmt: DELETE FROM PS_PTIASPRPTHEAD WHERE PTIASPRPTNO IN (26478413)..."

(Doc ID 2335459.1)

Last updated on DECEMBER 04, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

On : 8.55 version, PeopleSoft Update Manager

When loading PRP 26478413 to HCM Pum Image 24, the following error occurred:

ERROR
-----------------------
PeopleTools 8.56.03 - Data Mover
Copyright (c) 2017 PeopleSoft, Inc.
All Rights Reserved
Started: Mon Dec 4 10:11:29 2017
Data Mover Release: 8.56.03
Database: HR92U024 (ENG)
 Message Set Number: 200
 Message Number: 0
 Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 12 Return: 942 - ORA-00942: table or view does not exist
Failed SQL stmt: DELETE FROM PS_PTIASPRPTHEAD WHERE PTIASPRPTNO IN (26478413) (200,0)
SQL Error. Error Position: 12 Return: 942 - ORA-00942: table or view does not exist
DELETE FROM PS_PTIASPRPTHEAD WHERE PTIASPRPTNO IN (26478413)
Error: SQL execute error for DELETE FROM PS_PTIASPRPTHEAD WHERE PTIASPRPTNO IN (26478413)
Ended: Mon Dec 4 10:11:29 2017
Unsuccessful completion

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup HCM PUM 24
2. Apply the PRP 26478413 to the PUM environment

Changes

 

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