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 APRIL 04, 2025
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.55 and laterInformation 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
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 |