Continuing from my previous blog, here is the query which is responsible for retrieving users from fnd_user table for export. It might come handy for someone like me who was trying to debug issue when 0 users are being exported by the command. Make sure your where conditions are being met and this query returns […]
EBS: SSO: OID: FND_USER.USER_GUID getiing autoupdated: Users cannot login.
In one of my SSO implementation in UAT env, suddenly few of the users started complaining of below error. Upon analysis, I noticed that FND_USER.USER_GUID was updated with wrong values which did not match OID. Also Local users in EBS were updated somehow which was not the case at the time of implementation. Your Oracle E-Business […]
SSO: OID: EBS: java.sql.SQLException: ORA-06576: not a valid function or procedure name

While integrating OID 11.1.1.9 with EBS 12.2 (Reference Doc), the command got completed but with below error:- [oracle@oraworld01.local <PATCH> ]$ $FND_TOP/bin/txkrun.pl -script=SetSSOReg -registeroid=yes -provisiontype=3 -rdbmsdn=cn=OracleContext You are registering this instance with LDAP Server. Enter LDAP Host name? oid.oraworld.local Enter the LDAP Port on Oracle Directory server? 3060 Enter the LDAP Directory Administrator (orcladmin) Bind password? […]
Oracle EBS: E-Business Suite R12 – logout flow
This is a more of a documentation blog. Found an article online which i could not locate on Oracle Support Metalink, so blogging for future reference :-). Hope it will help someone else too. Introduction This note is some rough guidance on what happens when you click the “logout” button in Apps Rel 12. Note […]
Oracle: OID: DIP [LDAP: error code 20 – Attribute Or Value Exists]
A little bit of backgroup: In my recent SSO integration, we are using AD to OID synchronization based on Group Membership. ie. All the users who are added in a particular group will only be sync with OID and in turn with EBS. The error that i got was while Bootstrapping users and group from AD […]