The Challenge

ABC, a publicly traded services and manufacturing organization, has leveraged Oracle E-Business Suite (EBS) to manage a variety of back-office functions, including their suppliers. Suppliers have been provided data from EBS manually by internal teams — the data sent has varied in both content and as well as format.

Internal teams spend valuable time generating reports manually for external supplier organizations and suppliers are left with the tedious process of generating their own reports. All the while, both groups may be relying on measures out of line with ABC’s priorities.

The Solution

We took a systematic approach to the issue, addressing:

1. EBS/Data
   
2. Discoverer/Reporting Logic
   
3. Portal/UI
   

The Results

Finally, by setting up proper SSO and hooks from Portal to Discoverer and integrating end-to-end all the way down into the database, users in Portal (regardless of whether they are internal or external users) see only what their user account can see. Additionally, by leveraging the latest Portal 10.1.4 features, we were able to provide ABC with a portal that had a completely customized look-and-feel matching their external website exactly.

Within days, the entire solution was architected, designed, and developed. We were all excited about the quick progress and all of ABC’s expectations were exceeded.

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.

Bringing together many components of the Oracle Fusion Middleware Suite, as well as Oracle Applications (via E-Business Suite), M&S is uniquely positioned to delivery immense value in a short amount of time.

M&S is designing and implementing a security, integration, and user presentation architecture with Oracle’s EBS, Discoverer, Portal, and Identity Management.