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.
For e.g. https://hxyz-test.hcm.us2.oraclecloud.com/soa-infra/services/default/HcmCommonBatchLoaderCoreInboundLoaderComposite/inboundloaderprocess_client_ep
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
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.