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 Hub 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:

    • Upload data to the interface tables using Microsoft® Office Excel.

    • Upload data directly to the interface tables using APIs.

      Important: If you choose to upload data directly to the interface tables, then you must call the data load complete public API as the last step when uploading data.

  2. Match

    • Identify and resolve duplicates

    • Exclude unwanted data

  3. Import

    • Import and create a single source of truth blended record in the product information repository

    • Optionally, enforce the product change approval process when importing data

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 Hub 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

Related Topics

Creating Match Rules, Oracle Product Hub Implementation Guide

Defining Source Systems, Oracle Product Hub Implementation Guide

Creating Batches

Reviewing and Importing Batches

Reviewing and Importing PIMDH 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:

    • Batch Name

    • Source System

    • Batch Type - Specify the type of data contained in the batch, either items or structures.

    • Assigned To - Enter the name of the person responsible for reviewing and completing the batch.

      Users can only assign items to those organizations to which they have permission.

    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 Hub 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:

    • Before deleting data rows from interface tables, ensure that you do not need the batch information for any batch history purpose. No batch delete or purge function exists.

    • When using the Import Catalog Items or Bill and Routing Interface concurrent programs, ensure the Delete Processed Rows field equals No. For Import Workbench to function properly, rows must be deleted by Batch ID, not by process status.

    • Verify that adequate file system space and table space exists before loading data. For example, inadequate file system space for FND_FILE logging can result in incomplete import processes or partial imports.

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:

    • Items

    • Item Revisions

    • Item People

    • Item Categories

    • Item Organization Assignment

    • Manufacturer Part Numbers

    • Structures (only if the type of batch is Structure)

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

    • For an Item object, in the Add to Batch: Download Import Format page, find the item catalog category you want to use for the object selected (for example, select the Items object). A list of valid import formats for that item catalog category appears. See: Defining Item Catalog Import Formats , Oracle Product Hub Implementation Guide. Select one, then click Go.

    • For a Structure, in the Add to Batch: Import Structure page, select the import format you want to use, then click Go.

    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:

    • Import - Creates a Microsoft® Office Excel spreadsheet containing the batch data that matches the item catalog category and object type selected (or just the object type for structures). You can use this spreadsheet to import the data later. See: Importing Items Using a Spreadsheet

    • Add More - Enables you to select more records based on a different object, item catalog category, and import format criteria. Click Add More until you have selected all of the records you want to add to the batch.

    • Back - Returns you to the Add to Batch: Select Object page.

    • Cancel - Returns you to your search results.

    • Finish - Returns you to your search results.

  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 Hub Implementation Guide

