Oracle Order Management Interview Questions

1. What are base tables and interface tables in Order Management?
A: Interface Tables:
OE_HEADERS_IFACE_ALL, OE_LINES_IFACE_ALL, OE_PRICE_ADJS_IFACE_ALL, OE_ACTIONS_IFACE_ALL & OE_CREDITS_IFACE_ALL(Order holds like credit check holds etc.)
Base Tables: 
OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, OE_PRICE_ADJUSTMENTS & OE_SALES_CREDITS
Shipping Tables:
WSH_NEW_DELIVERIES, WSH_DELIVERY_DETAILS, WSH_DELIVERY_ASSIGNMENTS & WSH_DELIVERIES

2: Explain Order to Cash Flow?
A: Create Order
Book the Order
Pick Release & Pick Confirm
Ship Confirm
Invoice to AR

3: Explain Drop Ship Order Flow?
A:  Note: For Drop Shipment Orders Line Source Type will be set to "External"

1. Create an Order
2. Book the Order
3. Run the Workflow Background Process
4. Line status will changed to "Awaiting Receipt"
5. Run the Requisition Import (can run with default parameters)
6. Create Releases concurrent program will submitted automatically(Note: After completion of Requisition Import, Line status remains same "Awaiting Receipt" and we can see the Requisition information using the navigation, Actions(B) -> Additional Line Information(O) -> Drop Ship(T))
7. Purchasing Responsibility and Autocreate PO using Requisition Number
8. Click on Automatic(B) and enter the supplier name in supplier field and click on Create(B)
9. In PO Shipments, we can see the Sales Order Information
10. In PO Distributions, we can see the Requisition Information
11. Approve the PO
12. PO Receipt(Note:After entering the receipt qty and subinventory and once we click on Save, "Receiving Transaction Processor" CP submits in Background)
13. After completion of PO Receipt, Sales Order Line status changes from "Awaiting Receipt" to "Shipped"
14.  Run the Workflow Background Process, after completion of this program, Line status changes from "Shipped" to "Closed" 

4: Processing Constraints?
A: Processing Constraints prevent users from adding, updating, deleting, cancelling, splitting of order/lines information beyond certain points in the order cycle. Oracle has provided certain processing constraints which prevent data integrity violations.  Processing Constraints are defined for entities and attributes. Entities includes regions of sales order window such as order, line, order/line price adjustments, order/line sales credits. Attributes includes individual fields of a particular entity such as warehouse, ship to location or quantity etc.

5: Describe Scheduling in Sales Order?
A: It is process of communicating the balance between customer demand and a company's ability to fulfill an order from current inventory and supply sources

6: What are the various ways of Scheduling the sales order?
A: 

1. Setting Profile Option: OM: AutoSchedule to "Yes" 
2. From Tools Menu -> Check AutoSchedule checkbox in Sales Order Screen
3. Right Click on Sales Order Line -> Scheduling -> Schedule