EAP WTHD20: AP_APY1099 Process Abends at Step AP_APY1099.BD200.STEP140 (SQL) -- RC = 805, When Processing Corrections (Doc ID 2744656.1)

Last updated on OCTOBER 17, 2022

Applies to:

Symptoms

AP_APY1099 process abends when the "IRS Notified Twice of Invalid" option is selected when correcting a Withholding Supplier.

STEPS

Original File

1. Withholding Supplier has 2 Locations 
    a. Location 1 > Default > 01/01/1900
        1099M > Class 1 > Default
        1099M > Class 3 & 5
        1099N > Class 1
        Report to Address1
    b. Location 2 > Default > 01/01/1900
        1099M > Class 1 > Default
        1099M > Class 3, 5, 9
        1099N > Class 1
        Report to Address1
2. Adjust Withholding Entries > Location 1 > 3 rows of payments
    1099M > Class 1 > 1000.00
    1099M > Class 5 > 2000.00
    1099N > Class 1 > 3000.00
3. Adjust Withholding Entries > Location 2 > 4 rows of payments
    1099M > Class 3 > 4000.00
    1099M > Class 5 > 5000.00
    1099N > Class 9 > 6000.00
    1099N > Class 1 > 7000.00
4. 1099 Job > IRS file is correct
5. Withholding Sent File process

Corrections

1. Modify Address 1
2. Run 1099 Job > IRS Correction file is correct
3. Back to Location 1 > Withholding setup > check box for "IRS Notified Twice of Invalid"
4. 1099 Job
5. AP_APY1099 process ends in No Success
6. SQL error. Stmt #: 1738 Error Position: 0 Return: 805 - ORA-00001: unique constraint (EMDBO.PS_WTHD_TO_SND_DT)
    Process abends at Step AP_APY1099.BD200.Step140 (SQL) -- RC = 805

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.