Thursday, May 12, 2016

Performing Mass Update in Oracle Fusion Applications

Disclaimer: Opinions expressed are my own

While there are several methods of updating person records some of the most widely known ones being FBL (File Based Loader), HDL (HCM Data Loader) , Web Service Calls (eventually calls either the FBL or HDL loader service), Spreadsheet loaders or UI updates the most simple one is ‘Mass Update’.
This is a feature which is primarily designed to make bulk updates to records and is very easy and can be performed by either a Technical, Techno-Functional, Functional Consultants or for that matter even Business User. 

Check complete article at:

A Whitepaper on Document of Records Explains What, Why along with a Use Case Example

Disclaimer: Opinions are my own


This article would try to explain about 'Document of Records' feature in Oracle Fusion Applications detailing about what does it stands for why the same is useful and also a worked example of the same. Not sure whether this feature is been used widely during implementations but could come handy if you are interested in storing data in digital format. for complete details refer article below:

A Whitepaper on Document of Records Explains What, Why along with a Use case Example

Monday, May 2, 2016

Creating Job Set in Fusion Applications

Disclaimer :Opinions are my own.

Most of us from an EBS background might be aware of Request Set , the equivalent of the same in Oracle Fusion Applications is referred to as Job-Set where Job is referred to as individual ESS Job . A complete description of the same along with a sample example of creating a job-set can be found at below link:


Creating Job Set in Oracle Fusion Applications

Monday, April 18, 2016

Generating Letter format Reports in Fusion Applications - A Worked Example

Disclaimer: Opinions expressed are my own

We have learnt how to create BIP Reports in Fusion Applications ( both on-premise and cloud deplyment) and so now its time to extend the dame knowledge to try and generate letter format reports.

You may find the complete article at below link:

Generating Letter Format Reports in Fusion Applications - A Worked Example



Go through the article and share your views/comments/suggestions.

Thursday, April 14, 2016

Delta Changes HCM Extract ( Definition and Use)

Disclaimer: Opinions expressed here are my own

In the previous article :

Creating Custom HCM Extract

we learned how to create a Custom HCM Extract.

But one of the major requirement for all HCM Extract is to provide Incremental Data instead of full extract. For such scenarios we may use the 'Delta Changes HCM Extract. A use Case example of the same can be read at :

Delta Changes HCM Extract

One HCM Extract for all Outbound Integrations

Disclaimer: Opinions expressed here are my own


Imagine if we can have one HCM Extract which could meet all requirements of all 3rd party system from a data requirement perspective.

Yes! this is possible

A prototype of the same is explained in detail below:

One HCM Extract for all Outbound Integrations

Create Custom HCM Extract in Fusion Applications

Disclaimer: Opinions expressed are my own



In a course of a typical HCM implementation project its is a common requirement to create HCM Extracts ( a mode of data transfer from Fusion Application to external 3rd party system).

The below article explains the process of creating the same in simple lucid way with screenshots.

Please re-view and provide your comments.

The complete article may be read below:

Create Custom HCM Extract in Fusion Applications