Introduction

In one of the previous article we have seen how to load worker records in Oracle Cloud Application using the User Interface ( Navigator -> Tools -> Import and Export) option but many a times the source system ( legacy application where from we are trying to load the source data) does wants to load the files directly into the server without having an individual to manually login into the application.

Also due to security reasons many a times some organizations prefer not to give access to the Application pages but rather prefer some other way of performing a file transfer.

Weird it may sound at first but there are reasons like:

1. Organizations have separate task force for maintaining ERP application and they do not at times want to give application access to technical team (to ensure they should not be able to view sensitive data)

2. The Technical team members too at times also prefer a simple java based UI where they would only populate the required fields and get a confirmation

In such situations one may either build a new Java Application or use an existing one provided by Oracle HCM Centre of Excellence. The tool is named as HDLdi and the full form is HCM D ata L oader D esktop I ntegrator. Detailed documentation about the same can be found at below MOSC Article:

HDLdi

You may even wish to download the associated files from link below:

<Link to Download HDLdi Application>

Worked Out Example

Once we download the application and click on HDLdi2.3.11

The below page appears:

Next we need to click on the “Setup” link and populate the following details:

The application page would appear as below:

Next we need to click on “File Upload” and point to the zip file ( contains Worker Object)

Once we have provided the location of the file we would need to click on “UCM” button and then on “Refresh”. We would get the details from the server:

Next we may click on the “File Registration” button which would try to invoke the Import And Load Process.

Sample Payload:

Response:

So, this is how we can upload files to UCM Server and even invoke the HDL Loader Service. In the next step we would try to verify the existence of the file as well as whether the HDL program got invoked in the Oracle Cloud Application.

Verify Existence of File in UCM Server

We can verify whether the file (“SampleFileForUCMUpload.zip”) has been loaded in the application by navigating to  Navigator->Tools->File Import and Export and performing a search. The results when captured in screenshot would appear as below:

One may even search for file by using the Content Server Link and search for Title as “SampleFileForUCMUpload.zip”. The link of content server is of following format:

https://<host>:<port>/cs/idcplg

Verify whether HCM Data Loader Process was Invoked

As a last step we would navigate to (Navigator-> My Workforce (Data Exchange) -> Import and Load Data) and a quick search will reveal that a Data Load process was invoked

Inference / Summary

So, this is how we can load a file to UCM Server and even invoke Web Service to load data into the application. One can load as many files as required using the tool and may even automate the entire process too.

The HDLdi tool does gives a simple interface to end user to try performing a simple load and get acquainted with the Data Load Process

Hopefully this is a good read and would help you all in your projects.

Do try this out and share your experience.

That’s it from me for now, have a nice day ahead!

Ashish Harbhajanka

Add comment