Can we implement SSO from EBS to OAC like OBIEE?

Question

Hi Team,

We are planning to upgrade from OBIA 11.1.1.0.2 to 11.1.1.0.3 PS3 with OAC.  Currently OBIEE is integrated with EBS for Single Sign On. We are looking for the same setup for OAC as well. Therefore looking for any document which can provide the steps for EBS to OAC SSO Integration if its feasible.

Thanks,

Manoj Jain

Gianni Ceresa · Accepted Answer

Hi,

Are you really going to use OAC and not OAS?

In OAC, as far as I know, IDCS is the only security provider available. This means that if you want any form of SSO you should also use the cloud IDCS in your EBS. This seems to be doable (at least for some versions / configs).

But it's probably not what you have...

I'm sure some Oracle employee will soon post a link to some documents if it's possible, but my guess is that it will not be doable if you aren't using IDCS everywhere.

If you are planning to use OAS, you will have a lot more chances that it could be done (and the doc or MOS should cover that).

GayathriAnand-Oracle · Accepted Answer

As @Gianni Ceresa mentioned, for OAC, SSO support is via IDCS and you would have to configure EBS to use same IDCS SSO for a single sign on solution between EBS and OAC. Passing session context via cookies and populating USER/ROLES variables init blocks are not supported for OAC.

Have seen some customers use ALTER session and use USER session variable in connection pool execute on connect section to get the current logged in user context while initiating ebs connection, however none of these approaches are documented and would be a custom solution and not supported.

Thanks

Gayathri