EBS R12 integrated with SSO (OAM/OSSO) prompting for username / password again : Your Oracle E-Business Suite account has not been linked

This post covers issue encountered during EBS logon using Oracle Access Manager (OAM) as Single Sign-On Engine from our EBS-OAM Integration Trainnig.

Issue:  User trying to access EBS (integrated with OAM for SSO) is re-directed to login page (deployed on EBS AccessGate) . On typing username password, user is redirected to EBS page with message “Your Oracle E-Business Suite Account has not been linked with the Single Sign-On Account that you just entered. Please enter your Oracle E-Business Suite information.

 

EBS OAM Logon

 

 

First understand how SSO user (user stored in OID) is linked to EBS User (FND_USER).

1. Oracle Access Manager (OAM) by default validates username/password against weblogic’s embedded LDAP server. During EBS integration you point OAM to OID for username password validation. To change OAM 11.1.1.3 identity store to OID click here  and for OAM 11.1.1.5 to OID integration steps click here

2. OID contains username/password and also referred as SSO user or SSO Account.

3. Users are synced between OID and EBS (FND_USER and optionally HR & TCA account) either using DIP or OIM (EBS UM connector). More on Oracle EBS integration with OIM using EBS-UM connector later

4. User in EBS is linked with OID using value in column USER_GUID from table FND_USER in EBS with attribute ORCLGUID in OID.

5. If for any user

i) USER_NAME in FND_USER table matches with UID attribute in OID
and
ii) USER_GUID is NULL in FND_USER for this user
and
iii) EBS Profile Option Applications SSO User Auto Link is set to enbaled

then EBS AccessGate will update USER_GUID (in FND_USER table) from ORCLGUID value retrieved from OID. This process is called Auto Linking of EBS user with OID.

Coming back to our issue –  After OAM Logon user is redirected to EBS page with message “Your Oracle E-Business Suite Account has not been linked with the Single Sign-On Account that you just entered. Please enter your Oracle E-Business Suite information” could occur in following cases:

1. There is no user in EBS with USER_GUID (in FND_USER table) value same as ORCGUID in OID, and  EBS Profile Option Applications SSO User Auto Link is set to blank or disabled (auto link is disabled)

2. EBS Profile Option Applications SSO User Auto Link is set to enabled but there is no user in EBS with USER_NAME (in FND_USER table) value same as UID attribute in OID. This means user is not synced from OID to EBS.

3. There is user in EBS with USER_GUID (in FND_USER table) value same as ORCGUID in OID but user is end dated in EBS (END_DATE in FND_USER table) – In this case you should see message “Error Occurred” after typing username/password in EBSAccessGate logon page.

We provided a dedicated module for Troubleshooting where we cover Logging in WebGate, OHS, EBS Accessgate, DIP, OAM, and OID in our EBS-OAM/OID Integration Training , more about training here

If you have not yet downloaded FREE eBook – 7 Docs every Oracle Apps DBA must read for EBS R12 integration with OAM/OID for SSO get a copy in your eMail.

banner__

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

5 comments
Kanti says March 28, 2012

hi Atul,

You have covered the sync issue very well.Lets put this onto context of clones as well.After every clone you will have to do the sync.Depending on how you have setup the OID the scenario can differ.

Reply
Atul Kumar says March 28, 2012

@ Kanti,
I’ll cover cloning EBS (R12) integrated with OID/OAM in other posts soon.

Reply
Ashish says September 16, 2014

Hello,

I was able to integrate OAM with one of our EBS environment.
Now I have another EBS environment, which I am trying to integrate with the earlier installed OAM.

So basically, using the same OAM-OID combination to provide the SSO solution for another EBS environment.

Do I need to install, OHS (HTTP) server again for the 2nd EBS environment ?

Thanks,

Ashish

Reply
Mike says December 21, 2018

Interesting post, I clearly understood how EBS R12 integrated with SSO as well as issue encountered during EBS logon using OAM, thanks..We are planning to implement JDE Okta SSO ,Any recommendations pls…

Reply
Add Your Reply

Not found