When Creating All Views in HCM 9.1 To HCM 9.2 Through PI16 Upgrade UPG_SS_LOCATION View Fails To Build (Doc ID 2148350.1)

Last updated on JUNE 10, 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 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
-----------------------
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')


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Proceed in upgrade until Creating All Views task
2. Error occurs

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