MSCSLPPR5: Unique Constraint (MSC.MSC_SOLVER_GROUPS_U1) Violated

(Doc ID 2305215.1)

Last updated on SEPTEMBER 07, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

12.2.5

PROBLEM
-------------
Error launching the plan


MSCSLPPR5: Launch Supply Chain Planning Process
+---------------------------------------------------------------------------+

Current system time is 28-JUL-2017 06:37:41

+---------------------------------------------------------------------------+

**Starts**28-JUL-2017 06:37:41
**Ends**28-JUL-2017 06:37:41
ORA-20000: ORA-00001: unique constraint (MSC.MSC_SOLVER_GROUPS_U1) violated:p_source_plan_id9032 p_dest_plan_name9032 p_dest_plan_descATP Production Plan - EDD p_dest_plan_type1 p_dest_atp2 p_dest_production2 p_dest_notifications2 p_dest_inactive_on p_organization_id1612 p_sr_instance_id2021
ORA-20000: ORA-00001: unique constraint (MSC.MSC_SOLVER_GROUPS_U1) violated:p_source_plan_id9032 p_dest_plan_name9032 p_dest_plan_descATP Production Plan - EDD p_dest_plan_type1 p_dest_atp2 p_dest_production2 p_dest_notifications2 p_dest_inactive_on p_org
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

index - MSC_SOLVER_GROUPS_U1
PLAN_ID
ORGANIZATION_ID
SR_INSTANCE_ID
SOLVER_GROUP_ID

STEPS
--------
This is ATP 24x7 plan launch

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