Codec Case Study


Case Study

ICON streamlined and simplified month-end, budgeting, planning, profit and loss, and capital expenditure (CAPEX) reporting relating to clinical trials using Oracle Hyperion Planning and Oracle Hyperion Financial Reports.

Company: ICON
Industry: Pharmaceutical
Country: Ireland
Employees: 9000

Solution Featured

The Challenge

  • Streamline and simplify month-end, budgeting, planning, profit and loss, and CAPEX reporting related to clinical trials carried out at 82 offices and 6 subdivisions in 40 countries
  • Enable decision-makers in each division to create their own alternate hierarchies and meaningful views of spend data versus budget.
  • Give divisional managers the ability to carry out ad-hoc analyses to monitor expenses against budget for each cost center and division and rectify areas where overspending occurs.
  • Improve timeliness and accuracy of medium and long-term forecasting at divisional and corporate levels.


ICON plc. is a global provider of outsourced development services to the pharmaceutical, biotechnology and medical device industries. The company specializes in the strategic development, management, and analysis of programs that support clinical development—from compound selection, to Phase I-IV clinical studies. ICON currently has around 9,000 employees at 82 locations in 40 countries.

The Solution

Codec implemented Oracle Hyperion Planning and Oracle Hyperion Financial Reporting to simplify and consolidate regional, divisional, and corporate planning and reporting. With the implementation, the company significantly reduced reliance on Excel and increased planning intelligence accuracy, timeliness, and granularity.

The Results

  • Improved month-end financial reporting by replacing Excel-based reporting tools with a single instance of Oracle Hyperion Planning.
  • Reduced risk from working with multiple spreadsheets that needed monthly manual consolidation to increase the accuracy, timeliness, and granularity of planning and reporting intelligence.
  • Extracted actual, budget, and CAPEX data directly from Oracle Financials with Oracle Data Integrator and loaded that data into Oracle Hyperion Planning to view by country, office, division, and project, and to drill down to individual transaction level.
  • Automated separation of data into hierarchies for functions, such as IT, sales, and marketing, as required by different divisions and decision-makers, without the need for manual coding or intervention from the IT team.
  • Provided role-based access to data via Oracle Hyperion Smart View for Office, which enabled users to view, import, manipulate, distribute, and share insights in Microsoft Excel.
  • Benefited from automated data extraction to refresh information daily instead of monthly and give decision-makers near-real-time intelligence for strategic planning.
  • Enabled end-users to run cost allocations and attribute the appropriate percentage of each expense to the relevant division or activity.
  • Conducted constant currency analyses to determine the effect of fluctuating exchange rates or other factors related to profit and loss and the balance sheet, and incorporated that analysis in planning and reporting scenarios.
  • Ran regular variance analyses to identify and understand the causes of overspending, control ongoing costs, and refine future budgets.
  • Automated the generation of profit and loss summaries at regional, divisional, and office level, using Oracle Hyperion Financial Reporting.
  • Produced CAPEX, variance, allocation and revaluation reports configured within the planning process.
  • Created online management reporting packs with automatic refreshes every 24 hours.

“‘Codec has enabled us to leverage Oracle Hyperion Planning and Oracle Hyperion Financial Reports to transform the efficiency and timeliness of planning and reporting at ICON. We now plan to extend its benefits to forecasting.’ ”
Jonathan Curtain, Vice President Corporate Finance