Introduction
Use HCM Spreadsheet Data Loader (HDSL) to provide your business users with bulk-loading spreadsheets. This tutorial explains how to define a HSDL template to suspend and activate user accounts.
Objectives
In this tutorial you will:
- Create a spreadsheet template to activate and deactivate existing User accounts.
- Validate and test the template.
- Activate the template.
Prerequisites
To complete this tutorial, you will need:
- A Windows machine with the Desktop integration installed.
- Access to the Spreadsheet Templates task, with the ability to create templates for the User object.
Tip:
Follow the steps in the Configure Access to Design and Maintain HCM Spreadsheet Data Loader (HSDL) Templates to create such a role.Task 1: Create the Spreadsheet Template
In this step, you'll create the spreadsheet template and select the attributes that are required to activate-deactivate a user account.
- Log in to the application with a user that has access to create HSDL templates for the User business object.
- Navigate to My Client Groups > Data Exchange > Spreadsheet Templates.
- Click Create to open the Create Template dialog box.
- Specify the template name and code, set the Business Object to User, and optionally provide a description.
- Click OK. You'll be navigated to the Define tab.
- Click Design.
- Select the Person Number attribute in the Available Attributes panel and add it to the Selected Attributes panel.
- Select the Person Number User Key when you're prompted for which key type to use.
- Click OK.
- Drag the Suspended attribute from the Available Attributes panel and drop it in the Selected Attributes panel.
- Click Validate and Save.
All attributes that uniquely identify a record will be added to the Selected Attributes panel.
Tip:
The key icon prefixes all attributes that uniquely identify a record in the spreadsheet.Note:
If other mandatory attributes exist, they will be automatically added to the Selected Attributes list.The Suspended attribute is required for User Account activation and deactivation. The template now includes all required attributes to activate or deactivate user accounts.
Task 2: Configure the Template Attributes
In this step you'll modify the column heading and description.
- Select the Suspended attribute in the Selected Attributes panel and click the Edit icon.
- Modify the Column Heading from 'Suspended' to 'Deactivate'.
- Modify the Description to 'Supply Y to deactivate an existing active user account, or N to activate it.', or similar.
- Check the Required checkbox, making this attribute mandatory.
- Optionally define a default constant value of Y or N.
- Click OK.
Task 3: Test the Template
- Click Validate and Save. You shouldn't see any errors.
- Click Preview to generate a spreadsheet for the configured template.
- Click Yes when you're prompted to connect.
- Login with your application username and password. The spreadsheet is generated with each of the visible attributes in the Selected Attributes panel displayed as a column in the spreadsheet.
- Click Create Data Set on the Spreadsheet Loader toolbar.
- Click OK on the dialog page.
- Double click in any of the cells in the first row under the column headings to initiate the row.
- Enter the Person Number of the employee whose user account you want to deactivate in the Person Number column.
- Enter Y in the Deactivate column if it's not already defaulted.
- Click More > Upload on the Spreadsheet Loader toolbar.
- Click OK on any dialog pages displayed.
- Click Refresh regularly to refresh the spreadsheet row status.
- Navigate to Tools > Scheduled Processes to submit the Send Pending LDAP Requests process to action the account changes you've loaded with the spreadsheet.
This downloads the GenericHdlSpreadsheet.xlsx file. Open it.
Note:
Spreadsheet rows must be created within a data set. It's the data set that then gets uploaded to the Oracle HCM Cloud.A data set is created with a predefined name; you can override this if you want.
Tip:
Any mandatory cells without a value will be highlighted with a red outline. Any attribute configured with a default constant value will display the default.Note:
Uploading this spreadsheet row will deactivate the user account for this employee.Tip:
You activate a deactivated account by specifying N in the Deactivate column.The Upload Progress will change status until processing completes with a Success status.
Task 4: Configure Template Parameters
You can override the default spreadsheet data loading behavior by overriding the parameter default values. In this task you'll enable auditing of the changes uploaded using this template.
- Edit your template, if you've closed it click on the template name from the Spreadsheet Templates task.
- Click the Create icon on the Templates Parameters table toolbar.
- Specify a Category of Availability and click Search.
- Select the Enable Audit Data parameter. Click OK.
- Specify a Value of Yes to enable auditing of the changes uploaded using spreadsheets generated from this template.
Note:
Auditing of changes loaded by this template will only occur if audit of the User object has been enabled in the application.Task 5: Assign Access to the Template
The template can only be accessed by users with a role assigned to the template. In this step you'll assign a role to the template, configure the data-set actions it can perform and activate the template to make it available to users with that role.
- Click the Define page.
- Ensure the Upload Data As field is set to Session User.
- Click Role Access.
- Click Add on the Permitted Data Set Operations table toolbar.
- Use the Search and Select Roles window to search for an select the job role that should access to the template.
- Click Add.
- Create data sets with a spreadsheet template.
- Save the spreadsheet rows to the data set.
- Upload valid spreadsheet rows to the application.
- Uncheck any data set operations users of this role shouldn't have access to.
- If users with this job role should be able to view all data sets, not just those they have created themselves, check the View All checkbox.
- Repeat these steps for all job roles that should have access to use this template.
- Click Define
- Set Status to Active.
- Click Validate and Save.
Tip:
The Assign Roles to Template field in the Template Security section indicates if you can assign roles to this template.The role will be automatically configured to:
Tip:
The User object doesn't support roll back, so the Roll Back checkbox is disabled.The template will now be available to all users with roles assigned to the template and can be accessed from the Run Spreadsheet Data Loader task.
Related Links
The latest tutorials for HDL and HSDL are published in this topic on Cloud Customer Connect:
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.
Create a HCM Spreadsheet Data Loader Template to Activate and Deactivate User Accounts
F87109-03
September 2024