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. Oracle AS: Undeploying Multiple Applications (including BPEL Human Tasks)

   Undeploying a single application in Oracle Application Server is pretty straightforward. However, I had a scenario where I needed to...

4. Oracle WebCenter 10gR3 Review - Framework, Web 2.0 Services, and SOA

   Ashok Aggarwal, a Partner at M&S Consulting has recently written a complete review of Oracle WebCenter Suite. This has been...

5. Oracle Fusion Middleware 11g beta

   I have been involved in the Fusion Middleware 11g beta program as well as participating in other ways as a...

6. 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...