You can use any of the following methods to import items and item-related information:

• Item Open Interface

• Microsoft® Office Excel spreadsheet (see: Importing Items Using a Spreadsheet)

• Import Workbench (see: Overview of Inbound Product Data Synchronization and Data Quality Management)

  Caution: The Import Workbench is only available to customers who have licensed Oracle Product Information Management, and is not available to licensees of Oracle Product Lifecycle Management.

This topic discusses importing items using the Item Open Interface. The Open Interface program validates all data before importing it into the production tables. You can also import the following item-related data:

• Item people.

• User attributes.

• Customer items.

• Customer item cross references.

This topic discusses importing items and their associated data using interface tables. You can import and update items and their associated data from any source into Oracle Product Information Management using interface tables. When you import items through the item interface tables, you create new items in your Item Master organization or assign existing items to additional organizations. Validation of imported items is done using the same rules as the item definition pages, so you are insured of valid items.

Before you use the interface tables, you must write and run a custom program that extracts item and/or associated data from your source system and inserts it into the appropriate interface tables. After you load the interface tables, run the appropriate concurrent request(s) to import the data into the production tables. The concurrent request programs assign defaults, validates data you include, and then imports the new data.

You can use the following concurrent request programs to import data:

• Import Items - imports items and item revisions.

• Import Catalog Items - imports items, item revisions, and their related user defined attributes, item associations (the relationship between items and suppliers, supplier sites, and/or supplier site organizations), manufacturer part numbers, and item people.

• Import Item/Item Revision User Attributes - imports user defined attributes for items and item revisions.

• Import Item People - imports people associated to items.

• Import Customer Items

• Import Customer Item Cross References

• Import Item Cross References - imports item cross references and GTIN cross references.

• Import Related Items

   To import items:

1. Load the Item Open Interface table (MTL_SYSTEM_ITEMS_INTERFACE) with the data you want to import.

   See:

   • Open Item Interface and Importing Items for a full description of how to import items.

   • My Oracle Support (http://metalink.oracle.com) Document ID 730164.1 for instructions on how to use the Oracle Product Information Management public APIs and sample code examples.

   To import items and associated data:

You can import items and their associated data from any source into Oracle Product Information Management using interface tables and the Import Catalog Item concurrent request program. Before you use the Import Catalog Item concurrent request program, you must write and run a custom program that extracts item information from your source system and inserts it into the following interface tables:

• MTL_SYSTEM_ITEMS_INTERFACE - for items.

• MTL_ITEM_REVISIONS_INTERFACE - for item revisions.

• EGO_ITM_USR_ATTR_INTRFC - for user defined attribute values associated to items.

• EGO_ITEM_ASSOCIATIONS_INTF - for suppliers, supplier sites, and supplier site organizations associated to items.

• EGO_AML_INTF - for manufacturer part numbers associated to items.

• EGO_ITEM_PEOPLE_INTF - for people associated to items.

The set_process_id and data_set_id values must be consistent across these tables to identify data related to a single batch.

After you load the data into the interface tables, run the Import Catalog Item concurrent request to import the data into the production tables. This program assigns defaults, validates data you include, and then imports the new data.

1. Navigate to the Development Manager responsibility > Batch Import > Import Items > Import Catalog Items. This opens the Run this Request... window.

   The Name field is automatically filled in with the name of the concurrent program, Import Catalog Items, and the Parameters window opens.

2. In the All Organizations field, indicate whether to run the interface for all organizations in the item interface table (MTL_SYSTEM_ITEMS_INTERFACE). If you choose No, the interface runs only for the current organization and interface table rows for other organizations are ignored.

3. In the Validate Items field, indicate whether to validate all items and their data residing in the interface table that have not yet been validated. If items are not validated, they are not processed into Oracle Inventory. You would choose No if you had previously run the item interface and responded Yes for Validate Items and No for Process Items, and now want to process your items.

4. In the Process Items field, indicate whether to process items. If you choose Yes, all qualifying items in the interface table are inserted into Oracle Inventory. You would choose No, along with Yes for Delete Processed Rows, to remove successfully processed rows from the interface table without performing any other processing.

5. In the Delete Processed Rows field, indicate whether to delete successfully processed items from the item interface tables. Choose No to leave all rows in the item interface tables for successfully processed items.

6. In the Process Set (Null for All) field, you can optionally enter a batch ID.

   Use this field to process a particular batch. To process all records in the interface table, leave this field blank.

7. In the Create or Update Items field, select whether to:

   • Create New Items - only create new items. Do not update existing items.

   • Update Existing Items - only update existing items. Do not create new items.

   • Sync Items - Create new items and update existing items.

8. Choose OK to close the Parameters window, then choose Submit.

   To import user attributes for items:

1. Load the Item User-defined Attributes Open Interface table (EGO_ITM_USR_ATTR_INTRFC) with the data you want to import. For detailed help on loading the Open Interface tables, refer to:

   • My Oracle Support (http://metalink.oracle.com) Document ID 730164.1.

   • the Integration Repository. See: Oracle Integration Repository User's Guide.

2. Navigate to the Inventory Responsibility in Oracle Applications, and click the Inventory link. Then click the Items link

3. Click the Import link.

4. Click the Import Item/Item Revision User Attributes link.

   Note: The Parameters form automatically appears when you select a request that requires parameter values.

5. After entering the values in the required parameter fields, click OK.

6. Click Submit.

   To import item people:

1. Load the Item People Open Interface table (EGO_ITEM_PEOPLE_INTF) with the data you want to import. For detailed help on loading the Open Interface tables, refer to the Oracle Manufacturing Open Interfaces and APIs manual.

2. Navigate to the Inventory Responsibility in Oracle Applications, and click the Inventory link. Then click the Items link

3. Click the Import link.

4. Click the Import Item People link.

   Note: The Parameters form automatically appears when you select a request that requires parameter values.

5. After entering the values in the required parameter fields, click OK.

6. Click Submit.

   To import customer items and customer item cross references:

1. In the Navigator menu under the Batch Import : Import Items heading, click the Import Customer Items link or the Import Customer Item Cross References link.

   For more information, see:

   • Customer Item and Customer Item Cross Reference Interfaces

   • Importing Customer Items

   • Importing Customer Item Cross References

   To import item cross references:

You can import item cross references from any source into Oracle Product Information Management using the Item Cross Reference Interface. Before you use the Item Cross Reference Interface, you must write and run a custom program that extracts item cross reference information from your source system and inserts it into the MTL_CROSS_REFERENCES_INTERFACE table. After you load the item cross references into the interface table, run the Import Item Cross References concurrent request to import the data into the production table. This program assigns defaults, validates data you include, and then imports the new item cross references.

1. Navigate to the Development Manager responsibility > Batch Import > Import Items > Import Item Cross References. This opens the Run this Request... window.

   The Name field is automatically filled in with the name of the concurrent program, Import Item Cross References, and the Parameters window opens.

2. Optionally, in the Parameters window, enter the following values:

   • In the Process Set (Null for All) field, enter a batch ID to process a particular batch. To process all records in the interface table, leave this field blank.

   • In the Delete Processed Records field, enter No to retain all processed records. This field defaults to Yes, which deletes all processed records from the MTL_CROSS_REFERENCES_INTERFACE table.

3. Choose OK to close the Parameters window, then choose Submit.

   To import related items:

You can import related items from any source into Oracle Product Information Management using the Related Items Interface. Before you use the Related Items Interface, you must write and run a custom program that extracts related item information from your source system and inserts it into the MTL_RELATED_ITEMS_INTERFACE table. After you load the related items into the interface table, run the Import Related Items concurrent request to import the data into the production table. This program assigns defaults, validates data you include, and then imports the new related items.

1. Navigate to the Development Manager responsibility > Batch Import > Import Items > Import Related Items. This opens the Run this Request... window.

2. Optionally, in the Parameters window, enter the following values:

   • In the Process Set (Null for All) field, enter a batch ID to process a particular batch. To process all records in the interface table, leave this field blank.

   • In the Delete Processed Records field, enter No to retain all processed records. This field defaults to Yes, which deletes all processed records from the MTL_RELATED_ITEMS_INTERFACE table.

3. Choose OK to close the Parameters window, then choose Submit.

Other Sources