Defining Source Systems, Oracle Product Hub 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:

    • Batch Status - Select one of the following statuses:

      • All

      • Active

      • Pending

      • Completed

      • Rejected

    • Batch ID - Enter a full or partial batch ID number, using % as a wildcard character.

    • Batch Type - Select either Item or Structure. If you select Structure, then the Structure Details column in the search results shows a detail icon.

    • Assigned To - Select the person who created the batch from the list.

    • Created On - Select the date the batch was created.

    • Batch Name - Enter a full or partial batch name, using % as a wildcard character.

    • Source System - Select either All or a particular source system from the list.

    • Created By - Select either the blank option or a particular person from the list.

  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:

    • Batch Id - Batch ID is a system-generated unique batch identification number. Click on the title to sort the batch IDs in ascending or descending order.

    • Batch Name - The batch name is created manually with the batch. Click on the title to sort the batch names in ascending or descending order.

    • Batch Type - The batch type can be either Item or Structure. If it is a structure, then the Structure Details column shows a detail icon.

    • Batch Status:

      • Active - A batch consisting of one or more records currently being worked on by the assignee.

      • Pending - A batch with a matching or import concurrent request in process. The system automatically derives this status.

      • Rejected - A batch rejected by the user. The user can choose to reject a batch. For example, a user might reject a batch containing many errors.

      • Completed - A batch containing records that have all been successfully imported or manually marked as complete.

    • Last Import Request Phase - Lists the phase of the last import concurrent request. Clicking on the phase link takes you to a concurrent request page listing all of the concurrent requests for this batch. If the phase is Scheduled, then the concurrent request page lists the date and time for import.

      Tip: You can change the import schedule date and time for the batch in the Batch Summary page, if necessary (see: To update the batch header). The system cancels the old scheduled date and time request and submits a new one. To cancel the import, change the Import option to None.

    • Last Match Request Phase - Lists the phase of the last matching concurrent request. Clicking on the phase link takes you to a concurrent request page listing all of the concurrent requests for this batch.

    • Total Items

    • Total Items Successfully Imported

      Caution: This field can show that a master item imported successfully even when one or more of the child entities, such as category assignments and child organization attributes, had errors. You can view the errors in the Update Batch page, Import tab, Import Status column. The Import Status shows as Partial.

    • Batch Summary - Use the batch summary icon to navigate to the Batch Summary page when the batch is active, completed, or rejected. A user who is not the batch assignee can access the Batch Summary page using this icon and review the batch contents.

    • Update - Use the update icon to navigate to the Update Batch page. This icon is enabled only for active batches and is available only to the assignee.

    • Delete - Use the delete icon to delete a batch record, including all data and headers. Only the batch assignee can delete a batch.

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:

    • Import Details tab

      • Before Import - displays the entities you plan to import with the batch. Types of entities you can import include items, item revisions, item organization/store, item supplier, item supplier site, item organization supplier site, components, people, organization assignments, category assignments, approved manufacturers lists, and structures. Structure and component entities only appear for a batch type of structure.

        Note: Users can only assign items to organizations to which they have permission to do so.

      • After Import - displays the types of entities that were imported with the batch, but breaks them down into:

        • Updated - The number of existing entities that will be updated with new information once the batch is imported.

        • New - The number of entities that will be created once the batch is imported.

      • Change Order - displays the change orders that will be created after the batch is imported.

      • New Item Request - displays the new item requests that will be created after the batch is imported.

        Note: When importing style items with SKUs, the style item is processed first, then the associated SKUs, resulting in two new item requests. If you want to include the style item and SKUs in the same NIR, then you must move the SKU line items from their draft NIR to the style item draft NIR. See: Creating New Item Requests for more information on working with NIRs.

      the picture is described in the document text

    • Unimported Items tab

      • Confirmed Items - includes items matched and confirmed using match rules or new items (see: Creating Match Rules, Oracle Product Hub Implementation Guide). Confirmed items include three types:

        • Cross-Referenced - Source system records with an existing cross-reference to an Oracle PIMDH item.

        • Matched - The user confirmed a single match for these source system records.

        • New Item - The user confirmed that these source system records must create new items.

        The above three types cannot exist for unconfirmed items. To change any confirmed item information, click the Update icon in a particular confirmed item type row. Update takes you to the Update Batch page.

      • Unconfirmed Items - includes the following three types:

        • Single Match - displays source system records with a single match found by running match rules. The user needs to review and confirm the match.

        • Multiple Matches - displays source system records with many matches found by match rules. The user needs to review and confirm a single match.

        • No Match - displays source system records unmatched by match rules.

        These three types cannot exist for confirmed items. To change any unconfirmed item information, click the Update icon in a particular unconfirmed item type row. Update takes you to the Update Batch page.

      • Excluded Items - displays the items excluded by the user from import. The system tracks excluded items by source system. If previously excluded items are reimported, the system automatically identifies them and tracks them in the Excluded Items region.

    • Data Load Options and Import Options tabs - displays the same information set up for the source system (see: Defining Source Systems, Oracle Product Hub Implementation Guide).

  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.

    • Structure region - provides summary information about the batch.

    • Components region - shows a single-level view of the components to import.

      • View by Confirmation Status - select how you want to view the components: All, Confirmed, or Unconfirmed.

      • Component Actions - reported as Add, Modify, or Delete.

      • Match Status and Match Actions - the same statuses and actions are used for both items and structures.

      • PIMDH Component and Op Seq - These columns are only populated if structure information in the source system contains the effectivity data and operating sequence on that component. If that exists, the matching PIMDH effectivity data and operating sequence displays.

      • Next Level - If multiple levels exist, you can use the Next Level number link to click down to the same information for components at each level of the structure.

      All other columns are self-explanatory.

    • Details region - shows the attributes for the components or items, depending on what you have chosen to view in the Attributes field. Compare the source system item attributes with the PIMDH item attributes.

    • Actions - optionally, select one of the following, then click Go:

      • Batch Summary - return to the Batch Summary page.

      • Concurrent Requests - view the status of concurrent requests ran previously.

      • Import - creates a concurrent request to import the structure.

    • Revert - Click Revert to undo any changes made to the structure.

    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 Hub 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:

    • From the Import Batches page, search for a batch. Click the Update icon in the row for the batch.

    • From the Batch Summary page, Unimported Items tab, click the Update icon for a particular type row.

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

    • Unconfirmed tab - enables you to look at all unmatched items and find appropriate matching items.

      • Match Status - displays an icon representing the match status of the item. Match statuses include:

        Tip: Use the Match Status selection field to view unconfirmed items by match status.

        • Single Match

        • Multiple Matches

        • No Match

        • New Item

        Tip: Select Show Key Notation to view the key to the Match Status icons.

      • Match Action - Select the action you want to take for this source system item.

        • Confirm - The user confirms the match with an existing PIMDH item.

        • Exclude - The user excludes this item from import.

        • Ignore - Temporarily excluded this item from import. The next time the same item data is uploaded within a batch, it appears in the Excluded tab for that batch.

        • New Item - The user confirms that a new item must be created during import for this source system item.

        • Unconfirmed (default value) -The user must confirm the match status in order to import the item.

      • PIMDH: Item - The Product Information Management Data Hub (PIMDH) item indicates the item that is within your single source repository. For example, PIMDH is a single source repository. The PIMDH: Item column indicates the item that you intend to match to or update with external source system item information. This column only names an item in the case of a single match.

      • Source System Item - The name of the source system item.

      • Source System Description - The description of the source system item.

      • Revision Label - Item revision planned for import.

      • Item Catalog Category - Item catalog category planned for import.

      Note: Additional columns can appear in your display depending on the display format chosen. The columns described above always appear.

      the picture is described in the document text

      Click Search Batch Items to search the batch items by item, item description, and item catalog category. Click Show All to reset the table and show all of the unconfirmed items in the batch. Click Run Match to go to the Run Match page where you can select and run certain match rules.

      If you select an item, detailed information regarding that item appears below in the Matching Items region. For example, if the item selected has multiple matches, then they appear in this region and you can select the appropriate matching item. viewing and comparing item information and to find an appropriate match. To confirm the match, select the item, then the Confirm match action for the corresponding row in the table above. Click Find Match to search and find another match.

      the picture is described in the document text

      Use the View field to change the display format between:

      • List View - lists the source system items in rows.

      • Compare View - enables you to compare source system items and PIMDH items vertically. Item information is listed in columns, with the attributes to import listed in rows. All attributes to import are listed, independent of the display format.

      This tab does not appear when the source system is PIMDH.

    • Confirmed tab

      • Details - Click Show in the Details column to open a table below the row. The information in the table depends on the option selected in the tab header Details field. Details field options include:

        • None - removes the Details column from the page

        • Manufacturer Part Numbers

        • Category Assignments

      • Match Status - displays an icon representing the match status, just as in the Unconfirmed tab. Match statuses include:

        • Single Match

        • Cross-Referenced

        • New Item

        • Multiple Matches

        • No Matches

      • Match Actions - select the action you want to take for this match, just as in the Unconfirmed tab. Valid actions include Confirmed, Ignore, Unconfirm, and Exclude. Before you import a batch item record, you can unconfirm or exclude the record from import.

        Note: You can also unconfirm a cross-reference. Once you do this, the item moves to the unconfirmed tab with no match. When you find a new match for the unconfirmed item, the status for that matched item becomes a single match. Upon import, the existing cross-reference is end-dated and the new cross-reference is created with a start effective date equal to the import date.

      • PIMDH: Item - displays the Oracle Product Information Management Data Hub (PIMDH) item to which the imported item will be matched. This column only appears for source systems other than PIMDH.

      • Source System Item and Source System Description - display the item name and description as they appear in the source system.

      • Revision Label - displays the item revision planned for import. This column is only shown if included in the display format.

        Note: All of the columns up to the Revision label are fixed and always present. The columns between the Revision Label and Item Catalog Category are determined by the display format.

      • Item Catalog Category - displays the item catalog category planned for import.

      • Import Ready - indicates, generally, whether or not the item information is ready for import. In the case of a new revision creation, the system verifies that a revision label, code, and effective date exist. In the case of a new item, the system verifies that an item number and description exist. The nonexistence of these values indicates an error and the column is blank (no icon). If these values exist and no other data is required, the system flags the item as available for import by placing an icon in the column.

      the picture is described in the document text

      The Search Batch Items and Show All buttons function the same as in the Unconfirmed tab. Click Import to initiate the import process, during which you can review and modify change management options. See: To import a batch, for more information about the import process.

      The View field options of List View and Compare View function the same as in the Unconfirmed tab, but the Compare View option includes an additional column for change policy. This column indicates whether attributes are under change control in the given item phase.

    • Imported tab

      • Details - Click Show in the Details column to open a table below the row. The information in the table depends on the option selected in the tab header Details field. Details field options include:

        • Import Errors

        • None - removes the Details column from the page

        • Manufacturer Part Numbers

        • Category Assignments

      • New Item Request - displays the name of the new item request that the system creates during import. Click on the new item request name to go to the New Item Request summary page. A return link brings you back to the Update Batch page.

      • Change Order - displays the name for the change order associated with the item as part of the last import request. The change order can either be system generated or entered by the user, depending on the change type. If the last import request for an item did not create a change order, then the value for that item row is blank. Click on the change order name to go to the Change Order summary page. A return link brings you back to the Update Batch page.

      You can select items and click Re-Import to initiate the re-import process. The process takes you to the change order page. You can review and modify the change order if necessary and click Apply. A concurrent request initiates the re-import process.

    • Excluded tab - shows all of the source system records excluded from import into PIMDH. The only field requiring explanation is Match Actions. To move an item back to the Unconfirmed tab, select Unexclude in the Match Actions field. To temporarily exclude an item, select Ignore. The next time the same item data is uploaded within a batch, the item appears in the Excluded tab for that batch.

      The Excluded tab does not appear if the source system is PIMDH since the item already exists in the PIMDH.

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 Hub Implementation Guide

