M&S is excited to be the Principle Sponsor for the Pittsburgh OAUG Annual Golf Outing. We hope you’ll join us for a fun morning of Golf, Food, and Prizes on August 15th. We play a Par Quota Scramble held at Buffalo Golf Course, where you can enjoy “one of the best golfing experiences in the Pittsburgh area.” There will be a 9am shotgun start, so please join us early on the course at 8am. The cost is $40 per person or $160 per foursome. For registration information visit the PittOAUG website and download the flyer today. We hope to see you out there!
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.
We took a systematic approach to the issue, addressing:
- Discoverer/Reporting Logic
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.