EAP WTHD17: Withholding Sent (WTHD_SNT) Fails At Step WTHD_SNT.MAIN.Step01_1 (PeopleCode) (Sybase specific)
Last updated on JANUARY 29, 2018
Applies to:PeopleSoft Enterprise FIN Payables - Version 9.1 and later
Information in this document applies to any platform.
After applying the 1099 patch for 2017 , Withholding Sent Process fails.
The same process works fine in DB2,MSQL and Oracle Databases (supported databases for PeopleSoft) This issue is with Sybase compatibility.
SQL error. Function: SQLExec
Error Position: 0
Return: 257 - Implicit conversion from datatype 'CHAR' to 'SMALLINT' is not allowed. Use the CONVERT function to run this query.
Statement: SELECT COUNT(*) FROM PS_WTHD_SENT_DTL WHERE FISCAL_YEAR < :1 AND CALENDAR_SETID = :2 AND WTHD_RPT_ID = :3 AND WTHD_CNTL_ID = :4
Original Statement: select count(*) from PS_WTHD_SENT_DTL WHERE FISCAL_YEAR < :1 AND CALENDAR_SETID = :2 AND WTHD_RPT_ID = :3 and WTHD_CNTL_ID = :4
2017-11-21-15.34.34.000299 AePcdExecutePeopleCode  Exception logged: RC=100.
2017-11-21-15.34.34.000299 GetNextStateRecord  Exception logged: RC=3.
SQL error in NumResultCols. (2,278) WTHD_SNT.MAIN.GBL.default.1900-01-01.Step01_1.OnExecute PCPC:439 Statement:3
2017-11-21-15.34.34.000431 DoStepActions  Exception logged: RC=100.
Process 618463 ABENDED at Step WTHD_SNT.MAIN.Step01_1 (PeopleCode) -- RC = 8 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
The issue can be reproduced in FSCM 9.1 Sybase Environment at will with the following steps:
1. Run Withholding Sent Process
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms