EAP WTHD16 : Withholding Report Post 1099_RPT_PST abends at Step 1099_RPT_PST.PreProc.Step01A (Doc ID 2220998.1)

Last updated on JANUARY 06, 2017

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Withholding Report Post 1099_RPT_PST abends at Step 1099_RPT_PST.PreProc.Step01A with following error:


ERROR

1703 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 'FSTRN.dbo.PS_WTHD_1099_TMP2'; column does not allow nulls. UP DATE fails. [Microsoft][SQL Server Native Client 11.0][SQL Server]The st Failed SQL stmt: UPDATE PS_WTHD_1099_TMP2 SET PS_WTHD_1099_TMP2.ADDRESS_SEQ_NUM = ( SELECT MAX(WTRXN .ADDRESS_SEQ_NUM) FROM PS_WTHD_TRXN3_TMP WTRXN WHERE PS_WTHD_1099_TMP2.PROCESS_INSTANCE = WTRXN.PROC ESS_INSTANCE2 AND PS_WTHD_1099_TMP2.VENDOR_SETID = WTRXN.VENDOR_SETID AND PS_WTHD_1099_TMP2.VENDOR_I D = WTRXN.VENDOR_ID AND PS_WTHD_1099_TMP2.VNDR_LOC = WTRXN.VNDR_LOC AND PS_WTHD_1099_TMP2.WTHD_ENTIT

 
Process 1948416 ABENDED at Step 1099_RPT_PST.PreProc.Step01A (SQL) -- RC = 8601
 


STEPS
1.  After applying 1099 patch for year 2016 , run Withhold 1099 Report Job
Navigation: Main Menu > Suppliers > 1099/Global Withholding > 1099 Reports > Withhold 1099 Report Job

The Application Engine process 1099_RPT_PST in  in Job 1099 Job abends with above error

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms