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.

Configure the Oracle ATP ImportAccountTransaction 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. SeeConfigure 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 Oracle ERP SOAP ESS ImportAccountTrans Connection

1. In the Connections section, click the connection name.
2. In the Properties section, specify the WSDL URL. For example: https://<ERP Hostname>/publicFinancialCommonErpIntegration/ErpIntegrationService?wsdl.
3. In the Security section, enter the following details:

   Field	Information to Enter
   Security Policy	Select Username Password Token.
   Username	Enter the user name.
   Password	Enter the password.

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 FTP ImportAccountTransactions 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 Address	Enter the host address of your sFTP server.
   FTP Server Port	Enter the port of your sFTP server.
   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 ERP ImportAccountTransactions Connection

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 username 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 .

Update Integration Properties

1. Update integration properties for the integration flows in the recipe.
   1. In the Integrations section, click Actions on the Oracle FTP ERP ImportAccountTransactions ESS Trigg integration flow, then select Update property values.
   2. In the Update property values panel, update the integration properties with appropriate values.
      • NotificationFromEmail: This integration property holds the email address from where notification errors are sent. You can get the value from Settings > Integrations >Notifications.
      • NotificationToEmail: This integration property holds the email address to which notification errors are sent. Enter an email of your choice.
      • FileName: This integration property holds the name of the input transaction data file.
      • FolderPath: This integration property holds the path of the folder in the FTP server from which the input transaction data files are fetched. See Access Your FTP Server.
   3. In the Integrations section, click Actions on the Oracle ERP AccountTranactions ESS Job Monitor integration flow, then select Update property values.
   4. In the Update property values panel, update the integration properties with appropriate values.
      • From_Address: This integration property holds the email address from where notification errors are sent. You can get the value from Settings > Integrations >Notifications.
      • To_Address: This integration property holds the email address to which notification errors are sent. Enter an email of your choice.
2. Click Submit.

   A message confirms that the integration properties have been updated successfully.