My Oracle Support Banner

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 later
Information in this document applies to any platform.

Symptoms

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

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

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