12.2.3 - Loader Worker Fails With ORA-00001: Unique Constraint (MSC.MSC_SUPPLIES_U1) Violated (Doc ID 1910105.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

12.2.3

PROBLEM
-------------
1. Loader worker is failing with
value used for ROWS parameter changed from 1000 to 31
Record 4801: Rejected - Error on table "MSC"."MSC_SUPPLIES#".
ORA-00001: unique constraint (MSC.MSC_SUPPLIES_U1) violated

2. The BAD file shows line with TRANSACTION_ID = 18 / order_type = 11
-- all other transaction_id are above 370,000,000

3. We queried using
select * from msc_Supplies where TRANSACTION_ID = 18;
- this transaction_id does NOT EXIST in the collected data.
- this returned 1 row only for plan_id >0 - our failed plan.

4. We purged the plan having this data.

5. We created new plan - Ran plan and it failed in MBP - - l1019616.req in After_OWC.zip

Then setup profiles to get complete DAT files
6. Ran plan once more and again it failed again in loader worker with TRANSACTION_ID = 18;
-- again, this does not exist on collected data.
-- see DAT files and requests - l1019646.req and l1019650.req in After_OWC.zip

STEPS
--------
Run plan and see failure for this one org / item

EXPECTED BEHAVIOR
----------------------------
plan would not fail.

BUSINESS IMPACT
----------------------
cannot run plan for this division of our company.

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