1. HCM Data Loader
  2. How You Enable Administrator Access to HCM Spreadsheet Data Loader

How You Enable Administrator Access to HCM Spreadsheet Data Loader

There are two administrator aggregate privileges available for HCM Spreadsheet Data Loader, which allow you to give access to:

  • Maintain all HSDL templates
  • Access all data set and data set actions

Access to Maintain All Templates

If you want to have a single role responsible for maintaining all HSDL templates, add this aggregate privilege to your custom role:
Aggregate Privilege Name Aggregate Privilege Code
HCM Spreadsheet Data Loader Template Administration ORA_HRC_HSDL_TEMPLATE_ADMINISTRATION
This administration role provides the following access:
  • The Spreadsheet Templates task
  • Create spreadsheet templates for any object that supports HSDL
  • Maintain all existing templates

Access to All Data Sets and Data Set Actions

Apart from assigning roles to access the templates, you can configure the data set access for each role, such as create, save, upload, roll back and view all.

For business object templates where the object's application data security isn't extended to HCM Spreadsheet Data Loader, you won't be able to assign the role access. In such cases, you can create a custom role with this administrator access to grant data set permissions on all HSDL templates.

Aggregate Privilege Name Aggregate Privilege Code
HCM Spreadsheet Data Loader Data Set Administration ORA_HRC_HSDL_DATA_SET_ADMINISTRATION
This administration role provides the following access:
  • The Run Spreadsheet Data Loader task
  • Generate a spreadsheet from any active template
  • Create, save, upload, roll back and view all data sets within a generated spreadsheet, where the business object supports the capability.

However, in order to be able to upload data using the template you should grant this aggregate privilege

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

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)