After Applying HRMS 9.2 Image #16 To DEMO - Create View Errors On Two Tables - HR_GSS_PG_LVW & PERS_SEC_VW_LG (Doc ID 2128324.1)

Last updated on APRIL 18, 2016

Applies to:

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

Symptoms

On : 9.2 version, HR Maintenance

After applying HRMS 9.2.016 to our DEMO environment, the CREATEVW.DMS which recreates all of the views in the DMO environment, failed with the following errors.

 
ERROR 1
-----------------------

Creating View HR_GSS_PG_LVW
 - SQL Error. Error Position: 0 Return: 601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'PS_EP_PG_RATING_VW'.
 
 CREATE VIEW PS_HR_GSS_PG_LVW (SUPERVISOR_ID, SUPERVIS_EMPL_RCD, EMPLID, EMPL_RCD, EFFDT, LANGUAGE_CD, DESCR1, DESCR2, DESCR3, DESCR) AS SELECT A.SUPERVISOR_ID , A.SUPERVIS_EMPL_RCD , A.EMPLID , A.EMPL_RCD , B.EFFDT , RATEL.LANGUAGE_CD , COALESCE((SELECT DEPTLNG.DESCR FROM PS_DEPT_TBL_LANG DEPTLNG WHERE DEPTLNG.DEPTID= B.DEPTID AND DEPTLNG.SETID= B.SETID_DEPT AND DEPTLNG.LANGUAGE_CD=RATEL.LANGUAGE_CD AND DEPTLNG.EFFDT=( SELECT MAX(DEPT1.EFFDT) FROM PS_DEPT_TBL_LANG DEPT1 WHERE DEPT1.DEPTID=DEPTLNG.DEPTID AND DEPT1.EFFDT<={ fn CURDATE() } AND DEPT1.LANGUAGE_CD=DEPTLNG.LANGUAGE_CD AND DEPT1.SETID=DEPTLNG.SETID)),'') , COALESCE((SELECT LOCLNG.DESCR FROM PS_LOCATION_LANG LOCLNG WHERE LOCLNG.LOCATION=B.LOCATION AND LOCLNG.SETID=B.SETID_LOCATION AND RATEL.LANGUAGE_CD =LOCLNG.LANGUAGE_CD AND LOCLNG.EFFDT=( SELECT MAX(LOC1.EFFDT) FROM PS_LOCATION_LANG LOC1 WHERE LOC1.LOCATION=LOCLNG.LOCAT...

 

ERROR 2

--------------------------------
Creating View PERS_SEC_VW_LG
 - SQL Error. Error Position: 0 Return: 601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'PSOPRDEFN_LANG'.
 
 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
Record PERS_SEC_VW_LG is attempting to read a table named PSOPRDEFN_LANG which we do not have.




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply HCM 9.2 PUM 16 to DEMO
2. Error occurs when running CREATEVW.DMS script to recreate views.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete applicaton of PUM 16.

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