Skip Headers

Oracle Product Information Management User's Guide
Release 12.1
Part Number E13109-09
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Synchronizing Product Data and Managing Data Quality

This chapter covers the following topics:

Overview of Inbound Product Data Synchronization and Data Quality Management

Oracle Product Information Management uses the Import Workbench to bring product data from disparate systems into a master product information repository, known as the Product Information Management Data Hub (PIMDH). Examples of disparate systems and data include:

While importing data into a centralized data model, the Import Workbench identifies and resolves duplicates and errors while at the same time enriching existing data with external information. This process creates a blended record, known as the single source of truth. You can then create business reports and other documents related to the updates. The following steps describe the Import Workbench process:

  1. Extract and Load. Use one of the following options to extract and load:

  2. Match

  3. Import

You can import the following types of data using Import Workbench:

Important: You cannot update transaction attributes using the Item Open Interface, the Microsoft® Office Excel spreadsheet, or the Import Workbench. You must update them directly. See: Defining Transaction Attributes, Oracle Product Information Management Implementation Guide.

In order to import data from an external source system, you must define a source system for each data source and create match rules to help match imported data to existing data in the product information repository.

Importing Product Information Management Data Hub Data

You can use the PIMDH as its own source system when importing new or updated data. The advantage of using the Import Workbench instead of the Item Open Interface or importing data using a spreadsheet comes from the Import Workbench's extensive error management capabilities.

The process of importing PIMDH data is much simpler than importing data from a source system for the following reasons:

Process for Importing PIMDH Data

  1. Create a batch using the Product Information Management Data Hub as the source system. See: Creating Batches

  2. Review and import the batch. See: Reviewing and Importing PIMDH Batches

  3. Perform actions on the batch as necessary. See: Performing Actions on Batches

Importing GDSN Data

The process of importing GDSN data differs slightly from the process of importing data from other sources. To trigger this process, specify that the source is a GDSN data pool when defining the source system by selecting the Enable for Data Pool check box. See: Defining Source Systems, Oracle Product Information Management Implementation Guide

GDSN batches differ from other batches in the following ways:

Related Topics

Creating Match Rules, Oracle Product Information Management Implementation Guide

Defining Source Systems, Oracle Product Information Management Implementation Guide

Defining Units of Measure for GDSN Attributes, Oracle Product Information Management Implementation Guide

Creating Batches

Reviewing and Importing Batches

Reviewing and Importing PIMDH Batches

Reviewing and Importing GDSN Batches

Performing Actions on Batches

Creating New Items

Creating Batches

A batch consists of the data that you want to import into the master product information repository. You can use two methods to create batches:

Prerequisites

To create a batch online

  1. Navigate to the Import Workbench.

    In the Import tab, click Create Batch.

  2. Complete the following fields:

    the picture is described in the document text

  3. Review the selections on the Data Load Options and Import Options tabs and make changes as necessary.

    The selections default from the source system selected. For detailed information about each selection, see: Defining Source Systems, Oracle Product Information Management Implementation Guide.

    Note: You cannot change Import Options after you create the batch.

  4. Click Apply.

To create a batch using an API

  1. Use oracle.apps.ego.item.itemimport.server.EgoImportBatchHeaderAMImpl to create batches.

    Caution: Consider the following points when loading data directly into the open interface tables:

To add records to an existing batch

After creating a batch, load data into a batch. Use one of the following two methods to load data into a batch:

Using the Add to Batch button enables you to add records to a batch after the batch has been created.

Note: You can also add records to an existing batch by loading the item or structure interface tables directly using the same batch ID again. See: To create a batch using an API

  1. Navigate to the Import Workbench. Use the search fields to find a particular batch. For detailed information about each search field, see: To find a batch.

  2. Select the batch on which to perform the action.

  3. Click Add to Batch.

  4. In the Add to Batch: Select Object page, select the type of object to which to add the data:

  5. Perform one of the following, depending on the batch type of the batch you want to add:

    The import format determines the column names on the spreadsheet. For example, an item import format may have different columns than a manufacturing part number import format spreadsheet.

  6. Click one of the following:

  7. The Select Viewer page appears after you click Import. Select the version of Microsoft® Office Excel that you want to use to view the document.

  8. Check Reporting if you only want to use the document for reporting purposes.

    If you check Reporting, you cannot upload records from the document.

Related Topics

Overview of Inbound Product Data Synchronization and Data Quality Management

