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) | INVCustomerItemsCrossReference
 
INVCustomerItemsCrossReference
Use this transaction to import cross‐references between customer Items and existing Oracle Inventory Items into your master Organization. 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 Cross Reference
Open Interface Tables
Open interface table(s) exposed by the transaction are as follows:
*MTL_CI_XREFS_INTERFACE
Error SQL
Open interface table(s) queried by the error SQL are as follows:
*MTL_CI_XREFS_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_ID
Existing inventory Items ID.
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 create Customer Items Cross‐References use a TRANSACTION_TYPE of CREATE.
*We have experienced a bug in Oracle Applications. If you set the Delete Processed rows option to Yes, the records should be removed from the open interface tables after the import. However, the records are not removed and are not updated to show they have been processed.
**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.
*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 Cross Reference already exists error.
*Oracle Applications does not allow deletion through this open interface. You may set a Customer Item Cross Reference to Inactive using the Oracle Applications GUI.
*To import Items, run the Import Customer Items Cross Reference function, which is under the Inventory module.