Oracle EBS Learnings

What is Material Status? Material Status control restricts the movement and usage of portions of on-hand inventory. Using material status control enables you to control whether you can pick or ship an internal order or sales order, or issue material for a work order. You can also specify whether material needs to be quarantined until you inspect it. In addition, you can determine whether products with a particular status can be reserved, included in available to promise calculations, or netted in production planning. You assign material statuses at four levels: subinventory, locator, lot, and serial. You assign subinventory and locator statuses in the subinventory and locator windows. The location status applies to the material in the location and not the location itself. To assign a material status to a lot or serial, you must first enable the item attributes Lot Status Enabled, and Serial Status enabled on the item in the Item Master. You can also optionally assign a defa

1. What are the setups required to have encumbrance accounting in 11i and R12 architecture? For 11i: a) Enable the check box for PO encumbrance,INVOICE encumbrance and REQ encumbrance (if required) with  unique encumbrance types  for REQ,PO and INVOICE. Navigation: Purchasing > Setup > Organization > Financial Options > Encumbrance tab b) Enable the Budgetary Control flag and define the Reserve For Encumbrance (RFE) a/c for the Set of Books. Navigation: General Ledger > Setup > Financials > Books > Define c) It is preferred to enabled the 'Reverse Encumbrance' check box in Inventory > Setup > Organization > Parameters > Costing tab and define the Encumbrance account in Other Accounts tab if requisitions/purchase orders are created with inventory destination for inventory asset items in encumbered environment. d) Purchasing period under which the GL date of purchasing document falls and AP period under which the GL date of invoice falls sh

1. What are the Item Attributes that affect Drop Ship orders? Item attributes used for DropShip Processing:  Purchased (PO) Enabled Purchasable (PO) Enabled  Transactable (INV) Enabled  Stockable (INV) Optional  Reservable (INV) Optional Inventory Item (INV) Optional Customer Ordered (OE) Enabled Customer Orders Enabled (OE) Enabled Shippable (OE) Optional OE Transactable (OE) Enabled Default SO Source type Optional Costing Enabled enabled for items that are to be costed Inventory Asset Value enabled for asset items (non-expense items) 2. How do I drop ship across operating units? Please Refer Oracle Order Management User’s Guide section "Drop Ship Across SOB Major Features" 3. Is it possible to drop ship ATO/PTO models? Order Management enables you to enter drop ship sales orders and lines for standard, model and kit, and configured items, although you currently cannot perform a drop shipment for Ship Model Complete (SMC) PTO's. Drop ship funct