X

An Oracle blog about HCM Cloud

File Based Loader (FBL)- SFTP or UCM

Prasanna Borse
Center of Excellence at Oracle

Oracle HCM Cloud File Based Loader(FBL) was the tool of choice for data loading and integrations from Release 4 onwards. Starting Release 10 when HCM Data Loader (HDL) was introduced, FBL was deprecated.  We still have customers using FBL either manually or in automated fashion and for that reason, I am writing this article. The purpose of this article is to educate the audience on FBL automation as it regards with SFTP vs UCM usage, provide more information so we can move away from using SFTP for file transfer. 

Oracle Webcenter Content Server (UCM) is the preferred method of file transfer for FBL as well as HDL data loading tools. It is the replacement infrastructure for staging data files for FBL and supersedes the sftp option provided with Oracle HCM Cloud in prior releases. It provides improved and secured file management capabilities and it being used by other Oracle Cloud applications.  UCM is integral part of HCM Cloud and can be accessed directly within the application via File Import\Export UI.  

Automating FBL based Integrations is a two step process. First you need to stage the data file to either sftp\ucm followed by webservice call to invoke FBL.  Here are the key differences between usage of sftp vs ucm for automating inbound integrations. 

SFTP

  • Step1: Inbound file will be sent to cloud sftp server (sftp.cloud.oracle.com) using the ftp credentials for the application.
  • Step2: Web service call to involve FBL. In this case the FBL auto invoke URL will be for the loader composite. 
    • For e.g.  https://hxyz-test.hcm.us2.oraclecloud.com/soa-infra/services/default/HcmCommonBatchLoaderCoreInboundLoaderComposite/inboundloaderprocess_client_ep

UCM

  • Step1: Inbound file will be sent to ucm (webcenter content server) using hcm credentials. File will be sent to UCM using either the generic soap port web service or ucm ridc web service.

    • UCM (Soap - recommended)-e.g. https://hxyz-test.fs.us2.oraclecloud.com/idcws/GenericSoapPort?wsdl

    • or UCM (ridc – does not support SSO) - https://hxyz-TEST.fs.us2.oraclecloud.com/cs/idcplg

  • Step2: Web service call to involve FBL. In this case the FBL auto invoke URL will be for the integration webservice.
    • For e.g. https://hcm-aufsn4x0POD.oracleoutsourcing.com/hcmCommonBatchLoader/LoaderIntegrationService?wsdl
  • ​Detailed technical essay is available via Oracle Support - document id 1595283.1

Starting Dec 1st 2017, Oracle hosted sftp server will no longer be available. If you are using an Oracle hosted sftp server for inbound integrations, then you must switch to UCM and if you are using it for BI\extracts\outbound integrations then you can switch to UCM or a different sftp server. Please review FBL vs HDL article if you are considering the uptake of HDL. Review the support article 2312867.1 for additional information around sftp deprecation announcement. 

 

 

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha