You are here:

Peoplesoft/Peoplesoft payroll SQL error

Advertisement


Question
Invalid date error
Invalid date error  
Good afternoon Matthew,

I am hoping you can help provide some insight as to what may be causing this specific error once payroll is ran. Thank you so much for your time.

Answer
Most commonly this type SQL error is due to a misalignment between the COBOL source program and the related Stored SQL statements.  First be sure that the two source files are at the same version -- release and update.  The source files are PSPLDTL2.cbl and PSPLDTL2.dms and the statement name is PSPLDTL2_S_PYCLDT.

If the source files are in agreement as to the layout of this SQL statement, then you need to be sure these are the statements actually being executed.  This is accomplished by being sure that PSPLDTL2.cbl has been complied for the environment where you are running the COBOL process; and that the stored statements are loaded into that database using datamover.

If the above is not sufficient, TraceSQL report can provide more details on the specific SQL issue.  You should be able to find other solution documentation about running COBOL processes with TraceSQL enabled.

Peoplesoft

All Answers


Answers by Expert:


Ask Experts

Volunteer


Matthew Bowden

Expertise

I am willing to share my know how gained from 15 years of supporting PeopleSoft payroll and related modules. I do not have access to an installed system at this time, so my knowledge will be from memory and analysis of provided facts

Experience

PeopleSoft Payroll -- development and support PeopleSoft Payroll Interface -- development and support PeopleSoft Benefits Administration -- support PeopleSoft COBOL -- Functional expert/programmer

Education/Credentials
BA Mathematics, PeopleSoft employee 1993 to 2004

©2016 About.com. All rights reserved.