Install and Configure the Recipe

On your Oracle Integration instance, install the recipe to deploy and configure the integration and associated resources.

Install the recipe on your Oracle Integration instance. See Install a Recipe or Accelerator.

After you've installed the recipe, configure the following resources:

Configure the Oracle ERP Cloud Connection (Trigger, Invoke)

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the Oracle ERP Cloud host name. For example: https://your_domain_name.fa.DC.oraclecloud.com.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Username Password Token.
    Username

    Enter the user name of the account created for Oracle Integration on Oracle ERP Cloud.

    See Configure Oracle ERP Cloud.

    Password Enter the password of the account created for Oracle Integration on Oracle ERP Cloud.
  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

    A message confirms if your test is successful.

  6. To return to the project workspace, click Go back Back icon.

Configure the Oracle FTP Connection (Trigger, Invoke)

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    FTP Server Host Name Enter the host address of your sFTP server.
    FTP Server Port 22.
    SFTP Connection Select Yes from the list.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select FTP Server Access Policy.
    Username Enter the username to connect to your FTP server.
    Password Enter the password to connect to your FTP server.
  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

    A message confirms if your test is successful.

  6. To return to the project workspace, click Go back Back icon.

Configure the Lookup Table

Edit the Oracle HCM FTP Extract Employee Images lookup table and update the lookup keys with appropriate values.

  1. In the Lookups section, click the lookup name.
  2. In the lookup table, specify values for the following keys.
    Key Description
    IntegrationID

    The key to fetch all the remaining values from the lookup.

    For example: ORCL-HCM_FTP_EXTRACT_EMP_IMG
    EssJobName

    The name of the ESS job defined in the Oracle Fusion SaaS instance.

    For example: ExtractEmployeeImages
    EssJobPath

    The ESS job path defined in Oracle Fusion SaaS instance.

    For example: /company_name/apps/ess/custom/ExtractEmployeeImages/
    OICSFTPIn

    The FTP location where the ESS job output files must be stored. Enter the target location's path.

    For example: /home/users/In
    OICSFTPOut

    The FTP location where the images and CSV files must be stored. Enter the target location's path.

    For example: /home/users/Out
    OICSFTPArchive

    The FTP location where the processed ESS job task files must be stored. Enter the target location's path.

    For example: /home/users/Archive
    OICSFTPError

    The FTP location where the error files must be stored. Enter the target location's path.

    For example: /home/users/Error
    FilePrefix

    The file prefix of the ESS job outputs. For example: IMAGE_*.*
    FromEmailAddress Specifies the email address to which the error notifications are sent. Enter an email address of your choice.
    ToEmailAddress Specifies the email address from which the error notifications are sent. Enter an email address of your choice.
    EmailSubject Specifies the subject of the email error notification. For example: Export Employee Images Status
  3. Click Save. If prompted, click Save again.
  4. To return to the project workspace, click Go back Back icon.