My Oracle Support Banner

OAC : How to Connect to Oracle Fusion HCM-OTBI from OAC DV Dataset with SSO. (Doc ID 2607450.1)

Last updated on MARCH 08, 2023

Applies to:

Oracle Analytics Cloud
Information in this document applies to any platform.


End users should always use SSO for Login and connect to HCM integrated OTBI in SSO mode from OAC.

In addition, The Data Level Security and Object Level Security should be applicable based on the SSO Login User in OAC connecting to HCM/OTBI.


Both HCM and IDCS (where OAC instance is created) should be configured with the same External SAML IDP. Here it is OKTA SSO for example.

Applicable from OAC 5.2 where OAC is created with IDCS as its Identity management.

General Information:

1. Need an Admin User in HCM or BI System Administrator Role User in OTBI who has Native Password (Need not login in Web with that native pwd as SSO is enabled)
2. Need BI Impersonator Role in HCM assigned to the same Admin user
3. HCM.USER1 is only used to connect the HCM/OTBI, the same user (HCM.USER1) will impersonate as SSO Login user who tries to use the connection from OAC.
4. For SSO to work, users with the same username should exist in both HCM/OTBI and OAC/IDCS.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.