OEOrderImport
Use this transaction to import order entry data from a variety of sources. You can import data into orders with lines, schedule details, price adjustments, and sales orders. You can import complete, incomplete, and booked orders. You can also import quota, or non‐ quota sales credit information, changes to existing orders, line schedule detail information with each order and order line, and internal requisition orders from Oracle Purchasing.
For more information about this transaction, see your Oracle Applications documentation.
Oracle Applications Module
Order Entry/Shipping
Open Interface
Order Import
Open Interface Tables
Open interface table(s) exposed by the transaction are as follows:
SO_HEADERS_INTERFACE_ALL
SO_LINES_INTERFACE_ALL
SO_LINES_DETAIL_INTERFACE
SO_SALES_CREDITS_INTERFACE
SO_PRICE_ADJUSTMENTS_INTERFACE
Error SQL
Open interface table(s) queried by the error SQL are as follows:
SO_HEADERS_INTERFACE_ALL
FND_USER_VIEW
Inputs
Field | Description |
WM_USER | User ID of the person who initiated the transaction; that is, the user ID in the CREATED_BY field in the transaction. |
ORIG_SYSTEM_REF | Original system reference. |
PO_NUMBER | Purchase order number. |
CUSTOMER_NAME | Customer name. |
CUSTOMER_NUMBER | Customer number in legacy system. |
Outputs
Field | Description |
ORIGINAL_SYSTEM_REFERENCE | Original system reference. |
PURCHASE_ORDER_NUM | Purchase order number. |
CUSTOMER_NUMBER | Customer number in legacy system. |
CUSTOMER_NAME | Customer name. |
INTERFACE_STATUS | Current status of the transaction (pending, rejected, or success). |
Usage Comments
For each record in the Line Interface, a corresponding record should exist in the Headers Table. Otherwise, the Lines record will be left dangling and will not be picked up by Import Process.
You can enter Header Information without having Lines Detail.
To import Items, run the
Import Sales Order function, which is under the Order Entry module.