1 About This Recipe

Use this recipe to export employee images from Oracle HCM Cloud to an FTP server.

Note:

This recipe is available as Oracle HCM Cloud — FTP Server | Export Images in the Integration Store. Oracle provides this recipe as a sample only. The recipe is meant only for guidance, and is not warranted to be error-free. No support is provided for this recipe.

Overview

This recipe extracts employee images from Oracle HCM Cloud and exports them to an FTP server.

To use the recipe, you must install the recipe and configure the connections and other resources within it. Subsequently, you can activate and run the integration flow of the recipe manually or specify an execution schedule for it. When an employee image is added or updated in Oracle HCM Cloud, the recipe exports it to an FTP server. Further, when an employee image is deleted from Oracle HCM Cloud, the recipe generates a CSV file with the employee number and ID.

When the integration flow of the recipe is triggered, the following happens:

  • The integration flow calls an Oracle HCM custom Enterprise Scheduler (ESS) job using the export bulk data option of the Oracle ERP Cloud adapter.
  • The custom ESS job extracts employee image changes incrementally from Oracle HCM Cloud. That is, it extracts all records from last successful run of the ESS job. Subsequently, the ESS job exports the employee images as XML files to an FTP server.
  • Once ESS job's execution is complete, a callback is sent to Oracle Integration.
  • The integration flow reads the XML files placed in the FTP server by the ESS job, processes the data, and sends back the images (JPG files) to the FTP server. In case of deleted image files, a CSV file is generated with employee number and ID.
  • If an error is detected, a notification email is sent to the email Id specified in the lookup table.

System and Access Requirements

  • Oracle Integration, Version 24.02 or higher

  • Oracle Fusion SaaS

  • An account on Oracle Fusion SaaS with the Administrator role

  • A secure FTP (sFTP) server

  • An FTP client to access the sFTP server