My Oracle Support Banner

ETL9.2: Payroll Calc Issue: Invalid SELECT item number error with Return code of 08003 in PSPLDTL2_S_ADLDATA COBOL (Doc ID 2224079.1)

Last updated on OCTOBER 02, 2018

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On: 9.2 version, Core Processes

When attempting to Calculate payroll the following error occurs.

ERROR
-----------------------
PTPSQLRT - ERROR IN SELECT SETUP/DATA
STATEMENT=PSPLDTL2_S_ADLDATA
VARIABLE#=00003
DATA TYPE=00001
DATA LEN =00006
SCALE =00000
 
Application Program Failed
 Action Type : SQL SELECT
 In Pgm Section : SQLRT: PROCESS-SETUP(SELECT)
 With Return Code: 08003
 Error Message : Invalid SELECT item number
 Stored Stmt : PSPLDTL2_S_ADLDATA
 SQL Statement : SELECT A.FICA_STATUS_EE ,A.GL_PAY_TYPE FROM PS_JOB A WHERE A
  .EMPLID=:1 AND A.EMPL_RCD=:2 AND A.EFFDT= (SELECT MAX(G.EFFD
  T) FROM PS_JOB G WHERE G.EMPLID=A.EMPLID AND G.EMPL_RCD=A.EM
  PL_RCD AND G.EFFDT<=:3) AND A.EFFSEQ= (SELECT MAX(H.EFFSEQ)
  FROM PS_JOB H WHERE H.EMPLID=A.EMPLID AND H.EMPL_RCD=A.EMPL_
  RCD AND H.EFFDT=A.EFFDT)
 
 
 
Application Program Failed
 In Pgm Section : GET-JOB-DATA(SELECT)
 With Return Code: 08003
 Error Message : Invalid SELECT item number


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run pay calc
2. View error in log


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete payroll without the workaround.

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.