My Oracle Support Banner

Order Release (IN_FUL_RLS ) Abends at Step IN_ORD_RLS.GetCReqH.InsDmHdr (Doc ID 2616115.1)

Last updated on JULY 22, 2020

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.2 to 9.2 [Release 9]
Generic (Platform Independent)

Symptoms

Order Release process (IN_FUL_RLS) process failing with following error
02:41:48.392 Process 164601 ABENDED at Step IN_ORD_RLS.GetCReqH.InsDmHdr
(Action SQL) -- RC = 805
ROLLBACK

Detail Error

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1708 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_IN_RLS_DH_TAOx) violated
Failed SQL stmt: INSERT INTO PS_IN_RLS_DH_TAO26 (PROCESS_INSTANCE, PROCESSING_GROUP, BUSINESS_UNIT, DEMAND_SOURCE, SOURCE_BUS_UNIT, ORDER_NO, PICK_BATCH_ID, REQ_ID) SELECT DISTINCT B.PROCESS_INSTANCE, B.PROCESSING_GROUP, B.BUSINESS_UNIT, B.DEMAND_SOURCE, B.SOURCE_BUS_UNIT, B.ORDER_NO, B.PICK_BATCH_ID, C.REQ_ID FROM PS_IN_RLS_DMD_TAO B, PS_IN_DEMAND C WHERE B.PROCESS_INSTANCE = 4932859 AND B.PROCESSING_GROUP = 1 AND B.BUSINESS_UNIT = 'xxxx' AND B.DEMAND_SOURCE IN ('PR', 'PO') AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.DEMAND_SOURCE = B.DEMAND_SOURCE AND C.SOURCE_BUS_UNIT = B.SOURCE_BUS_UNIT AND C.ORDER_NO = B.ORDER_NO AND C.ORDER_INT_LINE_NO = B.ORDER_INT_LINE_NO AND C.SCHED_LINE_NBR = B.SCHED_LINE_NBR AND C.INV_ITEM_ID = B.INV_ITEM_ID AND C.DEMAND_LINE_NO = B.DEMAND_LINE_NO

Process  ABENDED at Step IN_ORD_RLS.GetCReqH.InsDmHdr (SQL) -- RC = 805 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

STEPS
1. Create a requisition
2. Two schedules for one line with different Ship To and different Ship Via
3. Run Auto sourcing to create a new Material Stock Request
4. Run Reservation process
5. Run Order release process


Changes

 Not available

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.