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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.