Configuring Connections in Oracle Integration Cloud
After the packages are imported and verified, the respective connections have to be configured.
This section describes the procedure to set up the following connections:
OU FTP WACS FTP for WACS-ERPFA
This connection is used to connect to the Oracle Utilities Work and Asset Cloud Service FTP server to poll the asset extract files using the FTP adapter.
To configure OU FTP WACS FTP for WACS-ERPFA connection:
1. Login to Oracle Integration Cloud and navigate to the connection.
2. In the Connection Properties section, set the values for FTP Server Host Address (xxxx.com), FTP Server Port, and SFTP Connection.
3. In the Security section:
a. Select the “FTP Server Access Policy” as the Security Policy.
b. Enter the Oracle Utilities Work and Asset Cloud Service FTP server Username and Password.
4. Click Test at the upper-right corner.
5. After the connection is tested successfully, click Save.
Important: Make sure the FTP Server is setup and configured in Oracle Utilities Work and Asset Cloud Service.
OU REST ERP FA for WACS-ERPFA
This connection is used to invoke ERPFA REST APIs to get the Asset Details using REST adapter.
To configure OU REST ERP FA for WACS-ERPFA connection:
1. Login to Oracle Integration Cloud and navigate to the connection.
2. In the Connection Properties section:
a. Select “restUrl” as the Connection Type.
b. Enter the ERP Cloud Host URL.
3. In the Security section:
a. Select Basic Authentication Security Policy.
b. Enter the ERP Username and Password to connect to Oracle Assets.
4. Click Test at the upper-right corner.
5. After the connection is tested successfully, click Save.
OU ERP FA Cloud for WACS-ERPFA
This connection is used to invoke asset FBDIs to create/update/retire assets in ERPFA using Oracle ERP Cloud adapter.
To configure the OU ERP FA Cloud for WACS-ERPFA connection:
1. Login to Oracle Integration Cloud and navigate to the connection.
2. In the Connection Properties section, enter the ERP Cloud Host URL.
Example: https://ERP_domain_name.ds-fa.oraclecloud.com
Note: The Oracle ERP Cloud host name can easily be derived from the Oracle ERP Cloud login URL.
3. In the Security section:
a. Select Username Password Token Security Policy.
b. Enter the ERP Username and Password to connect to Oracle Assets.
4. Click Test at the upper-right corner.
5. After the connection is tested successfully, click Save.
OU REST Trigger for WACS-ERPFA
This connection is used to receive and send asset records across the Oracle Integration Cloud integration flows using REST adapter. It is also used to invoke the common error handler Oracle Integration Cloud flow.
To configure the OU REST Trigger for WACS-ERPFA connection:
1. Login to Oracle Integration Cloud and navigate to the connection.
2. In the Security section, select OAuth2.0 Security Policy.
3. Click Test at the upper-right corner.
4. After the connection is tested successfully, click Save.
OU REST WACS OS for WACS-ERPFA
This connection is used to connect to Oracle Utilities Work and Asset Cloud Service object storage to poll the asset extract files using REST adapter.
To configure the OU REST WACS OS for WACS-ERPFA connection:
1. Login to Oracle Integration Cloud and navigate to the connection.
2. In the Connection Properties section:
a. Enter the object storage API endpoint in the Connection URL field.
The Connection URL follows this format: https://objectstorage.{region}.oraclecloud.com
Refer to the Oracle Cloud Infrastructure documentation/API Reference and Endpoints to see the Object Storage Service API and endpoints at: https://docs.oracle.com/en-us/iaas/api/
3. In the Security section:
a. Select the OCI Signature Version 1 security policy.
b. Provide the following Object Storage information:
a. Tenancy OCID
b. User OCID
c. Upload the private key
d. Fingerprint (obtained from object storage after register the public key for the appropriate user)
For more information, refer to the Object Storage Setup Guide 20C at: https:// docs.oracle.com/cd/F35460_01/index.htm
4. Click Test at the upper-right corner.
5. After the connection is tested successfully, click Save.
OU SOAP ERP FA for WACS-ERPFA
This connection is used to invoke ERPFA SOAP APIs that invoke BI Report service in ERP.
To configure OU SOAP ERP FA for WACS-ERPFA connection:
1. Login to Oracle Integration Cloud and navigate to the connection.
2. In the Connection Properties section, enter the ErpIntegrationService WSDL URL.
3. In the Security section:
a. Select Basic Authentication Security Policy.
b. Enter the ERP Username and Password to connect to the Oracle ErpIntegrationService.
4. Click Test at the upper-right corner.
5. After the connection is tested successfully, click Save.
OU BI ERP FA for WACS-ERPFA
This connection is used to invoke the BI Report SOAP service in ERP.
To configure OU BI ERP FA for WACS-ERPFA connection:
1. Login to Oracle Integration Cloud and navigate to the connection.
2. In the Connection Properties section, enter the BI Report Service WSDL URL.
3. Click Test at the upper-right corner.
4. After the connection is tested successfully, click Save.