While using SSO, in order to create a public connection to Oracle Discoverer for Oracle Applications, I suggest creating a service account (user) in EBS and marking that user for LOCAL authentication (instead of SSO).

There may not be many reasons to create a public connection in this scenario, but I did come across one recently and it is not well-documented, so I thought I would share.

Of course, with Oracle BI Discoverer (non-Oracle-Applications), connections are made by database users and creating a public connection doesn’t require any EBS changes.

Related Information:

1. Supplier Portal - Oracle EBS and Middleware

   The Challenge

   ABC, a publicly traded services and manufacturing organization, has leveraged Oracle E-Business Suite (EBS) to manage a variety...
2. Selected for Oracle iSupplier Portal Integrated Solution Bringing together many components of the Oracle Fusion Middleware Suite, as well as Oracle Applications (via E-Business Suite), M&S is...
3. Applications with SQL Maintained Outside of Stored Procedures I have seen multiple custom solutions and packaged applications store their SQL outside of stored procedures. I am focusing this...
4. Oracle APEX Tutorial 10 - Access Control - Part 1 - Video Training Security. We hear about it everywhere. Make this more secure, make this less secure. In the computer industry this is...
5. Oracle APEX Tutorial 10 - Access Control - Part 2 - Video Training Security. We hear about it everywhere. Make this more secure, make this less secure. In the computer industry this is...