My Oracle Support Banner

EPY: Pay Calculation Process PSPPYRUN Errors Out after reviewing stored statement PSPSHFTB_S_SHFTB (Doc ID 2601297.1)

Last updated on OCTOBER 17, 2019

Applies to:

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

Symptoms


Pay Calculation PSPPYRUN errors out, but the trace is not showing any errors.
The last part of the trace shows:

GETSTMT Stmt(cached)=PSPSHFTB_S_SHFTB, length=209

COM Stmt=SELECT A.EFFDT ,A.EFF_STATUS ,A.EMPL_SHIFT_DIFF ,A.SHIFT_RT ,A.SHIFT_FACTOR ,A.SETID ,A.SHIFT FROM PS_SHIFT_TBL A WHERE A.SETID=:1 AND A.SHIFT=:2 AND A.EFFDT<=:3 ORDER BY A.SETID ASC ,A.SHIFT ASC ,A.EFFDT DESC

Bind-1, type=SQLPBUF, length=5, value=XXX01
Bind-2, type=SQLPBUF, length=1, value=N
Bind-3, type=SQLPDTE, length=10, value=2019-10-12
SSB column=1, type=SQLPDTE, length=10
SSB column=2, type=SQLPBUF, length=3
SSB column=3, type=SQLPBUF, length=3
SSB column=4, type=SQLPSPD, precision=19, scale=6
SSB column=5, type=SQLPSPD, precision=5, scale=3
EXE
Fetch
Fetch
Disconnect
Fetch

 

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


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