How to generate a tab delimited output using BI Publisher

Hi community,

I just want to share a useful finding I have discovered recently. The requirement was to generate a tab delimited output from Oracle HCM Cloud database to deliver a file to an outbound integration.
Earlier I used eText templates to do similar transformations but it can be achieved without it.

Let’s go through the steps do demonstrate it:

  • Create a BIP data model based on the simple query

Here is an output

  • Create a BIP report
  • Open “Report Properties>Formatting(Tab)”

Scroll down to the CSV Output properties and set the CSV Delimiter property to Tab(\t). You might as well set it to Pipe(|):

  • Set a Default Format -> Data(CSV)

That’s it.

Here it is. Easy-peasy 🙂

I hope you find it helpful.


Oracle HCM Cloud document records upload with an OIC integration

Hi, community,

I keep exploring OIC features and find them quite powerful and flexible.
In this blog, I would like to share a scenario to automate document records upload into Oracle HCM Cloud I came up with.
It might be useful to load a batch of scans of personal documents in bulk for many employees and my scenario meets this requirement.
I accommodated the On-Premises Connectivity Agent functionality to create a local shared stage area where user can put scans in the PDF format with the certain name convention like: <PersonNumber>_<DocumentType>_decription.pdf

Check this blog for details on how to install and configure a connectivity agent.

My OIC integration polls this shared area and parses a filename and loads the documents for employees into Oracle HCM Cloud.

For demonstration purposes, the integration handles only two document types but can be easily extended to the required number of document types.

Below is a short video that demonstrates a scenario in action:

I hope you find it useful.
Feel free to reach to me and we will help you in building any complicated integration in Cloud.