EAP WTHD21: Existing Data Removed From WTHD_TO_SND_DTL Record When a Different Run Control / Withholding Control ID is Run (Doc ID 2828339.1)

Last updated on OCTOBER 17, 2022

Applies to:

Symptoms

The 1099 Job is removing existing data in the WHTD_TO_SND_DTL record when a new 1099 Job is run using a different Run Control ID / Withholding Control ID. However, the WTHD_TO_SND_HDR record retains the different Withholding Control ID's.

STEPS

1. Setup Financials/Supply Chain > Product Related > Procurement Options > Withholding > Report Control Information > Add new Report Control ID = CORP2

2. Suppliers > 1099/Global Withholding > 1099 Reports > run Withhold 1099 Report Job
    a. Control ID = CORP
    b. Withholding Type Process Option = 1099-MISC, 1099-INT, 1099-G
    c. Process Scheduler Request > run 1099 Job

3. Data in the WTHD_TO_SND_DTL and WTHD_TO_SND_HDR

4. Run 1099 Job again
    a. Use new Run Control
    b. Different Control ID
    c. Different Withholding Type Process Option = 1099-NEC

5. WTHD_TO_SND_DTL only contains the last job run
    a. All other existing data is gone
    b. Query WTHD_TO_SND_HDR and the two Withholding Control ID's are listed in this record

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.