- Sync ESG Data from EcoVadis to Suppliers in Oracle Procurement Cloud
- Install and Configure the Recipe
3 Install and Configure the Recipe
On your Oracle Integration instance, install the recipe to deploy and configure the integration and associated resources.
- On the Oracle Integration Home page, in the Get started section, click Browse store.
- 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.
- 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 ERP Connection
- In the Connections section, click the connection name.
- In the Properties section, enter the Oracle ERP Cloud host name. For example:
https://your_domain_name.fa.ocs.oraclecloud.com
. - In the Security section, enter
the following details:
Field Information to Enter Security Policy Select Username Password Token. User Name Enter the user name of the account created for Oracle Integration on the Oracle Procurement Cloud instance. See Before You Install the Recipe. Password Enter the password of the account created for Oracle Integration on the Oracle Procurement Cloud instance. - Click Save. If prompted, click Save again.
- 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.
- To return to the project workspace,
click Go back
.
Configure the ERP REST Connection
- In the Connections section, click the connection name.
- In the Properties section,
enter the following details:
Field Information to Enter Connection Type Select REST API Base URL Connection URL Enter the connection URL. For example: https://your_domain_name.fa.ocs.oraclecloud.com
- In the Security section, enter
the following details:
Field Information to Enter Security Policy Select Basic Authentication. User Name Enter the user name of the account created for Oracle Integration on the Oracle Procurement Cloud instance. See Before You Install the Recipe. Password Enter the password of the account created for Oracle Integration on the Oracle Procurement Cloud instance. - Click Save. If prompted, click Save again.
- 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.
- To return to the project workspace,
click Go back
.
Configure the EcoVadis Connection
- In the Connections section, click the connection name.
- In the Properties section,
enter the following details:
Field Information to Enter Connection Type Select REST API Base URL. Connection URL Specify the URL of your EcoVadis instance. For example: https://api-sandbox.ecovadis-survey.com
- In the Security section, enter
the following details:
Field Information to Enter Security Policy Select OAuth Custom Two Legged Flow. Access Token Request -X POST -d grant_type=password&username=xxxxx&password=xxxxx https://api-sandbox.ecovadis-survey.com/EVToken - Under Optional security, enter the following details:
Field Information to Enter Refresh Token Request -X POST -d grant_type=password&username=xxxxx&password=xxxxx https://api-sandbox.ecovadis-survey.com/EVToken $access_token access_token $refresh_token access_token $expiry expires_in $token_type token_type access_token_usage -H Authorization: ${token_type} ${access_token} - Click Save. If prompted, click Save again.
- 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.
- To return to the project workspace,
click Go back
.
Configure the Lookup Table
Edit the field names and corresponding values in the lookup table of the recipe.
- In the Lookups section, click the lookup name EcoVadis.
- Update the fields and corresponding values in the lookup table.
EcoVadis Field Value buyer_contact_first _name Specify the first name of the internal user in your buying organization who will be responsible for communication with EcoVadis. A valid value is required. buyer_contact_last_ name Specify the last name of the internal user in your buying organization who will be responsible for communication with EcoVadis. A valid value is required. buyer_contact_email Specify the email address of the internal user in your buying organization who will be responsible for communication with EcoVadis. A valid value is required. Do not use mailing list email. buyer_phone Specify the phone number of your buying organization that can be used for communication with EcoVadis. A value is optional. campaign_type Enter STD for long standard assessment process (12- 14 weeks) with EcoVadis.
Enter RFP for short assessment process (Request For Proposal 4-6 weeks) with EcoVadis.
A value is required.
data_last_update_in_days Enter integer value larger than zero (0). Use this to specify the number of days in the past that the integration would look for ESG data update.
For example, when set as 1, the integration will look for ESG data updated in the past one day.
A value is required.
- Click Save. If prompted, click Save again.
- To return to the project workspace,
click Go back
.