Purchasing Requisition Loader (PO_REQLOAD) ABENDED at Step PO_REQLOAD.DFLINSP.INSPCD (SQL) -- RC = 8601 (108,524) (Doc ID 1916492.1)

Last updated on NOVEMBER 01, 2016

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

PO_REQLOAD abends when processing data for an adhoc item and the System Source = FRM.

Error:  Process ABENDED at Step PO_REQLOAD.DFLINSP.INSPCD (SQL) -- RC = 8601 (108,524)

Error Position: 0  Return: 8601 - [Microsoft][SQL Server Native Client 10.0]
SQL Server]Cannot insert the value NULL into column 'INSPECT_CD', table 'FSMMSND.dbo.PS_RQLD_LOAD1_T4'; column does not allow nulls. UPDATE fails.
[Microsoft][SQL Server Native Client 10.0][SQL Server]The statem
Failed SQL stmt:UPDATE PS_RQLD_LOAD1_T4 SET INSPECT_CD = ( SELECT inspect_cd FROM ps_itm_cat_tbl ITM , PS_SET_CNTRL_REC ITM_SET ,
PS_PO_REQLOAD_RQST PRR WHERE PRR.SYSTEM_SOURCE = 'BPO' AND PRR.LOADER_LINE_STATUS = '2'
AND PRR.PROCESS_INSTANCE = 13596 AND ((PRR.BUSINESS_UNIT_AM = ' ' OR PRR.PROFILE_ID = ' ')
OR (PRR.BUSINESS_UNIT_AM > ' ' AND PRR.PROFILE_ID > ' '))
AND PRR.inv_item_id = ' ' AND ITM_SET.setcntrlvalue = PRR.loader_bu AND ITM_SET.recname = 'MASTER_ITEM_TBL'
AND ITM.setid = ITM_SET.setid AND ITM.category_id = PRR.category_id AND ITM.eff_status = 'A'
AND ITM.effdt = ( SELECT MAX(effdt) FROM PS_ITM_CAT_TBL B WHERE B.SETID = ITM.SETID
AND B.CATEGORY_ID = ITM.CATEGORY_ID AND B.eff_status = ITM.eff_status AND B.effdt <= { fn CURDATE() })
AND prr.loader_req_id = PS_RQLD_LOAD1_T4 .replenish_id AND PRR.GROUP_SEQ_NUM = PS_RQLD_LOAD1_T4 .GROUP_SEQ_NUM)
WHERE PS_RQLD_LOAD1_T4 .inv_item_id = ' '


Steps to recreate the issue:
1. Create a new Req Load Defaults for System Source = FRM and Business Unit = US010
2. Create a 'Stage for Loading' row using FRM and Loader BU = US010
3. The Item entered must be an Adhoc item.
4. Run PO_REQLOAD.
5. Process abends.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create requisitions using this functionality for adhoc items.

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