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