When Creating All Views in HCM 9.1 To HCM 9.2 Through PI16 Upgrade UPG_SS_LOCATION View Fails To Build
Last updated on NOVEMBER 13, 2017
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
On : 9.2 version, HR Upgrade
UPG_SS_LOCATION view fails to build during HCM 9.1 to HCM 9.2 Through Update Image 16 upgrade. The task number is Task 6-12-6: Creating All Views.
Error: UPG_SS_LOCATION - SQL Error. Error Position: 139 Return: 904 - ORA-00904: "A"."TRANSACTION_NBR": invalid identifier
CREATE VIEW PS_UPG_SS_LOCATION (DESCR, TRANSACTION_NBR, EMPLID, EMPL_RCD, JOB_DESCR_SS, NAME, DESCR1) AS SELECT 'Lucation Change Status' , A.TRANSACTION_NBR , A.EMPLID , A.EMPL_RCD , A.job_descr_ss , B.NAME , CASE WHEN A.SS_STAT_INDICATOR = 'I' THEN 'In Approval Process' ELSE 'Administrator Action Require' END FROM PS_HR_LOC_TRANS A , PS_PERSON_NAME B WHERE A.EMPLID = B.EMPLID AND A.SS_STAT_INDICATOR IN ('I' , 'M')
The issue can be reproduced at will with the following steps:
1. Proceed in upgrade until Creating All Views task
2. Error occurs
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