1. Using Product Master Data Management
  2. Manage Publication Maps

Manage Publication Maps

You can specify a mapping between the Oracle Product Hub attributes and a target spoke system (to which the data will be published) using publication maps. Use the Manage Publication Maps task in the Product Information Management work area to search, create, edit, delete, or duplicate publication maps.

You can publish your data in a more streamlined and efficient manner because you can prune the data that’s sent to your spoke systems. Therefore, the ingesting systems can now receive a subset of the deltas based on the previous publication.

Create Publication Map and Specify Mapping Attributes

To create a new publication map:
  1. In the Product Information Management work area, click the Tasks panel tab and then click Manage Publication Maps.

    The Publication Maps page is displayed.

  2. Click the Add icon.

    The New publication map drawer appears on the right side.

  3. Provide the following information:
    • Name: Name of the publication map
    • Description: Description of the publication map
    • Output File Type: Type of file being uploaded.
    • Delimiter: If you’ve selected Text as the Output File Type, select Comma or Pipe.
    • Active: Indicate if the publication map is in active or inactive state.
    • Upload CSV data file that contains the spoke system attributes in the first row. The file size should not exceed 25 MB.
  4. Click Create to create the publication map and open it in edit mode. Clicking Cancel will close the drawer and publication map won’t be created.

    If you've uploaded a CSV file, the contents of the CSV are extracted and the Map details page is displayed, where you can specify the mapping between the spoke system attribute and the attribute mapping.

    If you haven't uploaded a CSV file, the mapping table will be empty when you try to edit the publication map. In this case, you can manually add spoke columns and their corresponding mapping rows to the table.

  5. In the mapping table, add the following mapping details for each attribute that you want to map.

    For existing rows that were extracted from the input CSV file, Sequence number and Spoke Attribute are available, and Master Attribute must be mapped.

    To add new rows to the mapping table, use the first inline edit row present in the table. In this row, you must specify the Sequence number, Spoke Attribute, and Master Attribute.
    • Sequence: Enter a unique sequence number for each row in the mapping table.
    • Spoke Attribute: Name of the target spoke attribute that you want to map.
    • Master Attribute: Click the drop-down list and select the master attribute that you want to map to the target spoke system attribute. Entity and Attribute Group columns are autopopulated when a master attribute is selected.
      Note: You can map one master data attribute to multiple spoke system columns.

    In Actions, click the Apply icon to add the mapped attribute as a row.

  6. To edit the attribute mapping, click the Edit icon for the respective row.
  7. To clear the attribute mapping, select the required rows and click Clear Mappings.
  8. To delete one or more attribute mapping, select the required rows and click Delete.
  9. To export the attribute mappings to an Excel file, select all or the required rows and click the Export icon.
  10. Click Save or Save and Close to save the changes.

Edit Publication Map

To edit a publication map:
  1. On the Publication Maps page, search for the publication map.
  2. From the search results, click the required publication map to open it in edit mode.
  3. Specify the attribute mapping between the spoke system attributes and the master data attributes. You can also modify the Description, Output File Type, Delimiter, and the status. For details, see Create Publication Map and Specify Mapping Attributes.
  4. Click Save or Save and Close to save the changes.

Duplicate Publication Map

To duplicate a publication map:
  1. On the Publication Maps page, search for the publication map that you want to use to create another publication map.
  2. From the search results, for the publication map that you want to duplicate, click Duplicate.

    The <Publication Name> (Copy) drawer appears on the right side.

  3. Change the details such as Name, Description, Output File Type, Delimiter, and click Create.
    Note: When you duplicate an existing map, you can’t upload a CSV file.

    The Map details page is displayed.

  4. Update the attribute mapping between the spoke system attributes and the master data attributes. For details, see Create Publication Map and Specify Mapping Attributes.
  5. Click Save or Save and Close to save the changes.

Delete Publication Map

On the Publication Maps page, search for the publication map that you want to delete and click the Delete icon. A message appears asking for confirmation. Click Delete to confirm the deletion.

Business Rules and Guided Journeys for Publication Maps

The New publication map drawer and Map details page support extensibility through business rules and page properties.

The predefined business rules are:
  • Default
  • Delimiter Required and Default Value Localization Rule

You can also define any extension business rules for the New publication map drawer and the Map details pages.

You can control the visibility of the description and active badge on the page header and configure the Guided Journeys for the Map details page using the Page Properties section.

For details on how to configure business rules and guided journeys, see: