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 MAY 02, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
ConcurrentProgram:MSCSLPPR5 - Launch Supply Chain Planning Process

*** Checked for relevance on 3 May 2012 ***

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

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