Defining Source Systems, Oracle Product Hub 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:

    • From the Import Batches page, search for a batch. Click the Update icon in the row for the batch.

    • From the Batch Summary page, Unimported Items tab, click the Update icon for a particular type row.

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

    • Confirmed tab

      • Match Status - displays an icon representing the match status. Match statuses include:

        • Single Match

        • Cross-Referenced

        • New Item

      • Item, Description, and Long Description - display the item name and descriptions as they appear in PIMDH.

      • Revision Label - displays the item revision planned for import. This column is only shown if included in the display format.

        Note: All of the columns up to the Revision label are fixed and always present. The columns between the Revision Label and Import Ready are determined by the display format.

      Click Search Batch Items to search the batch items by item, item description, and item catalog category. Click Show All to reset the table and show all of the confirmed items in the batch. Click Import to initiate the import process, during which you can review and modify change management options. See To import a batch for more information about the import process.

      Use the View field to change the display format between:

      • List View - lists some key item information, similar to the item information in the Batch Summary page.

      • Compare View - Item information is listed in columns, with the attributes to import listed in rows. All attributes to import are listed, independent of the display format.

    • Imported tab

      • Details - Click Show in the Details column to open a table at the bottom of the page that indicates the errors per item. The table displays:

        • Entity - the entity (such as a user-defined attribute) where the error occurred.

        • Message Text - explains the details of the error.

        • Message Date

        • Message Type - an error or a warning.

      • Last Import ID - the concurrent request ID of the last import.

      • Last Import Date

      • Last Import Status - displays the concurrent request import statuses:

        • Success - indicates the importing of all attributes.

        • Partial - indicates the importing of only some attributes due to validation errors, change order policies, or security restrictions.

        • Error - no item attributes were imported.

      • New Item Request - displays the name of the new item request that the system creates during import. Click on the new item request name to go to the New Item Request summary page. A return link brings you back to the Update Batch page.

        Note: When importing style items with SKUs, the style item is processed first, then the associated SKUs, resulting in two new item requests. If you want to include the style item and SKUs in the same NIR, then you must move the SKU line items from their draft NIR to the style item draft NIR. See: Creating New Item Requests for more information on working with NIRs.

      • Change Order - displays the name for the change order associated with the item as part of the last import request. The change order can either be system generated or entered by the user, depending on the change type. If the last import request for an item did not create a change order, then the value for that item row is blank. Click on the change order name to go to the Change Order summary page. A return link brings you back to the Update Batch page.

      The columns between Last Import Status and New Item Request are self-explanatory.

      You can select items and click Re-Import to initiate the re-import process. The process takes you to the change order page. You can review and modify the change order if necessary and click Apply. A concurrent request initiates the re-import process.

  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.

    • Structure region - provides summary information about the batch.

    • Components region - shows a single-level view of the components to import.

    • Component Actions - reported as Add, Modify, or Delete.

    • PIMDH Component and Op Seq – Columns are self-explanatory

    • Next Level - If multiple levels exist, you can use the Next Level number link to click down to the same information for components at each level of the structure.

    • Details region - shows the attributes for the components or items, depending on what you have chosen to view in the Attributes field.

    • Actions - optionally, select one of the following, then click Go:

      Batch Summary - return to the Batch Summary page.

      Concurrent Requests - view the status of concurrent requests ran previously.

      Import - creates a concurrent request to import the structure.

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.

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:

    • Success - Purges the data of all successfully processed entities within the batch.

    • Fail - Purges the data of all failed entities within the batch.

    • Partial - Purges the data of all partially processed entities within the batch.

    • All - Purges the data of all entities within the batch, but leaves the batch itself intact.

  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 Hub Implementation Guide

Defining Source Systems, Oracle Product Hub Implementation Guide

Creating Batches

Reviewing and Importing Batches