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

Last updated on JUNE 19, 2017

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

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