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.
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.
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
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