While Running Item Category Assignment Open Interface Request Getting Error 'You Cannot Delete A Mandatory Category Set' (Doc ID 363570.1)

Last updated on JUNE 12, 2023

Applies to:

Symptoms

User is trying to load item categories with the following process:

• Delete Default item categories.
• Load the mtl_item_categories_interface table with TRANSACTION_TYPE = DELETE
• Run "Item Category Assignment Open Interface" request and getting the error message as "You cannot delete a mandatory category set".

Changes

The problem still persists even after applying the <Patch 4060373> in 11.5.10.2 instance.

Patch Description : 
Old Behavior :
In Inventory => Items => Import => Import Item Category Assignment program does not support Transaction Type 'UPDATE'. Currently to update an item category assignment, 2 records with transaction types 'DELETE' and 'CREATE' have to be inserted in Item Category Interface table. The record with 'DELETE' transaction type would delete the existing category and the record with 'CREATE' transaction type would create the new category.

New Behavior :
After the fix, Import Item Category Assignment program will support Transaction Type 'UPDATE' for updating Item Category Assignments. To update an item category assignment, a single record with transaction type as 'UPDATE' has to be inserted in Item Category Interface table. In the Item Category Interface table, the existing category to be updated should be entered in columns Old_Category_Id or Old_Category_Name. The category to be updated should be entered in columns Category_Id or Category_Name.

Cause

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