Oracle EBS Implementations By Averon

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

Our Testimonials

Our clients praise us for our personable service, expert knowledge, and on-time delivery. Look what they have to say!

Our Testimonials

How can we help You?

Learn How We Can Transform Your Business?