Oklahoma Office of State Finance Streamlines American Recovery and Reinvestment Act (ARRA) Data Submissions and Reporting with Oracle

Office Generates Valuable Reports and Eases Regulatory Compliance

News Facts

• Oklahoma Office of State Finance (www.ok.gov/OSF/) implemented Oracle® Database (www.oracle.com/database/index.html) , Oracle Warehouse Builder (www.oracle.com/technology/products/warehouse/index.html) and Oracle Business Intelligence Suite Enterprise Edition Plus (www.oracle.com/appserver/business-intelligence/enterprise-edition.html) (Oracle BI Suite EE Plus), with the help of Oracle Consulting, to more effectively manage and improve visibility into American Recovery and Reinvestment Act (ARRA) funding data.

• The Oracle software enables the Office of State Finance to effectively and efficiently manage and collect data related to awards, sub-awards and vendor payments from more than 25 state agencies and higher education institutions that have received Federal funding under ARRA and then automatically submit the data in reports mandated by the Office of Management and Budget (OMB) to the FederalReporting.gov Web site. The Oracle solution enables the department to better cleanse, combine and report the data, improving data accuracy.

• Prior to the Oracle implementation, the Office of State Finance was limited in its ability to drill down into the data to the individual award level. The Oracle solution enables the department to easily and quickly generate accurate, up-to-date ARRA reports, called Transparency reports, based on the data received from the state agencies. These reports, for example, outline the number of jobs created by different functions of government and within specific geographic locations, as well as highlight sub-award amounts categorized by award and payments made to vendors.

• In an effort to ensure full transparency and accountability for the state’s citizens, Oklahoma Gov. Brad Henry has also ordered the creation of a Web site to track how each individual agency is using ARRA funds. In the near future, Oklahoma Office of State Finance plans to leverage its existing Oracle solution to support this Web site, which will enable citizens to access clear and concise information about the Federal stimulus initiative including graphs illustrating how much money the state has spent in a certain quarter, a breakdown of the spending by category, and the ability to drill down into spending figures, job creation statistics, and other data.

Supporting Quote

• “The ARRA project was most difficult, as underlying assumptions changed almost hourly and we had to face major challenges at every turn. The Oracle team responded beautifully, providing the proper levels of leadership and teamwork to make the project a success,” said Michael Clingman, director, Oklahoma Office of State Finance.

• "ARRA has made it clear that every taxpayer dollar spent on economic recovery must be subject to unprecedented levels of transparency and accountability. The State of Oklahoma is focused on providing this transparency to its citizens. With Oracle Consulting, the state is able to meet these new challenges with regard to collecting, monitoring and communicating key information about its use of public funds using dashboards developed with Oracle Business Intelligence Suite Enterprise Edition Plus, and leveraging data currently existing in its financial, planning and tracking systems,” said Steve Holdridge, group vice president, Government and Education Consulting, Oracle.

Supporting Resources

About Oracle

Oracle (NASDAQ: ORCL) is the world’s largest business software company. For more information about Oracle, please visit our Web site at www.oracle.com (www.oracle.com/) .

Trademarks

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Contact Info