Before You Install the Recipe

You must perform the following configuration tasks on your Oracle Fusion SaaS instance, Oracle ERP Cloud, and FTP server in order to successfully connect to these external systems using Oracle Integration and export employee images.

Access Your FTP Server

Obtain an FTP server and ensure that you can access it.

  1. Log in to the server using your user name and password through an FTP client; for example, FileZilla.
  2. Create a directory on the server to add the XML data files and employee images. Note down the path of the directory.

Configure Oracle ERP Cloud

To access the Oracle ERP Cloud instance from Oracle Integration, you’ll require a separate user account on Oracle ERP Cloud.

Log in to your Oracle ERP Cloud instance as an Administrator and perform the following tasks.

  1. Create a user account for Oracle Integration. Make a note of the user name and password you set for the account. You’ll use the credentials of this user account to connect to Oracle ERP Cloud from Oracle Integration.
  2. Assign the following roles to the user account. For more information on these roles, see Assign Required Roles to an Integration User.
    • Integration Specialist
    • Oracle ERP Cloud-specific data access to the integration user

Configure Oracle Fusion SaaS

Complete the following tasks in your Oracle Fusion SaaS instance to successfully connect to it from Oracle Integration and export employee images.

  1. Add an FTP server or sFTP server as a delivery channel from the Administration page of Oracle Business Intelligence. See Add an FTP or SFTP Server.
  2. Enable auditing on Person Image. See Auditing Community Development Data.
  3. Deploy the custom Business Intelligence Publisher (BIP) Data Model and Business Intelligence Publisher Report. You can download the EmployeeImageExtract.catalog file to use in the recipe from BI Publisher catalog.
  4. Update PARAMETER4 of bursting code in BIP Data Model with the folder path that you created in your FTP server. See Access Your FTP Server.
  5. Deploy the custom ESS job. See Creating an Oracle Enterprise Scheduler (ESS) Job.

    Specify the following values for the fields while creating the custom ESS job.

    Field Information to Enter
    Display Name Oracle HCM FTP Extract Employee Images
    Name ExtractEmployeeImages
    Path /ExtractEmployeeImages/
    Job Application Name EarHcmEss
    Job Type BIP job type
    Enable Bursting Report Set this property to enable bursting report.
    Report ID /Custom/Human Capital Management/EmployeeImageExtract/EmployeeImageExtractReport.xdo

    Note:

    If you want to customize any of the above-mentioned values, ensure that you make necessary changes in the lookup table and BIP Data Model. Deploy the BIP Report in the path specified in Report ID.