Introduction
In one of the previous article we have seen how to load worker records in Oracle Cloud Application using the User Interface ( Navigator -> Tools -> Import and Export) option but many a times the source system ( legacy application where from we are trying to load the source data) does wants to load the files directly into the server without having an individual to manually login into the application.
Also due to security reasons many a times some organizations prefer not to give access to the Application pages but rather prefer some other way of performing a file transfer.
Weird it may sound at first but there are reasons like:
-
Organizations have separate task force for maintaining ERP application and they do not at times want to give application access to technical team (to ensure they should not be able to view sensitive data)
-
The Technical team members too at times also prefer a simple java based UI where they would only populate the required fields and get a confirmation
In such situations one may either build a new Java Application or use an existing one provided by Oracle HCM Centre of Excellence. The tool is named as HDLdi and the full form is HCM D ata L oader D esktop I ntegrator. Detailed documentation about the same can be found at below MOSC Article:
You may even wish to download the associated files from link below:
<Link to Download HDLdi Application>
Worked Out Example
Once we download the application and click on HDLdi2.3.11
The below page appears:
Next we need to click on the “Setup” link and populate the following details:
Attribute Name |
Attribute Value |
Protocol |
Soap |
UCM Server URL |
https://<hostname>:<port>/idcws/GenericSoapPort?wsdl |
UCM Username |
<UserName> |
UCM Password |
<UserPassword> |
Inbound Folder |
hcm/dataloader/import |
Outbound Folder |
hcm/dataloader/export |
WSDL URL |
https://<hostname>:<port>/hcmCommonDataLoader/HCMDataLoader?wsdl |
HCM Username |
<UserName> |
HCM Password |
<UserPassword> |
Sequence |
1 |
The application page would appear as below:
Next we need to click on “File Upload” and point to the zip file ( contains Worker Object)
Once we have provided the location of the file we would need to click on “UCM” button and then on “Refresh”. We would get the details from the server:
Next we may click on the “File Registration” button which would try to invoke the Import And Load Process.
Sample Payload:
Response:
So, this is how we can upload files to UCM Server and even invoke the HDL Loader Service. In the next step we would try to verify the existence of the file as well as whether the HDL program got invoked in the Oracle Cloud Application.
Verify Existence of File in UCM Server
We can verify whether the file (“SampleFileForUCMUpload.zip”) has been loaded in the application by navigating to Navigator->Tools->File Import and Export and performing a search. The results when captured in screenshot would appear as below:
One may even search for file by using the Content Server Link and search for Title as “SampleFileForUCMUpload.zip”. The link of content server is of following format:
https://<host>:<port>/cs/idcplg
Verify whether HCM Data Loader Process was Invoked
As a last step we would navigate to (Navigator-> My Workforce (Data Exchange) -> Import and Load Data) and a quick search will reveal that a Data Load process was invoked
Inference / Summary
So, this is how we can load a file to UCM Server and even invoke Web Service to load data into the application. One can load as many files as required using the tool and may even automate the entire process too.
The HDLdi tool does gives a simple interface to end user to try performing a simple load and get acquainted with the Data Load Process
Hopefully this is a good read and would help you all in your projects.
Do try this out and share your experience.
That’s it from me for now, have a nice day ahead!
Comments
I'll be sure to bookmark it and come back to read more of your useful info.
Thanks for the post. I'll certainly return.
It was really informative. Your site is very useful. Thanks for sharing!
Regards
from PHP. I have always disliked the idea because of the expenses.
But he's tryiong none the less. I've been using WordPress on numerous
websites for about a year and am anxious about switching to another platform.
I have heard great things about blogengine.net. Is there a way I can transfer all my wordpress content into it?
Any help would be greatly appreciated!
get my blog to rank for some targeted keywords but I'm not seeing very good
results. If you know of any please share. Thank you!
blogger, and I was curious about your situation; we have
created some nice procedures and we are looking to exchange methods with others, please shoot
me an e-mail if interested.
It positively helpful and it has helped me out loads.
I am hoping to contribute & aid other users
like its aided me. Good job.
I will make sure to bookmark it and come back to learn more of your helpful info.
Thank you for the post. I will definitely return.
this site and be updated with the newest information posted here.
that you just shared this helpful info with us. Please keep us informed like this.
Thanks for sharing.
or reviews and extra material, is there any other
website which offers such information in quality?
offers feature based articles.
I really like all the points you have made.
it appears good. I have bookmarked it in my google bookmarks.
Hello there, simply become alert to your weblog through Google, and found that it's truly informative.
I am gonna be careful for brussels. I'll appreciate
if you proceed this in future. A lot of other people will probably be benefited from your writing.
Cheers!
to be updated on a regular basis. It consists of nice information.
but your blogs really nice, keep it up! I'll go ahead and bookmark your site to come back down the
road. Many thanks
i am too cheerful to share my familiarity here with friends.
its really really good piece of writing on building up new blog.
It kind of feels that you are doing any unique trick.
In addition, The contents are masterpiece. you have done a
wonderful process on this subject!
that kind of info in such an ideal means of writing?
I have a presentation subsequent week, and I'm at the
search for such info.
on our site. Keep up the good writing.
doubt that that you need to publish more on this subject, it
may not be a taboo matter but usually folks don't speak about these subjects.
To the next! Best wishes!!
from somewhere? A theme like yours with a few simple tweeks would really make my
blog jump out. Please let me know where you got your theme.
Thanks a lot
I am having troubles with your RSS. I don't understand the reason why I am unable to join it.
Is there anybody having identical RSS issues? Anybody who knows the
solution can you kindly respond? Thanks!!
remarkable for people experience, well, keep up the good work
fellows.
used to be having a look for. You've ended my four day lengthy hunt!
God Bless you man. Have a great day. Bye
blog web site? The account helped me a appropriate deal.
I had been a little bit acquainted of this your broadcast offered vibrant transparent idea
helps new internet users, who are wishing in favor of blogging.
A design like yours with a few simple adjustements would really make
my blog shine. Please let me know where you got your design. Cheers
posts and other information, is there any other web page which gives such things in quality?
The world hopes for more passionate writers like you who are
not afraid to say how they believe. At all times go after your heart.
Going through this article reminds me of my previous roommate!
He continually kept preaching about this.
I'll send this information to him. Fairly certain he's going
to have a very good read. Thanks for sharing!
I realized it's new to me. Regardless, I'm definitely delighted
I discovered it and I'll be book-marking it and checking back
often!
website is truly fastidious and the people are actually sharing nice thoughts.
would be okay. I'm definitely enjoying your
blog and look forward to new updates.
the largest changes. Many thanks for sharing!
so I decided to browse your site on my iphone during lunch break.
I love the knowledge you provide here and can't wait to take a look when I get home.
I'm surprised at how quick your blog loaded on my cell phone ..
I'm not even using WIFI, just 3G .. Anyways, great site!
Extremely helpful info specially the last part :) I care for such info a lot.
I was seeking this certain info for a long time. Thank you and good luck.
added I recieve four emails with the same comment.
Perhaps there is an easy method you can remove me from that service?
Thanks a lot!
new scheme in our community. Your site offered us with valuable info to work on. You have done an impressive job and our entire community will be thankful to you.
wanted to say that I have really enjoyed browsing your
weblog posts. In any case I will be subscribing for your feed
and I hope you write once more very soon!
I'm hoping to start my own site soon but I'm a little lost on everything.
Would you propose starting with a free platform like Wordpress or go for a paid option? There are so many choices
out there that I'm completely confused .. Any recommendations?
Kudos!
I surprise how a lot attempt you place to create any such fantastic informative web site.
after that he must be go to see this website and be up
to date all the time.
Is this a paid topic or did you customize it yourself? Either way keep up the nice quality writing, it's uncommon to look a great
blog like this one today..
also clear their motive, and that is also happening with this paragraph which I am reading at this place.
I honestly appreciate people like you! Take care!!
I'm starting a blog soon but have no coding skills so I wanted to get guidance from someone with experience.
Any help would be enormously appreciated!
value bookmarking for revisiting. I wonder how much attempt
you put to make this sort of magnificent informative website.
through Google, and found that it's truly informative.
I am gonna watch out for brussels. I'll be grateful if you continue this in future.
A lot of people will be benefited from your writing.
Cheers!
find high quality writing like yours nowadays. I
really appreciate individuals like you! Take care!!
have book marked it. Money and freedom is the best way
to change, may you be rich and continue to
guide other people.
of my previous room mate! He always kept chatting about this.
I will forward this post to him. Pretty sure he will have a good read.
Many thanks for sharing!
that would be okay. I'm definitely enjoying your blog and look forward
to new updates.
I appreciate you spending some time and energy to put this information together.
I once again find myself personally spending way too much time both
reading and posting comments. But so what, it was still worthwhile!
I've loaded your blog in 3 completely different browsers and I must say this blog loads a
lot quicker then most. Can you recommend a good internet hosting provider at a fair
price? Thanks a lot, I appreciate it!
I think that you could do with some pics to drive the message home a little bit, but
instead of that, this is wonderful blog. A great read. I will certainly be back.
I in finding this matter to be really one thing which I think I'd never understand.
It sort of feels too complicated and very extensive for me.
I am taking a look ahead for your next publish,
I'll attempt to get the dangle of it!
I have found something that helped me. Kudos!
us. Please keep us up to date like this. Thank you for sharing.
getting more from this site, and your views are fastidious designed for new
people.
on Aol for something else, Regardless I am here now and would
just like to say many thanks for a incredible post
and a all round exciting blog (I also love the theme/design), I don't have time to read it all at the moment but I have bookmarked it and also added in your
RSS feeds, so when I have time I will be back to read much more,
Please do keep up the great work.
ans also sharing in delicious. And obviously,
thank you on your sweat!
RSS feed for comments to this post