EAP WTHD17: Withholding Sent (WTHD_SNT) Fails At Step WTHD_SNT.MAIN.Step01_1 (PeopleCode) (Sybase specific)

(Doc ID 2354558.1)

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.

Symptoms

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.


ERROR:
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 [188] Exception logged: RC=100.
2017-11-21-15.34.34.000299 GetNextStateRecord [68] 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 [1941] 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



Replication:
The issue can be reproduced in FSCM 9.1 Sybase Environment at will with the following steps:
1. Run Withholding Sent Process



Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms