My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

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

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

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.