Oracle Apps Adapter 6.0 | webMethods Oracle Applications Adapter Documentation | webMethods Oracle Applications Adapter Sample Transaction Definitions User’s Guide Documentation | Transaction Definition (IS-to-Oracle Applications 11.5) | OEOrderImport
 
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.