Value Chain Planning - EBS (MOSC)

MOSC Banner

Planning ODS Load of Data Collection completes with Error

edited Jul 29, 2016 5:06AM in Value Chain Planning - EBS (MOSC) 1 commentAnswered

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center