SQL Error Accessing Global Payroll Results By Calendar on DB2 over zOS platform
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.
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.
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%'
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
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