PeopleSoft NA Payroll or HCM Functional Training:

PeopleSoft NA Payroll or HCM Functional Training:

Please send email to nandu.peoplesoft@gmail.com for enrolling the course or call me @8897575066. Please see below HCM Functional training AGENDA.

Payroll for North America training AGENDA.

This is an online Functional Training. Training goes through webex and explain you with real time execution of processes with examples. Recordings and documentation will be given once the training is done.

Thursday, March 8, 2012

Pay confirmation Process failed with error : "Error Message : Invalid SELECT item number "

Error :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 : PSPTBUPD_S_PA_RES
SQL Statement : SELECT RES_PSD_CD ,NLGRS_MTD ,NLGRS_QTD ,NLGRS_YTD ,TXGRS_MT
D ,TXGRS_QTD ,TXGRS_YTD ,TAX_MTD ,TAX_QTD ,TAX_YTD ,TIPS_MTD
FROM PS_TAX_BALANCE WHERE EMPLID=:1 AND COMPANY=:2 AND BALA
NCE_ID=:3 AND BALANCE_YEAR=:4 AND STATE=:5 AND LOCALITY=:6 A
ND TAX_CLASS=:7 AND WORK_PSD_CD=:8 AND RES_PSD_CD=:9_



Application Program Failed
In Pgm Section : SELECT-PA-PSD
With Return Code: 08003
Error Message : Invalid SELECT item number

PAGE_NUM= 12,LINE_NUM= 1,SEPCHK=0,EMPLID=0987678,NAME=

Application Program Failed
In Pgm Section : PROCESS-CHECK(PSPTBUPD)
With Return Code: 080 
  Observation when we receive this error:
The PSPTBUPD.CBL COBOL program was recompiled but the dms script came with that patch was not ran. Resolution:  The Invalid SELECT item number error that was received in the most recent run of Beta indicates that the cobol and dms objects are out of sync.  Need to recompile the PSPTBUPD.CBL COBOL program and run the dms script.