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