MSCSLPPR5 Launch Supply Chain Planning process errors ORA-20000: ORA-00001: Unique Constraint (Msc3.Msc_plans_u1) Violated (Doc ID 1124024.1)

Last updated on JULY 02, 2019

Applies to:

Symptoms

 MSCSLPPR5 module: Launch Supply Chain Planning Process errors with the following:

ORA-20000: ORA-00001: unique constraint (MSC3.MSC_PLANS_U1) violated:INSERT INTO MSC_PLANS(plan_id,sr_instance_id,organization_id, compile_designator,last_update_date, last_updated_by, creation_date, created_by, last_update_login, curr_operation_schedule_type, curr_plan_type, plan_type, curr_overwrite_option, curr_append_planned_orders, append_planned_orders, curr_part_include_type, curr_planning_time_fence_flag, curr_demand_time_fence_flag, curr_consider_reservations, curr_plan_safety_stock, curr_conside
ORA-20000: ORA-00001: unique constraint (MSC3.MSC_PLANS_U1) violated:INSERT INTO MSC_PLANS(plan_id,sr_instance_id,organization_id, compile_designator,last_update_date, last_updated_by, creation_date, created_by, last_update_login, curr_operation_schedule_

 STEPS
--------
1.  Run the ASCP Plan
2.  The MSCSLPPR5 concurrent program errors

Cause

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