Oracle Inventory Interview Questions and Answers-2

⦁ What are the Inter–Organization Transfer accounts?

Transfer credit
Payable
Receivable
Intransit inventory
Purchase price variance

⦁ What is a sub inventory?
Sub inventories are unique physical or logical separations of material inventory, such as raw inventory, finished goods, or defective material.

All material within an organization is held in a sub inventory therefore, you must define at least one sub inventory.

⦁ What is quantity tracked in sub inventory? What is it its relevance?

It Indicate whether each transaction for this sub inventory updates the quantity on hand for the sub inventory (Quantity Tracked).

If you leave this option unchecked, on–hand balances are not
maintained and you cannot check or update the Asset Inventory,
Include in ATP, Reservable, or Nettable options.

* Asset Sub inventory: Indicate whether to maintain the value of this sub inventory on the balance sheet (Asset Sub inventory).

⦁ Nettable:  Indicates whether the planning process uses the on–hand balance of these sub inventory items as available inventory.
⦁ What are the types of locator controls you have?

Pre-specified:
Dynamic entry:
Item level:
None

⦁ For what purpose are the pre–processing, processing, and post–processing lead times for items used in the sub inventory?

These lead times are used when you use min–max planning at the
Sub inventory level.

⦁ How do you inactivate a sub inventory and what are the measures you need to take?
Enter the date on which the sub inventory becomes inactive.

As of this date, you can no longer assign the sub inventory to any function within Oracle Applications. In addition, you cannot receive items into or issue items from the sub inventory.

Attention: Before you disable a sub inventory, you must make
certain that no open jobs or schedules in Oracle Work in Process use it as the back flush sub inventory and that no active bills in Oracle Bills of Material use it as the supply sub inventory for pull requirements.

* What are the sub inventory general ledger account fields?

Material account
Outside processing account
Material overhead
Overhead
Resource
Encumbrance
Expense


What are stock locators used for?
We use locators to identify physical areas where we store inventory items. Item quantities can be tracked by locator. Items can also be restricted to specific locators.

What is organization access? And who determines it?
You can specify which organizations a responsibility can access by mapping responsibilities to organizations. Once this mapping is set up, a user logging into an Oracle Manufacturing product is restricted to the organizations mapped to the responsibility chosen. The Change Organization window is restricted as well.

Attention: Until you assign an organization to a responsibility in this window, all responsibilities have access to all organizations. Once you have restricted any responsibility to an organization, you must then explicitly define the organizations, which all responsibilities can access.


How do you enable material shortage for WIP?
By enabling the CHECK SHORTAGE filed in shortage parameters.

What are the exclusions you have in material shortage check?
Bulk components
Supplier components
Material components

Who will receive a workflow notification about the material shortage?
Component planner
Component buyer
Assembly planner
Job /schedule creator.

Pick wave move order:
A pick wave move order can exist if no available/on–hand quantity exists at pick release, or if the pick wave move order is pick confirmed short or backordered at ship confirm.

Freight carrier:
A freight carrier is a commercial company used for internal transfers between organizations, as well as shipments to and from customers and suppliers. You must associate a general ledger account with each carrier to collect costs associated with using this carrier. You assign a carrier to each inter–organization transaction.

What is Unit of measure class?
Unit of measure classes represent groups of units of measure with similar characteristics. Each unit of measure you define must belong to a unit of measure class.

Each class has a base unit of measure. The base unit of measure is used to perform conversions between units of measure in the class.

Example: UOMCLASS           Base UOM        Other UOM
Quantity                  each                  dozen, box
Weight                   gram                   pound, kilogram
Volume                   cubic inches       cubic feet,
Time                       second                minute, hour


What is the need for UOM?
Units of measure are used by a variety of functions and transactions to express the quantity of items.

Primary Unit of Measure
The primary unit of measure is the stocking unit of measure for an item in a particular organization. The primary unit of measure is an item attribute that you specify when defining each item.

Can you delete a unit of measure:
You can delete existing units of measure that are not base units of measure if no standard or item specific conversions are defined.