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
I hope you find it helpful.
Can we generate this through BIP or from OIC?
We are triggering the load from OIC and if there are any failures we want to get back those failed lines, can we do this though OIC or in BIP which we can call from OIC using WCC