HCM Data Loader

Generate HCM Data Loader Files for Data That Failed to Load

Posted by

1

Hi community,


Long time no see. It’s time to post something interesting.
Recently I have been reviewing Oracle HCM Cloud 21C new features document and bump into the feature I found it quite useful. It is already available in our 21A instance, so it seems I missed it earlier.
The feature is related to HCM Data Loader and allows generating an HDL file for the failed lines.
This is quite useful during data migration steps when you run large HDL files and if it is only a few record failed you can just extract those failed lines into a new HDL, fix it (normally errors are related to incorrect referential data) and then load only this part. It saves a lot of time.

Well let’s get through it.

  • You have to enable this feature in the FSM task: Configure HCM Data Loader:
  • Load something with HDL to get failed lines:
  • Press an “Extract Failed Lines” button and submit a process
  • Once it is finished you can download an HDL file generated

That’s it!

I hope you find it helpful.

SY,

Volodymyr

Advertisement

HCM Data Loader Automation – Part II

Posted by

3

A year ago I wrote an article in which I discussed an approach how to automate HCM Data Loader process using a WebCenter Content Document Transfer Utility and a Data Loader Web Service.(https://xxxx.oraclecloud.com/hcmCommonDataLoader/HCMDataLoader?WSDL)

I couldn’t even imagine it would be so much popular. There are more than 2K views for this year.

But there was one issue with an integration web service that prevented to get full advantage of that approach. There was impossible to get a final status of HCM Data load process through a web service method. Continue reading →