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 MAY 10, 2016

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


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