ODS ends with warning due to the mismatch in UOM code.
During the Data Collection, ODS ends with the following warning message.
----------------------------------------------------------------------------------------------------------
16-DEC 00:34:09 : Error in PROCEDURE=LOAD_UOM, TABLE=MSC_UNITS_OF_MEASURE
16-DEC 00:34:09 : COLUMN=UOM_CODE, VALUE=AAA
16-DEC 00:34:09 : COLUMN=UNIT_OF_MEASURE, VALUE=AAA- TESTING
16-DEC 00:34:09 : ORA-00001: unique constraint (MSC.MSC_UNITS_OF_MEASURE_U2) violated
----------------------------------------------------------------------------------------------------------
Here the Unit Of Measures between Source & Planning instance are different for UOM Code 'AAA'. This causing to the unique constraint violation.
Dont know how to correct the UOM for the problematic UOM code.
Please sugest how do it.
Would it be possible to correct from the application or need to go for data edit?