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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms