My Oracle Support Banner

Unable To Build GP Thailand Views After PUM Image #17 (Doc ID 2156986.1)

Last updated on APRIL 04, 2019

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
PeopleSoft Enterprise HCM Global Payroll Thailand - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Unable to build views after PUM17 on HCM giving below error:
(VIEWS-1) Views defined in the Application Designer and not found in the Database: for 9 Views.

GPTH_BENEF_VWC1
GPTH_BENEF_VWC2
GPTH_BENEF_VWC3
GPTH_BEN_VWCE1
GPTH_BEN_VWCE2
GPTH_BEN_VWCE3
GPTH_CNID_VW
GPTH_ENID_VW
GPTH_PIT90_VW

ERROR
-----------------------
Error: GPTH_BENEF_VWC1 - SQL Error. Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.



The issue can be reproduced at will with the following steps:
1. Open these VIEWS in Application Designer
2. Error Building Views, Reflected in the DDD Audit

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.