Deprecation of SaaS sFTP servers for Oracle HCM Cloud and other Oracle Cloud applications was announced recently.
Refer to the below MOS Support Doc Note for the announcement and related articles.
Oracle Applications Cloud Hosted SFTP Server Deprecation Announcement (Doc ID 2312867.1)
Subsequently, there is a need to rethink file based integrations that were in the past using the SaaS FTP server.
The recommended alternative is to use Oracle WebCenter Content Server (also known as Universal Content Management or just UCM in this blog), which is the standard method of data file transfers for Oracle Cloud Applications.
UCM can be used to store and transfer files such as BI Publisher extracts, Bulk data import and export files, HDL data files and other artifacts.
Download Hcm Bulk Data Files From Universal Content Management ( Ucm)
DOWNLOAD 🔥 https://byltly.com/2yGBqD 🔥
This blog summarizes the OIC solutions to move from 'sFTP based' to 'UCM based' flows for Oracle HCM Cloud integration.
Though the blog talks about Oracle HCM Cloud specifically, the solution pattern can be employed to integrate with other Oracle Cloud applications like ERP Cloud and also on-premise products like Product Data Hub (PDH) which use UCM (aka WebCenter Content Server) as the document repository.
This step can be implemented using FTP Connection and the "download to ICS" operation.
It is common to receieve PGP encrypted zip files from third party sources, so select the options to decrypt and unzip as needed
The UCM Webservice with IdcService=CHECKIN_UNIVERSAL can be used to upload file contents into UCM repository
Let us configure SOAP Connection Invoke Operation to call the service; The file content downloaded from previous FTP step needs to be passed in UCM payload as an MTOM attachment
So remember to enable MTOM attachment option for the request payload when configuring the invoke activity !
Refer to the figure below which shows SOAP adapter configuration with MTOM enabled for request
Note the use of 'Field' repeating element when mapping values to UCM webservices payload.Refer to this doc on how repeating elements can be added and mapped using the ICS Mapper -cloud-service/ocmap/repeating-target-element-map-different-sources.html
Refer here for the HCM DataLoader webservice
This is a SOAP connection Invoke operation to call the importAndLoadData operation
Use the mapper to map the Unique identifier of the file (dDocName) to be imported to the ContentId field of the HCM data Loader request as shown below
We use the UCM Webservice with IdcService=GET_SEARCH_RESULTS to search for files within UCM. Search criteria can be specified as Querytext for the search operation
There is no need to enable MTOM attachments on request or response payloads since this operation does not return the content of files.
Figure below shows sample mappings used for the search operation
The result of GET_SEARCH_RESULTS is a list of document metadata which includes the document ID (dID) of files matching the search criteria.
The dID will be needed in the next step to retrieve the file contents from UCM using another SOAP connection invoke.
Check the appendix for some example GET_SEARCH_RESULTS payloads for reference
The orchestration flow shown above depicts the iteration over the resultList to retreive list of dIDs from the search operation using "ForEach"
For each file dID, the subsequent step is performed to retrieve the file from UCM
The UCM Webservice with IdcService=GET_FILE is used to download the file contents from UCM repository as an attachment.
Figure below shows mapper with sample payload mapping for GET_FILE operation
Note- If you are using ICS, note that some of these features are available only starting 18.1.3 of ICS (Feb 2018).
Specifically MTOM attachment feature is available only with "Early Uptake Enabled" on 18.1.3 ICS. Contact Oracle Support to have it enabled on your ICS instance
ICS 18.1.3 also brings 2 new ICS Mapper functions that can encode/decode base64 directly from File Contents. The File Contents can refer to VFS FileReferences from File based activities like FTP, Stage activities and Attachments. Below are the new functions. Refer the 18.1.3 documentation for details of these new functions.
These functions provide an alternate way to set content into UCM webservice requests. This could be handy if SOAP Connection MTOM feature is not enabled on the ICS instance !
A FileReference from FTP download operation can be base64encoded and set as inline content in the UCM request payload for UNIVERSAL_CHECKIN operation
Similarly the Content within GET_FILE operation's response payload can be base64decoded and mapped to the next File based activity in the flow !
As a member of Cloud Solution Architects A-Team, my area of work involves SaaS, PaaS4SaaS and IaaS. My work focuses on Solution architecture involving Fusion Supply Chain Management (SCM), Integration, Extensions, High Availability, Security, Infrastructure, Hybrid Cloud and Networking aspects of Oracle cloud solutions.
This blog details the solution using Oracle Integration Cloud (OIC) for file based integrations using Universal Content Management (UCM) Webservices for Oracle HCM Cloud integration.
Subsequently, there is a need to rethink file based integrations that were in the past using the SaaS FTP server.
\nThe recommended alternative is to use Oracle WebCenter Content Server (also known as Universal Content Management or just UCM in this blog), which is the standard method of data file transfers for Oracle Cloud Applications.
\nUCM can be used to store and transfer files such as BI Publisher extracts, Bulk data import and export files, HDL data files and other artifacts.
This step can be implemented using FTP Connection and the "download to ICS" operation.
\nIt is common to receieve PGP encrypted zip files from third party sources, so select the options to decrypt and unzip as needed
The UCM Webservice with IdcService=CHECKIN_UNIVERSAL can be used to upload file contents into UCM repository
\nLet us configure SOAP Connection Invoke Operation to call the service; The file content downloaded from previous FTP step needs to be passed in UCM payload as an MTOM attachment
\nSo remember to enable MTOM attachment option for the request payload when configuring the invoke activity !
\nRefer to the figure below which shows SOAP adapter configuration with MTOM enabled for request
Refer here for the HCM DataLoader webservice
\nThis is a SOAP connection Invoke operation to call the importAndLoadData operation
\nUse the mapper to map the Unique identifier of the file (dDocName) to be imported to the ContentId field of the HCM data Loader request as shown below
We use the UCM Webservice with IdcService=GET_SEARCH_RESULTS to search for files within UCM. Search criteria can be specified as Querytext for the search operation
\nThere is no need to enable MTOM attachments on request or response payloads since this operation does not return the content of files.
\nFigure below shows sample mappings used for the search operation
The result of GET_SEARCH_RESULTS is a list of document metadata which includes the document ID (dID) of files matching the search criteria.
\nThe dID will be needed in the next step to retrieve the file contents from UCM using another SOAP connection invoke.
\nCheck the appendix for some example GET_SEARCH_RESULTS payloads for reference
The orchestration flow shown above depicts the iteration over the resultList to retreive list of dIDs from the search operation using "ForEach"
\nFor each file dID, the subsequent step is performed to retrieve the file from UCM
The UCM Webservice with IdcService=GET_FILE is used to download the file contents from UCM repository as an attachment.
\nFigure below shows mapper with sample payload mapping for GET_FILE operation
\n
Use Mapper to directly map the MTOM attachment to a FileReference of a file based activity which here is an FTP write operation onto a third party FTP server.
\nSee response mapper in figure below
ICS 18.1.3 also brings 2 new ICS Mapper functions that can encode/decode base64 directly from File Contents. The File Contents can refer to VFS FileReferences from File based activities like FTP, Stage activities and Attachments. Below are the new functions. Refer the 18.1.3 documentation for details of these new functions.
These functions provide an alternate way to set content into UCM webservice requests. This could be handy if SOAP Connection MTOM feature is not enabled on the ICS instance !
\nA FileReference from FTP download operation can be base64encoded and set as inline content in the UCM request payload for UNIVERSAL_CHECKIN operation
\nSimilarly the Content within GET_FILE operation's response payload can be base64decoded and mapped to the next File based activity in the flow !
One of our largest clients has recently gone through the process of migrating upwards of 60 million client documents from an old Stellent enterprise document management system to the newer Oracle Universal Content Management (UCM) system.
The Oracle Batch Loader is a Java utility for loading large numbers of documents, saving the manual effort of manually loading those documents through the standard Oracle UCM check-in interface. It is integrated into Oracle Fusion Middleware as part of the Oracle WebCenter Content (WCC) product. The utility immediately releases the document after loading and does not put them into any workflow process. 152ee80cbc
the divine reality god islam and the mirage of atheism pdf download