SQL Error Accessing Global Payroll Results By Calendar on DB2 over zOS platform

(Doc ID 2295744.1)

Last updated on AUGUST 10, 2017

Applies to:

PeopleSoft Enterprise HCM Absence Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Processes

When accessing Global Payroll & Absence Management > Absence and Payroll Processing > Review Absence/Payroll Info > > Results by Calendar
receive SQL error

When clearing the error message, results count in search page says 300 of 0 results returned

Issue happens only on DB2 over zOS platform.

ERROR
-----------------------

On Results by Calendar page:

A SQL error occurred. Please consult your system log for details.

 

App server log:


PSAPPSRV.6357348 (805) [2016-12-30T15:59:52.439 TUNSTEAC@10.114.5.2 (IE 11.0; WI
N) ICPanel](3) File: /vob/peopletools/src/psppr/ramget.cppSQL error. Stmt #: 686
Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2] SQL0171N The data ty pe, length or value of the argument for the parameter in position "2" of routine "||" is incorrect. Parameter name: "". SQLSTATE=42815 (SQLSTATE 42815) -171 Failed SQL stmt: SELECT COUNT ( DISTINCT EMPLID || EMPL_RCD || NAME || GP_PAYGRO UP || PYMT_DT || CAL_ID ) AS COUNT_KEYS FROM PS_GP_RSLT2_SRCH WHERE OPRID=:1 AN D EMPLID LIKE '702710%'



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Access Global Payroll & Absence Management > Absence and Payroll Processing > Review Absence/Payroll Info > > Results by Calendar
2. Enter an emplid then click search
 

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