Generate HCM Data Loader Files for Data That Failed to Load

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