Initial Oracle Integration Setup
To configure Oracle Integration for Unifier, complete the initial setup outlined below.
Prerequisites
Ensure the following:
- Oracle Integration is provisioned.
- Unifier is to be added as a trusted application using client credentials grant type in Oracle Integration. Contact Oracle Support. You will need the Client ID, Client Secret, and App Scope information generated for Unifier in the procedure outlined below.
While creating the trusted application ensure the following:
- Client Credentials OAuth 2.0 Grant type is used.
- In the client configuration, add the Oracle cloud service resource as the scope. The App scope generally ends with 'urn:opc:resource:consumer::all'.
- Assign the Application with ServiceUser and ServiceAdministrator role in Oracle Cloud Service.
For more information, see Authenticate Requests for Invoking Oracle Integration Flows.
- You have the Oracle Integration URL and the IDCS URL hosting the Oracle Integration instance.
- In Oracle Integration, configure and deploy the Oracle Integration Accelerator. For more information, see the Accelerator to Integrate Oracle Primavera Cloud Resources and Schedule with Unifier.
It is highly recommended to use a dedicated Unifier Integration User Account for Oracle Integration flows while configuring the connections in the Accelerator.
- You have the relevant permissions to administer and configure Oracle Integration in Unifier. To set these permissions in Unifier:
- Go to the Company Workspace and switch to Admin mode.
- In the left Navigator, select User Administration, and then select Access Control.
- In the right page, expand Administration Mode Access, expand Integrations, and then select Oracle Integration Cloud.
Initial Setup Procedure
To establish a connection with Oracle Integration:
- Go to the Company Workspace tab and switch to Admin mode.
- In the left Navigator, select Integrations, and select Oracle Integration Cloud.
- In the right pane, select the Connect tab.
- Set up the connection with Oracle Integration:
- Enter the following information the first time you connect with Oracle Integration:
- OIC URL: Enter a valid Oracle Integration URL (usually ending with ocp.oraclecloud.com) to send and receive data between Unifier and Oracle Integration. This might be an instance embedded with Unifier or you might have your own instance of Oracle Integration.
- IDCS URL: Enter a valid Oracle Identity Cloud Service (IDCS) URL hosting Oracle Integration.
- Client ID: Enter the client ID generated for adding Unifier as a trusted application in Oracle Integration.
- Client Secret: Enter the client secret generated for adding Unifier as a trusted application in Oracle Integration.
- App Scope: Enter the App Scope generated for adding Unifier as a trusted application in Oracle Integration. It generally ends with 'urn:opc:resource:consumer::all'
- Click Save & Generate Access Token.
This generates a token and sets the Enable Integration fields to Yes on connecting successfully. Otherwise, recheck your Oracle Integration configuration details.
Note: For subsequent use, recheck the above field information and complete Step 2 to connect with Oracle Integration as-needed, on demand.
- Enter the following information the first time you connect with Oracle Integration:
- Select the Unifier modules that will use integrations from Oracle Integration:
- In the Integrations tab, click Manage Modules and select/deselect any of the following modules:
- Business Processes
- System Activity Sheets
- Manual Activity Sheets
- Master Rate Sheet
- Click Save.
- In the Integrations tab, click Manage Modules and select/deselect any of the following modules:
- For each module selected in the previous step, add one or more endpoints as follows:
- In the left pane of the Integrations tab, select a module. For example, select Business Processes.
- In the right pane, click Add Integration.
- For each endpoint, enter the following information:
- Integration Name: (Required) Enter a user-friendly name for the integration being set up.
- OIC Name: Enter the name of the integration created in Oracle Integration.
- API Path: (Required) Copy the relative path of the endpoint URL from the POST field on the Configure and Run page of the integration from Oracle Integration. It usually starts with /ic/api/.
- In the Action field, click Submit.
The Usage status of the integration defaults to Unused.
Note: If the integration is being used in the BP Setup/Activity Setup, the Usage status is set as In Use.
- In the Activate field, slide right to activate the integration. However, if the integration is deactivated, but being used in the BP Setup of a particular status/step, when the BP record is submitted, the integration will not be invoked.
When the integration is triggered as part of a BP workflow event or Get Data of System Activity Sheet, the job status can be viewed from the following locations:
- OIC Integration Log under the System Information node
- Integration Log of the BP record/Activity Sheet History tab
However, the progress of the integration execution is available in the OIC Integration Log only if the integration has a call to invoke the Unifier API with a status and corresponding error message. For more details, see the topic, Callback API to Update Oracle integration Recipe Instance in the Unifier Integration Interface Guide.
Tip: To temporarily disable a specific integration, slide left in the Activate field. To permanently delete a specific integration, see Deleting an Oracle Integration Connection.
- Add users or groups with appropriate permissions to access and use integrations from Oracle Integration:
- In the left Navigator, select User Administration, and then select Access Control.
- In the right pane, expand Administration Mode Access, expand Integrations, and then select Oracle Integration Cloud.
- In the Module Permission Settings window, click Add.
- In the Select Users/Groups pane, click Add Users/Groups to add users or groups, and then click OK.
- In the Permission Settings pane, assign any of the following permissions to users or groups:
- Configure: Select this option to allow users or groups to configure the Oracle Integration connection.
- View: Select this option to allow users or groups to only view the Oracle Integration connection.
- Click OK.
- Click Apply, and then click OK.
Proceed with Setting Up Business Processes With Oracle Integration as outlined in the Primavera Unifier Modules Setup Administration Guide.
See Also
Unifier and Oracle Integration
Enabling Oracle Integration Connection
Disabling Oracle Integration Connection
Editing an Oracle Integration Endpoint Connection
Deleting an Oracle Integration Connection
Last Published Friday, April 11, 2025