Value Chain Planning - EBS (MOSC)

MOSC Banner

How to clean up the data from MSC_ITEM_ID_LID_N2?

Oracle App Version - 12.2.7

Issue:-

In Oracle planning application, Planning ODS Load getting errored with below message :-

27-NOV 10:40:14 : Failure in Transform Keys or Data Cleansing.
27-NOV 10:40:14 : Data cleansing process failed.
27-NOV 10:40:14 : ORA-0000: normal, successful completion
27-NOV 10:40:14 :  pST_STATUS= MSC_UTIL.G_ST_READY

And, Generate Items and Category Sets Keys program completing with warning. It has "ORA-00001: unique constraint (MSC.MSC_ITEM_ID_LID_N2) violated" error.

27-NOV 09:15:23 : The sql statement is  INSERT INTO MSC_ITEMS ( ITEM_NAME,   INVENTORY_ITEM_ID,   LAST_UPDATE_DATE,   LAST_UPDATED_BY,   CREATION_DATE,   CREATED_BY) VALUES ( :Item_Name,   :INVENTORY_ITEM_ID,   :v_current_date,   :v_current_user,   :v_current_date,   :v_current_user)
27-NOV 09:15:23 : The sql statement is  INSERT INTO MSC_ITEM_ID_LID ( SR_INVENTORY_ITEM_ID,   SR_INSTANCE_ID,   INVENTORY_ITEM_ID) VALUES ( :SR_INVENTORY_ITEM_ID,   :SR_INSTANCE_ID,   :INVENTORY_ITEM_ID)
27-NOV 09:15:49 : ========================================
27-NOV 09:15:49 : Error in PROCEDURE=GENERATE_ITEM_KEYS, TABLE=MSC_ITEM_ID_LID
27-NOV 09:15:49 : COLUMN=ITEM_NAME, VALUE=PRSVBA057D483  
27-NOV 09:15:49 : COLUMN=SR_INVENTORY_ITEM_ID, VALUE=15220490
27-NOV 09:15:49 : ORA-00001: unique constraint (MSC.MSC_ITEM_ID_LID_N2) violated
27-NOV 09:15:49 : ========================================
27-NOV

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