Although duplicate Item creation is not allowed in Oracle, often times you would come across duplicate Items created in INV, PIM such that the creation date and time is exact same to the level of the milliseconds.
This is a rare scenario, but when undetected it could hamper transactions. Oracle has provided a solution to fix this issue manually. Below are the steps for correction of the duplicate items, which has different inventory IDs but same Item number.
| Objective | How to rectify duplicate Items created in Oracle EBS |
|---|---|
| Application | Oracle EBS |
| Things to Note | Duplicate Items are created in MTL_SYSTEM_ITEMS_B with exact same segment1 but different inventory_item_id |
| Step1 | Select 'System Administrator' responsibility |
| Step2 | Change profile option 'INV: Updateable Item name' to 'Yes' for your responsibility or user |
| Step3 | Navigate to: Inventory > Items > Master Items |
| Step4 | Click on the Folders tab located in vertical top left with folder icon |
| Step5 | Using the wild card (%) and F11 / ctrl F11 query the duplicate items by entering only a portion of the item name |
| Step6 | Both the Items will be displayed |
| Step7 | Change Item number for one of the Item to unused item name. Ensure the Item to be changes is correct by looking at the description. You can also use, Help > Diagnostics > Examine to view the inventory_item_id |
| Step7 | Save changes. Now search for both the Items independently with new names to ensure Item numbers have been changed |
If above solution does not work, or if you want to solve the duplicate issue from backend, you should open an
SR for Oracle Customer Support to provide a datafix script.
