Setup Import Options for a Spoke System

If the spoke system is used to import items into Oracle Product Hub, you can define options such as a schedule, a default organization, and whether to process per item or per bundle.

You can also define additional options such as if the application should check data quality on upload, pack update options, new item request options, item structure name and update options, and change order options.

Setting up the import options for a spoke system allows to quickly default the parameters for the item batches when importing items.

To edit the import options for a spoke system:
  1. On the Manage Spoke Systems page, click Action for the spoke system for which you want to edit the import options and then click Edit Import Options.
  2. Specify the settings as per your requirement for the following:
    • Default Batch Assignee
    • Import options to import items through an item batch:
    • Data Quality settings
    • Item Structure
    • Pack
    • New Item Request
    • Change orders
  3. Click Save and Close.

Item Batch Import Options

Here are the import options you can set for item batch import.
Option/Field Name Description
Schedule

Determine when the data specified in the item batch will be imported:

  • Manual (default): Import the data at a later time.
  • On Data Load: Import process is run immediately at the time of data upload.
Default Organization Select the organization to import data.
Process Items Determine if the items are to be imported individually (Per Item) or as a bundle (Per Bundle). The Per Bundle option is typically used when importing data from a GDSN data pool.
Delete Processed Rows

Delete the rows that have been processed. The options are:

  • All Rows
  • Error Rows
  • Completed Rows
Process Sequentially Specifies the publication jobs to run sequentially when there's more than one job. Otherwise, the jobs run in parallel with each other. Select this option to process the records sequentially. Otherwise, don't select this option.
Cross-references only
If you select this option, then source system data isn't imported. A cross-reference of the source system item is created with a matched, new, or cross-referenced item in Oracle Product Hub.
Note: You can only select the Cross-References Only option when creating an item batch. If the source system specified in the item batch definition is Product Information Management Data Hub, then the Cross-References Only option isn't available for selection.

If you select Cross-References Only, then import options for New Item Requests and Change Orders aren't available. However, options can be set for Item Structure and Pack.

Data Quality Import Options

Option/Field Name Description
Enable data quality matching See Available Options to Check Data Quality for Item Batches for description of each option.
Confirm single matches
Confirm unmatched as new item

Item Structure Import Options

Option/Field Name Description
Name Name of the item structure.
Update

Specify the structure components that must be updated:

  • All components: Dynamically updates all structure entities.
  • Changed components only: Updates only the components that have changed.

For more information about these option, see Item Batch Structure Options.

Pack Import Options

Option/Field Name Description
Update

Specify the pack components that must be updated:

  • All components: Update all components.
  • Changed components only: Update only those components that have changed.

New Item Request Import Options

Option/Field Name Description
New Item Request

Create change orders or add to existing change orders when importing items or structures:

  • One per Item
  • One per Item Batch
  • One per Item Bundle
  • One per Item Class

For information about these options, see Item Batch New Item Request Options.

Effective Date

Set the effective date for the new item request:

  • Type default: Uses the effective date from the New Item Request Type setting.
  • Effective immediately: New Item Request Type lines using this setting are effective immediately.
Add all items Select this option to add all the items for the import.

Change Order Import Options

Option/Field Name Description
Change Order

Create change orders or add to existing change orders when importing items or structures:

  • One per Item
  • One per Item Batch
  • One per Item Bundle
  • One per Item Class

For information about these options, see Item Batch Change Order Options.

Effective Date

Set the effective date for the change order:

  • Type default: Uses the effective date from the Change Order Type setting.
  • Effective immediately: Change order lines using this setting are effective immediately.
  • User-entered: Use this option for special cases in the item batch that uses the import map. For details, see Importing Item Data Using Import Maps.
Add all items Select this option to add all the items for the import.