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.

The following figure shows a sample configuration of the INCOIN Concurrent Program:

Parameters

The following table lists the inputs of the INCOIN Concurrent Program of the CustomCP project:

Parameter Type Input
argument1 VARCHAR2 204
argument2 VARCHAR2 1
argument3 VARCHAR2 1
argument4 VARCHAR2 1
argument5 VARCHAR2 1
argument6 VARCHAR2 See process property INCOIN_input/arg6_set_process_id
argument7 VARCHAR2 1

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