My Oracle Support Banner

GPAUS: STP, Prep Process Goes To SQL Error: An Expression In The ORDER BY clause is not valid (Doc ID 2600085.1)

Last updated on OCTOBER 16, 2019

Applies to:

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

Symptoms


DB2 Database, STP, Prep Process goes to SQL error: An expression in the ORDER BY clause in the following position, or starting with "PRC_ORD_TS" in the "ORDER BY" clause is not valid.


STEPS TO REPLICATE
---------------------------------------
The issue can be reproduced at will with the following steps:
1) Login as payroll admin, run the STP Prep process on the DB2 batabse.
2) Locate the error.

ERROR MESSAGE
----------------------------
Prep Process goes to 'No Success' with SQL error in
GPAU_STP_PRC.STGLOAD.Step12 (Action Do Select) and GPAU_STP_PRC.STGLOAD.Step13 (Action Do Select)
Here the log:

-- 10.33.00 Process 5482 ABENDED at Step GPAU_STP_PRC.STGLOAD.Step13 (Action Do Select) -- RC = 8602
ROLLBACK
/
-- 10.33.00 SQL Error: [IBM][CLI Driver][DB2] SQL0214N An expression in the ORDER BY clause in the following position, or starting with "PRC_ORD_TS" in the "ORDER BY" clause is not valid. Reason code = "2". SQLSTATE=42822
 (SQLSTATE 42822) -214
---

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.