Presentation Transcript

1. Graphic Section Divider
2. CON9502: Introduction and Update: Oracle Hyperion Public Sector Planning and Budgeting Prasad Kulkarni Senior Director, Software Development Andrea Zirman Functional Lead, CalPlanning Team, UC Berkeley, UC Berkeley
3. Safe Harbor Disclaimer “The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle Corporation.”
4. Agenda Oracle Hyperion Enterprise Performance Management Public Sector Planning and Budgeting Human Capital Planning Decision Packages Reporting UC Berkley Implementation Story Upcoming Enhancements Strategy and Roadmap Questions and answers
5. Oracle Hyperion EnterprisePerformance Management
6. Oracle’s Enterprise Performance Management System BI / EPM Apps StrategyManagement Planning &Forecasting CRM Analytics Industry Analytics ERP Analytics Complete. Open. Integrated. Financial Close & Reporting Cost Management BI/EPM Platform Interactive Dashboards Query & Analysis Scorecards Reports & Publishing Office Search Detect & Alert Embedded Mobile BI Server Essbase Dimension Management Predictive Analytics Unstructured & Semi-Structured Common Enterprise Information Model OLAP Sources Packaged Applications (Oracle, SAP, Others) Data Warehouses Data Marts Business Processes OLTP & ODS Systems Exadata Excel XML/Office
7. Hyperion Performance Management Applications Market-Leading, Integrated Suite Integrates data from multiple transaction systems Automates and links strategic and financial management processes Modular, integrated suite Fast time to value; lower total cost of ownership Over 6,000 customers Strategy Management Planning and Forecasting Financial Close and Reporting Cost Management Common Administration Services Oracle BI Foundation
8. Critical Capabilities for Government Budget Planning Products Source: Gartner, Inc., “Critical Capabilities for Government Budget Planning Products” by Massimiliano Claps, 7 September 2011. This graphic was published by Gartner, Inc. as part of a larger research note and should be evaluated in the context of the entire report. The Gartner report is available upon request from Oracle.
9. Public Sector Planningand Budgeting
10. Public Sector Planningand Budgeting
11. Planning on Oracle Exalytics First In-Memory Engineered System for Analytics Highly accelerated planning cycles Re compute cubes in Minutes vs. Days More users, more granular scenarios, more powerful what-if modeling Planning and performance management at the speed of business 80X Faster Reads, 20X Faster Writes, and 5X more Concurrency Deeper structures, more dimensions, and complex allocations Lower TCO through application consolidation Certified to work with Oracle Hyperion Planning and Public Sector Planning and Budgeting
12. Magic Quadrant for Corporate Performance Management Suites Source: Gartner, Inc., “Magic Quadrant for Corporate Performance Management Suites” by Christopher Iervolino, John E. Van Decker, Neil Chandler, 14 February 2013 . This graphic was published by Gartner, Inc. as part of a larger research note and should be evaluated in the context of the entire report. The Gartner report is available upon request from Oracle.
13. The Enterprise Planning Process Run models based on key strategies to set targets Validate operational feasibility to financial plan Update forecast with latest budget and actuals Seed targets to annual operating plan and start annual process Evaluate resource and capital requirements Assess and Manage Risk
14. Oracle Hyperion Enterprise Planning Solutions Predictive Modeling and Simulation Profitability and Cost Management Specialized Modules Plan for Profitable Growth Long Term Financial Planning Public Sector Planning Project Financial Planning Capital Asset Planning Workforce Planning Planning, Budgeting and Forecasting Middleware Database Systems and Hardware
15. Public SectorPlanning and Budgeting
16. Public Sector Planning and BudgetingOverview Web-based integrated budgeting and planning solution that enables public service organizations to prepare and manage budgets and plans with reliable information from Human Resource (HR) and General Ledger (GL) systems Strategic solution to address public sector requirements through Oracle Enterprise Performance Management Planning module Built with Planning as the foundation technology Addresses the unique public sector challenges Includes decision packages Includes position and employee budgeting Supports management of budgetary processes including budget books Takes advantage of bi-directional integration with ERP systems
17. Applies to a Wide Audience Higher education State and local governments Country departments of government Ministries of finance Federal agencies International organizations Utilities, healthcare, and other regulated industries Non-profit and non-governmental organizations, and many others
18. Hyperion Public Sector Planning & Budgeting Flexible Configurable Modeling and “What If” Multiple Versions and Scenarios Easy to Use Owned and maintained by the budget group Wizard driven configuration and drag and drop report authoring Complete Integration with Microsoft Office Complete Decision Packages Position and Employee Budgeting Capital Budgeting Budget Book Creation
19. Features (1/2) Prepare sophisticated line-item budgets Create and manage decision packages and budget requests Plan for new initiatives and new programs Manage position and employee-related data Allocate position and employee budgets to programs, projects, or other chart of account dimensions Build budgets from prior years or prior versions Support multiple scenarios Distribute work and merge data into an overall process
20. Features (2/2) Define approval processes Set constraints and validate the data against them Handle overrides with comprehensive audit trails Integrate and aggregate position budgets into operating expense budgets Prepare, distribute, review, and approve budgets Include date-driven calculation logic for the entire organization Support mass updates and multiple levels of defaults Derive multi-dimensional data for further analysis
21. Hyperion Financial Data Quality Management Enabling Seamless Metadata and Data Integration Data & Metadata Meta-data Financial Close Web Interface Planning & Forecasting Data Financial Reports Strategy Management Microsoft Office Cost Management Drill-Through & Write-Back File Excel XML Data WarehouseData Mart Oracle EBS, PeopleSoft, JDE, Fusion APPs, SAP R/3 Other Systems
22. Commitment Control Integration Enable budgetary control of multi-dimensional budgets Handle data mapping complexities through ERP Integrator and Public Sector Planning and Budgeting functionality Supports two-way synchronization Supports run-time checking of rules
23. Commitment Control Integration Budget and actual data extracted from PeopleSoft tables Budgets in Public Sector Planning and Budgeting are validated by preparers through a web service call for funds checking Funds check status is returned as a link to view errors Final (approved) budgets are pushed back to PeopleSoft and posted
24. Human Capital Planning
25. Budget Administration Overview Maintain global (application-wide) defaults and the salary rate tables and grades that budget preparers use when defining positions Review initial position and employee data Review and make global updates to other compensation elements (non-salary expenses, additional earnings, and employer-paid taxes) Perform mass updates of position and employee data entered during the budget cycle or loaded from HR
26. Budget Administration Tasks Predefined and extensible context menus Predefined task list Composite form
27. Budget Preparation Overview Define positions Complete the life cycle of positions and employees: Assign employees to positions Transfer employees and change employee status Reconcile to-be-hired vacancy with an existing employee Copy, terminate, and delete position data Exclude positions from the budget Adjust compensation Allocate position expenses to GL accounts Specify effective date for distribution information Revise original budget with supplemental budgets
28. Budget Preparation Tasks Effective dating Predefined task list Data validation Predefined form Predefined and extensible context menus
29. Decision Packages and Budget Requests
30. Decision Packages and Budget Requests Overview Submit incremental funding requests for any budget type Personnel costs Operational costs Major initiatives Programs and projects Develop collaborative budget proposals affecting multiple planning units Adjust existing budgets Provide narrative justification and supporting detail (with or without amounts) Submit for review and approval
31. Key Functional Capabilities Flexible review and approval of decision packages Include or exclude budget requests from the budget at any time Enter formatted narrative justification Include public and/or private notes and attachments Select specific reviewer(s) Integrate with compensation, operating, and capital budgets Include collaborative budget proposals with multiple planning units Share across multiple entities Use specific forms for different types of decisionpackages
32. Decision Packages Summary view of funding requests Text editor for entering and formatting narratives Multiple public and private notes Multiple public and private attachments (documents or URLs)
33. Decision Packages Assigned a rank Included or excluded at any time from the overall budget Shared across multiple planning units for collaborative proposals Display dynamic totals Approved or rejected individually May be submitted to a specific reviewer
34. About Decision Packages Include or exclude from the overall budget Assigna rank Approve or reject individually Display dynamic totals Can share across multiple planningunits for collaborative proposals Can submit to a specific reviewer
35. Budget Requests Assigned a rank Included or excluded at any time from the overall budget Contain private and public notes and attachments Direct navigation to budget entry forms Support narrative at request level Totals display updates after entries are saved Moved to a different decision package
36. About Budget Requests Include or exclude from the overall budget Assign a rank Can be moved to a different decision package Can contain public and private notes and attachments Navigate to budget entry forms Display updated totals after entries are saved
37. Approvals Overview Review and track budget status. Submit budgets for review following the promotional path. Set up the approval path to be independent of the organizational structure. Highlight budget exceptions and problem areas with validation rules. Decision package considerations: Associate decision packages with a scenario, version, entity, an owning entity, and any shared entities. Ensure that planners have access to entities, scenarios, and versions.
38. Approvals for Decision Packages Approvals Status for Healthy Living Shows indicates that it is under review. Current owners
39. Promotional Path Promotional path shows cwest as the current owner. Change status actions
40. Decision Package Types Logically group and organize decision packages for data entry Specify the forms used to create budget requests Support forms for all types of budgets Control the aggregate totals that are displayed Map aggregate members from different cubes Support ASO and BSO cubes concurrently Define the mandatory and optional questions that planners answer to justify decision packages and budget requests Create as many decision package types as needed Set up the aggregation of budget request amounts for ASO and BSO databases Specify mappings to other applications that are based on data in decision packages
41. Standard Reporting
42. About Reporting and Budget Publication Reporting Applications Map to any Essbase target application Map to multiple, differently-dimensioned cubes for different audiences Support analysis Financial Reporting Create standard reports Create budget books Smart View Perform adhoc, multi-dimensional reporting Integrate with Microsoft Office Excel, Word, PowerPoint, and Outlook
43. Budget Books Overview Summarize the organization’s budget data and include details about salary increases, new recruitments, capital requirements, and other expenses Detail approved revenue, expenses and capital budgets, as well as associated financial, operational, and textual information Create budget books in Financial Reporting Publish as a PDF document or a static HTML Web site for internal or external constituents
44. Budget Books Features Books—combine Financial Reporting reports, Microsoft Word documents, URL links, pictures, and HTML, PDF, or other file types Reports—include related content and Planning content Microsoft Word documents—include Financial Reporting content with the FRExecute function Links—include links to documents published in Workspace and in document management systems (Oracle WebCenter) Table of contents (TOC) Cascading Style Sheet templates Book printing options in Workspace BI Publisher support
45. Book Editor Section Heading text Subsections Reports URL Document Custom text for TOC display Shortcut menu Display or hide an item in the TOC
46. 11.1.2.3 Highlights
47. Timeline Revisions Adjustments Dashboards DP Attributes Recurring Budgets Human Capital Plan Positions and Employees PeopleSoft HCM Decision packages Budget requests Approvals Narrative Justifications Human Capital Plan FY date Data load settings Process HR data Allocation task 2013 2010 2011 2012 Reporting Budget books SmartView enhancements Planning Text box sizes Upgrade Push to BSO Commitment Control PFP Planning ADF EBS HR Integration Enhanced Allocation Copy DP Options Planning ASO
48. Public Sector Planning and Budgeting11.1.2.3 Highlights Decision Packages Decision Package & Budget Request Attributes Recurring Budgets Copy Decision Package options Revisions & Adjustments Decision Packages Charts and Graphs FR support for Decision Package Reports Human Capital Planning Flat Amount Allocations Allocations for Additional Earnings Special Allocations for Benefits and Additional Pay Position Budgeting Charts and Graphs
49. Decision Package and Budget Requests Decision Package and Budget Attributes Attribute types: Text (free-form), List of Values (Smartlist), Date, Boolean User selects one or more attributes and enters or selects values as they create decision packages and budget requests Attributes can be used for filtering in reports Use in Copy feature
50. Recurring Budgets Recurring budgets is a way for customers to segregate on-going from one-time budgets. i.e. g depreciation costs, contract services, maintenance, current positions/employees, etc. Applies to all budgets within a budget request Budget request can be changed to recurring or non-recurring. Default is “recurring” when a new budget request is created. Can be used with Copy Decision Package to create new baseline
51. Copy Decision Packages Decision packages may be copied between different scenarios as well as versions Filter the decision packages by attribute and approval status Budget requests may be filtered by whether they are recurring, non-recurring or either budget type Period mapping is provided to move amounts between different periods. Use with caution. Ability to merge budget requests from multiple decision packages in the source scenario and version to one specific decision package in the target scenario and version
52. Revisions and Adjustments Capture delta changes to adopted/approved budgets Revision feature for line item budgets requires the decision package feature to be enabled Supports selective copy of decision packages into the revision version for preparers to perform their adjustments in new budget requests. Supports revisions for both compensation and non-compensation costs. Decision package approvals supports the revision process Full decision package and budget request and approvals functionality available for revisions to budgets.
53. Decision Package Charts and Graphs
54. Compensation Cost Allocation Enhancements Flat allocations Flat amount funding for a position/employee that cannot be exceeded; subsequent increases to compensation will be applied to percent allocations Allocations can now be a mix of flat and percent calculation Total flat plus total calculated percent allocations cannot exceed the compensation
55. Position Budgeting Charts and Graphs
56. Hyperion Planning Platform
57. Strategy and Roadmap
58. Key Investment Themes EPM Applications in the Cloud Continued Functional Innovation Analytics-Driven Performance Management
59. Continued Functional Innovation Performance-based budgeting Integration with OSSM Plans and Budgets Capital plan, program budgeting and funding/debt model Valid combinations Project, grants and awards budgeting (for grantor / grantee) Integration EBS HR EBS and PeopleSoft Projects and Grants Fusion integration (HR, Commitment Control)
60. Conclusion Oracle delivers the widest spectrum of proven public sector performance management functionality Including purpose built product on a widely adopted EPM and Planning platform Decision packages Oracle offers the most options around implementation on-premise and in the cloud Exalytics for analytics at the speed of business Oracle public sector performance management solution is available now
61. Questions and Answers
62. The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract.It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.