Oracle Inventory Interview Questions - Part I

What is an Item?

Item is a part or service you Purchase, Sell, Buy, Plan, Manufacture, Stock, Distribute and a Prototype. It can also be the containers and the components you build into other items.

What is Item Master Organization?

An item master organization is a logical entity that you use to define items. After you define an item in the item master, you can assign it to any number of other organizations. You should also define one item master organization per implementation. When you define an item, Oracle automatically changes your current organization to the master organization.

What is an Inventory Organization?

Inventory Organization is a facility where you store and transact items. It can be a manufacturing unit, warehouse, distribution centre, item master organization (logical entity), etc.

What is subinventory?

Subinventories are unique physical or logical separations of material inventory, such as raw inventory, finished goods, or defective material. All material within an Inventory Structure organization is held in a subinventory therefore, you must define at least one subinventory.

What is Locator?

Locators are structures within Subinventories. Locators are the third level in the enterprise structuring schema of Oracle Inventory. Locators may be a row, bin, aisles in a warehouse. Stock locators are used to identify physical areas where you store inventory items. Item quantities can be tracked by locator. Items can also be restricted to specific locators.

Can you copy inventory org structure?

Yes. But can copy only organizations within the same operating unit.

What is Shipping Network?

An inter-organization shipping network describes the relationships and accounting information between a shipping organization and a destination organization. You must define a shipping network between two organizations before you can transfer material between organizations. When you setup a shipping network you must select a transfer type as Intransit or direct.

Explain Intransit and Direct Transfers?

In Intransit transfer, Oracle Inventory moves material to an intermediary state before it reaches the destination organization, and a receipt transaction is required in the destination organization once the material arrives in order to retrieve it.

In Direct transfer, Oracle Inventory moves the material directly to the destination organization.

Explain UOM and UOM class?

Unit of measure classes represent groups of units of measure with similar characteristics. For example, quantity is a unit of measure class and each, dozen, and gross are examples of units of measure within the class.

What is the difference between category and category set?

Categories and Category Sets can be used to group the items for various reports and programs.

A category is a logical classification of items that have similar characteristics.

A category set is a distinct grouping scheme and consists of categories.

How do you assign items to item categories?

1. Navigate to the Category Set window.

2. Enter a category set.

3. Choose Assign. The Item Assignment window appears.

4. Select the item from the current organization to assign to the category.

5. Select a category.

The list of values contains categories with the same flexfield structure as the category set you selected in the Category Set window. If Enforce the list of valid categories is selected the list is limited to those categories.

6. Save your work.

(Or)

1. Navigate to the Master Items Summary or Organization Items Summary window.

2. Select an item.

3. Choose Categories from the Tools menu.

The item you selected appears at the top of the Category Assignment window.

4. Select a category set

5. Select a category.

The list of values contains categories with the same flexfield structure as the category set you selected. If Enforce the list of valid categories is selected the list is limited to those categories.

6. Save your work.

How do you load / import items?

Navigate to Items à Import Items

Items can be imported using Open Item Interface.

You can import and update items, and their category assignments from any source into Oracle Inventory and Oracle Engineering using the Item Interface.

With this interface, you can convert inventory items from another inventory system, migrate assembly and component items from a legacy manufacturing system, convert purchased items from a custom purchasing system, and import new items from a Product Data Management package.


Read Oracle Inventory Interview Questions - Part II