Importing Orders in Various statuses in Order Management

Orders can be imported as ENTERED, BOOKED or CLOSED.

ENTERED:

If an order is imported with an entry status of ENTERED (OE_HEADERS_IFACE_ALL.BOOKED_FLAG=N or NULL) then the result after import is that the line is BOOK_ORDER eligible.

Oracle Apps Order Import Interface training with examples

Order Import Interface (Sales Order Conversion)

Order Import enables you to import Sales Orders into Oracle Applications instead of manually entering them.

Pre-requisites:

Order Type

Line Type

Items

Customers

Ship Method/ Freight Carrier

Sales Person

Sales Territories

Customer Order Holds

Sub Inventory/ Locations

On hand Quantity

Import an Order with its customer account and address using Order Import Process

Import an order, the customer account, and the customer address using Order Import process

In this example, the address is categorized as Bill_To and Ship_To address.

1. Populate the order import interface tables.

INSERT INTO oe_headers_iface_all (order_source_id,

                                  orig_sys_document_ref,

                                  operation_code,

                                  ordered_date,

How to create a new customer during Order Import

Order Management provides the capability to add a new customer, the address and contacts using the Order Import feature.

The table OE_CUSTOMER_INFO_IFACE_ALL needs to be populated for this to occur. 
Based on the data available in the OE_HEADERS_IFACE_ALL the data from the table OE_CUSTOMER_INFO_IFACE_ALL will be processed to add a new customer.
This table can also be used to import a new address only or contact information of an existing Customer.