Discoverer - Public Connections for Oracle Applications with SSO
By M&S Consulting (Ashok) on Apr 11th, 2009
Filed Under Technical Tips // Tags: bi and reporting, identity management, oracle application server, oracle apps (ebs), oracle discoverer, oracle portal
Filed Under Technical Tips // Tags: bi and reporting, identity management, oracle application server, oracle apps (ebs), oracle discoverer, oracle portal
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:
- 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... - 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...
- 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...
- 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...
- 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...
- 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...
