1 About This Recipe

Use this recipe to import worker data from an FTP server to Oracle HCM Cloud.

Note:

This recipe is available as FTP Server — Oracle HCM Cloud | Import Worker Data in Oracle Integration. 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 imports worker data from an FTP server to Oracle HCM Cloud.

To use the recipe, you must install the recipe and configure the connections and other resources within it. When triggered, the recipe's integration flow picks a comma-separated values (CSV) file that contains the worker data from a specified location in an FTP server. The imported CSV file is converted to NXSD format in Oracle Integration. The NXSD is used within Oracle Integration to generate a DAT file that is compatible with HCM Data Loader. The DAT file with the worker data is then uploaded to Oracle HCM Cloud using HCM Data Loader.

Note that for successfully processing the worker data in Oracle Integration, the input file should be in a particular format. You can download a sample input file Worker.csv from Sample file.

System and Access Requirements

  • Oracle Integration, Version 23.06.02 or higher

  • Oracle HCM Cloud

  • An account on Oracle HCM Cloud with the Administrator role

  • A secure FTP (sFTP) server

  • An FTP client to access the sFTP server