My Oracle Support Banner

Receive Error INV_CAT_CANNOT_CREATE_DELETE - Cannot Create/Delete Item Controlled category set from Organization Items When Trying To Import Item Category Assignments (Doc ID 2984081.1)

Last updated on NOVEMBER 06, 2023

Applies to:

Oracle Inventory Management - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

Following error is received when trying to import item category assignments:

INV_CAT_CANNOT_CREATE_DELETE - Cannot Create/Delete Item Controlled category set from Organization Items.


Steps

  1. Insert category assignment data into the Item Category Assignment import tables.
    Refer to Note 115557.1 - How to Use Item Open Interface (IOI) to Import Item Category Assignments

  2. Run the "Item Category Assignment Open Interface" request to import the data.
    Navigate: Inventory > Items > Import > Import Item Category Assignment

  3. Review the errors in MTL_INTERFACE_ERRORS table and see some records with the following error:

    INV_CAT_CANNOT_CREATE_DELETE - Cannot Create/Delete Item Controlled category set from Organization Items.
     

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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