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 Management
Open Interface
Order Import
Open Interface Tables
The open interface tables exposed by this transaction are:
OE_HEADERS_IFACE_ALL
OE_LINES_IFACE_ALL
OE_PRICE_ADJS_IFACE_ALL
OE_CREDITS_IFACE_ALL
OE_LOTSERIALS_IFACE_ALL
Error SQL
Inputs
Field | Description |
WM_USER | Name of the user for the corresponding user ID in the CREATED_BY column of the MTL_CI_INTERFACE table. This parameter will accept wild cards. % returns all errors. |
ORIG_SYS_DOCUMENT_REF | Original system identifier loaded in the ORIG_SYS_DOCUMENT_REF column of the OE_HEADERS_IFACE_ALL table. This parameter will accept wild cards. % returns all errors. |
Outputs
Field | Description |
ORIG_SYS_DOCUMENT_REF | Original system reference from the external system. |
MESSAGE_TEXT | Error message. |
CUSTOMER_PO_NUMBER | Customer purchase order related to the sales order. |
CUSTOMER_NAME | Customer name associated with the order. |