Item Attributes & Groups

Item Attributes

Item attributes are the collection of information about an item. 

Item Attribute Groups

The Items defined in Inventory can be used in different functional areas based on attributes. Attribute are the properties which are used to control how to use these items in different functional areas. Attributes are almost 265 which are come with the package.

The entire 265 attributes are divided into 17 tabbed regions/groups (Excluding Mai Tab).

Each Attribute can be controlled at two levels

·         Master Level

·         Organization Level

If an attribute is controlled at master level we can set this attribute only at master level and when we assigned this item to the member organization we are not allowed to change the attribute which are controlled at master level.

If an attribute is controlled at organization level we can set this attribute at master level or organization level and when we assigned an item to the member organization we can over rite the attribute which are controlled at organization level.

Navigation: mcr inv > Setups à Items > Attribute Controls and Press Ctrl +F11 Key.

Here the inventory Item is controlled at Master Level.

 
Define an Item as MI-Attr01 in Mater Item 
Navigation: mcr inv > Items > Master Items > MIH (Inv. Org.)

 

Assign the item MI-Attr01 to MIB through Tools à Organization Assignment option.

 

To open the item attributes at member organization we have two options.

1.   When we assign the item to member organization where we have a button called Org Attributes, if we click on it, we can see the item attributes which are disable or enable based on Member or Organization levels.

2.   Switch to Member Organization (MIB) through Change Organization option and go to Items > Organization Items > enter the item as MI-Attr01 > Find

Here Attribute Inventory Item is controlled at Master Level so can set this attribute at Master Level only and when we assigned this item to the member organization (MIB) we are not allowed to change the attribute which are controlled at master level (Grade out).

 

Item Statuses & Attributes

You can use statuses to provide default values for certain item attributes to control the functionality of an item. The Item Status attribute has a defined set of yes or no values for the status attributes. You apply the values to the status attributes when you choose an item status code when you define an item. When the item is ready, you change the Item Status attribute to Active to enable all item functions.

You can assign one or more pending statuses for an item, to be implemented on future dates. These statuses become effective on their assigned effective dates. You can view the status history of an item if needed.

Status Attributes: Status Attributes are the controls which are dependent on some group attributes they can be defaulted based on status settings. We can use statuses to provide default values for certain item attributes to control the functionality of an item. Status Settings are three types.

Defaults Value: If the status setting is “Defaults Value” the status attribute will be enabled by default and will be allowed for editing.

Sets Value: If the status setting is “Sets Value” the status attribute will be enabled but will not be allowed for editing.

Not Used: If the status setting is “Not Used” the status attribute will not enabled but will be allowed to make the changes/editing.

Navigation: mcr inv > Setups > Items > Attribute Controls and Keep the cursor at Status Attributes and Press Ctrl +F11 Key.

Define Item Template for Item Attribute:

Oracle Inventory has several predefined templates that we can use to define and update items or we can create our own templates.

If we regularly define many items that share the same values for a number of attributes, we may require defining item template. We can only use copy once when we define an item.

We can enable attributes and assign them values in each template that we create. When we apply a template to an item, Oracle inventory updates only the attribute that are enabled for the template.

To Create Item Template:

Navigation: mcr inv à Setups à Items à Templates à New.

Enter the values for Inventory, Purchasing and Order Management as per the below screen shot and save the changes.

Backend Table for Item Template:

SELECT * FROM MTL_ITEM_TEMPLATES WHERE TEMPLATE_NAME='MCR Temp'

Define Item in the Master Item by using Item Template MCR Temp

Navigation: mcr inv à Items à Master Items à MIH (Inv. Org.)

Click on Apply and Done. Now all item attribute has copied as per the template.