Top 20 Oracle Inventory Interview Questions You Must Prepare 24.Apr.2024

Prerequisites:

Define an inventory item that is common to both organizations. Define at least two organizations, one of which is valid to receive material from the other. Set up inter–organization relationships and their corresponding accounts. Like Shipping Network.  For direct trfers, if the item to trfer is under serial number control, the item must have the same unit of measure in each organization. 

  • System Item
  • Item Catalog
  • Item Categories
  • Stock Locator
  • Account Aliases

  1. All the 6 key flex fields i.e. Items, Item Catalog, Account Alias, Sales Order, Locator and Item Category 
  2. Organizations
  3. Change Organizations
  4. Intercompany Relations
  5. Unit of Measure Classes
  6. Sub inventories
  7. Item Attribute Controls, Categories
  8. Default Category set
  9. Item Statuses
  10. Cost types
  11. Profile Options
  12. Inventory Accounting Periods

A traction action is a predefined method of changing the quantity and/or location and/or cost of an item. It is used in Traction Type form.

Depending on the inter–organization trfer charge that applies between the organizations, a percentage of the traction value or a discrete amount that Oracle Inventory uses to compute trfer charges.

Yes, you can do by setting the profile option INV: Traction Date validation to Provide warning when date in past period or Allow date in any open period. It allows entry of a past date.

INVENTORY_ITEM_STATUS_CODE is the Colum in table MTL_ITEM_STATUS will tell you the different status for item while you defining the item in item master form (INVIDITM). You can have different status as shown in below, also u can define your own custom status in status code form in item setups (INV DOIS)like “easyapps”.

Active, Inactive, Engineer, Obsolete, Phase-Out, Prototype, OPM, Lease, Production, Concept, Design, DEM_Status, Pending.

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.

No, you can not apply it to Average Costing Organization. However you can apply it to Standard Costing Organization.

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

Inventory Interface Program populates the interface tables with tractions submitted through Confirm shipment forms. It updates order lines with shipped quantities and updates inventory.

There are 4 inventory Planning methods as mentioned below:

  1. Min-max planning
  2. Re-order point planning
  3. Kanban planning 
  4. Periodic Automatic Replenishment(PAR)

Org Id is a unique ID for the Operating Unit. Organization Id: The Organization Id is an ID for the Inventory Organization which is under an Operating Unit.

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.

Yes, you can change it if you have set the profile option INV: Updatable Customer Item to Yes and INV: Updatable item to Yes respectively.

There are two types of templates:

Predefined and Custom Template.

Predefined templates are planning item, purchased, outside processing item, lease item. So that once you assign any template, to new item then all default characters are assign to new item.

  1. Cycle counting is the periodic counting of individual items throughout the course of the year to ensure the accuracy of item. Physical Inv. counts the entire inventory once a year Physical Inv. takes a snapshot of inv.'s on-hand quantity at the beginning of the process. All adjustments are made against snapshot quantity.
  2. In cycle counting fewer items are counted each day so less disruption to normal production or distribution In PI all items are counted once a year so a lot of disruption.

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.