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
| 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. |
| 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 specifying Lines Detail.
- To import orders, run the Import Sales Order function, which is under the Order Entry module.