Last updated on JULY 19, 2017

Applies to:

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