Introduction
Generating a CSV File from Oracle HCM Cloud Application has not been an easy task to do, the closest one can get is:
Generate .CSV File From BI Report In Oracle HCM Cloud Application
But the approach is cumbersome as it requires the following pre-requisites:
- Need of a etext template
- Need of a Report
However, starting release 19B one can very easily generate CSV Files from HCM Extracts and it provides flexibility of using “Encryption” / “Compression” among other things.
Some of the major advantages of using this approach are:
- No Need of any Template
- No need of creating Reports
- Allows Compression
- Allows Encryption
- Gives flexibility to include/exclude header record
- Gives flexibility to include/exclude default attributes (flow parameters)
Hence, due to all the above advantages it makes sense to use the HCM Extract CSV file generation method. We will demonstrate the same now.
Creating a Simple Custom HCM Extract
For this example, we will create a simple extract which will contain the following attributes:
- Person Number
- Hire Date
- Assignment Effective Start Date
- Assignment Effective End Date
The PersonNumber Attribute is configured as shown in image below:
Hire Date attribute is setup as below:
Assignment Effective Start Date has the following setup (screenshot):
Assignment Effective End Date has the below setup:
Choosing a Delivery Option
Choosing the correct delivery option is the most critical part here. Here we have various options like “Compress”, “Encryption” , “Encryption Key” , “Delimiter”, “Print Header Record”, “Print Default Attributes” and so on.
A screenshot of the setup values used in this example is given below for ready reference:
Running the Extract and Verifying Results
We will now submit the Extract and verify the results
If we now click on the down arrow under “Extract Delivery Options” section a file would get downloaded which when opened should show us the data.
Conclusion
So, this is how we can generate CSV files from HCM Extract.
Hope this article was useful and you guys were able to learn something from it.
Thanks all for your time and have a nice day ahead.