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 APRIL 11, 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.
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 |