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:

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

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