Inventory Demand (PO_REQINVS) Abends at Step PO_REQINVS.IS6000.ISRTHDRC (SQL) - RC = 805 (108,524) (Doc ID 2256739.1)

Last updated on JULY 10, 2017

Applies to:

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

Symptoms

Inventory Demand (PO_REQINVS) failure with unique constraint error and abends at Step PO_REQINVS.IS6000.ISRTHDRC.

Stmt #: 1708 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_ISSUE_HDR_INV) violated
Failed SQL stmt: INSERT INTO PS_ISSUE_HDR_INV( BUSINESS_UNIT , DEMAND_SOURCE , SOURCE_BUS_UNIT , ORDER_NO , FULFILL_FLAG , INTERNAL_FLG , REQUEST_TYPE) SELECT DISTINCT D.BUSINESS_UNIT_IN , D.DEMAND_SOURCE , D.BUSINESS_UNIT , D.ORDER_NO , 'N' , D.INTERNAL_FLG , D.REQUEST_TYPE FROM PS_PO_DEMAND_WRK1 D WHERE PROCESS_INSTANCE = 43494414 AND NOT EXISTS ( SELECT 'X' FROM PS_PO_DMDKEY_TMP K WHERE K.PROCESS_INSTANCE = D.PROCESS_INSTANCE AND K.BUSINESS_UNIT = D.BUSINESS_UNIT_IN AND K.DEMAND_SOURCE = D.DEMAND_SOURCE AND K.SOURCE_BUS_UNIT = D.BUSINESS_UNIT AND K.ORDER_NO = D.ORDER_NO AND K.RECORD_TYPE = 'E')

Process 43494414 ABENDED at Step PO_REQINVS.IS6000.ISRTHDRC (SQL) -- RC = 805 (108,524)

ABENDED at Step PO_REQINVS.IS6000.ISRTHDRC (SQL) -- RC = 805 (108,524)

 
STEPS
The issue can be reproduced at will with the following steps:
1 - Create a requisition that gets sourced from inventory
2 - To simulate the concurrent process, include the next steps:
  2a. Add the sleep step in PO_REQINVS.IS6000 after step DELTEDM2
  2b. Add the code in the TEST Step (in the attached replication instructions)
  2c. Add new program id under navigation: PeopleTools > Utilities > Administration> String Table
  2d. Set the STRING TEST as 0 to stop the program.
3 - Run PO_AUTO_SRC informing Requisition id. Wait for the program status = ‘Inv Demand Build in Process’.
4 - Make sure that the row created in PS_IN_DEMAND: SELECT * FROM PS_IN_DEMAND WHERE REQ_ID = '0000000188'
5 - Run Reserve Material process
6 - Run Order Release Request
7 - Set the STRING TEST as 1 continue PO_AUTO_SRC process.



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