HCM 23 PT8.56 Change Assistant Step 'Setting Tablespace Names After Copy' Returns Oracle Error 'ORA-00942: table or view does not exist' (Doc ID 2303570.1)

Last updated on SEPTEMBER 01, 2017

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, HR Maintenance

Error in setting tablespace name step during application of PRP to HCM Image 23

Applying PRP to HCM Image 23. Bug ID is PRJ26519986. Change Assistant job is failing on the step "Setting Tablespace names after copy."

This is an Image Database


ERROR

  ORA-00942: table or view does not exist


STEPS

The issue can be reproduced at will with the following steps:
1. apply PRP to HCM Image 23. Bug ID is PRJ26519986.
2. In Change Assistant job is failing on the step "Setting Tablespace names after copy."

 

(SQR 5528) ORACLE OCIStmtExecute error 942 in cursor 4:
ORA-00942: table or view does not exist
SQL: SELECT V.version FROM PSLOCK V WHERE OBJECTTYPENAME = 'RDM'

Error in include file "C:\PT85601\sqr\setspbdy.sqc" on line 161:
(SQR 3716) Error in SQL statement.

(SQR 5528) ORACLE OCIStmtExecute error 942 in cursor 5:
ORA-00942: table or view does not exist
SQL: SELECT P.RecName, P.SQLTableName FROM PSRECDEFN P WHERE RECTYPE = 0 OR
RECTYPE = 7 ORDER BY RECNAME

Error in include file "C:\PT85601\sqr\setspbdy.sqc" on line 214:
(SQR 3716) Error in SQL statement.

(SQR 5528) ORACLE OCIStmtExecute error 942 in cursor 8:
ORA-00942: table or view does not exist
SQL: SELECT VER.version FROM PSLOCK VER WHERE OBJECTTYPENAME = 'RDM'

Error in include file "C:\PT85601\sqr\setspbdy.sqc" on line 247:
(SQR 3716) Error in SQL statement.

(SQR 5528) ORACLE OCIStmtExecute error 942 in cursor 9:
ORA-00942: table or view does not exist
SQL: SELECT REC.RecName, REC.SQLTableName FROM PSRECDEFN REC WHERE
REC.RECTYPE IN (1, 6) AND BITAND(REC.AUXFLAGMASK, 16777216) = 16777216
ORDER BY RECNAME

 

Other known resolutions have already been confirmed, such as:

E_CA: (SQR 5528) ORACLE OCIStmtExecute error when Setting Tablespace Names After Copy. (Doc ID 2269757.1)

In the situation described, the cause is wrong security.
Users are advised to check the CA > Define Database page configurations for

a. Access id = should be (SYSADM/SYSADM)
b. Connection id = should be (people/peop1e)
c. Please uncheck - (Set DB Owner Credential)

 

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