Interview Questions.

Q1. What Are The Components Used In Customizing A Traction?

The following are the 3 additives utilized in a traction

Traction Source Type

Traction Action

Traction Type

A Traction Source Type and a Traction Action come collectively to form a Traction Type.

Q2. What Is Net Table In Sub Inventory Setup?

This wills determine whether or not to take into account the onhand of the sub inventory as available for planning obligations.

Q3. Why Master Org Is Required?

So that we are able to have an object maintained at master degree with commonplace attributes and then we are able to use the identical object across multiple companies as opposed to defining it over and over.

Q4. Name Any Four Purposes Where Miscellaneous Traction Can Be Used?

Cycle be counted adjustment, Physical inventory adjustment, adjusting inventory amount inside an inventory enterprise and decrementing on-hand balances from a subinvemtory.

Q5. Define Abc Analysis?

ABC evaluation determines the relative fee of a set of inventory gadgets based totally on a user special valuation criterion.

This method divides inventory into three categories A, B & C primarily based on their annual consumption price.

It is likewise called Selective Inventory Control Method (SIM).

Q6. Define Inventory Organization?

It is a facility a good way to allow you to shop and tract the items. It may be a manufacturing unit, ware residence, distribution center and so on.

Q7. What Is A Sub Inventory?

Subinventiries are particular physical or logical separations of cloth stock. These can be raw cloth, completed items or defective fabric sub stock. You have to define as a minimum one sub stock. Sub inventories are of  sorts: garage and receiving.

Storage sub inventories are intermediate or final put away locations for cloth. Material that resides in a storage sub stock appears in handy amount, and is tracked by way of the device. The device can e book orders in opposition to, and use production tactics on fabric that is living in a garage sub stock. You ought to define at least one storage sub stock on your implementation.

Receiving kind sub stock is best used for receiving gadgets. Items in this sub inventories can't be on-hand or reserved.

Q8. What Are The Processes Of Cycle Count?

Create a cycle rely header with required facts

Assign the items to be counted

Then run the desired cycle depend file

Using the report do the cycle counts

Then cross and Approve the cycle remember

Q9. How A Mo Is Diff From Subinv Trfer?

MO generally is the request of movement of gadgets in a single agency. It may be of from three sources, MO requisition, Replenish MO, Pick Wave MO. MO can be MO Issue which will problem the object from the area and MO trfer which ll trfer the object to any other place.

Q10. What Is Move Order In Om?

Move orders generated as a part of Pick Wave are the ones from Sales order.

Q11. What All Setups You Have Done In Inventory Organization Implementation?

Location

Calendar

Organization

Parameter

Cost Group

Sub inventory

Stock Locator

Receiving Options

Shipping Networks

Intercompany Traction flows

Cost Sub elements

Q12. From Where I Can See The List Of Time Zones In Oracle.

The list of time zones and their different info may be observed from underneath 2 tables.

Fnd_timezones_b, fnd_timezones_tl.

Q13. What Are The Status Attributes In Item And How Many Of Them?

We can define exclusive reputation for an object mixture those attributes as per the business want.

Following are the attributes:

BOM Enabled

Build in WIP

Customer order enabled

Internal Order enabled

Inviolable

Purchasable

Stackable

Tractable

Q14. What Is The Use Of Wms Rules Workbench?

The Rules workbench allows you to assign techniques, rules and fee organization values at once to any wide variety of objects in an task matrix.

Q15. Explain Shipping Method?

Shipping methods are the way you deliver fabric. When you create a delivery method, you have to allow it earlier than you could use it in a shipping community. If you disable a shipping method, it can't be used in a delivery community.

Q16. What Is A Traction Type?

A traction type is a mixture of a traction source type and a traction motion. It is used to classify a specific traction for reporting and querying functions.

Ex: Sales order trouble (txn kind) + difficulty from stores (txn action) = income order (txn source kind).

Move order trfer (txn kind) + sub stock trfer (txn action) = flow order (txn source kind).

Q17. What Is The Difference Between Purchased And Purchasable Flag For An Item?

Purchasable is a standing attribute flag, so primarily based on this flag, sure tractions can be controlled for an object.

Purchased flag decides whether to purchase and get hold of this object.

Purchasable flag comes to a decision whether or not to reserve this object in a buy order.

If accessible is enabled, item can be ordered in a buy order, if not, new buy orders can’t be created and approved for the gadgets.

If bought is enabled, item may be acquired if already present in an accredited buy order.

Q18. How Many Types Of Bar Codes Are There?

Mainly 2 kinds Linear (1 dimensional) and Matrix (2D).

Q19. What Are Different Planning Methods In Inventory?

There are five distinct planning techniques in oracle Inventory:

Subinv Replenishment Planning

Min Max Planning

Re-order factor making plans

Kanban Planning

Periodic Automatic Replenishment

Q20. What Are The Lot Control Setups?

Lot manage may be setup at object attributes at business enterprise degree.

Either No Control or Full Control.

Q21. Can We Change The Item Name After It Created?

Yes we can trade the call in grasp degree.

Q22. How Many Key Flex Fields Are There In Inventory?

Seven KFF are there in Inventory: 

Account Alias

Item

Item Category

Item Catalogues

Stock Locators

Sales Order

Service Items

Q23. Explain Min-max Planning Technique?

Min-Max planning is a device for making plans inventory that looks at consumer-defined minimal and maximum inventory ranges. It does now not recollect lead times.

We can carry out this approach at org stage or sub stock degree.

Q24. What Is Consignment Inventory?

Consignment Inventory is stock this is inside the possession of the purchaser, but is still owned via the dealer. In other words, the supplier locations a number of his inventory in his patron’s possession (of their keep or warehouse) and allows them to sell or consume directly from his inventory. The client purchases the stock best after he has resold or ate up it. The key gain to the patron ought to be apparent; he does not should tie up his capital in stock. This does no longer mean that there are not any stock sporting prices for the client; he does nevertheless incur costs related to storing and handling the inventory.

Q25. What Are The Criteria In Cycle Count?

Depending on the requirement, we can cause cycle count number.

We can define everyday cycle count of high values objects.

If back ordered or choose denied, we are able to trigger cycle matter for those gadgets.

Q26. What Is The Use Of Sales Order Kff?

This is used during cloth traction when supply is Sales Order.

Segments are Sales order Number. Sales Order Type. Sales Order Source.

Q27. What Is Revision Control In Oracle Inventory?

A revision is a selected model of an object, bill of material, or routing. Revision control is normally enabled for figuring out a changed item. Item can be positioned under revision manipulate by means of checking the container `Revision manipulate` in Inventory tab while defining new object or for current item. Base table for Item Revision is MTL_ITEM_REVISIONS.

Q28. What Are The Different Inventory Tractions?

A traction is an item motion inside, into or out of inventory. A traction changes the amount and region of an object.

The following are the extraordinary inventory tractions:

Receive an object into an corporation from GL account wide variety.

Issue an item from an company into a GL account number.

Trfer objects from one sub inventory to different in the identical organization.

Trfer of gadgets between various inventory groups.

Reservation of items.

Q29. What Is The Different In Mo Issue And Mo Trfer?

MO Issue will flow out the inventory from stock against an account.

MO trfer will circulate the inventory from one sub inventory to different.

Q30. Inventory Master Org Is Mandatory?

Yes. If you may no longer create any precise grasp org, then gadget will remember the identical inv org as its master org.

Q31. What Is The Picking Rule In Inventory?

Picking Rule is used to decide the listing of gadgets for income order/ delivery based totally on the revision, Lot, Sub inventory and Locator.

Assign the specified Picking Rule to the object in Order Management tab.

Q32. What Are Item Attributes?

Item attributes are the gathering of statistics approximately an item. These are used to store particular traits of an object, together with object status, unit of measure, revision control, and many others. These can be managed at either the grasp or the enterprise level. These attributes are stored in a desk named MTL_ITEM_ATTRIBUTES.

Q33. What Are The Factors That Affect Inventory Control?

Type of product

Type of manufacture

Volume of production

Q34. Describe Various Inventory Traction Types?

Miscellaneous traction: This traction is used to do adjustments in stock due to damage, obsolescence, issuing objects for R & D or issuing track in a position price objects.

Sub inventory trfer: This traction is used to trfer items from one sub inventory to any other in the equal stock company.

InterORG trfer: This traction is used to trfer items from one inventory organization to some other.

Receiving traction: This traction is used to move goods from receiving dock to precise sub inventory and locator.

Sales problem: This traction is used to move goods from select sub inventory to staged sub stock.

WIP trouble: This traction is used to problem materials in opposition to manufacturing orders.

Q35. What Are The Basic Steps Involved In Defining An Item?

Create an object in the item grasp shape.

Copy the template from the tools menu to assign specific attributes to the item and store it.

Assign the object to a class from equipment menu and shop your work.

Select company assignment from equipment menu and assign the object to extraordinary inventory corporations via ticking the checkbox next to the stock corporations.

Q36. What Is The Valuation Accounts Used In Inventory?

Material: An asset account that tracks material value. For average costing, this account holds your stock and in trit values. Once you carry out tractions, you can not exchange this account.

Material Overhead: An asset account that tracks material overhead cost.

Resource:  An asset account that tracks resource cost.

Overhead: An asset account that tracks resource and outside processing overheads.

Outside processing: An asset account that tracks outdoor processing cost.

Expense:  The cost account used when monitoring a non-asset item.

Other Accounts:

Sales: The earnings and loss (income statement) account that tracks the default revenue account.

Cost of Goods Sold: The income and loss (income announcement) account that tracks the default value of products sold account.

Purchase Price Variance: The variance account used to record variations between buy order charge and popular price. This account isn't used with the common value method.

Inventory A/P Accrual: The legal responsibility account that represents all stock buy order receipts no longer matched in Accounts Payable, which include the uninvoiced receipts account.

Invoice Price Variance: The variance account used to document variations among buy order rate and bill price. This account is used by Accounts Payable to document bill charge variance.

Encumbrance: An fee account used to recognize the reservation of finances whilst a buy order is accredited.

Average Cost Variance: Under common costing with poor amount balances, this account represents the inventory valuation mistakes as a result of issuing your stock before your receipts.

Q37. What Is An Item Category And Category Set?

A category is a logical classification of objects that have comparable traits.

A class set is a awesome grouping scheme and consists of a couple of categories. An item can belong to any variety of category sets. We can assign object to 1 category within every category set. The classes may be retrieved from the table ‘MTL_CATEGORIES_B‘ and object class set from ‘MTL_CATEGORY_SETS_B’.

Q38. Explain Inventory Control?

Inventory Control is the method through which stock is measured and regulated according to predetermined norms including monetary lot length for order or manufacturing, safety stock, minimum stage, maximum degree, order level and so on.

Q39. What Is An Item?

An object is part or services in which you can Purchase, Sell, Plan, Manufacture, Stock, Distribute and Prototype.

Items also can be boxes for items as well as additives you build into different items.

Q40. What Are The Key Flex Fields In Oracle Inventory?

Oracle Inventory offers the following flex fields:

System Items

Item Catalogs

Item Categories

Stock Locators

Account Alias 

Sales Order

Q41. When Should The Material Be Ordered?

When on-hand quantity + supply – demand is less than safety stock (safety inventory is not anything but minimum stock stage)

[On-hand quantity] + [supply] – [demand] < [min inventory level]

Q42. What Are The Traction Managers?

Traction manager is the interface managers which perform all traction once submitted by way of the customers.

Q43. How Lot Number Generates?

You can generate new Lot numbers at some stage in tractions.

Q44. Explain Re-order Point Planning?

Reorder factor making plans makes use of demand forecasts to determine when to reserve a new amount to refill inventory. Reorder point making plans indicates a brand new order for an object whilst the available amount (on-hand quantity plus planned receipts) drops underneath the object’s protection inventory degree plus forecast call for for the item at some point of its replenishment lead-time. The advised order amount is an financial order quantity that minimizes the full price of ordering and wearing stock. Oracle Inventory can mechanically generate requisitions to inform your shopping department that a replenishment order is needed to deliver your employer.

If the forecast is correct and the order arrives on time, the stock level must be proper at the protection inventory level on the time of receipt. In cases where the desired safety stock degree modifications at some stage in the order lead time, Oracle Inventory makes use of the biggest protection stock amount all through the lead-time.

When an order is induced, the EOQ is the dimensions of the brought on order.

EOQ = square root of: [(2 X annual demand X order cost) / (carrying cost percent X Unit cost)]

Oracle Inventory calculates annual call for as the present day demand rate annualized through multiplying the present day length call for forecast through the quantity of intervals in keeping with yr (12 or thirteen).

Reorder factor making plans can be performed on the corporation level only.

Q45. What Is The Predefined Locator In Sub Inventory And How It Works In Business?

We can setup locator manipulate in four diff methods for each sub inventory:

None:  There will now not be any locator statistics required in the course of any traction.

Prespecified: System will ask you to select locator combinations which already been described within the sub inventory at some stage in the traction.

Dynamic Entry: Either you could choose any locator all through traction or you could create a new mixture.

Item Level: This will take the locator which has been defined at item characteristic degree.

Q46. What Are The Diff In Lot And Serial?

Lot control is to control an entire batch of objects. For example in drug industry we've batch number which may be managed the usage of lot where we are able to tune the complete batch the use of precise information.

Serial manipulate is to screen and song every single qty of an object like digital gadgets in which we song by serial wide variety.

Q47. What Is The Use Of Item Template?

An Item template is a hard and fast of attributes that permit the consumer to quickly create an Item. You can use the existing templates are you could create your custom template.

Q48. How Wms Is Helpful Compared To Inventory?

Warehouse Management (WMS) allows groups to maximise their utilization of exertions, area and gadget investments through coordinating and optimizing useful resource usage and fabric flows. Specifically designed to guide the needs of distribution, manufacturing, asset-in depth, and carrier businesses, Oracle WMS gives a single-platform throughout your entire global deliver chain.

Q49. What Is The Concurrent Program For The Planning?

Min Max planning file under making plans menu in Inventory obligation

Q50. What Are The Objectives Of Inventory Control?

To meet unexpected future call for due to variant in forecast figures and actual figures.

To common out demand fluctuations because of seasonal or cyclic variations.

To meet the patron requirement timely, effectively, effectively, easily and satisfactorily.

To smoothen the production manner.

To facilitate intermittent manufacturing of numerous products on the same facility.

To benefit economy of production or buy in lots.

To reduce loss because of adjustments in prices of stock objects.

To meet the time lag for trportation of products.

To meet the technological constraints of production/procedure.