Planning ODS Load of Data Collection completes with Error
Hi Folks,
Planning ODS Load of Data Collection completes with following Error/Warning.
16-JUL 13:17:14 : Error in PROCEDURE=LOAD_UOM, TABLE=MSC_UNITS_OF_MEASURE
16-JUL 13:17:14 : COLUMN=UOM_CODE, VALUE=KV
16-JUL 13:17:14 : COLUMN=UNIT_OF_MEASURE, VALUE=KILOVOLT
16-JUL 13:17:14 : ORA-00001: unique constraint (MSC.MSC_UNITS_OF_MEASURE_U2) violated
Source Output:
SELECT unit_of_measure,uom_code,uom_class
FROM mtl_units_of_measure
WHERE uom_code ='KV';
KILOVOLT KV VOLT
Destination Output:
SELECT unit_of_measure,uom_code,uom_class
FROM msc_units_of_measure
WHERE uom_code ='KV';
KILOVOLTS KV Current
As we can see from output,only uom_code matches on both sides.How to update/rectify this issue?