Tuesday, June 15, 2021

Few R12 Inventory Interview Questions in Oracle Apps

  1. What is Master Item? 
  2. What is Onhand quantity and Available quantity?
  3. What is Move Orders? 
  4. What are the Inventory Organizations, Name few Sub-Inventories?
  5. What is KFF? Name few KFF's.
  6. Tell some of the base tables in Inventory Module? 
  7. In which column item will be stored?
  8. What is the Primary key in MTL_SYSTEM_ITEMS_B table?
  9. In which table we an find out Master Organizations?
  10. In which table we can find out Sub-inventories?
  11. In which column we can find out Item category name?
  12. What is ABC analysis and ATP date? 
  13. What are the Item Transactions we have?
  14. What are the reports you have developed or Customized in Inventory Module?
  15. What is min-max planning?

3 comments:

Query To Fetch AP Invoice Details From SO Number(Doc ID 2949013.1)

SELECT dh.source_order_number       ,df.source_line_number as so_line_number   ,df.fulfill_line_number    ,ddr.doc_user_key as po_number...