Financial Management - PSFT (MOSC)

MOSC Banner

1099_RPT_POST job fails

Hi,

Recently we applied the patch as of November 13 from Oracle for 2020 1099 process. When we run the 1099_RPT_POST job the very first process(1099_RPT_PST) in the job fails with the below error.

File: E:\pt85604d-retail\peopletools\src\psappeng\aebuf.cppSQL error. Stmt #: 584 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'WTHD_RPT_ID_N', table 'FSSUP2.dbo.PS_W1099_RPT_AET'; column does not allow nulls. INSER T fails. [Microsoft][SQL Server Native Client 11.0][SQL Server]The stat Failed SQL stmt: INSERT INTO PS_W1099_RPT_AET (PROCESS_INSTANCE,REQUEST_ID,RUN_CNTL_ID,WTHD_RPT_ID,W THD_RPT_ID_G,WTHD_RPT_ID_I,WTHD_RPT_ID_M,WTHD_ENTITY,WTHD_TYPE,CALENDAR_SETID,CALENDAR_ID,FISCAL_YEA R,PERIOD,SETID,WTHD_CNTL_ID,MANUAL_CHANGE_SW,LINE_NO,VENDOR_SETID,VENDOR_ID,DESCR,BUSINESS_UNIT,PAYE R_TIN,USE_RPT_DATE_IND) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center