Create a Category Map

This topic describes how to create a supplier content map set and its category maps.

In this scenario, you map categories in supplier catalogs to the corresponding catalog categories in the application, by creating a map set containing category maps.

Note: Use the Oracle ADF Desktop Integration Add-In for Excel to create category maps. You can install the add-in from Navigator > Tools > Download Desktop Integration Installer.

To create a map set:

1. From the Navigator, under Procurement, click Catalogs.

2. On the Overview page, click the Tasks tab.

3. The Tasks panel shows all the catalog management tasks you can perform.

   Click the Manage Supplier Content Map Sets task.

4. On the Manage Supplier Content Map Sets page, in the Search Results section, click Create.

5. On the Create Map Set dialog box, the Procurement BU is already selected for you.

6. Enter a Map Set name and Description.

7. Click Save and Close.

8. Click OK on the Confirmation dialog.

9. On the Manage Supplier Content Map Sets page, in the Search Results section, click the Manage Maps icon in the row for the newly created map set

10. On the Manage Maps dialog, select the Category map row and click Create.

11. To open the mapping spreadsheet, sign in using the same credentials you used to sign in to the application.

12. Use the Edit Category Map spreadsheet to enter category maps.

    On the Manage Map tab, Categories subtab, in the External Category column, enter the category name from the supplier.

13. In the Internal Category Name column, enter the corresponding value used in the application. The internal category must be an existing category in the application.

    1. Click in the Internal Category column to select an existing category.

    2. In the Select Internal Category dialog, search for and select an internal category, then click OK.

14. The value in the Key column is automatically populated.

15. To add more category maps, select the next row, right-click and select Insert.

16. When you're done entering maps, click Upload to upload the mappings.

17. Notice the Status column is updated to show status of the upload for each row.

To delete an entry from the map set:

1. On the Manage Map tab, Categories subtab, click Download. Once the download is complete, the Status column is blank.

2. Select the row you want to delete.

3. On the selected row, click in the cell for the Mark for Deletion column. Notice a bullet displays in the column to indicate the row is marked for deletion.

4. Click the Upload button.

5. Notice the row is deleted.

6. Close the spreadsheet.

To edit a map set:

1. On the Manage Supplier Content Map Sets page, in the Search Results section, locate the row for the map set you want to edit. Then click the Manage Maps icon for the row.

2. On the Manage Maps dialog, in the Category Map row, click Edit.

3. Open the mapping spreadsheet and sign in.

4. On the Edit Category map spreadsheet, you can edit, insert and delete rows. You can't enter duplicate rows.

5. When you're done making edits, click Upload.

6. When the edited mappings are uploaded, notice the Status column is updated to show the status of the upload for each affected row.

7. Close the spreadsheet.

8. On the Manage Supplier Content Map Sets page, click Done.