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) | INVCustomerItems
 
INVCustomerItems
Use this transaction to import customer items from your legacy system into Oracle Inventory. For each customer item, you must define related information such as the Customer and Item Definition Level.
For more information about this transaction, see your Oracle Applications documentation.
Oracle Applications Module
Inventory
Open Interface
Customer Item
Open Interface Tables
The open interface table exposed by this transaction is:
*MTL_CI_INTERFACE
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.
Outputs
Field
Description
CUSTOMER_ITEM_NUMBER
Customer item number in legacy system.
CUSTOMER_ITEM_DESC
Description of item.
TRANSACTION_TYPE
Transaction type (CREATE or UPDATE).
PROCESS_MODE
Process flag to indicate whether processing of row has succeeded or failed.
CUSTOMER_NAME
Customer name
ERROR_EXPLANATION
Detailed error message.