My Oracle Support Banner

CREATE VIEW PS_GPAU_SETCTR_VW Error When Applying GP 9.1 Bundle 2014-D (Doc ID 1967828.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise HCM Global Payroll Australia - Version 9 and later
PeopleSoft Enterprise HCM Global Payroll Core - Version 9 and later
Information in this document applies to any platform.

Goal

 While applying GP 9.1 Bundle 2014-D, customer is running into an error when executing the Create View database script:

 

Failed SQL stmt: CREATE VIEW PS_GPAU_SETCTR_VW (COUNTRY, GPAU_XMLSET_CTR, DESCR) AS SELECT S.COUNTRY ,S.XML_SET ,S.DESCR FROM PS_XML_SET_TBL S (200,0)

SQL Error. Error Position: 74  Return: 904 - ORA-00904: "S"."COUNTRY": invalid identifier

 

Solution

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
Goal
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.