INCOIN Concurrent Program Configuration
You can import items from any source into Oracle Inventory and Oracle Engineering by using the INCOIN Item Open Interface. With this interface, you can 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 import new items from a product data management package.
Parameters
The following table lists the inputs of the INCOIN Concurrent Program of the CustomCP project:
Open Interface Tables or Views
The INCOIN Concurrent Program contains 5 interface tables, as listed in the following table.
Name | Description |
---|---|
INV.MTL_SYSTEMS_ITEM_INTERFACE | Use this table for your new item numbers and all item attributes. This is the main Item Open Interface table. It might be the only table that you choose to use. |
INV.MTL_ITEM_REVISIONS_INTERFACE | Use this table if you are importing revision details for your new items. This table is used only for revision information. It is not required. |
INV.MTL_ITEM_CATEGORIES_INTERFACE | Use this table to import item category assignments. It stores data about item assignments to category sets and categories to be imported into the Oracle Inventory MTL_ITEM_CATEGORIES table. |
INV.MTL_DESC_ELEM_VAL_INTERFACE | Use this table to describe elements that apply to your item. |
INV.MTL_DESC_ELEM_VAL_INTERFACE | Use this table to record error messages for failed records in the interface table. |
Note: The open interface is not included in the Oracle E-Business Suite Integration Repository; therefore, you must go through the plug-in Custom Concurrent Program activity to access it. You must implement this activity by using the standard parameters for calling FND_REQUEST.SUBMIT_REQUEST; therefore, replace argument names with argument numbers for Concurrent Program.
The following table lists the important inputs of the interface tables of the CustomCP project:
Parameter | Type | Input |
---|---|---|
ORGANIZATION_ID | NUMBER | 204 |
DESCRIPTION | VARCHAR2 | See process property INCOIN_input/item_name |
SEGMENT1 | VARCHAR2 | See process property INCOIN_input/item_name |
ATTRIBUTE1 | VARCHAR2 | 2001 |
CUSTOMER_ORDER_FLAG | VARCHAR2 | Y |
CUSTOMER_ORDER_ENABLED_FLAG | VARCHAR2 | Y |
PROCESS_FLAG | NUMBER | 1 |
ORGANIZATION_CODE | VARCHAR2 | V1 |
TRANSACTION_TYPE | VARCHAR2 | CREATE |
SET_PROCESS_ID | NUMBER | See process property INCOIN_input/arg6_set_process_id |
Copyright © TIBCO Software Inc. All Rights Reserved.