HDL(Inbound) Integration in Oracle Fusion

 

HDL (Inbound) Integration

Requirement:

Automating Job creation in Oracle HCM Cloud using external CSV data.

High-Level Integration Flow

We developed an end-to-end integration that pulls CSV files from a remote server, transforms them into the mandatory HDL .dat structure, and stages them on an FTP server. 

The final process picks up these files and pushes them into Oracle Fusion HCM, ensuring seamless job record synchronization.

Integration Metadata

Source: FTP Server

Target: Oracle HCM Cloud Fusion Application

Direction: Inbound

Pattern: Schedule-based Orchestration

Implementation Strategy

Before developing the integration logic, we must establish secure connectivity between the source and target systems. This involves:

FTP Connection: Configuring the SFTP/FTP adapter to access the remote data server.

HCM Cloud Connection: Setting up the Oracle HCM Cloud adapter to facilitate data loading and web service invocations.

Login with only HCM user as HDL works with only HCM Objects.

Test the connection and save it

 

Now, open FileZilla

Click on Connect button to access FTP Remote Server

Inside remote server site, right click and choose create directory

Type HDL in place of New Directory

Place job.zip file from local site to remote site under the path: A2CF77/HDL

 

Now, start the Integration Flow

Choose Schedule Style of Integration

Click on create

First step is to list down the files by using the FTP List File operation

Choose List Files operation

*.zip means it will consider all the files ending with .zip

As I have only one file, I have used * but in case if there are multiple files then we need to specify the name of the file here

Now, use for-each-function

It will check for all the files

Click on Save

Parallel Processing is not checked

Since HDL gets large amount of data, we will go for download the file option instead of read the file.

Read File can do up to Max(10 MB for read file)

Download operation, we can use upto 1 GB

Choose download

Save the downloaded file in temp directory

Click on mapper

Now, connect to HCM Cloud

Click on + symbol

Choose HCM Cloud

Choose import bulk data using HDL

Choose the first option

And later second one

We are not getting any encrypted files. If we do then we need to decrypt the files.

From OIC to HCM Cloud mapping

 

File reference is mandatory when we are dealing with bulk data

File Name is also y mandatory

We have submitted the job and we need to know the status.

We need to wait for some to run the process

So, let us wait for some time; choose wait option under actions in the Integration

Click on + ad add wait

Wait for 2 min.

Click on + and go for HCM Cloud connection again

Get Status of HDL job

Previously we have submitted the data, now choose query the status of job.

Click on mapper

Click on + and add the Logger

Logger helps to give the information about success or failure

Choose Logger

Under status

We can see status

 The Integration Process Flow:

List Files: Identify all available files in the remote FTP directory.

Looping Mechanism: Use a For-Each action to process multiple files in a single run.

Download to Staging: Transfer files from the FTP to the OIC temporary directory.

Submit HDL Job: Trigger the Bulk Data Import in HCM Cloud to process the .dat files.

Process Monitoring: Implement a Wait action followed by a Get Status call to monitor the import progress.

Result Logging: Log the final outcome (Success/Failure) for auditing and troubleshooting.

 

Now, click on (I) symbol on the top and enable the Business Identifiers

Click on Save to enable Business Identifier

Activate Integration

Run the integration

 

Navigation to HDL in Fusion Application

Go to Myclient Groups---?Data Exchange-->HDL

 

Setup and maintenance

Search for manage common lookup

We can get the source system owner

Update the correct source system owner and then run the integration again

When you make changes in Integration then need to deactivate and then reactivate it again

Compress and zip the file and place it in