Introduction

One of the most common requirement faced whenever one tries to transfer data from One Application to another is getting the Flat File in desired format along with a desired File Name and extension.

While generating a file in desired format is not a challenge in Oracle HCM Cloud but getting, the appropriate file extension (specifically CSV) has been troubling consultant (including myself) for long.

It seems that at last I probably have managed to figure out a solution and thought to share the same with the greater audience. So without further delay let-us get started with the same.

In the interest of time we would assume that we already have a E-Text Based BIP Report available with us and would only concentrate on how to get a CSV File (both data as well as extension) from the same.

Pre-requisite

We would assume that we already have an E-Text Template Based BIP Report available in the Application. I would share some details of the same (like Sample Data File, Data Set ,E-Text Template , Report Layout along with Sample Output as it appears on the application) before we start with our actual demonstration.

Sample Data File

We will use a XML File as the Data to be used in the Report. The XML file structure is as below:

Data Set

We would use the XML File (shown in image above) and create a Data Set (as shown in screen-shot below):

E-Text Template

The E-Text Template used is as below:

Layout

The Layout associated with the Report has the following properties:

Sample Output

The Sample Output is shown below:

Changes Required to Get Data in CSV File (.csv Extension)

Till now, we have seen that we can get CSV Data from the Report, but we are not only interested in the Data Format but also the file extension. For this we would have to make the following changes namely:

Upload RTF File

In order to ensure that any new changes made does not effects the existing data or report we would upload a new RTF File. Actually, we would download the already existing RTF File and reload the same with a new name. Post Upload the ‘Edit Layout’ Page should appear as:

A quick look at the Layout tab post this addition would look as below:

And the Report Output appears as:

Scheduling the Report

Once you schedule the report, you should be able to view the details under “Job History” and the screen would appear as below:

Verification

We should receive an email with the same subject line on the email box.

Ashish Harbhajanka

Add comment