Introduction

This article is in continuation with the previous article where-in we defined how to create one HCM Extract which might be used for all Outbound Integrations. The complete article may be found at: ONE EXTRACT FOR ALL HCM OUTBOUND INTEGRATIONS

In this article we would have a look on how-to extract only incremental data instead of the entire full extract from the system. For this we would need to have an existing HCM Extracts.

For this example we would use ‘XX Worker Extract’ referred to in previous example.

So now without further delay we would start with the same.

Step1: Filter Criteria

I am able to recall that during the last article we had used a filter criteria where-in we have used one filter criteria as shown below:

Login to Fusion Applications -> Provide appropriate login credentials

Once on homepage, click on the Icon (Navigator Icon) and a new popup window appears. Click on Data Exchange under My Workforce option

Navigator->Data Exchange-> Manage HCM Extract Definitions -> Search for (‘XX Worker Extract’)

Once you click on ‘XX Worker Extract’ next point the cursor to the Design block and that would take you to the next screen

Next click on the Filter Criteria (Filter Icon)

Once we click on the Filter Criteria as displayed above it opens up the filter condition

For this example we would need to alter the filter condition to ensure that there are two Worker Records whose details would be fetched in Full Extract. Afterwards we would make changes in the worker record for one of them and would expect details of only the worker (whose details have been changed) to reflect in the HCM Extract.

We have verified previously that there does exist a worker whose Person# is 123

The modified version of the criteria is

Extract Person Number = 1826 Or Extract Person Number = 123

Save the changes

Step2: Run Full Extract

Navigate to the Payroll Checklists in the Navigator menu and submit the Full Extract. Click on Payroll Checklists under Payroll option

Then you need to click on ‘Submit a Process or Report’

Provide input parameters as below and submit

We would next look at the results (Yes! We need to use the ‘OK and View Checklist’)

XML File is Generated

The generated file holds details for both Person# 123 (as shown below)

As well as for Person# 1826 (as shown below)

Step3: Make changes to Person Record

We would change the details of Person# 123

First we will search for the Person# from Person Management

For this example we will make following changes in Name Details:

Submit the changes

Step4: Running the Extract in Incremental Mode

This brings us to the next screen.( Click on Go To Task and this takes you to new screen )

View Results

XML Link comes up

If we now open the XML file and try to search for Person# 1826 it would yield no matches

Also one more point to note is that since we only modified the Name Record for Person# 123 only details pertaining to that section is displayed in the XML all other sections are empty.

Associated XML Files:

And with this I would conclude this article with the hope that I was able to help all of you in some way or other.

Thank you for your time and have a nice day ahead!

Ashish Harbhajanka

Add comment