Creating Match Rules, Oracle Product Information Management Implementation Guide

Defining Source Systems, Oracle Product Information Management Implementation Guide

Reviewing and Importing Batches

Performing Actions on Batches

Reviewing and Importing Batches

Reviewing batches while the data is in the open interface tables consists of the following actions:

Once you have reviewed a batch, initiate the import process to import the data into PIM Data Hub.

Only the batch assignee can access a batch to perform matching, import and other functions for a batch's records. This ensures that only one person can work on a batch at a time. However, anyone with access to the Import Workbench can change the assignee.

To find a batch

  1. Search for a batch using one or more of the following fields:

  2. Click Go to retrieve the search results or click Clear to clear all of the search fields.

  3. Review the search results under the following columns:

To review batch records

Review batch records to determine possible further actions, such as:

  1. Navigate to the Import Workbench. Use the search fields to find a particular batch. For detailed information about each search field, see: To find a batch.

  2. Click the Batch Summary column icon (eyeglasses) for a particular batch.

  3. Review the Batch Summary page:

  4. If you are importing structures, review the structure details.

    Navigate to the Compare Structure page. From the Import Workbench search results, Structure Details column, click the structure details icon for a batch.

    Click Save to save any changes made to the structure.

    the picture is described in the document text

To update the batch header

If you need to change the Data Load Options, Import Options, or Batch Name of a batch, select Update from the Actions field in the Batch Summary page, then click Go. For information about the Data Load Options and Import Options tab fields, see: Defining Source Systems, Oracle Product Information Management Implementation Guide.

To update batch records

  1. If, after reviewing batch records, you need to take action, you can navigate to the Update Batch page in one of two ways:

  2. Review each batch record in the Update Batch page tabs. Some key fields in the tabs are described below.

To import a batch

The import concurrent request imports item and structure information and updates the matching PIMDH item and structure. The import process updates a specifically requested item revision, latest item revision or creates a new item revision, depending on the matching item. The import process performs security checks in the following order:

The system behaves as follows when importing attributes:

The source system item number and description updates the cross-reference table source system item and description fields.

  1. From the Update Batch page, select Import Batch from the Actions field, then click Go.

    The system submits your import concurrent request, gives you a concurrent request number, then returns to the Import Batches page.

To view your import concurrent requests

  1. From the Update Batch page, select Concurrent Requests from the Actions field, then click Go.

    The Request Summary Table displays details about every import concurrent request of the batch.

Related Topics

Overview of Inbound Product Data Synchronization and Data Quality Management

Creating Match Rules, Oracle Product Information Management Implementation Guide

Defining Source Systems, Oracle Product Information Management Implementation Guide

Creating Batches

Performing Actions on Batches

Reviewing and Importing PIMDH Batches

