EGL/AP: Voucher Build Process ABENDED at Step GL_AA_EDIT.LOGERROR.StepXX (SQL) -- RC = 8601 (108,524) (Doc ID 1517171.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.1 [Release 9]
PeopleSoft Enterprise FIN Payables - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

ENVIRONMENT
--------------------
Application 9.10 with bundle level 20
tools 8.52.10

ISSUE
---------
AP - Batch Processes - Vouchers - Voucher Build process runs to status of 'No Success'.

ERROR:
Log file shows
**********************************
File: e:\pt85210b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1620 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert the value NULL into column 'MESSAGE_PARM4', table 'FSPROD.dbo.PS_TSE_ACCTLN_FLD'; column does not allow nulls. INSERT fails.

Failed SQL stmt:INSERT INTO PS_TSE_ACCTLN_FLD (TSE_JOBID , TSE_PROC_INSTANCE , TSE_SET_NBR , TSE_EDIT_TYPE , TSE_FIELDNAME , MESSAGE_SET_NBR , MESSAGE_NBR , MESSAGE_PARM , MESSAGE_PARM2 , MESSAGE_PARM3 ,BUSINESS_UNIT,DISTRIB_LINE_NUM,VOUCHER_ID,VOUCHER_LINE_NUM) SELECT DISTINCT 'GL_AA-EDIT' , 3109425 , 000001 , 'A' , 'ALTACCT' , 09600 , 00076 , ' ' , ' ' , ' ' ,BUSINESS_UNIT,DISTRIB_LINE_NUM,VOUCHER_ID,VOUCHER_LINE_NUM FROM PS_VED_CMB_TAO7 WHERE BUSINESS_UNIT_GL = '30840' AND PROCESS_INSTANCE IN (3109425, 9003109425) AND CHART_EDIT_STATUS = 'c'
 
Process 3109425 ABENDED at Step GL_AA_EDIT.LOGERROR.Step04 (SQL) -- RC = 8601 (108,524)

BUSINESS IMPACT
-------------------------
Unable to run voucher build

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