Skip to main content
The client ID and secret must be generated by an Oracle Life Sciences IAMS customer-delegated administrator (CDA) with the system-admin role.

Find your tenant details

Your tenant details identify your Oracle Clinical One environment and the Oracle Life Sciences IAMS service that issues its access tokens.

1

Find your tenant name

Your Tenant Name is the full tenant name in the host URL your organization uses for Oracle Clinical One.

  • Format: https://{tenant}.clinicalone.oraclecloud.com/eclinical-portal/
  • Example: if your URL is https://acmepharma.clinicalone.oraclecloud.com/eclinical-portal/, your tenant name is acmepharma
  • If you don’t have this URL, ask your Oracle project manager.
  • Copy the Tenant Name into your Connector Profile.
2

Get your token URL

Ask your Oracle project manager for the Oracle Life Sciences IAMS URL that issues access tokens. It is different from the URL you use to make Oracle Clinical One API calls.

  • Format: https://{token host}/ms_oauth/oauth2/endpoints/{tenant ID}/tokens
  • Example: if your token URL is https://login.example.oraclecloud.com/ms_oauth/oauth2/endpoints/hsgb/tokens, your token host is login.example.oraclecloud.com and your tenant ID is hsgb
  • Copy the IAMS Token Host into your Connector Profile, with no protocol and no /ms_oauth path.
  • Copy the Tenant ID into your Connector Profile. It is the abbreviated tenant name, while Oracle Clinical One API calls use the full tenant name.

Assign the system administrator role

The role is not assigned by default, and you only need to request it once.

1

Request the system-admin role

Sign in to Oracle Life Sciences IAMS as a customer-delegated administrator, using the URL specific to your organization.

  • Find the URL in your browser bookmarks or in the welcome email Oracle sent when your account was created. See Oracle Life Sciences IAMS bookmarks.
  • Under the Administration section, click Users.
  • Under the Search Users section, search for your own user.
  • In the Search Results table, click your user name.
  • On the User Details page, select the Roles tab.
  • From the Actions drop-down, select Request.
  • Search the roles for system-admin.
  • Click Add to Cart.
  • In the upper-right, click Checkout.

Create a client ID and secret

Request a Password Grant client in the OAuth Admin Console.

1

Request a new client

Sign in to your Oracle Life Sciences IAMS OAuth Admin Console account with your customer-delegated administrator credentials.

  • The OAuth Admin Console URL is different from the Oracle Life Sciences IAMS URL. Get it from your Oracle project manager.
  • On the home page, click Request New Client.
  • Client Name: StackOne Integration
  • Client Type: Password Grant
  • Business Service: clinicalone-CNE, the business service of the users who will connect
2

Add permissions

Enables actions: Add A Kit In A Study, Add A Subject, Add A Visit, Add Comment Or Reply To An Object, Add Form In A Study Version, Add Study, Bulk Assign Forms To Visits, Bulk User Effective Dates Update, Bulk User Sites Update, Create A New Treatment Arm For A Study Version, Create A Site, Create A Subject Transfer, Create All Visits, Forms And Questionnaires, Create And Assign Bulk Users, Create Codelist, Create Data Elements For The Flat Part Of A Multi Section Form, Create Data Elements For The Repeating Part Of A Multi Section Form, Create Manual Shipment In Resupply Strategy, Create Multiple Data Elements For A Subject, Create Open Query, Create Organization, Create Randomization List, Create Visit Status Record, Delete A Site By ID, Delete A Specific Form, Delete A Visit, Delete Data Elements In A Form Within A Visit, Export Kit Details For The Inventory, Export Randomization List, Get A Global User’s Details By User ID, Get A List Of All Studies, Get A List Of Study Forms, Get A List Of Study Visits, Get A Specific Form, Get A User’s Modes And Roles, Get All Comments For An Object, Get All Items With Source Data Verification Information, Get All Visits, Forms And Questionnaires, Get Associated And Dynamic Forms For A Subject Visit, Get Codelist By Name, Get Country Name, Get Data Elements Based On Subject, Visit, And Form, Get Data Elements By Subject And Event ID, Get Global Users, Get Inventory Statuses, Get Kit List Details, Get Kit Types, Get List Of Randomization Designs In A Study Version, Get List Of Treatment Arms For All Study Versions, Get List Of Visits Status For A Subject, Get Non-Serialized Inventory Order Items, Get Number Of Open Queries In A Study For Selected Subjects, Get Organizations, Get Query By ID, Get Query Data Based On Multiple Parameters, Get Randomization List, Get Sign Information, Get Site Or Depot Details By Study ID Using Filters, Get Study Design Visits, Get Study Site Details With Study Version Property By Site ID, Get Study Visit, Get Subject Details, Get Subject History, Get Subjects And Their Visit Schedule, Get Subjects For The Specified Study And Mode, Get Subjects With Open Queries In A Study, Get The Audit History For A Data Element, Get The Number Of Queries In A Study, List Available Order Status Values, List Codelists, Search For Kits In A Given Range For A Site, Search Shipments For A Site, Search Shipments For A Study, Update Data Elements For The Repeating Part Of A Multi Section Form, Update Single Data Element, Update Subject, Update Visit Status For A Given ID, Upload Kit List File, Upsert Data Elements For The Flat Part Of A Multi Section Form, Verify Multiple Data Elements For A Subject

Each permission gives access to one Oracle Clinical One API category, and you can refine them later.

  • Click Add Permissions.
  • In the Add permissions dialog, select each permission listed.
  • Click Add.
3

Save the client ID and secret

The generated client ID and secret are displayed on the Request New Client dialog.

  • Copy the Client ID into your Connector Profile.
  • Copy the Client Secret into your Connector Profile.

Create the StackOne Connector Profile

1

Create a Connector Profile

Enable the connector and create a Connector Profile in your project. See Setup Connector Profile.
2

Link an Account

Once the Connector Profile is created, continue to link an account.