Oracle Inventory Interview Questions and Answers-3

Item Master Organization: you define an item in the Item Master, you can assign it to any number of other organizations.

There is no functional or technical difference between the Item Master organization and other organizations. However, for simplicity, Oracle recommends that you limit the Item Master to just an item definition organization.

You cannot associate items in one item master organization with
another item master organization.

Information such as unit of measure, description, and so on is
maintained at the Master level.


There are two types of attribute control:
Master Level
Item level.

A status code controls certain item attributes designated as status attributes. These attributes control the functionality of an item over time.

The status attributes are:
– BOM Allowed
– Build in WIP
– Customer Orders Enabled
– Internal Orders Enabled
– Invoice Enabled
– Transactable
– Purchasable
– Stockable

An item-defining attribute identifies the nature of an item. What designates an item as an “engineering item” is the attribute Engineering Item, but what controls the functionality of the item are the collection of attributes that describe it. You can buy an engineering item if you want to; simply set Engineering Item, Purchased, and Purchasable to Yes.

Each status attribute is dependent on the value of at least one other attribute. For example, you cannot set Stockable to Yes if you set Inventory Item to No.


What are pending statuses: 
We use pending statuses to automatically update an item’s status on a specified date. For each item, specify a list of pending statuses and the corresponding effective dates.

What are the relationships between attributes?

When you define items, Oracle Inventory enforces particular
relationships between some of the item attributes:

Required attribute—you must enter a value for the attribute
based on the settings for other related attributes.

Interdependent attributes—you can enter only certain values
depending on other attribute values.

Updatable attributes—you can update values under certain
conditions.

Control level dependencies—you can update the control level of
some attributes only under special conditions and with certain
consequences.


What are the item attribute controls we have?
Centralized control (Master level)
Decentralized control (item level)

What are the status settings we have for status attribute?

Defaults Value: Value of this attribute, as defined by the status code, defaults when you assign the status to an item. You can change this default value.

Not Used: Use neither default nor status control.

Sets Value: Value of this attribute, as defined by the status code, defaults when you assign the status to an item. Once assigned, you cannot change the default.

What are user item type item attributes?
The User Item Type item attribute is a Quick Code we use when we define an item. We can use the types provided by Oracle Inventory or create our own.

You cannot change the values in this field after saving them. To remove an obsolete Quick Code you can disable the code, enter an end date, or change the meaning and description to match a replacement code.

What are item templates?
Templates are defined sets of attributes that you can use over and over to create many similar items. Templates make initial item definition easier.

Copying Templates: To make defining templates easier, you can use the Copy From function on the Tools menu in the Item Templates window.

You can apply as many templates as you want to an existing item.

Indicate whether the template is restricted to use by only one
Organization. If you leave the organization code blank, you can use the template in any organization.

Why can’t we change the organization specific templates?
For organization specific templates, some attributes, such as the planner, may be tied to the organization. For this reason, you cannot change the organization specified in the template once the template has been defined.

Attention: If you enable a status attribute, its value will not be applied to the item if the status attribute is under status control.

What does Cross–Reference Types Define?
Cross–reference types define relationships between items and entities such as old item numbers or supplier item numbers.

How do you assign cross–references types to items from the Master Items.
Navigate to the Master Items Summary window.
2. Select an item.
3. Choose Cross References from the Tools menu.
4. Enter the cross–reference type name.
  Etc….

What are customer item commodity codes?
Customer Item Commodity Codes are used to group customer items
and can be entered during the definition of customer items.