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