Oracle EBS Implementations By Averon

Success Story


The Customer

Marsh & McLennan Companies, Inc. is a global professional services firm, headquartered in New York City with businesses in insurance brokerage, risk management, reinsurance services, talent management, investment advisory, and management consulting. Marsh & McLennan Companies brings together more than 60,000 experts in risk, strategy, and people across Marsh, Guy Carpenter, Mercer, and Oliver Wyman, serving clients in over 130 countries. Marsh enables enterprise worldwide by helping clients manage risks, transforming uncertainty into opportunity.

The Challenge

With the latest functionality additions in R12, the client has planned for a multi-phased EBS Re-implementation rollout Project with a clean and streamlined data transitioning. Various business stake holders including Global Process Owners, Controllers, Data Governance Team, Reporting leads, Consolidation Managers, Change Control Team, QA Managers, IT SMEs have collaborated with this effort and have made a multi-year plan for the project. Business decided to take a lead for this implementation by hiring independent consultants to support the project as part of their core Implementation team. A strict deadline, pre-set IT budget, complex integration route, and strict data cleansing approach have put lot of pressure on the Project. Maintaining thin GL while having the source information available for reporting purposes is a challenge and have been addressed through FAH for the GL Integration. However, the challenge has become outrageously challenging, when the business users decided to use single source of truth for all their reporting purposes.

The Solution

The team began to look for plugins that could add functionality to APEX and ease up the development of application pages with a high level of complexity. Through their online research, United Insurance learned about the FOEX Plugin Framework and the additional functionality it brings to the standard APEX environment. After a successful free trial, the development team recommended using FOEX’s solution as a future development tool in addition to Oracle APEX.

A team of 1 system analyst and 2 Developers were tasked with rebuilding 13 different financial and insurance business applications using the combination of APEX and FOEX. These internal systems were initially developed with Forms & Reports and had a total of 500 pages and sub-pages. In addition to migrating from Oracle Forms & Reports 10g to APEX and FOEX, another objective was to build a friendly user interface that would provide a smooth navigation and allow users to find the necessary information easier.
When asked about his experience with using APEX and FOEX to migrate from Oracle Forms & Reports, Mr. Ibrahim Al-Shut, the IT Manager of United Insurance, stated: "I think developing critical business applications using APEX & FOEX is very much faster than ADF. It would have taken at least double the time if the applications had been developed using ADF and that’s assuming that our development team already had the required level of proficiency and experience in using both JAVA and PL/SQL."



"Functionality of Oracle FAH extended with OBIEE for reporting and Web ADI custom Integrators as a data entry point has transformed the project in the direction of success. Balance forward options from the SLA to GL in subledger only mode is the best choice recommendation made by Naga Nandigum who steered the golive to success along with our core IT team. The solutions offered with respect to performance, reporting and consolidation are efficient and streamlined the overall processes. Overall, I testify that Naga Nandigum has been a Key Member of the Phase1 Go-live success"

How can we help You?

Learn How We Can Transform Your Business?

Get in Touch