3 Install and Configure the Recipe

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

1. On the Oracle Integration Home page, in the Get started section, click Browse store.
2. Find the recipe you want to install, then click Get.

   A message confirms that the recipe was successfully installed, and the recipe card shows In use.

3. Click Configure on the recipe to configure its resources.

   The project workspace opens, displaying all the resources of the recipe. Configure the following resources before you activate and run the recipe.

Note that you can delete and replace the recipe's REST Payroll API Connection with a REST connection created specifically to connect to the downstream application of your particular use case.

Configure the Oracle FTP Connection

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 .

Configure the Oracle ATP Connection

1. In the Connections section, click the connection name.
2. In the Properties section, specify the database service name in the Service Name field. See Configure Oracle ATP.
3. In the Security section, enter the following details:

   Field	Information to Enter
   Security Policy	Select JDBC With OCI Signature.
   Wallet	Select the check box, then click Upload to upload the wallet file. See Configure Oracle ATP.
   Wallet Password	Enter the wallet password.
   Database Service Username	Enter the database service username to connect to the ATP database. The database service username is the schema username for the user to log in to the database. The database service username is not the same as the database service name that you specify in the connection Properties section.
   Database Service Password	Enter the database service password to connect to the ATP database.
   Object Storage Region	Specify the region in which your object storage is located. For example, us-ashburn-1.
   Object Storage Tenancy OCID	Specify the value you copied from the Oracle Cloud Infrastructure Console. For example, ocid1.tenancy.oc1.alphanumeric.value
   Object Storage Compartment OCID	Specify the value you copied from the Oracle Cloud Infrastructure Console. For example, ocid1.compartment.oc1.alphanumeric.value
   Object Storage User OCID	Specify the value you copied from the Oracle Cloud Infrastructure Console. For example, ocid1.user.oc1.alphanumeric.value
   Private Key	Click Upload to select the key you created. Ensure that the key is in RSA (PKCS1) format. Note: Only a private key without a pass phrase/password is supported.
   Finger Print	Enter the finger print that was generated when you created the key in the Oracle Cloud Infrastructure Console.

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 .

Configure the Lookup Table

The recipe contains the following lookup tables that you can edit and configure as per your requirement.

• Email_Notification
• Group_Setup

1. In the Lookups section, click the lookup name.
2. Edit the following lookup tables.
   1. In the Email_Notification lookup table, edit the value of the BatchNotificationTo lookup key by entering an email address of your choice to which notification error emails have to be sent.
   2. In the Group_Setup lookup table, use the default directories provided for GRPID: HCM_To_Payroll or edit them as required with the directories that you created in your FTP server. See Access Your FTP Server.
      • InputDir: Enter the directory path to receive and store the input files from the upstream system (for example: /pob-Workshop/HCM_To_Payroll_Input).
      • ArchiveDir: Enter the directory path to archive files from the upstream system which were successfully processed (for example: /pob-Workshop/HCM_Archive.
      • ProcessingHomeDir: Enter the path of the home directory (for example: /batchHome).
3. Click Save. If prompted, click Save again.
4. To return to the project workspace, click Go back .