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

Last updated on AUGUST 21, 2016

Applies to:

Oracle Inventory Management - Version: 11.5.10.2 and later   [Release: 11.5.10 and later ]
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms