inventory interview question

Question:

How Many Key Flex Fields Are There In Inventory?
Answer :
Seven KFF are there in Inventory:
Account Alias
Item
Item Category
Item Catalogues
Stock Locators
Sales Order : This is used during material transaction when source is Sales Order.
Segments are Sales order Number. Sales Order Type. Sales Order Source.
Service Items

Question:

What Is The Difference Between Purchased And Purchasable Flag For An Item?
Answer :
purchased flag decides whether item is able to purchasable and receivable or not
purchased is enabled: item can be received
purchasable flag decides whether the item is orderable or not in PO
If purchasable is enabled:item can be ordered in a purchase order
if not:new purchase orders can’t be created and approved for the items.

Question:

 What Is The Valuation Accounts Used In Inventory?
Answer :
Material: An asset account that tracks material cost. For average costing, this account holds your inventory and in transit values.
Once you perform transactions, you cannot change 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 outside processing cost.
Expense:  The expense account used when tracking a non-asset item.
Other Accounts:
Sales: The profit and loss (income statement) account that tracks the default revenue account.
Cost of Goods Sold: The profit and loss (income statement) account that tracks the default cost of goods sold account.
Purchase Price Variance: The variance account used to record differences between purchase order price and standard cost. This account is not used with the average cost method.
Inventory A/P Accrual: The liability account that represents all inventory purchase order receipts not matched in Accounts Payable, such as the uninvoiced receipts account.
Invoice Price Variance: The variance account used to record differences between purchase order price and invoice price. This account is used by Accounts Payable to record invoice price variance.
Encumbrance: An expense account used to recognize the reservation of funds when a purchase order is approved.
Average Cost Variance: Under average costing with negative quantity balances, this account represents the inventory valuation error caused by issuing your inventory before your receipts.

Question:

What Is The Different In Mo Issue And Mo Transfer?
Answer : (MO-move order)
MO Issue will move out the stock from inventory against an account.
MO transfer will move the stock from one sub inventory to other Sub inventory.

Question

How A Mo Is Diff From Subinv Transfer?
Answer :
Move order is generally request of movement of items in one organization.
there we have involved steps like create MO, Approved Mo, Allocated MO,Transact MO
We have different types of move orders
requisition move order
replenishment move order
pick wave move order
possible to perform MO issues also. there we will get transaction number.
Subinventory transfer there you haven't get any transaction number/id
purpose of move order/ subinventory is moving the material from one sub inventory to another sub inventory within the organization.

Question:

What Is Net Table In Sub Inventory and non-nettable sub inventory ?
Answer :
nettable sub inventory:
To consider the onhand of the sub inventory as available for planning tasks.
non-nettable sub inventory:
we cant able to make future plans by using non-nettable sub inventory.

Question

When Can You See Such Scenario,
Item Available To Qty Is 0 But Available To Transact More Than 0?
Answer :
If item is not resolvable
If Sub inventory Allow reservation is not allowed
If Item is lot controlled and lot is expired

Question:

What Is A Transaction Type?
Answer :
Transaction Source Type
Transaction Action
Transaction Type
A transaction type is a combination of a transaction source type and a transaction action. It is used to classify a particular transaction for reporting purposes.
Ex: Sales order issue (txn type) + issue from stores (txn action) = sales order (txn source type).
Move order transfer (txn type) + sub inventory transfer (txn action) = move order (txn source type).
transaction types:
transaction source types come seeded with Oracle Inventory:
Purchase Order
Account Alias
Move Order
Internal Order
Standard Cost Update
Internal Requisition
Sales Order
Cycle Count
Periodic Cost Update
Physical Inventory
Account
RMA (Return Material Authorization)
Inventory
Job or Schedule
we have 6 transaction actions in oracle inventory.
issue from stores
receipt into stores
direct transfer
intransit
subinventory transfer

Question:

Describe Various Inventory Transaction Types?
Answer :
Miscellaneous transaction:
transaction is used to do adjust the the quantity through miscellaneous transaction we can increase/ decrease the quantity
Sub inventory transfer: used to transfer goods from one sub inventory to another within the same inventory organization.
InterORG transfer: This transaction is used to transfer goods from one inventory organization to another inventory organization with in the operating unit.
Receiving transaction: This transaction is used to move goods from receiving dock to specified sub inventory and locator.

Question:

Which Tables Are The Transcriptional Details Are Stored?
Answer :
MTL_MATERIAL_TRANSACTIONS
after completion of the transaction those records will be stored in the MMT table.
MTL_TRANSACTIONS_INTERFACE
when we perform interface trip stop program where the data moved from interface table to MMT table
MTL_MATERIAL_TRANSACTIONS_TEMP
where the pending transactions stored in the table
MTL_TRANSACTION_ACCOUNTS
where transaction related accounts stored in the table