EBS: PS: MSC_SCP PS Launch PS Plan Fails With Unique Constraint Error (Doc ID 1530387.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

Oracle Production Scheduling - Version 12.1.3.8 and later
Information in this document applies to any platform.

Symptoms

Launch PS Plan that has an associated ASCP Plan, fails with ORA-00001 unique constraint

ORA-00001: unique constraint (MSC.MSC_WORK_ORDER_OPERATION_PK) violated

 

Operation Sequence Number and Resource Sequence Number for some Flow manufacturing resources appear as "0" in ASCP planned order resources requirements form which is causing an hard error in PS Launch process

 

 

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