Before you can build an integration, you have to create the connections to the applications with which you want to share data.
To create a connection in Oracle Integration:
In the left navigation pane, click Home > Integrations > Connections.
In the Create Connection — Select Adapter dialog, select the adapter to use for this connection. To find the adapter, scroll through the list, or enter a partial or full name in the Search field and click Search.
In the Create Connection dialog, enter the information that describes this connection.
- Enter a meaningful name to help others find your connection when they
begin to create their own integrations. The name you enter is
automatically added in capital letters to the
Identifier field. If you modify the
identifier name, don't include blank spaces (for example,
- Enter optional keywords (tags). You can search on the connection keywords on the Connections page.
- Select the role (direction) in which to use this connection (trigger, invoke, or both). Only the roles supported by the adapter are displayed for selection. When you select a role, only the connection properties and security policies appropriate to that role are displayed on the Connections page. If you select an adapter that supports both invoke and trigger, but select only one of those roles, you'll get an error when you try to drag the adapter into the section you didn't select. For example, let's say you configure a connection for the Oracle Service Cloud (RightNow) Adapter as only an invoke. Dragging the adapter to a trigger section in the integration produces an error.
- Enter an optional description of the connection.
- Enter a meaningful name to help others find your connection when they begin to create their own integrations. The name you enter is automatically added in capital letters to the Identifier field. If you modify the identifier name, don't include blank spaces (for example,
Your connection is created. You're now ready to configure the connection details, such as connection properties, security policies, connection login credentials, and (for certain connections) agent group.
Configure Connection Properties
Enter connection information so your application can process requests.
- Go to the Connection Properties section.
The fields that are displayed are based on your version of Oracle Integration.
- For new connections created with the initial release of the simplified
connections page on 2/18/20, the ERP Cloud Host field is
displayed. Enter the Oracle ERP Cloud host name. For example:
Note:The Oracle ERP Cloud host name can easily be derived from the Oracle ERP Cloud login URL. For example:
- For existing connections created prior to the initial release of the simplified
connections page on 2/18/20, the URL fields are
displayed. Specify the URLs to use in this integration.
ERP Services Catalog WSDL URL
ERP Events Catalog URL (optional)
Interface Catalog URL (optional)
For information about obtaining the URL, see Obtain the Oracle ERP Cloud Service Catalog Service WSDL, Event Catalog URL, or Interface Catalog URL (For Connections Created Prior to 2/18/20).
Configure Connection Security
Configure security for your Oracle ERP Cloud Adapter connection by selecting the security policy and security token.
- Go to the Security section.
- Select the security policy to use. Based on
your selection, the page is refreshed to display
various login credential fields.
Note:Passwords are mandatory.
Element Description Username Password Token With PGP Key Support Specify the following details to upload an encrypted file to Oracle WebCenter Content (Universal Content Management (UCM). The supported algorithm for the public key is RSA for encryption and key size should be 1024 bits long.
- Username: Enter the username.
- Password: Enter the password.
- PGP Public Key for UCM Upload: Click
, then browse for and upload the public key to encrypt the file. The
PGP public key must already be created. See Upload Files to Oracle WebCenter Content.
Ensure that a unique filename is present in the upload request payload file. See Use a Unique File Name for the Upload Request Payload When using PGP Encryption.
Username Password Token You receive the username and password to enter when subscribing to Oracle ERP Cloud.
- Username: Enter the username.
- Password: Enter the password.
OAuth Authorization Code Credentials
- Client ID: Enter the client identifier (ID) issued during OAuth client application creation. The client ID identifies the client (the software requesting an access token) making the request. See Perform Prerequisites to Use the OAuth Authorization Code Credentials Security Policy.
- Client Secret: Enter the client secret issued during OAuth client application creation. See Perform Prerequisites to Use the OAuth Authorization Code Credentials Security Policy.
- Authorization Code
URI: Enter the URI from which to request the authorization
code. This endpoint is used to initiate the OAuth authentication and
authorization process during which a user is directed to the OAuth server to
provide credentials, to review granted permissions, and to provide
- Access Token
URI: Enter the URI to use for the access token. A request must
be sent to this URI to obtain an access
Enter the scopes specified during OAuth client application creation:
- The URL that corresponds to the federated Oracle Fusion Application instance.
Scopes enable you to specify the type of access you need. Scopes limit access for the OAuth token. They do not grant any additional permission beyond that which the user already possesses. See Perform Prerequisites to Use the OAuth Authorization Code Credentials Security Policy.
- Client Authentication:
You can optionally configure OAuth flows with
client authentication. This is similar to the
Postman user interface feature for configuring
- Send client credentials as basic auth header: Pass the client ID and client secret in the header as basic authentication.
- Send client credentials in body: Pass the client ID and client secret in the body as form fields.
When configuration is complete, perform the following steps:
- Click Provide Consent to test the OAuth flow.
- If the Oracle Identity Cloud Service Oracle Integration and
Oracle Fusion Applications users are different, log in to the respective
instance when prompted.
Note: You are not prompted to log in if these users are the same.
- Return to the Connections page and click Test.
Note: If you receive an
Unauthorized 401error when testing your connection with a nonfederated user account, you may be logged in with the wrong user account. See Avoid Potential Errors When Testing Your Connection with a Nonfederated User Account.
Test the Connection
Test your connection to ensure that it's configured successfully.
- In the page title bar, click Test. What happens next
depends on whether your connection uses a Web Services Description Language
If Your Connection... Then...
Doesn't use a WSDL
The test starts automatically and validates the inputs you provided for the connection.
Uses a WSDL
A dialog prompts you to select the type of connection testing to perform:
Validate and Test: Performs a full validation of the WSDL, including processing of the imported schemas and WSDLs. Complete validation can take several minutes depending on the number of imported schemas and WSDLs. No requests are sent to the operations exposed in the WSDL.
Test: Connects to the WSDL URL and performs a syntax check on the WSDL. No requests are sent to the operations exposed in the WSDL.
- Wait for a message about the results of the connection test.
- If the test was successful, then the connection is configured properly.
- If the test failed, then edit the configuration details you entered. Check for typos, verify URLs and credentials, and download the diagnostic logs for additional details. Continue to test until the connection is successful.
- When complete, click Save.