My Oracle Support Banner

While Applying 9.1 Bundle 21, Error Occurs: "Table psoprdefn_lang does not exist. Failed SQL stmt: CREATE VIEW PS_PERS_SEC_VW_LG (Doc ID 2102842.1)

Last updated on JULY 22, 2020

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

ISSUE STATEMENT
---------------
While applying HCM 9.1 Bundle #21, the following error occurs:

 
ERROR
---------------
Table psoprdefn_lang does not exist.

Failed SQL stmt: CREATE VIEW PS_PERS_SEC_VW_LG (LANGUAGE_CD, ACCESS_TYPE_JPN, USER_ROLE_JPN, DESCR) AS SELECT '1' , OPRID ,LANGUAGE_CD , OPRDEFNDESC FROM PSOPRDEFN_LANG UNION SELECT '2' , ROLENAME , LANGUAGE_CD , DESCR FROM PSROLEDEFNLANG (200,0)
SQL Error. Error Position: 137 Return: 942 - ORA-00942: table or view does not exist


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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.