How You Enable Access to HCM Spreadsheet Data Loader Tasks

You can perform the following tasks in the Data Exchange work area using the predefined job roles Human Resource Specialist and Human Capital Management Integration Specialist:

Spreadsheet Templates
Run Spreadsheet Data Loader
Delete Spreadsheet Stage Table Data

This topic explains how to give other roles access to these tasks. You must have the IT Security Manager job role or privileges.

Access to the Spreadsheet Templates Task

On the Spreadsheet Business Object Access page, you can authorize selected custom roles to create and import spreadsheet templates for selected business objects. You must also enable those custom roles to perform the Spreadsheet Templates task in the Data Exchange work area. To enable this access, you edit the custom roles to add the following aggregate privilege:

Privilege Name	Privilege Code
Manage HCM Spreadsheet Data Loader Templates	`ORA_HRC_MANAGE_HSDL_TEMPLATES`

In addition, if the Manage Data Exchange Work Area (HRC_MANAGE_DATA_EXCHANGE_PRIV) function security privilege isn't already granted to the role, then you must grant it.

If you want the users of this role to upload data for testing purposes using the Spreadsheet Templates preview functionality, you should also grant this aggregate privilege:

Aggregate Privilege Name	Aggregate Privilege Code
Load Data Using HCM Spreadsheet Data Loader	`ORA_HRC_LOAD_DATA_USING_HSDL`

Access to the Run Spreadsheet Data Loader Task

On the Manage Role Access tab of a spreadsheet template, you can authorize selected custom roles to generate spreadsheets and perform data-set actions. You must also enable those custom roles to perform the Run Spreadsheet Data Loader task in the Data Exchange work area. To enable this access, you edit the custom roles to add the following aggregate privileges:

Aggregate Privilege Name	Aggregate Privilege Code
Access HCM Spreadsheet Data Loader Templates	`ORA_HRC_ACCESS_HSDL_TEMPLATES`
Load Data Using HCM Spreadsheet Data Loader	`ORA_HRC_LOAD_DATA_USING_HSDL`

In addition:

Roles that are authorized to maintain a spreadsheet template must have the Manage HCM Spreadsheet Data Loader Templates (ORA_HRC_MANAGE_HSDL_TEMPLATES) aggregate privilege. You authorize a role to maintain a spreadsheet template on the Manage Role Access tab of the template.
If the Manage Data Exchange Work Area (HRC_MANAGE_DATA_EXCHANGE_PRIV) function security privilege isn't already granted to the role, then you must grant it.

Access to the Delete Spreadsheet Stage Table Data Task

To enable custom roles to perform the Delete Spreadsheet Stage Table Data task in the Data Exchange work area, add the following function security privilege:

Function Security Privilege Name	Function Security Privilege Code
Delete HCM Spreadsheet Data Loader Stage Data	`HRC_DELETE_HSDL_STAGE_DATA_PRIV`

In addition, if the Manage Data Exchange Work Area (HRC_MANAGE_DATA_EXCHANGE_PRIV) function security privilege isn't already granted to the role, then you must grant it.

Here's a tutorial on configuring roles to access HCM Spreadsheet Data Loader functionality Configure Roles to Access HCM Spreadsheet Data Loader

Here's a tutorial on setup tasks in preparation for defining HCM Data Loader integrations in Oracle Integration Cloud Setup Tasks for HCM Data Loader (HDL) Integrations in Oracle Integration Cloud (OIC)