How You Delete Data Using HCM Spreadsheet Data Loader

You can delete business objects using HCM Spreadsheet Data Loader, regardless of how they were created. This topic describes how to delete data using HCM Spreadsheet Data Loader.

Designing the Spreadsheet Template

To delete data, you create a spreadsheet template and set the Supported Action value to Delete only. You can use spreadsheets generated from that template to delete specified objects. The Delete only option for the Supported Action field is available only for objects with at least one component that can be deleted. The object components that appear on the Design tab of the Spreadsheet Templates page are those that you can delete. For example, for the Job object you see the Job Evaluation, Job Valid Grade, Job Extra Information, and Job Legislative Extra Information components. You don't see the parent Job component, because you can't delete it.

When you move an attribute to the Selected Attributes panel of the Design page, all attributes required for deleting the component move across simultaneously.

Copying Spreadsheet Templates

When you copy a spreadsheet template, you can't change the supported action. Therefore, if the source template has Delete only as its supported action, then the copy has the same supported action.

Uploading the Spreadsheet

To delete object components using a spreadsheet, you enter attribute values to identify the components and upload the spreadsheet. When you delete a parent component, its child components are deleted automatically.

Tip:

You can monitor progress on the Import and Load Data page. Search for data sets by file type to list those loaded from spreadsheets.