My Oracle Support Banner

Collections Error at BOM_COMPONENTS : ORA-00001: unique constraint (FUSION.MSC_KEYS_U2) violated (Doc ID 2596773.1)

Last updated on FEBRUARY 05, 2020

Applies to:

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

Symptoms

PROBLEM STATEMENT
----------------------

When trying to Collect Work Definitions from EBS to Fusion Integration, Collections process ends in Error.

Load Entity logs show below error:


ERROR
-----------------------
ORA-00001: unique constraint (FUSION.MSC_KEYS_U2) violated

STEPS TO REPRODUCE ISSUE
-----------------------
The issue can be reproduced at will with the following steps:
1. Extract files from EBS
2. Upload files
3. BOM_COMPONENTS load entity ends in error


Changes

 

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