After creating a batch using PIMDH as the source system (see: Creating Batches, you can review the batch records, make changes as necessary, and import the batch.

To review the batch

  1. Navigate to the Import Workbench. Use the search fields to find a particular batch. For detailed information about each search field, see: To find a batch.

  2. Click the Batch Summary column icon (eyeglasses) for a particular batch.

  3. Review the Batch Summary page.

    See: To review batch records for a detailed explanation of this page.

  4. If, after reviewing batch records, you need to take action, you can navigate to the Update Batch page in one of two ways:

  5. Review each batch item in the Update Batch page tabs. Some key fields in the tabs are described below.

  6. If you are importing structures, review the structure details.

    Navigate to the Compare Structure page. From the Import Workbench search results, Structure Details column, click the structure details icon for a batch.

To import a PIMDH batch

The process of importing a PIMDH batch is the same as the non-PIMDH process. See: To import a batch.

Reviewing and Importing GDSN Batches

The system automatically preprocesses and creates a batch for inbound items received from 1SYNC. Review the batch records, make changes as necessary, and import the batch. You can send the following messages to 1SYNC to inform the data pool of the items' status.

To manually send messages, see Managing 1SYNC Messages.

Prerequisites

To review a GDSN batch

Review batch records to determine possible further actions, such as:

  1. Navigate to the Import Workbench. Use the search fields to find a particular batch. For detailed information about each search field, see: To find a batch.

  2. Click the Batch Summary column icon (eyeglasses) for a particular batch.

  3. Review the Batch Summary page.

    See: To review batch records for a detailed explanation of this page.

  4. If, after reviewing batch records, you need to take action, you can navigate to the Update Batch page in one of two ways:

  5. Review each batch item in the Update Batch page tabs. Some key fields in the tabs are described below.

  6. If you are importing structures, review the structure details.

    Navigate to the Compare Structure page. From the Import Workbench search results, Structure Details column, click the structure details icon for a batch.

    Click Save to save any changes made to the structure.

    the picture is described in the document text

To import a batch

The import concurrent request imports item and structure information and updates the matching PIMDH item and structure. The import process updates a specifically requested item revision, latest item revision or creates a new item revision, depending on the matching item. The import process performs security checks in the following order:

The system behaves as follows when importing attributes:

The source system item number and description updates the cross-reference table source system item and description fields.

  1. From the Update Batch page, select Import Batch from the Actions field, then click Go.

    The system submits your import concurrent request, gives you a concurrent request number, then returns to the Import Batches page.

Performing Actions on Batches

Once you have found a batch (see: To find a batch), you can perform the following actions.

Prerequisites

To add to a batch

You can add all types of item and structure information, such as item attributes, people, category assignments, component attributes and various other data to a batch, at the same time. See: To add records to an existing batch.

Note: You can only add to a batch when the batch header Enabled for Data Pool field value equals No.

To complete a batch

You can complete a batch once all the required records are either imported or excluded. To complete a batch, you can confirm or leave the records unconfirmed if you do not want to import them.

  1. Select a batch, then click Complete. The Batch Status column now displays Completed for the batch.

    Once a batch has a status of complete, you cannot perform any actions on the batch. You can delete the batch or re-activate it.

To reject a batch

  1. Select a batch, then click Reject. The Batch Status column now displays Rejected for the batch.

    You can no longer perform any actions on a batch once it has a status of Rejected, but you can delete the batch. You can also re-activate the batch.

To reassign the batch

  1. Select a batch, then click Reassign. The Reassign Batch page appears. Find and select another user to assign to the batch.

    When a batch is assigned to another user, you cannot make any changes to the batch. If you need to make changes to the batch, reassign it to yourself.

To create a new batch

See: Creating Batches

To purge a batch

  1. Select a batch, then select Purge from the Actions field.

  2. In the Purge Batch page, select one of the following options in the Import Status field:

  3. Click Apply.

    The Purge concurrent program initiates and you receive a concurrent program confirmation message along with the concurrent request ID. Verify that the concurrent request executed properly and the data was purged.

Related Topics

Overview of Inbound Product Data Synchronization and Data Quality Management

Creating Match Rules, Oracle Product Information Management Implementation Guide

Defining Source Systems, Oracle Product Information Management Implementation Guide

Creating Batches

Reviewing and Importing Batches

Managing 1SYNC Messages

You have the option to manually send the following messages to 1SYNC:

To manually send a CIC message

When an item is imported successfully, all of the items with the same Group ID are imported and a packaging BOM is created. A CIC-Synchronize message is sent to 1SYNC automatically. You can also send this message manually for an imported item.

When the Import Workbench rejects the top item in a pack, the system automatically sends a CIC-Reject message to 1SYNC. All items with the same Group ID move to the Excluded tab of the batch, with a Last Synchronization Status of Rejected. You can also send this message manually for a top level item.

When you need data corrections, manually send a CIC-Review message to 1SYNC for a top level item.

The steps to manually send all three types of CIC messages are similar and described below.

  1. Navigate to the Import Workbench, then the Update Batch page.

  2. Select Send Message, then click Go.

  3. In the Send Message page, select one of the following Message Types:

  4. For Rejected or Request for Correction messages, specify the Status using the drop-down list.

  5. For a Request for Correction message, specify the Corrective Action assigned to the supplier from the drop-down list.

  6. For a Rejected or Request for Correction message, enter any additional comments, if required.

  7. Search for the item for which you want to send the message. You can use the following search criteria: Source System Item Description, Source System Item, and Group ID.

    The search results show only the top level items, not the child items. The CIC message is sent for the entire hierarchy, not each individual item. Select the item hierarchies to synchronize.

  8. Click Submit.

To send a Request for Customer Item Notification (RFCIN) message

The Request for Catalogue Item Notification (RFCIN) message originates from a 1SYNC data recipient (retailer) and is sent to the 1SYNC datapool. Using the RFCIN message, a data recipient can request 1SYNC to resend Catalog Item Notification (CIN) messages matching specific criteria. You can receive the catalog items in two different ways based on whether the Is Reload box is checked or not:

RFCIN Sent to 1SYNC from the Data Recipient

<?xml version="1.0" encoding="UTF-8"?>
<os:envelope xmlns:os="http://www.1sync.org" xmlns:sh="http://www.gs1.org/sh"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.1sync.org
http://www.preprod.1sync.org/schemas/item/1.0/RequestForCatalogueItemNotificationProxy.xsd">
	<header version="1.0">
		<sender>6701115112315</sender>
		<receiver>8380160030102</receiver>
		<messageId>rfcin.SK101005_1995</messageId>
		<creationDateTime>2006-09-05T17:20:00</creationDateTime>
	</header>
	<requestForCatalogueItemNotification version="1.0">
		<header>
			<userGLN>6701115112315</userGLN>
			<userId>6701115112315@XML</userId>
		</header>
		<document>
			<documentId>rfcin.SK101005_1995.0001.20060905174209</documentId>
			<dataRecipientGLN>6701115112315</dataRecipientGLN>
			<isReload>true</isReload>
			<informationProviderGLN>7701115112376</informationProviderGLN>
			<targetMarket>US</targetMarket>
			<gtin>00010108675321</gtin>
		</document>
	</requestForCatalogueItemNotification>
</os:envelope>

Upon receiving a RFCIN message, the 1SYNC datapool responds with a Request for Catalogue Item Notification Response message (RFCIN Response).

RFCIN Response Sent from 1SYNC to the Data Recipient

This example contains both a documentAcknowledgement and documentException.

<?xml version="1.0" encoding="UTF-8"?>
<os:envelope xmlns:os="http://www.1sync.org" xmlns:sh="http://www.gs1.org/sh"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.1sync.org
http://www.preprod.1sync.org/schemas/item/1.0/ResponseProxy.xsd">
	<header version="1.0">
		<sender>8380160030102</sender>
		<receiver>6701115112315</receiver>
		<messageId>rfcinr.SK101005_1998</messageId>
		<creationDateTime>2006-09-05T18:01:00</creationDateTime>
	</header>
	<requestForCatalogueItemNotificationResponse version="1.0">
	<header>
		<originatingMessageId>rfcin.SK101005_1995</originatingMessageId>
	</header>
	<documentAcknowledgement>
		<originatingDocumentId>rfcin.SK101005_1995.0001.2006005174209</originatingDocumentId>
	</documentAcknowledgement>
	<documentException>
		<originatingDocumentId>rfcin.SK101005_1995.0002.2006005174209</originatingDocumentId>
		<description code="002">Invalid Information Provider GLN [7701115112261].</description>
	</documentException>
	</requestForCatalogueItemNotificationResponse >
</os:envelope>
  1. Select the M4U: Demand Side User responsibility, then Send Request for Item Notification.

  2. In the Request for Catalogue Item Notification page, enter values in the following fields:

  3. Click Send Item Information Request to send the RFCIN message to the 1SYNC datapool.

Managing Subscriptions

Data recipients must create subscriptions in the 1SYNC datapool to set up item synchronization. Subscriptions in the 1SYNC datapool act as filters that specify which item's information that are synchronized in the GDSN network are of interest to the data recipient. 1SYNC supports both creation and deletion of subscriptions using the Catalogue Item Subscription (CIS) messages. Upon receipt of a CIS Add message, the 1SYNC datapool responds with a CIS Response message.

For more information about 1SYNC messaging, see 1SYNC_Data_Recipient_XML_Guide_R6.1v2.pdf, available for download from 1SYNC. Contact 1SYNC at http://www.1sync.org/home.html.

Example of a CIS Sent to 1SYNC

<?xml version="1.0" encoding="UTF-8"?>
	<os:envelope xmlns:os="http://www.1sync.org" xmlns:sh="http://www.gs1.org/sh"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.1sync.org
	http://www.preprod.1sync.org/schemas/item/1.0/CatalogueItemSubscriptionProxy.xsd">
		<header version="1.0">
			<sender>6701115112315</sender>
			<receiver>8380160030102</receiver>
			<messageId>cis.SK101005_1446</messageId>
			<creationDateTime>2006-09-05T17:20:00</creationDateTime>
		</header>
		<catalogueItemSubscription version="1.0">
		<header>
			<userGLN>6701115112315</userGLN>
			<userId>6701115112315@XML</userId>
		</header>
		<document>
			<documentId>cis.SK101005_1446.0001.20060905174209</documentId>
			<dataRecipientGLN>6701115112315</dataRecipientGLN>
			<operation>ADD</operation>
			<informationProviderGLN>7701115112377</informationProviderGLN>
			<targetMarket>US</targetMarket>
			<gtin>00010108675321</gtin>
		</document>
	</catalogueItemSubscription>
</os:envelope>

Upon receipt of a CIS message, the 1SYNC datapool responds with a CIS Response message.

Example of a 1SYNC CIS Response

This example contains both a documentAcknowledgement and a documentException.

<?xml version="1.0" encoding="UTF-8"?>
<os:envelope xmlns:os="http://www.1sync.org" xmlns:sh="http://www.gs1.org/sh"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.1sync.org
http://www.preprod.1sync.org/schemas/item/1.0/ResponseProxy.xsd">
	<header version="1.0">
		<sender>8380160030102</sender>
		<receiver>6701115112315</receiver>
		<messageId>cisr.SK101005_1886</messageId>
		<creationDateTime>2006-09-05T18:01:00</creationDateTime>
	</header>
	<catalogueItemSubscriptionResponse version="1.0">
		<header>
			<originatingMessageId>cis.SK101005_1446</originatingMessageId>
		</header>
		<documentException>
			<orginatingDocumentId>cis.SK101005_1446.0001.20060905174209
			</orginatingDocumentId >
			<description code="002">Invalid Information Provider GLN [7701115112377].</description>
		</documentException>
		<documentAcknowledgement>
			<orginatingDocumentId >cis.SK101005_1446.0002.260909</orginatingDocumentId >
		</documentAcknowledgement>
	</catalogueItemSubscriptionResponse>
</os:envelope>

Once you add a subscription using the Subscription Management pages, you can synchronize the subscription with the 1SYNC datapool using the CIS Add message. Optionally, you can delete a subscription from the 1SYNC datapool using the CIS Delete message.

To create a subscription

  1. Navigate to the M4U Demand Side User responsibility.

  2. Select Create Subscription from the responsibility menu.

  3. In the Create Subscription page, enter values for each of the following CIS message parameters to create a CIS record.

  4. Click Apply to save the subscription details.

To synchronize a subscription with the 1SYNC datapool

  1. Navigate to the M4U Demand Side User responsibility.

  2. Select Search Subscription from the responsibility menu.

  3. In the Search Subscription page, search for the subscription created earlier.

    Enter search options, then click Go. The list of matching subscriptions displays below.

  4. Select the subscription, then click Subscribe. A CIS message is sent to 1SYNC.

    Note: You can only subscribe to the 1SYNC datapool when the subscription has a status of New or Add Failed.

To delete a subscription

Follow these steps to delete a subscription that has been synchronized with the 1SYNC datapool.

  1. Navigate to the M4U Demand Side User responsibility.

  2. Select Search Subscription from the responsibility menu.

  3. In the Search Subscription page, search for the subscription created earlier.

    Enter search options, then click Go. The list of matching subscriptions displays below.

  4. Select the subscription to delete, then click Unsubscribe.

    This sends a CIS Delete message to the 1SYNC datapool.

    Tip: You can only delete/unsubscribe when the status of the subscription is Subscribed.

To view the status of a subscription

  1. Navigate to the M4U Demand Side User responsibility.

  2. Select Search Subscription from the responsibility menu.

  3. In the Search Subscription page, search for a particular subscription.

    Enter search options, then click Go. The list of matching subscriptions displays below.

  4. The status displays in the Search Subscription page.

    Valid subscription statuses include:

To edit a subscription

You can edit subscriptions that are not yet synchronized with 1SYNC. You cannot edit subscriptions that have already been synchronized with 1SYNC. To edit a synchronized subscription, you must delete (unsubscribe) the subscription from 1SYNC before making any changes.

  1. Navigate to the M4U Demand Side User responsibility.

  2. Select Search Subscription from the responsibility menu.

  3. In the Search Subscription page, search for the subscription you want to edit.

    Enter search options, then click Go. The list of matching subscriptions displays below.

  4. Click the Update icon in a particular subscription's row.

    Note: You can only edit subscriptions with a status of New, Add Failed, Delete Failed, or Unsubscribed.

Related Topics

Reviewing and Importing GDSN Batches