Skip to Main Content

Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

.NET - Need .NET example for invoking the HCMDataloader

3015132Dec 8 2015 — edited Dec 8 2015

The purpose of this request is to ask the community if anyone has invoked the "/hcmCommonDataLoader/HCMDataLoader" service from .NET. (any framework; prefer c#)

I have been tasked by my company to set up an automated process for data integration between our ADP HR system and the HCM application tables.

The integration will consist of two steps:

Step 1

    Load data file from ADP to WCC; will use the  "WebCenter Content Document Transfer Utility for Oracle Fusion Applications" so that this can be done from the command line and hence automated.

Step 2 (using the web service)

    Load from WCC to HCM tables

It is in Step 2 that I need to invoke the web service.

The SOAP message is very basic (see below):

As you can see I only need to pass in the Content ID and we are good to go ...

My concern however, is that I also need to pass in the user name and password. Has anyone done this in .NET and if so do you have an example?

SOAP Message Example

http://{Host}/hcmCommonDataLoader/HCMDataLoader

<soap:Envelope xmlns:soap=”http://schemas.xmlsoap.org/soap/envelope⁄″&gt;

<soap:Body>

<ns1:importAndLoadDataAsync

xmlns:ns1=”http://xmlns.oracle.com/apps/hcm/common/dataLoader/core/dataLoaderIntegrationService/types/”&gt;

<ns1:ContentId>UCMFA001234</ns1:ContentId>

<ns1:Parameters></ns1:Parameters>

</ns1:importAndLoadDataAsync>

</soap:Body>

</soap:Envelope>

Comments

Celvin Kattookaran

Why would you cherry pick department members in Planning webforms? Can't you drive that selection using functions available?

Why not use the Delete Descendants/Delete IDescendants/Delete Level0 in Operation?

Create a load file of the format

Parent,Department,Operation

Department,Engineering Department,Delete Descendants

This will delete all members under Engineering Department, then you can load members. (You cannot refer members which are used in webform)

Regards

Celvin

VManek

Thank Celvin for your reply.

You are right. Leaf level Departments are not used in web-forms and most of them are in Page section. But how about the deletion of approval status as per documentation? Using the approach suggested if we are in middle of budget / forecast cycle and if any member is moved between/across parents or is deleted, what would be the potential impact to change statuses (approval process) and/or planning unit hierarchy?

Regards,

VManek

Celvin Kattookaran

If you are deleting member which are used in your planning unit hierarchies, then yes those will be removed.

I think if you delete a member (no matter which method you use) those are going to be deleted. Issue that you'll have to worry about is the movement. There is an option to load planning units using outline load, or you can use LCM export the planning units and then import them back once the movement is done.

Regards

Celvin

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 5 2016
Added on Dec 8 2015
0 comments
639 views