Tables and Process
01. Item Creation
MTL_SYSTEM_ITEMS_B
02. Shipping Network Creation
03. Internal Location creation and assign to Inventory Organization
04. Miscellaneous Receipts to make On-Hand
MTL_MATERIAL_TRANSACTIONS,
MTL_ONHAND_QUANTITIES_DETAIL
Create the Internal Customerassign the location, bill to ship to
05. Item Price
06. Create Internal Requisition
PO_REQUISITION_HEADERS_ALL(Segment1 is the IR No), PO_REQUISITION_LINES_ALL
Requisition Approval, Purchasing Super user- setup user> organizations> Financial Parameters> Human Resource Tab, Uncheck Use Appruval Hierarchicals for Position Approval
Define Jobs, setup -- Personnel -- Jobs
Setup approval group, setup -- Personnel --approvals-- Approval Groups
Approval Assignment
Employee creation/ Job Assignment
Run to Create Internal Request concurrent, Order will insert into the Order Management Interface Table with Location_id,
Import Internal Order
OE_HEADERS_IFACE_ALL, OE_LINES_IFACE_ALL ... FLOW_STATUS_CODE will show the status of each step
OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL ... FLOW_STATUS_CODE Will be Entered
After Book the order FLOW_STATUS_CODE Will be Booked of OE_ORDER_HEADERS_ALL and FLOW_STATUS_CODE Will be AWAITING_SHIPPING of OE_ORDER_LINES_ALL
WSH_DELIVERY_DETAILS will create with released_status=R(Ready to Release), WSH_DELIVERY_ASSIGNMENTS will create
Order entry OE_ORDER_HEADERS_ALL 1 record created in header table OE_ORDER_LINES_ALL Lines for particular records OE_PRICE_ADJUSTMENTS When discount gets applied OE_ORDER_PRICE_ATTRIBS If line has price attributes then populated OE_ORDER_HOLDS_ALL If any hold applied for order like credit check etc Order Booked OE_ORDER_HEADERS_ALL Booked_Flag=Y, Order booked. WSH_DELIVERY_DETAILS Status Opened WSH_DELIVERY_ASSIGNMENTS WSH_DELIVERY_ASSIGNMENTS.delivery_id will be NULL as still pick release operation is not performed as final delivery is not yet created. MTL_DEMAND. ‘Demand interface program’ is triggered in the background and demand of the item with specified quantity is created Order Scheduled/Reserved This step is required for doing reservations SCHEDULE ORDER PROGRAM runs in the background(if scheduled) and quantities are reserved. OE_ORDER_LINES_ALL Awaiting Shipping MTL_RESERVATIONS This is only soft reservations. No physical movement of stock WSH_DELIVERY_DETAILS R: Ready to Release: Line is ready to be released Pick Released Pick Release is the process of putting reservation on on-hand quantity available in the inventory and pick them for particular sales order. OE_ORDER_LINES_ALL WSH_DELIVERY_DETAILS S: Released to Warehouse WSH_NEW_DELIVERIES A new record is created in WSH_NEW_DELIVERIES with status_code = ‘OP’ (Open). WSH_NEW_DELIVERIES has the delivery records. WSH_DELIVERY_ASSIGNMENTS Deliveries get assigned WSH_PICKING_BATCHES After batch is created for pick release MTL_TXN_REQUEST_HEADERS A move order is created in Pick Release process which is used to pick and move the goods to staging area (here move order is just created but not transacted). MTL_TXN_REQUEST_HEADERS, MTL_TXN_REQUEST_LINES are move order tables MTL_TXN_REQUEST_LINES move order line Pick Confirm Pick Confirm is to transact the move order created in Pick Release process OE_ORDER_LINES_ALL flow_status_code =’PICKED’ MTL_MATERIAL_TRANSACTIONS_TEMP (Record gets deleted from here and gets posted to MTL_MATERIAL_TRANSACTIONS) MTL_MATERIAL_TRANSACTIONS MTL_MATERIAL_TRANSACTIONS is updated with Sales Order Pick Transaciton MTL_TRANSACTION_ACCOUNTS updated with accounting information for mtl_material Transactions WSH_DELIVERY_DETAILS Y: Staged- Line has been picked and staged by Inventory MTL_ONHAND_QUANTITIES Ship Confirmed The goods are picked from staging area and given to shipping. “Interface Trip Stop” program runs in the backend. OE_ORDER_LINES_ALL .flow_status_code =‘SHIPPED’ Shipped_Quantity get populated WSH_DELIVERY_DETAILS Released_Status=C ;Shipped ;Delivery Note get printed Delivery assigned to trip stop quantity will be decreased MTL_TRANSACTIONS_INTERFACE Data from MTL_TRANSACTIONS_INTERFACE is moved to MTL_MATERIAL_TRANACTIONS MTL_MATERIAL_TRANSACTIONS updated with Sales Order Issue transaction WSH_NEW_DELIVERIES If Defer Interface is checked then OM & inventory not updated. If Defer Interface is not checked: Shipped OE_ORDER_LINES_ALL WSH_DELIVERY_LEGS 1 leg is called as 1 trip.1 Pickup & drop up stop for each trip. OE_ORDER_HEADERS_ALL If all the lines get shipped then only flag N WSH_NEW_DELIVERIES Data Deleted MTL_RESERVATIONS Data Deleted MTL_DEMAND Data Deleted MTL_ONHAND_QUANTITIES Item deducted from MTL_ONHAND_QUANTITIES MTL_TRANSACTION_ACCOUNTS updated with accounting information. WSH_TRIPS WSH_TRIP_STOPS Auto Invoice After shipping the order the order lines gets eligible to get transfered to RA_INTERFACE_LINES_ALL. Workflow background engine picks those records and post it to RA_INTERFACE_LINES_ALL. OE_ORDER_LINES_ALL invoice_interface_status_code = ‘YES’ WSH_DELIVERY_DETAILS Released_Status=I RA_INTERFACE_LINES_ALL Data will be populated after work flow process. RA_CUSTOMER_TRX_ALL After running Auto Invoice Master Program for RA_CUSTOMER_TRX_LINES_ALL Specific batch transaction tables get populated Close Order Last step of the process is to close the order which happens automatically once the goods are shipped OE_ORDER_LINES_ALL flow_status_code =’CLOSED’ and open_flag = ‘N’ Read more: http://www.oracleerpfunctional.com/2014/02/oracle-order-to-cash-tables-o2c-tables.html#ixzz3Yh5U984J
