Pre-requirements for creating Fusion ERP connection in Oracle Integration Cloud

In our last article, we tackled the process of linking Oracle Integration Cloud with Fusion Apps, like ERP Cloud, through OAuth 2.0. As we navigated the setup, we detailed the creation of two confidential applications in OCI IAM to tap into the Fusion Apps Endpoint URL. But before you dive into the Oracle Integration Cloud configurations, there are essential prerequisites to bear in mind. Neglecting these could lead you to grapple with numerous CASDK-0004 errors when you give the connection in Integration Cloud a test run.

Export and import JWK signing keys

One important pre-requirement that needs to be configured is when the IDCS domains for Integration Cloud and ERP Cloud are different. In most implementations, this is the case, as Fusion Apps is provisioned by Oracle (Sales). Given this scenario, it falls upon the diligent shoulders of an IT Admin to transfer the JWK signing keys—these are crucial for the OAuth authorization token—from the OCI IAM (previously known as IDCS) domain straight into Fusion Apps. And if you’re wondering about the ‘how’, there’s a handy REST API tailored for IDCS that simplifies fetching these keys.

Temporarily add Identity Administrator role to Fusion Client (Confidential) App

In our previous article titled ‘How to Create Confidential Applications in OCI IAM for Invoking Fusion Apps Endpoint Using OAuth,’ we discussed the creation of an OAuth 2.0 client application. To enable the retrieval of JWK signing keys, we will need to assign the ‘Identity Domain Administrator’ role to this application within the IDCS (Oracle Identity Cloud Service).

To accomplish this, follow these steps to edit the OAuth configuration for ‘FusionClientApp‘:

  1. Check the ‘Add app roles‘ checkbox.
  2. Click the ‘Add role‘ button. This action will open a side-panel where you can search for and add roles.
  3. Search for ‘Identity‘ and select the ‘Identity Domain Administrator‘ role.
  4. Confirm the selection by clicking the ‘Add‘ button.
  5. After adding the role, remember to save the changes to finalize the configuration.

Please don’t forget to remove it when it is no longer needed at the end of the process.

Export JWK signing keys from OCI IAM

To obtain the signing certificates used by JWK (JSON Web Key), a JavaScript Object Notation (JSON) data structure representing a cryptographic key, you can utilize a REST API provided by IDCS (Oracle Identity Cloud Service).

The REST endpoint is designed to retrieve the Tenant’s Signing Certificate in JWK Format. It utilizes the API resource path /admin/v1/SigningCert/jwk, which must be preceded by the IDCS domain URL. The most convenient method for fetching these keys is by using Postman and making a GET request to the complete URL. It’s worth noting that the IDCS REST API requires an OAuth token for authentication. Therefore, prior to calling the SigningCert API resource, you’ll need to obtain an OAuth access token using the token URL with the resource path: /oauth2/v1/token.

The first image depicts a GET request to the resource, executed in Postman, using the client ID and secret of the OAuth confidential application, such as FusionClientApp.

To acquire the SigningCert keys and format the certificate for uploading it in binary (file) format, you must call the API resource path /admin/v1/SigningCert/jwk. To authenticate with this API, you’ll need to copy the obtained access token and use it as a bearer token, as demonstrated in the second image. The response will contain a set of two keys under the x5c attribute, starting with the phrase MIID. The first key corresponds to the certificate of the IDCS domain, while the second key is the certificate of the signing authority

Obtain access token
Get JWK signing keys

After you retrieved the two keys you need to format each of them correctly to a X.509 certificate. I like to use a browser tool from SAMLtool for this : https://www.samltool.com/format_x509cert.php. This tool formats the string and adds the required header and footer. Store each certificate in its own file e.g., idcs.crt and ca.crt.

Import JWK signing keys into Fusion Apps

The next part of the process is to import the certificates into Fusion App. For you to be able to do this you need to login as “IT Security Manager” in Fusion App, else you are not able to see the Security Console. Below are the steps to complete:

  • Login to your Fusion App home URL as IT Security Manager
  • Click on the Hamburger icon next to the logo
  • Under Tools, click on the option called Security Console
  • In the Security Console, navigate in the menu to API Authentication
  • The API Authentication page shows all providers, click the Create Oracle API Authentication Provider button
  • In the Trusted Issuer field, enter https://identity.oraclecloud.com and press Enter
  • Select all token types; JWT, SAML and STS and click Save and Close
  • Click on Inbound API Authentication Public Certificates option on the left sidebar.
  • On this page all added certificates are listed, click the Add New Certificate link to add the IDCS certificate
  • Enter a Certificate Alias, e.g., OIC_IDCS_CERT, import / choose the public certificate file and click Save
  • To the same for the signing authority certificate, enter a certificate alias, e.g., OIC_CA_CERT, choose file and Save
Now your domain certificates are uploaded and one of the important pre-requirements is completed.

!! Do not forget to remove the Identity Domain Administrator role on the confidential application !!

Create a shadow user in OCI IAM mirroring Fusion App user

Another small pre-requirement is that the user that is used for logging into Fusion App needs to be mirrored in the OCI IAM domain. This means that there needs to exist a user with the same username. Lets say we have a system account user in Fusion Apps with the username SA_FA_DEV_OIC we also need to mirror the user in OCI IAM used by Integration Cloud.

Assign the correct integration roles to the Fusion App user

Before proceeding further to ensure that we avoid encountering CASDK-0004 errors during our testing of the Integration Cloud connection to Fusion Apps, we must adhere to the prerequisites outlined in Oracle’s documentation page. This page includes a list of requirements, including the assignment of specific roles to the Fusion App user. Notably, two crucial roles are SOAOperator and FND_MANAGE_CATALOG_SERVICE_PRIV.

If the user does not have them you will run into an error while testing the connection : 

CASDK-0004 : Unauthorized [401] Error while connecting to the URL – https://<FA POD>.oraclecloud.com/soa-infra
Authentication Failure. Please check if the credentials provided are valid.

Conclusion

In this article, we have outlined all the essential prerequisites that must be met before establishing a connection between Oracle Integration Cloud and a Fusion App Endpoint. These prerequisites hold significant importance as they help prevent CASDK-0004 Unauthorized errors during testing. If you’re interested in learning more about the process of creating a connection between Oracle Integration Cloud and Fusion Apps, stay tuned for our upcoming article next week.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top