My Oracle Support Banner

PL_LOAD_OPT Error at Step PL_LOAD_PO.InPlPO.IPlPO_V.SQL with SQL Error: ORA-00001: unique constraint (SYSADM.PS_PL_PLN_PO) violated (Doc ID 2585358.1)

Last updated on JUNE 08, 2020

Applies to:

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

Symptoms

PL_LOAD_OPT fails at step PL_LOAD_PO.InPlPO.IPlPO_V.SQL with error:

SQL Error: ORA-00001: unique constraint (SYSADM.PS_PL_PLN_PO) violated 

Steps to Reproduce Issue:

1) Select a few items (at least 3) set for purchase on each several business units.

Check ‘Demand Planning Item’ checkbox in ‘Planning –
General’ tab and define purchase attributes in ‘Planning – Order Modifiers’ tab.
 
2) Create a stock request of 50000 for
all these BU/items and check that a demand has been created for each stock
request in IN_DEMAND table with IN_FULFILL_STATE = ‘20’
 
3) Run reservation on each business unit.
 
4) Check that the first demand
line has been either reserved (IN_FULFILL_STATE= ‘ 30’) or cancelled (IN_FULFILL_STATE=
‘ 90’) and that a second demand line has been created for each demand with
IN_FULFILL_STATE = ‘20’ with the remaining unavailable quantities
 
5) Shut down planning engines on business units.
 
6) Run PL_LOAD_OPT on each planning
engine on each business unit
 
7) Start each planning engine at each business unit
 
8) Run
material solver for each planning instance on each business unit
 
Check that several new planned purchase orders have been created in
PL_PLN_PO table for each item /BU which had stock requests
 
9) Delete all already
existing rows in table PL_PO_PLAN_ORD for planning engines on each business unit.
 
10)  Freeze all planned purchase orders on each
planning instance at each business unit by running mass
maintenance (PL_PI_MSMNT):
 
11)  Shut down planning engines at each business unit and Post Updates for
both planning instances simultaneously using five different run controls and
by setting the same run time for all run control IDs:
 
12)  Check that the same SEQ_NBR has been used in table PL_PO_PLAN_ORD for planned purchase orders from different planning instances :
 
13)  Approve all planned purchase orders on each planning
instance of each business unitnd save:
 
14)  Load planning instance USBIKE :

Check that PL_LOAD_OPT fails
at step PL_LOAD_PO.InPlPO.IPlPO_V while
trying to insert into PL_PLN_PO table with the following error :
SQL Error: ORA-00001: unique constraint (SYSADM.PS_PL_PLN_PO) violated  


Changes

Not applicable. 

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.