Order Management Interfaces

Order Import is the Order Management Open Interface used to Import Sales order and Returns from Legacy or Other System into Oracle Apps.

Orders Imported can be of Entered, Booked, Closed or Cancelled Status.

Order Import Includes the Interface to Create Internal Orders from Purchasing Module, Via Internal Requisition.

Features in Order Import Program

1. Defaulting 
2. Processing Constraints Validation
3. Order Hold (Apply or Release)
4. Scheduling
5. Insert. Update or Delete Orders/Lines
6. Create Sales Order With Valid Lines, Reservations, Price Adjustments and Sales Credits.
7. Multi Org Access Control Via Concurrent Parameter.

Interface Tables

 OE_CUSTOMER_INFO_IFACE_ALL
OE_HEADERS_IFACE_ALL
OE_LINES_IFACE_ALL
OE_PRICE_ADJS_IFACE_ALL
OE_PRICE_ATTS_IFACE_ALL
OE_CREDITS_IFACE_ALL
OE_LOTSERIALS_IFACE_ALL
OE_RESERVTNS_IFACE_ALL
OE_ACTIONS_IFACE_ALL
ONT.OE_PAYMENTS_IFACE_ALL

Application Process Interface -API

 Process Order is the application process interface called by order import to validate, insert, update, Schedule and delete sales order and lines.

Order Import process one order with all lines at a time with process order API and completes the process of Validating, Inserting, Updating, Scheduling and/or Deleting the Sales order and Lines.