Introduction

Use HCM Spreadsheet Data Loader (HDSL) to provide use-case specific bulk data-loading spreadsheets for your business users and your inbound integrations. You configure spreadsheet templates for your use cases and assign access to those templates to just the roles that require them. For example, your HR Specialist could have access to a New Hire spreadsheet, whereas the Overtime Hours spreadsheet may only be available to your Payroll Administrator.

You create custom templates in your non-production environments, either from scratch, by importing shared templates from Cloud Customer Connect, or by copying and editing a preconfigured template. Once you've tested your template, you then import it into your production environment and assign the roles that can use them.

This tutorial explains how to find shared templates on Cloud Customer Connect and how to import these and your custom templates.

Objectives

In this tutorial, you will:

  • Understand how to find shared HSDL templates on Cloud Customer Connect.
  • Import a template and configure template access.
  • Review and override template parameters.

Prerequisites

To complete this tutorial, you need:

  • A HSDL Template Designer role for importing templates into non-production environments, or a HSDL Template Maintenance role for production environments. The role needs to assigned access to the business objects you want to import templates for.

Tip:

The Configure Access to Design and Maintain HCM Spreadsheet Data Loader (HSDL) Templates tutorial explains how to configure these roles.

Task 1: Downloading Templates from Cloud Customer Connect

HSDL templates can be found on the HCM Resource Center on Cloud Customer Connect.

  1. To access the forum from the Cloud Customer Connect home page, click Categories > Human Capital Management > HCM Resource Center.
    2. Filter by HSDL and user

  2. Search for topics with the Keyword HSDL to see all available HSDL templates.
  3. Search for topics with the Keywords HSDL and User to see all HSDL templates for the User object.
    4. Filter by HSDL and user

  4. Search for the topic titled HSDL Templates: User Account Management and click the topic name.
    5. Filter by HSDL and user

    Tip:

    Topics named HSDL Templates: (plural) will provide links to templates related to the subject, such as User Account Management. Topics named HSDL Template: (singular) will provide the download for a specific template.
  5. Click on the template you want to import. For example, Add or Remove User Account Roles.
    Filter by HSDL and user

    Each HSDL template topic provides:

    • A description of the template and the actions that are supported.
    • Links to related topics.
    • A zip file containing the xml template definition.

  6. Click the zip file to download it.
  7. Extract the zip file ready for the xml to be imported.

Task 2: Importing Spreadsheet Templates

In this step you'll import the template into the application where you can edit it and make it active.

  1. Log into the application with template designer or maintenance role.
  2. Navigate to My Client Groups > Data Exchange > Spreadsheet Template.
  3. Click Import.
    4. Filter by HSDL and user

  4. On the Import dialog window, specify a name that describes the use case the spreadsheet template supports, such as Add or Remove User Account Roles.

    5. Tip:

    A code will be defaulted based on the name specified but you can override this. It needs to be unique.
  5. Select the xml file of the template file to import, using the Import field.
  6. Provide a description so business users can understand when to use this template.
  7. If the template is legislation specific, specify the Legislative Data Group that it's applicable for.
    8. Filter by HSDL and user

  8. Click OK.

    9. You should receive confirmation that the template was imported with no errors. Click OK.

    Filter by HSDL and user

    Tip:

    If errors were encountered, download the log file for more information.

    You'll be returned to the Spreadsheet Templates page where you can now edit or assign roles to the template.

Task 3: Securing Template Access

If you want business users to have access to individual spreadsheet templates, you need to configure the template to assign the roles that can use the template and what data set actions they have.

Note:

Not all objects support data security in HSDL. You can't share templates based on these objects with business users.
  1. Edit your template, if you've closed it click on the template name from the Spreadsheet Templates task.
    2. Filter by HSDL and user

  2. On the Define tab, review the value for the Assign Roles to Template field found in the Template Security section. Only if it is 'Enabled' can you continue with assigning role access to your template.
    Review Assign Roles to Template

  3. If the Upload Data As field has a value of Elevated User, data security will be ignored. Select Session user to ensure data security is used.
    Select Session User

    Note:

    This field is read-only when Assign Roles to Template has a value of Disabled.
  4. Click Role Access.
    Click Role Access

  5. Click the Add icon on the Permitted Data Set Operations table toolbar.
    Click Add Role

  6. Search for and select the job role that should have access to the template:
    Search for and select the role

  7. Click Add.
  8. Configure the data set operations that users with this role should have:
    Data Set Operations
    Operation Access
    Create Users can create new data sets.
    Save Data set changes can be saved to the staging tables.
    Upload Data sets can be uploaded to the Oracle HCM Cloud.
    Roll Back Data sets can be rolled back, deleting data that was successfully loaded and not subsequently updated. Roll back is only available for a few business objects.
    View All All data sets can be downloaded, not just those created by the user.
  9. Click Save.

Task 4: Configuring Template Parameters

You can configure template parameters to override default processing. For example, you can enable incremental events and audit changes uploaded by a spreadsheet.

Note:

Events and audit must be enabled in the application for the business object the template loads data for, for these template parameters to have any affect.
  1. Edit your template, if you've closed it click on the template name from the Spreadsheet Templates task.
  2. Navigate to the Define page.
  3. Click the Add icon on the Template Parameters table toolbar.
    4. Search for and select the role

  4. Click Search on the Search Template Parameters page.
  5. Review the list of parameters and their default values to determine if you need to override the default. For example, you may want to enable events or audit data.
    6. Review parameters

    Note:

    The parameter defaults for the environment are configured using the Configure HCM Data Loader task so consider overriding parameters for the template that you don't want to change if the default setting is overridden for the environment.
  6. Select the parameter to override and click OK.
  7. Specify the Value for the chosen parameter in the Template Parameters table.
    8. Override parameters

  8. Repeat as required.

Task 5: Activating Your Template

Most templates available from Cloud Customer Connect will have a draft status. For business users to access the template it needs to be activated.

Note:

Once you've activated a template you are limited as to the edits you can make. If your role isn't assigned as a maintenance role for the template, it won't appear in the Spreadsheet Templates page once you've activated it. Activating a template should be your last step.

Review the Assigning Maintenance Access steps in the Grant Access to Run HCM Spreadsheet Data Loader tutorial for more information.

  1. Edit your template, if you've closed it click on the template name from the Spreadsheet Templates task.
  2. Navigate to the Define page.
  3. Update the Status field to Active.
    Review parameters

  4. Click Save and Validate.

The latest tutorials for HDL and HSDL are published in this topic on Cloud Customer Connect:

Refer to these help topics for further information:

Acknowledgements

  • Authors - Ema Johnson (Senior Principal Product Manager)

More Learning Resources

Explore other labs on docs.oracle.com/learn or access more free learning content on the Oracle Learning YouTube channel. Additionally, visit education.oracle.com/learning-explorer to become an Oracle Learning Explorer.

For product documentation, visit Oracle Help Center.