EAP WTHD24: 1099 Report Process, AP_APY1099, Abends at Step AP_APY1099.C-REC.EvalAmt2 (Do Select) - RC = 8609 (108,524), After Applying Bug 37025138 (Doc ID 3063838.1)

Last updated on DECEMBER 20, 2024

Applies to:

Symptoms

1099 Report process, AP_APY1099, abends after applying Bug 37025138 - 1099 Update for 2024.

ERROR:

Process 310391 ABENDED at Step AP_APY1099.C-REC.EvalAmt2 (Action Do Select) -- RC = 8612SQL Error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]
The multi-part identifier "A_REC.SEND_STATUS" could not be bound.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The multi-part identifier "A_REC.SEND_STATUS" could not be bound.

STEPS:

1. Accounts Payable > Vouchers > Add/Update > Regular Entry > US003
    a. Add withholding voucher = WW1
    b. Withhold Type = 1099I
    c. Class 01
    d. Payments tab > Record Payment > Reference = 100003

2. Accounts Payable > Batch Processes > Payment > Payment Posting > Payment Reference 100003

3. Suppliers > 1099/Global Withholding > Maintain > Post Withholdings > Post by BU = US003

4. Suppliers > 1099/Global Withholding > 1099 Reports > Withhold 1099 Report Job
    a. Type of File/Return = Test (also tested with Original/Correction and received same results)
    b. Withholding Type Process Option = All
    c. Process 1099 Job

5. PeopleTools > Process Scheduler > Process Monitor > 1099 Job Run Status = No Success
    a. IRS file generated but information is incorrect
    b. 1099-INT Copy B forms not generated

Changes

Applied Bug 37025138 -1099 UPDATE FOR 2024 

Cause

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