ORA-00001: unique constraint (FUSION.MSC_MEASURE_DATA_U1) violated (Doc ID 2630829.1)

Last updated on AUGUST 07, 2024

Applies to:

Symptoms

On : 11.13.19.10.0 version, Demand Collections

When attempting to load Measures using File-Based Data Interface the process is failing with error.

ERROR
-----------------------
***** Execution started in LoadMaster *****
submitting Load request for entity MEASURES
MEASURES : 34161 : ORA-00001: unique constraint (FUSION.MSC_MEASURE_DATA_U1) violated
Submitting request for PurgeStagedData
BOLIST from Collections :MEASURES
errorEntity as actual run :MEASURES
INPUT BO List in ERP Flow :null
This flow is not via ERP Integration flow or BO List from ERP flow is Null.
Few entities moved to Error status, so finding their BO.
Inside getErrorBoFromEntity :
Final Input BO LIST :null
Request has been successfully submitted for PurgeStagedData with Request Id : 34165

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

ORA-06512: at "FUSION.MSC_COLL_MEASURES", line 7741

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

ORA-06512: at "FUSION.MSC_COLL_MEASURES", line 7992
ORA-06512: at "FUSION.MSC_COLL_MEASURES", line 5233
ORA-06512: at line 1
ORA-06512: at "FUSION.MSC_COLL_FRAMEWORK", line 1671

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

ORA-06512: at "FUSION.MSC_COLL_FRAMEWORK", line 1711
ORA-06512: at "FUSION.MSC_COLL_FRAMEWORK", line 3133

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Download FBDI template Supply Chain Planning Measures
2. Enter data into required fields
3. Generate csv file
4. Create zip file per FBDI template instructions
5. Upload ZIP file to the SFTP server location.
6. Log into Oracle Fusion Applications
7. Navigate to Scheduled Processes
8. Select the Load Interface File for Import Process
9. Select the process indicated in the Overview section to load the CSV file to the interface tables.
10. Review the results of the process.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.