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

Last updated on APRIL 04, 2025

Applies to:

Symptoms

On : 12.1.3 version, Cost Maintenance

ACTUAL BEHAVIOR


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.

EXPECTED BEHAVIOR

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

STEPS

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.

Cause

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