How to ROLLBACK Element Entry HDL Load?
How to ROLLBACK Element Entry HDL Load?

 1,568 total views

In this article we will look into how to ROLLBACK the Element Entry HDL data load.

Want to learn Fusion Technical tools? Checkout this article

Normally we cannot rollback whatever data that has been loaded using HDL. However from 19D, Oracle has introduced this feature for Element Entry Business Object. Currently this is the only Business Object which supports the ROLLBACK feature.

If you use HDL Transformation Formula, and use the “Load data from File” payroll flow, even then we can ROLLBACK the entries for Element Entries Business Object only. For other Business Objects the Rollback feature isn’t enabled at this point. However Oracle is working on adding this feature for other Business Objects as well.

Let’s look into how to use this feature now

We will first look into the process to ROLLBACK data set from Import and Load data screen.

Element Entry load completed and is successful HDL Fusion hcm
Element Entry load completed and is successful

Now we will have to click under Total Objects for the dataset that needs to be ROLLED BACK.

Click on the 2 count under Total Objects
Click on the 2 count under Total Objects
We need to click the Schedule Request on this screen
We need to click the Schedule Request on this screen

It shows the details of the rows that have been loaded on this screen. I have hidden the key and source id keys for confidentiality. We need to click on Schedule Request button at the right top.

Select the Action as Roll Back and then click submit
Select the Action as Roll Back and then click submit

In the popup, we need to select the Action of Roll Back and click submit to initiate the Rollback process.

Once the submit is clicked, a process will be submitted to rollback the new element entries created by the respective data set. You can check the status of the process on the same screen by clicking Refresh.

If you try the same option for other business objects, we don’t get the Rollback option.

Rollback not available for Job Business Object
Rollback not available for Job Business Object

Now let’s check the process if we have loaded the data using the HDL Transformation formula and the flow “Load Data from File“.

To roll back your element entry data, on the Payroll Flow page, select the Initiate Data Loader flow. Select Mark as Incomplete from the Actions menu. In the Warning dialog box, click Continue. The application rolls back the newly created element entries.

References: Overview of Loading and Rolling Back Element Entries

NOTE: The ROLLBACK feature will only rollback the newly created Element Entries. It will not rollback the updates done to existing element entries and the deletes to element entries. It’s not a complete ROLLBACK of everything.

The following two tabs change content below.
Sricharan is a Fusion HCM Solution Architect with over 13+ years of overall experience and 5+ years of Fusion experience. He is passionate about technical aspects of Fusion HCM and writes interesting articles on HCM Extracts, HCM Data Loader, Fast Formula, BI Publisher, Integrations and Automation etc.

This Post Has One Comment

  1. Gopi

    Thanks Bro, good to know… keep it up.
    Atleast Oracle is realized now that which is very much required..

Leave a Reply