Fusion HCM Integration by Kiran Mundy


clip_image002Because of frequent questions from HCM customers on how they can use BPEL to integrate with Fusion HCM, I’ve put together the details here

Your orchestration layer is the software [such as Oracle’s SOA BPEL or BPM Studio] you currently already use, to wire together Fusion HCM Loader/Extract programs to other apps.

Companies already using SOA/BPEL can just add Fusion HCM into the mix.
Steps to accomplish this are below:.


  1. BPEL’s "File Adapter" to read the data in.
  2. BPEL’s Transform Activity with Domain Value Maps to transform the data.
  3. You need to get the UCM Service exposed externally (In Rel10 it will be exposed, but on Rel9, you’ll need to do the following):
    1. File an SR requesting Fusion HCM to perform a Key Exchange – Aside from allowing you to send "encrypted" files into Fusion, this step will also result in the UCM Service being exposed externally.
      • Ensure you file the SR under Oracle Cloud Global Human Resources Cloud Service.
      • Choose Hosting Services – Application -> Encryption Key Exchange
  4. Use BPEL to Invoke the UCM Soap Service to write the File into UCM.
  1. Invoke the HCM Loader Programs passing them the encryption parameter along with other required parameters.
    • FBL wsdl is the following form: https:// <Hostname>/LoaderIntegrationService?WSDL
    • HDL wsdl is the following form: https:// <Hostname>/hcmCommonDataLoader/HCMDataLoader?wsdl
  2. Find out which user privileges you must assign to the users who call these web services in OER: https://fusionappsoer.oracle.com
  3. Sample Payloads for the above services are available here. [You can enter comments into the sample payloads doc if you find any issues].
  4. Later when REST Services are available (Release 9 Patch Bundle 6 under "controlled availability" most likely), for your lighter weight inbound integrations, such as Fusion/Taleo, you will have the option to switch #3/4/5 to a REST service call to create/update the employee in Fusion. NOTE: Cco-existence scenarios should continue to use batch loaders because:
    • Performance Reasons – services won’t perform as well under heavy loads
    • The breadth of data needed for co-existence isn’t covered (or intended to be covered) by the REST Services.

OUTBOUND FROM FUSION HCM Read the complete article here

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

About Jürgen Kress
As a middleware expert Jürgen works at Oracle EMEA Alliances and Channels, responsible for Oracle’s EMEA Fusion Middleware partner business. He is the founder of the Oracle SOA & BPM and the WebLogic Partner Communities and the global Oracle Partner Advisory Councils. With more than 5000 members from all over the world the Middleware Partner Community is the most successful and active community at Oracle. Jürgen manages the community with monthly newsletters, webcasts and conferences. He hosts his annual Fusion Middleware Partner Community Forums and the Fusion Middleware Summer Camps, where more than 200 partners get product updates, roadmap insights and hands-on trainings. Supplemented by many web 2.0 tools like twitter, discussion forums, online communities, blogs and wikis. For the SOA & Cloud Symposium by Thomas Erl, Jürgen is a member of the steering board. He is also a frequent speaker at conferences like the SOA & BPM Integration Days, JAX, UKOUG, OUGN, or OOP.

One Response to Fusion HCM Integration by Kiran Mundy

  1. Debra Lilley says:

    thank you for this, very helpful

Leave a Reply to Debra Lilley Cancel 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

%d bloggers like this: