My Oracle Support Banner

Costing Category Assignment Change Does Not Update Default Material Overhead Rate (Doc ID 2101194.1)

Last updated on JUNE 08, 2021

Applies to:

Oracle Item Master - Version 12.2.4 and later
Information in this document applies to any platform.
Costing Category Set
Default Material Overhead Rate


On : 12.1.3 version, Cost Maintenance


When using INV_ITEM_CATEGORY_PUB.UPDATE_CATEGORY_ASSIGNMENT API to change category assignment, where the Default Material Overhead rate value is different for the new category, the Item is not getting updated with the new value.

If the change in category assignment takes place via the form, then the Default Material Overhead Rate associated with the new category is updated in the item.


Default Material Overhead Rate will update for Existing Items when category assignment is changes whether by form or API


The issue can be reproduced at will with the following steps:

We have executed following steps to update Default Material Overhead Rates-

1. Item Conversion and Item assignment to Inventory Organization done
2. Costing Category automatically assigned the Default Category value to all items in all Inventory organizations-and the associated value Material Overhead Default rate automatically assigned in Item Frozen cost also in all Inventory Organizations
3. Create a new Costing Category with a new Material Overhead rate.
4. Update Costing Category assignment value from Default to New Category using INV_ITEM_CATEGORY_PUB.UPDATE_CATEGORY_ASSIGNMENT API

Expected behavior:
Material Overhead Rate for Items in Inventory Org should change to new rate defined as Costing Category value updated using API

Current Result and Observation:

While we update Costing Category value from the Default to New category manually from Oracle Forms ;Material Overhead default value is getting updated properly but while Costing Category value is updated using API Material Overhead Default value is not getting updated at all.


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

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