OWB in the News: Department of Energy Success Story
By antonio romero on Sep 28, 2010
Warehouse Builder was one of a great many Oracle products leveraged in a success story for Oracle at the Department of Energy that shows off the breadth, depth and integration of Oracle’s offerings.
Sep 28, 2010 08:00 ET
U.S. Department of Energy Leverages Oracle Solutions to Consolidate and Streamline Department-Wide Systems and Business Processes
Reporting System Integrates Financial, Budgetary, Procurement, Personnel, Program and Performance Information
REDWOOD SHORES, CA--(Marketwire - September 28, 2010) - Oracle (NASDAQ: ORCL)
- U.S. Department of Energy (DOE) has deployed Oracle Business Intelligence, Oracle Financials, Oracle's PeopleSoft Enterprise Human Resources, Oracle Portal, Oracle WebCenter Suite, Oracle Beehive and Oracle's Primavera Enterprise Project Portfolio Management applications to build a reporting system to manage agency-wide systems and data.
- After it received American Recovery and Reinvestment Act (ARRA) funding that doubled its annual budget from $26 billion to almost $44 billion, DOE needed a comprehensive system to help manage the additional funding as well as provide accurate, timely reports on funding allocation and usage to both the Office of Management and Budget (OMB) and the public in near real-time, through recovery.gov and the DOE's own recovery funds portal.
- To meet OMB's requirement for near real-time access to how DOE is spending its ARRA funding, the agency integrated its financial, budgetary, procurement, personnel, program and performance information into a reporting system. Oracle Warehouse Builder supports the system at the core, linking common data elements from each of the department's business systems and supporting both external and internal reporting.
With the initial goal of securing 800 users on Oracle Financials, DOE has grown its user community to more than 1,700 users in less than one year, and is experiencing a growth of about 100 new users per month.
- DOE uses its core systems to provide the basic information for ARRA reports and can use Oracle Business Intelligence to easily make minor modifications to address new reporting requirements. With Oracle, DOE can now deliver financial reports to OMB on a daily, instead of weekly, basis. The Oracle software also provides automatic e-mail alerts to DOE staff when financial figures are not falling within expected ranges, so the agency can address budget allocation issues more proactively. The portal also enables users to create their own financial and project reports to meet their specific needs.
- In addition, DOE's budget and procurement offices can now use Oracle Application Express (APEX) to work more easily with various program offices by connecting an easy-to-use Web form or spreadsheet with Oracle Database to pull required data directly from corporate systems.