Payroll for NA / Time and Labor - PSFT (MOSC)

MOSC Banner

PSPPYRUN cobol failing with "INVALID CHARACTER AT END OF DATA" error

Hello,

Environment: HCM 9.2, PeopleTools 8.57, Image 17, MS SQL Server, Windows (all tiers)

Problem:

Payroll calc (PSPPYRUN) fails in lower environment with bind variable mismatch. COBSQL trace shows the SQL statement PSPEARRY_S_ERN has 5 bind placeholders, but the COBOL program passes 6 binds. The 6th bind is a space character (appears to be ORIG_PAYGROUP). Error: RC=8080 "An invalid bind variable number was specified."

Process logs:

Checking PaySheet Update ended at 14:28:14.20.
PTPSQLRT - ERROR IN BIND SETUP/DATA
STATEMENT=PSPSTRUN_S_RECALCO
VARIABLE#=00005
INVALID CHARACTER AT END OF DATA=

Application Program Failed
Action Type : SQL SELECT
In Pgm Section :Error Message :Stored Stmt : PSPSTRUN_S_RECALCO

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center