My Oracle Support Banner

Fusion Source Collection Fails With ORA-00001: Unique Constraint (FUSION.MSC_RESERVATIONS_U1) Violated (Doc ID 2490855.1)

Last updated on AUGUST 24, 2020

Applies to:

Oracle Fusion Planning Central Cloud Service - Version 11.13.18.05.0 and later
Information in this document applies to any platform.

Symptoms


When attempting to run Planning collections from a Fusion Source, the following error occurs.


ERROR

ORA-00001: unique constraint (FUSION.MSC_RESERVATIONS_U1) violated
ORA-00001: unique constraint (FUSION.MSC_RESERVATIONS_U1) violated

ORA-06512: at "FUSION.MSC_COLL_OTH_SUPPLIES", line 6078

ORA-00001: unique constraint (FUSION.MSC_RESERVATIONS_U1) violated
ORA-00001: unique constraint (FUSION.MSC_RESERVATIONS_U1) violated

ORA-06512: at "FUSION.MSC_COLL_OTH_SUPPLIES", line 6090
ORA-06512: at "FUSION.MSC_COLL_OTH_SUPPLIES", line 6288

ORA-00001: unique constraint (FUSION.MSC_RESERVATIONS_U1) violated
ORA-00001: unique constraint (FUSION.MSC_RESERVATIONS_U1) violated

ORA-06512: at "FUSION.MSC_COLL_OTH_SUPPLIES", line 6361
ORA-06512: at line 1
ORA-06512: at "FUSION.MSC_COLL_FRAMEWORK", line 1468

ORA-00001: unique constraint (FUSION.MSC_RESERVATIONS_U1) violated
ORA-00001: unique constraint (FUSION.MSC_RESERVATIONS_U1) violated

ORA-06512: at "FUSION.MSC_COLL_FRAMEWORK", line 1480
ORA-06512: at "FUSION.MSC_COLL_FRAMEWORK", line 2849


STEPS TO REPRODUCE
1. Navigate to Supply Chain Planning -> Planning Central
2. Open right task panel and select Collect Planning Data
3. Select collection mode and desired entities
4. Launch job
5. Hit the error


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
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.