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,