My Oracle Support Banner

EPY: Unable To View Non-PDF Self Service Paychecks on DB2 z/OS (Doc ID 2246246.1)

Last updated on NOVEMBER 23, 2019

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

ENVIRONMENT:
IBM z/OS on System z
HCM 9.1
Through Tax Update 17-A


ISSUE:
Ever since applying tax update 16-D, the Payroll group is no longer able to view non-pdf self service paychecks for employees. Navigate to Main Menu > Payroll for North America > Payroll Processing USA > Produce Payroll > Review Self Service Paycheck.  The list of available self service paychecks is shown. When the Payroll group selects a non-pdf paycheck, the next page displays showing only the employee name. When the return to search button is selected, the search page displays and after the record is selected, a SQL error is thrown. Also, an employee can view their own non-pdf self service paycheck but the Payroll group can no longer view non-pdf self service paychecks for other employees.

 

ERROR
-----------------------
A fatal PeopleCode SQL error occurred. Please consult your system log for details

Error
ErrorReturn-> 279 - SQL error in DescribeCol. (2,279) PY_SSP_VIEW_DATA.Activate PCPC:31415 Statement:297

Error Position: 0
  Return: 8010 - [IBM][CLI Driver][DB2] SQL0206N "NULL" is not valid in the context where it is used. SQLSTATE=42703

  Statement: SELECT L.DESCR FROM PS_LOCATION_TBL L WHERE L.SETID = (SELECT S.SETID FROM PS_SET_CNTRL_REC S WHERE S.SETCNTRLVALUE = :1 AND S.RECNAME = :2) AND L.LOCATION = :3 AND L.EFFDT = (SELECT MAX(L1.EFFDT) FROM PS_LOCATION_TBL L1 WHERE L1.SETID = L.SETID AND L1.LOCATION = L.LOCATION AND L1.EFFDT <= NULL)
  Original Statement: SELECT L.DESCR FROM PS_LOCATION_TBL L WHERE L.SETID = (SELECT S.SETID FROM PS_SET_CNTRL_REC S WHERE S.SETCNTRLVALUE = :1 AND S.RECNAME = :2) AND L.LOCATION = :3 AND L.EFFDT = (SELECT MAX(L1.EFFDT) FROM PS_LOCATION_TBL L1 WHERE L1.SETID = L.SETID AND L1.LOCATION = L.LOCATION AND L1.EFFDT <= ÚteIn(:4))
PSAPPSRV.8978560 (3561)
1-229573 12.18.00 0.000147 ErrorReturn-> 279 - SQL error in DescribeCol. (2,279) PY_SSP_VIEW_DATA.Activate PCPC:31415 Statement:297


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.