EPY: Create 1099-R Print And Electronic Files(TAX930PM) Fails with "String or binary data would be truncated in table 'PS_PY_SS_1099_TMP', column 'PY_YE_BURST_ID'" on SQL Server (Doc ID 3065972.1)

Last updated on FEBRUARY 18, 2025

Applies to:

Symptoms

This issue is Specific for Microsoft SQL Server databases.

When attempting to run TAX930PM (Create 1099-R Print and Electronic Files),
the following error appears in the tax930pm_xxxxx.out file.


(SQR 5528) ODBC SQL dbexec: SQLExecute error 2628 in cursor 24:
  [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]String or binary data would be truncated in table 'ACTH9DEV.dbo.PS_PY_SS_1099_TMP', column 'PY_YE_BURST_ID'. Truncated value: '1099R2023PEN000012711 07035070'.
(SQR 5528) ODBC SQL dbexec: SQLExecute error 3621 in cursor 24:
  [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.

Error on line 2782:

  (SQR 3735) Could not execute SQL.

SQR for PeopleSoft: Program Aborting.
...


Steps to Reproduce

1. Review and update the Balances for Year field on the Annual Tax Reporting Parameters page for year-end reporting.
    a) Navigation: Payroll for North America, U.S. Annual Processing, Define Annual Tax Reporting, Tax Reporting
   b) Make sure the year shows 2024 for the 1099-R Company

2. Review the Tax Report Type field on the Company Table -Tax Details page and update for 2024 year-end reporting if necessary.
   a) Navigation: Set Up HRMS, Foundation Tables, Organization, Company, Default Settings
   b) Search for Company TYG
   c) Click the Tax Details link in the Payroll for North America group box and make sure it shows 1099R is chosen
   d) Add a new row for 2024 and save
3. Update the Year End 1099-R Form Options page by manually adding a new row for Tax Year 2024 for each 1099-R Company
   a) Payroll for North America, U.S. Annual Processing, Define Annual Tax Reporting, Year End 1099-R Form Options
   b) Ensure there is a 2024 row added.

4. Ensure Tax Form BI Publisher Options are set.
   a) Navigation: Payroll for North America > U.S. Annual Processing > Define Annual Tax Reporting > Tax Form BI Publisher Options
   b) See the 2024 row

5. Run the Form 1099-R Audit Report
   a) Navigation: Payroll for North America > U.S. Annual Processing > 1099-R Reporting > Form 1099-R Audit Report
   b) Review the PDF

6. Create the 1099-R PDF/File:
   a) Navigate to Payroll for North America > US Annual Processing > 1099-R Reporting > Create 1099-R PDF/File
   b) Add the Distribution Code and check Total Distribution
   c) Add the Earnings Codes for the Company's Retirement Earnings
   d) Run the process
   e) When on SQL Server, the process fails with the error, found in the TAX930PM_xxxx.out file

Changes

Cause

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