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) | INVItems
 
INVItems
Use this transaction to convert inventory Items from another inventory system, migrate assembly and component items from a legacy manufacturing system, convert purchased items from a custom purchasing system, and insert new items from a Product Data Management package. When importing items, this transaction creates new Items in the Item Master organization or assigns existing Items to additional organizations. You can specify values for all Item attributes, or you can use default or null values. The INVItems transaction also enables you to import revision details, including past and future revisions and effective dates.
For more information about this transaction, see your Oracle Applications documentation.
Oracle Applications Module
Inventory.
Open Interface
Items Transaction.
Open Interface Tables
Open interface table(s) exposed by the transaction are as follows:
*MTL_SYSTEM_ITEM_INTERFACE
*MTL_ITEM_REVISIONS_INTERFACE
Error SQL
Open interface table(s) queried by the error SQL are as follows:
*MTL_SYSTEM_ITEM_INTERFACE
*MTL_INTERFACE_ERRORS
*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
ITEM_NUMBER
Item number in old system.
DESCRIPTION
Description of item.
TRANSACTION_TYPE
Transaction type (CREATE or UPDATE).
PROCESS_FLAG
Process flag to indicate whether processing of row has succeeded or failed. Possible process flags are:
1. Pending
2. Assign complete
3. Assign/validation failed
4. Validation succeeded; import failed
5. Import in process
6. Import succeeded
ERROR_MESSAGE
Detailed error message.
Usage Comments
*To create Items, choose TRANSACTION TYPE as CREATE. When importing these Items, choose Create Items.
*To update Items, choose TRANSACTION_TYPE as UPDATE. When importing these Items choose Update existing Items.
*If you have a list of transactions containing both UPDATES and CREATES, give all CREATES one SET_PROCESS_ID and all UPDATES a different SET_PROCESS_ID. When importing you specify Items to import by their SET_PROCESS_ID.
*Be careful when running the import process. We have experienced a problem running Oracle Applications 10.7SC on Windows NT. If you specify a SET_PROCESS_ID used for your CREATE records and then during the import you specify the SET_PROCESS_ID for UPDATE records, a Dr. Watson Error will be triggered on Oracle Applications. The process flag on the records will show pending and the SET_PROCESS_ID will be set to – 999.
*Oracle Applications does not allow the deletion of Items using the open interface tables. CREATE and UPDATE transaction types are currently supported.
*To import Items, run the Import Items function, which is under the Inventory module.