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 Applications 11.0) | INVItems
 
INVItems
Use this transaction to import customer items from any legacy system into Oracle Inventory. For each customer item, you must define related information such as the Customer and Item Definition Level. If you set Item Definition Level 3 while Customer Category is required for Item Definition Level 2, Customer Address is required.
For more information about this transaction, see your Oracle Applications documentation.
Oracle Applications Module
Inventory
Open Interface
Customer Items Transaction
Open Interface Tables
Open interface table(s) exposed by the transaction are as follows:
*MTL_CI_INTERFACE
Error SQL
Open interface table(s) queried by the error SQL are as follows:
*MTL_CI_INTERFACE
*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.
Outputs
Field
Description
CUSTOMER_ ITEM_NUMBER
Customer item number in old system.
INVENTORY_ITEM_DESC
Description of item.
TRANSACTION_TYPE
Transaction type (CREATE or UPDATE).
PROCESS_MODE
Process flag to indicate whether processing of row is succeeded or failed.
CUSTOMER_NAME
Customer name.
ERROR_EXPLANATION
Detailed error message.
Usage Comments
*To import Customer Items, run the Import Customer Items function, which is under the Inventory module.
*PROCESS FLAG and PROCESS_MODE columns report the status of the record after the import and validation process is complete. These columns are required on insert and should be populated with the value 1.
*INACTIVE_FLAG is a required field. Set it to 1 for Yes and 2 for No.
*DEP_PLAN_REQUIRED_FLAG and DEP_PLAN_PRIOR_BLD_FLAG fields have required values of 1 for Yes and 2 for No.
*Oracle Applications does not allow update through this open interface. If you use a TRANSACTION_TYPE of UPDATE, the import will treat it as a CREATE and you receive a Customer Item already exists error.
*Oracle Applications does not allow deletion through this open interface. You may set a Customer Item to Inactive using the Oracle Applications GUI.