Costing Category Assignment Change Does Not Update Default Material Overhead Rate
Last updated on MARCH 08, 2017
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms