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:
Oracle Inventory Management - Version 11.5.10.2 and laterInformation 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
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 |
Changes |
Cause |
Solution |
References |