February 11, 2022

Steps to fetch Oracle Cloud SaaS Application Certificates | Oracle Integration Cloud

In this Article I have mentioned the steps to fetch external services certificates (ex - Oracle Cloud SaaS Application ) which we can import to OIC instance. Certificate enables Oracle Integration to connect with external services.



Knowledge :👀
Certificates are used to validate outbound SSL connections. If you make an SSL  connection in which the root certificate does not exist in oracle integration, an Exception is thrown. In that case you must upload the appropriate certificate. A certificate enables Oracle Integration to connect with external services. If the external endpoint requires a specific certificate, request the certificate and then upload it into oracle integration.





Lets see the steps in details : 

Step 1 : Open the Oracle Cloud SaaS Application( ex - OTM, HCM etc. ) URL in browser. Then click on the Lock Icon 🔓 



Step 2 : Select '🔓 Connection is Secure'
 

Step 3 : Now click ' 📄Certificate is Valid'


Step 4 : Click on 'Certification Path'






Step 5 : Now please note we need to download the first 2 certification path i.e. DigiCert Global Root G2 & DigiCert Global G2  TLS RSA ...

Lets first download DigiCert Global Root G2 :
    • Select "🗟 DigiCert Global Root "and then click View Certificate
    • Click on Details tab and then click Copy to File

    • Click Next
    • Select Base 64 encoded X.509 (.CER) and then click Next


    • Now select any folder where you want to save the certificate file

    • Enter any Name with which you want to save the certificate file (ex - OTM Root Certificate )
    • Click Next 
    • Click Finish
    • You can see the pop up window with message "The Export was Successful ". This way you can download any Oracle Cloud SaaS application certificate.
    • If you open the folder where you have saved the certificate in above step, you can see a new file with the name given got generated.


Step 6 : Now Similarly by following Step 4 , download the other certificate "DigiCert Global G2  TLS RSA ..."

This way you can download both the certificates which you can upload to OIC instance.





Thank You !

February 7, 2022

Integration to upload file to the UCM Server in HCM Cloud | Oracle Integration Cloud


In this article we will see the steps to configure HCM cloud adapter in an Integration to Upload files to the Universal Content Management (UCM) or simply 'content server' in HCM Cloud.




PART 1 : Create HCM Adapter Connection :


    • Configure the connection using  HCM Cloud Host name & Username Password Token Security policy (as shown in below image )




PART 2 : HCM Adapter Configuration : 

Now Lets see the steps to configure the HCM adapter & it's mappings in an Integration flow to upload file to UCM Server in HCM cloud.


    • Search for the connection which has been created above 'Part 1'. Give any meaningful name (ex :- UploadFileToUCM ) and then click Next.


    • Select 'Send File to HCM Cloud' and click Next
Knowledge :  👀 

Send File to HCM Cloud : Please note this will only upload the files and not perform any additional operation on the file like Import Bulk Data  using HDL option.. 



    • Now select the File Upload Parameters as suggested below and click Next :
      • *Security Group : FAFusionImportExport
      • *Doc Account : hcm$/dataloader$/import$




    • Adapter Configuration Completed. Click Done


    • Now open the Mapper to complete the mappings. Click on edit icon 🖉 :


    • Complete the Mappings as given below :
      • Doc Title  → Pass File Name (with this name file will get generated in UCM server)
      • Security Group  → enter "FAFusionImportExport"
      • Doc Account  →  enter "hcm$/dataloader$/import$"
      • File Reference  → Map the File reference (file which you want to upload to UCM server)


That's it. Configuration to upload file in UCM server in HCM cloud completed. When you run this configuration in any Integration you will get Process Id in response, which you can use to search uploaded file in UCM server in HCM cloud.


 

Steps to check File uploaded to the UCM Server in HCM Cloud :

  • Login to UCM Content server , UCM URL : https://<saas domain >/cs  (example : https://eiiv-dev14.fa.us6.oraclecloud.com/cs )
  • Click on search button. You can see the file recently got uploaded or you can also search using the Process Id which you received as response in above Integration.






Thank You ! Please do let me know in the comment section if you have any query.