EAP WTHD20: AP_1099 PSJob Abends at Step 1099_RPT_PST.PreProc.Step01A (SQL) -- RC = 8601 (108,524) Cannot Insert the Value NULL Into column 'ADDRESS_SEQ_NUM' (Doc ID 2734071.1)

Last updated on OCTOBER 17, 2022

Applies to:

Symptoms

When trying to run the Withhold 1099 Report Job process (AP_1099 PSJob), the system abends at Step 1099_RPT_PST.PreProc.Step01A when trying to fill in with a NULL value the Record Field PS_WTHD_1099_TMP2.ADDRESS_SEQ_NUM.

This seems to happen when launching the Withhold 1099 Report Job process (AP_1099 PSJob) for Withhold Type 'ALL' for the first time.

REPLICATION STEPS:

    1.- Ensure that the 1099 Patch Update from Fiscal Year 2020 has been applied
    2.- Log into the FSCM Online Application as a Payables User
    3.- Navigate to: Suppliers > 1099/Global Withholding > 1099 Reports > Withhold 1099 Report Job
    4.- Create a new Run Control ID, and fill in all needed required field values
    5.- Make sure that at the '1099 Report Copy B Sort' section, the Withhold Type is set to ALL
    6.- Click on the RUN button
    7.- Select the 1099 Job (AP_1099 PSJob)
    8.- Click on OK button to launch the process
    9.- Confirm that the RPT_1099_PST sub process abends

ERROR MESSAGE:

    " SQL error. Stmt #: 1725  Error Position: 0  Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'ADDRESS_SEQ_NUM', table 'FS92QAA.dbo.PS_WTHD_1099_TMP2'; column does not allow nulls. UPDATE fails.
      [Microsoft][SQL Server Native Client 11.0][SQL Server]The Failed SQL stmt: UPDATE PS_WTHD_1099_TMP2   SET PS_WTHD_1099_TMP2.ADDRESS_SEQ_NUM = (  SELECT DISTINCT WTRXN.ADDRESS_SEQ_NUM   FROM PS_WTHD_TRXN3_TMP WTRXN   WHERE PS_WTHD_1099_TMP2.PROCESS_INSTANCE = WTRXN.PROCESS_INSTANCE2   AND PS_WTHD_1099_TMP2.VENDOR_SETID = WTRXN.VENDOR_SETID   AND PS_WTHD_1099_TMP2.VENDOR_ID = WTRXN.VENDOR_ID   AND PS_WTHD_1099_TMP2.VNDR_LOC = WTRXN.VNDR_LOC   AND PS_WTHD_1099_TMP2.WTHD_ENTITY = WTRXN.WTHD_ENTITY   AND PS_WTHD_1099_TMP2.WTHD_TYPE = WTRXN.WTHD_TYPE   AND PS_WTHD_1099_TMP2.WTHD_CLASS = WTRXN.WTHD_CLASS   AND PS_WTHD_1099_TMP2.BUSINESS_UNIT = WTRXN.BUSINESS_UNIT   AND PS_WTHD_1099_TMP2.PROCESS_INSTANCE = 5189936   AND WTRXN.WTHD_DECL_DATE = (  SELECT MAX(A.WTHD_DECL_DATE)   FROM PS_WTHD_TRXN3_TMP A   WHERE PS_WTHD_1099_TMP2.PROCESS_INSTANCE = A.PROCESS_INSTANCE2   AND PS_WTHD_1099_TMP2.VENDOR_SETID = A.VENDOR_SETID   AND PS_WTHD_1099_TMP2.VENDOR_ID = A.VENDOR_ID   AND PS_WTHD_1099_TMP2.VNDR_LOC = A.VNDR_LOC   AND PS_WTHD_1099_TMP2.WTHD_ENTITY = A.WTHD_ENTITY   AND PS_WTHD_1099_TMP2.WTHD_TYPE = A.WTHD_TYPE   AND PS_WTHD_1099_TMP2.WTHD_CLASS = A.WTHD_CLASS   AND PS_WTHD_1099_TMP2.BUSINESS_UNIT = A.BUSINESS_UNIT   AND PS_WTHD_1099_TMP2.PROCESS_INSTANCE = 5189936   AND A.WTHD_DECL_DATE <= '2020-12-03'))
      Process 5189936 ABENDED at Step 1099_RPT_PST.PreProc.Step01A (SQL) -- RC = 8601 (108,524) "

The Users are unable to properly generate the needed 1099 Reports on all Withholding Types in one go. Users need to run the program one Withholding Type at a time (1099G, 1099I, 1099M, and 1099N).

It is expected that the AP_1099 PSJob completes successfully, with all its sub-processes, regardless of what Withhold Type value is being selected in the Run Control ID page (All, 1099G, 1099I, 1099M, and 1099N).

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.