Introduction

In one of the previous article (Generating EText Output From HCM Extracts In Oracle Fusion HCM Cloud Application) we have seen how we can generate EText Data from HCM Cloud Application. One can even get eText Output from BI Publisher Report. But the major limitation in both the approach is that the output file extension is .TXT and one would need other means to have .DAT file.

If the generated file is prepared with the intent of loading the data back into Oracle HCM Cloud Application using HDL one can do same using Loading Data into Oracle HCM Cloud Using Inbound Interface Delivery Option

In this post we will demonstrate how can one generate eText file with .DAT extension from Oracle HCM Cloud Application. However, the only limitation at this point of time is that the .DAT file will be under a zip folder.

For this example too we will use the same “UpdateAssignmentExtract”

We would have two data groups created namely WorkerDataGroup and WorkTermsDataGroup. WorkerDataGroup is the Root Data Group

Some Details related to Data Group are in table below:

Also we should have the following Connection between the Root Data Group (WorkerDataGroup) and WorkTermsDataGroup

Once we have all these details populated we would need to define the Extract Delivery Options. Details for which are in below table

Once we are done with the above setup we will get the output file (Worker.txt for this example) but we are trying to generate .DAT file and so to ensure we get the file with same filename we will have to perform the following steps:

Add a parameter named “Auto Load” to the UpdateAssignmentExtract

Add “Initiate HCM Data Loader” to UpdateAssignmentExtract payroll flow

Add “Auto Load” Parameter to UpdateAssignmentExtract

We would need to add a new parameter. Details of the parameter are in below table

*Note: We always have to use ‘N’ as the value of this parameter for this specific scenario or else it will try to load data back into application (which is not the ask here)

Add Initiate HCM Data Loader Payroll Flow to UpdateAssignmentExtract Payroll Flow

As a next step we would also need to Add “Initiate HCM Data Loader” Payroll flow as part of UpdateAssignmentExtract Payroll Flow. We can either navigate to Payroll->Checklist->Search for UpdateAssignmentExtract Payroll Flow Pattern or use Refine Extracts->Search for UpdateAssignmentExtract

Once the search results are retrieved we need to click on “Edit” (pencil icon) and choose the following task

*Please make sure to select the payroll flow which has the description of  “Generate HCM Data Loader File and optionally perform a Data Load” as the other payroll flow task which has similar name will not serve the purpose here (both have different definition)

Once we add the payroll flow task we should click on “Go To Task” and add the following details:

Now the setup part is complete and we will try running “UpdateAssignmentExtract” and check if a .DAT file gets generated

If we go tot the “Extract Delivery Options” tab we can see all the output files generated.

If we click on “DL_WORKER_1457667” a zip file will get downloaded

And when we unzip the file we can see a .dat file

Summary

So this is how one can get .dat file from Oracle HCM Cloud Application making use of HCM Extracts.

Hope this was useful.

Have a nice day.

Ashish Harbhajanka

Add comment