Inventory Demand (PO_REQINVS) Process Abends with a Unique Constraint at Step PO_REQINVS.IS6000.INTEMDM2 (SQL) -- RC = 805 (Doc ID 2020138.1)

Last updated on JANUARY 13, 2017

Applies to:

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

Symptoms

When requisition with multiple distribution is sourced from inventory the build demand process runs to no-success with unique constraint error.

ERROR:

Process nnnnn ABENDED at Step PO_REQINVS.IS6000.INTEMDM2 (SQL) -- RC = 805

SQL error. Stmt #: 1625 Error Position: 0 Return: 805 - ORA-00001: unique constraint (UNDPFS.PS_IN_DEMAND1_T21) violated Failed SQL stmt:INSERT INTO PS_IN_DEMAND1_T21 (PROCESS_INSTANCE ,BUSINESS_UNIT ,DEMAND_SOURCE ,SOURC E_BUS_UNIT ,ORDER_NO ,ORDER_INT_LINE_NO ,SCHED_LINE_NBR ,INV_ITEM_ID ,DEMAND_LINE_NO ) SELECT B.PROC ESS_INSTANCE ,A.BUSINESS_UNIT ,B.DEMAND_SOURCE ,IND.SOURCE_BUS_UNIT ,B.ORDER_NO ,IND.ORDER_INT_LINE_ NO ,IND.SCHED_LINE_NBR ,C.INV_ITEM_ID ,0 FROM PS_DF_SETUP_INV A ,PS_PO_DEMAND_WRK1 B ,PS_MASTER_ITEM _TBL C ,PS_IN_DEMAND IND WHERE A.BUSINESS_UNIT = IND.BUSINESS_UNIT AND A.IN_NSFT_RSV_ST_FLG = '1' AN D B.PROCESS_INSTANCE = 33975785 AND B.BUSINESS_UNIT = IND.SOURCE_BUS_UNIT AND B.BUSINESS_UNIT_IN = I ND.BUSINESS_UNIT AND B.DEMAND_SOURCE = IND.DEMAND_SOURCE AND B.ORDER_NO = IND.ORDER_NO AND B.LINE_NB
Errors

SQL error. Stmt #: 1625 Error Position: 0 Return: 805 - ORA-00001: unique constraint


STEPS:


1. Create a Req that will source from inventory with 2 distributions
2. Go to Requisition Selection to stage the req
3. Find the requisition, unselect Define PO and select the row with the req and save
4. Run Inventory Demand (PO_REQINVS)

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