Retro Benefit/Deductions Load to Paysheets Error: 08001 Invalid bind variable number
(Doc ID 2288173.1)
Last updated on OCTOBER 28, 2021
Applies to:
PeopleSoft Enterprise HCM Benefits Administration - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
The Retro Benefits Deductions Load to Paysheets program PSPRDPSH fails with error message - Invalid Bind Variable number
Retro Deduction Paysheet Update started for Run: DN482016 at 14:38:02.73.
PeopleSoft Benefits -- Version 9.2
Copyright (c) 2012, Oracle and/or its affiliates. All rights reserved.
On-Cycle Arrears/Paysheet Load started for Run: DN482016 at 14:38:02.74.
PTPSQLRT - ERROR IN BIND SETUP/DATA
STATEMENT=PSPRDPS1_S_EEDATA
VARIABLE#=00005
DATA TYPE=00015
DATA LEN =00010
SCALE =00000
Application Program Failed
Action Type : SQL SELECT
In Pgm Section : SQLRT: PROCESS-SETUP(BIND)
With Return Code: 08001
Error Message : Invalid bind variable number
Stored Stmt : PSPRDPS1_S_EEDATA
SQL Statement : SELECT A.EMPLID ,A.NAME ,B.BENEFIT_RCD_NBR ,C.JOBCODE ,C.DEP TID ,C.GL_PAY_TYPE ,C.POSITION_NBR ,C.SHIFT ,C.EMPL_TYPE ,C.
LOCATION ,C.HOURLY_RT ,C.EFFDT ,F.BENEFIT_PROGRAM ,C.BUSINES S_UNIT ,C.FICA_STATUS_EE ,C.FLSA_STATUS ,C.UNION_CD FROM PS_
PERSON_NAME A ,PS_PER_ORG_ASGN B ,PS_JOB C ,PS_BEN_PROG_PART IC F WHERE A.EMPLID=:1 AND B.EMPLID=A.EMPLID AND C.EMPLID=A.
EMPLID AND B.EMPL_RCD=C.EMPL_RCD AND B.EMPL_RCD=:2 AND F.EMP LID=A.EMPLID AND F.EMPL_RCD=B.EMPL_RCD AND C.EFFDT= (SELECT
MAX(D.EFFDT) FROM PS_JOB D WHERE D.EMPLID=A.EMPLID AND D.EMP L_RCD=B.EMPL_RCD AND D.EFFDT<=:3) AND C.EFFSEQ= (SELECT MAX(
E.EFFSEQ) FROM PS_JOB E WHERE E.EMPLID=A.EMPLID AND E.EMPL_R CD=B.EMPL_RCD AND E.EFFDT=C.EFFDT) AND F.EFFDT= (SELECT MAX(
G.EFFDT) FROM PS_BEN_PROG_PARTIC G WHERE G.EMPLID=A.EMPLID A ND G.EMPL_RCD=B.EMPL_RCD AND G.EFFDT<=:4)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Retro Deduction Load to Paysheets process. Payroll for North America > Retroactive Payroll > Retro Benefits/Deductions > Process and Review Requests > Load Retro Deds to Paysheets
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 |
Cause |
Solution |