MSCITTK: Generate Items and Category Sets Keys has error - ORA-00001: unique constraint (MSC.MSC_ITEM_ID_LID_N2) violated (Doc ID 2914222.1)

Last updated on FEBRUARY 22, 2023

Applies to:

Symptoms

When attempting to run the Data Collection process, the following child process completes with error:

MSCITTK: Generate Items and Category Sets Keys


ERROR

05-DEC 09:34:28 : Error in PROCEDURE=GENERATE_ITEM_KEYS, TABLE=MSC_ITEM_ID_LID
05-DEC 09:34:28 : COLUMN=ITEM_NAME, VALUE=A100
05-DEC 09:34:28 : COLUMN=SR_INVENTORY_ITEM_ID, VALUE=458548
05-DEC 09:34:28 : ORA-00001: unique constraint (MSC.MSC_ITEM_ID_LID_N2) violated
05-DEC 09:34:28 : ========================================
05-DEC 09:34:28 : Error in PROCEDURE=GENERATE_ITEM_KEYS, TABLE=MSC_ITEM_ID_LID
05-DEC 09:34:28 : COLUMN=ITEM_NAME, VALUE=A101
05-DEC 09:34:28 : COLUMN=SR_INVENTORY_ITEM_ID, VALUE=458549
05-DEC 09:34:28 : ORA-00001: unique constraint (MSC.MSC_ITEM_ID_LID_N2) violated
05-DEC 09:34:28 : ========================================
05-DEC 09:34:28 : Error in PROCEDURE=GENERATE_ITEM_KEYS, TABLE=MSC_ITEM_ID_LID
05-DEC 09:34:28 : COLUMN=ITEM_NAME, VALUE=A102
05-DEC 09:34:28 : COLUMN=SR_INVENTORY_ITEM_ID, VALUE=458550
05-DEC 09:34:28 : ORA-00001: unique constraint (MSC.MSC_ITEM_ID_LID_N2) violated


STEPS

The issue can be reproduced at will with the following steps:
1. Responsibility: Advanced Supply Chain Planner
2. Navigation > Collections > Oracle Systems > Standard Data Collections
3. Child process: Generate Items and Category Sets Keys completes with error

Changes

Updated the item names in Inventory Management caused this issue.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.