While Running Item Category Assignment Open Interface Request Getting Error 'You Cannot Delete A Mandatory Category Set'
Last updated on FEBRUARY 26, 2018
Applies to:Oracle Inventory Management - Version 22.214.171.124 and later
Information in this document applies to any platform.
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".
The problem still persists even after applying the patch 4060373 in 126.96.36.199 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.
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