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 keep exploring OIC features and find them quite powerful and flexible. In this blog, I would like to share a scenario to automate document records upload into Oracle HCM Cloud I came up with. It might be useful to load a batch of scans of personal documents in bulk for many employees and my scenario meets this requirement. I accommodated the On-Premises Connectivity Agent functionality to create a local shared stage area where user can put scans in the PDF format with the certain name convention like: <PersonNumber>_<DocumentType>_decription.pdf
Check this blog for details on how to install and configure a connectivity agent.
My OIC integration polls this shared area and parses a filename and loads the documents for employees into Oracle HCM Cloud.
For demonstration purposes, the integration handles only two document types but can be easily extended to the required number of document types.
Below is a short video that demonstrates a scenario in action:
I hope you find it useful. Feel free to reach to me and we will help you in building any complicated integration in Cloud.