Login
Register

Home

Trainings

Fusion

R12

Blogs

Contact Us

Fusion PayRoll
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 

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.

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 below screen as shown:

Next click on the Filter Criteria (Filter Icon)

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

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 and submit the Full Extract.

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 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 as shown below:

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 below screen.( Click on Go To Task and this takes you to new screen )

View Results

XML Link

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

(snap-shot below) confirming the same:

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!

ONE EXTRACT FOR ALL HCM OUTBOUND INTEGRATIONS


Ashish Harbhajanka

About the Author

Ashish Harbhajanka

 

Oracle Fusion HCM Techno Functional Consultant with overall 10 years of Experience in software industry with 5 years in EBS HRMS and rest 5 in Fusion HCM.

My areas of intesrest in Fusion HCM include :

a) Inbound Outbound Integration using FBL/HDL or BIP/HCM Extracts.

b) Fast Formula

c) BIP Reports

d) OTBI Reports

e) RESTFUL API / Web Service Call

f) Functional Setup

g) End to End Testing

h) Regression Testing

i) Preparing COnfiguration Workbooks

j) Creating Speed Solutions

k) Preparing User Guides

l) UPK

........

More articles from this author

Overall Rating (0)

0 out of 5 stars
  • No comments found

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  May 2017  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
  1  2  3  4  5  6  7
  8  91011121314
15161718192021
2223242526
    

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner