My Oracle Support Banner

EPY: Create W-2C PDF Forms (tax920us) Is Not Successful With Error ‘Invalid Character Value for Cast Specification’ When Data Populated With SQL Scripts (Doc ID 3002837.1)

Last updated on FEBRUARY 07, 2024

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Unable to run Create W-2c PDF Forms (tax920us.sqr) in production to success when doing 'Final Print' when the data was populated using SQL Scripts.

An error appears in the SQR log file.

Insert-YE-Runcontrol, Insert PS_PY_YE_FORM_RCTL
  Error: [Microsoft][ODBC Driver 17 for SQL Server] Invalid character value for cast specification.

************* No Employee Records Selected *****************

(SQR 4717) Cannot open the report output file: \\\Tax'
(2): No such file or directory.

SQR for PeopleSoft: Program Aborting



Steps to Reproduce

This is assuming that SQL Scripts were used to populate the W2C data.  Component Interface will not work for this.
Please be aware, recommendation is to always Manually enter these, but this customer had too many to process.

Using the SQL Scripts is considered Customer-specific code, or custom code and must be determined and tested by the customer.

1. Navigate to Payroll for North America > U.S. Annual Processing > W-2c Reporting > Create W-2c PDF Forms
2. Enter US/Territory: US
3. Choose Employee Copy
4. Choose Final Print
5. Choose Process Current Batch
6. Choose Run
7. Process Scheduler Request shows Job PYYEW2C, click OK
8. The process shows unsuccessful


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.