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

Run Order import with multiple OPERATION_CODE in OE_ACTIONS_IFACE_ALL

How does one run order import with multiple rows in OE_ACTIONS_IFACE_ALL for 2 different value of OPERATION_CODE?

You can populate CHANGE_SEQUENCE field.

For example, to book and put order on hold, populate the interface table with:

#1. To book the order: