Budgeting Lifecycle from Development to Publishing the Budget

Budgeting Lifecycle from Development to Publishing the Budget Book FORCES August 18, 2018

Agenda Introductions EPRCS Overview & Terminology Putting it all Together – Live Demo

Today’s Presenter: Jay Chapman Senior Consultant Jay Chapman is a functional and technical professional with 15 years of experience working with Oracle’s Enterprise Performance Management, People. Soft, and Oracle’s Enterprise Performance Management Cloud which includes Planning Budgeting Cloud, Enterprise Performance Reporting Cloud, and Oracle Analytics Cloud. His industry background comprises of administering Hyperion Planning and Hyperion Public Sector Planning and Budgeting, as well as testing, troubleshooting, and migration across environments. He has a finance background with an emphasis on budgeting, forecasting, and reporting. Jay is an Oracle Hyperion Planning 11. 1. 1 Implementation Specialist and an Oracle Enterprise Performance Reporting 2016 Cloud Service Specialist. He also helped co-write the certification exam for Enterprise Performance Reporting Cloud.

EPRCS Overview

Overview Complete Platform for Management, Narrative and Regulatory- based Regulatory and Management Performance Reporting • Narrative-based management and external reporting in one solution • Integrated Regulatory Reporting (Disclosure Management, Tax Reporting, etc. ) • Centralized EPM Cross-Cloud Reporting Hub • Complete: Authoring, collaboration, commentary and delivery • Report Development Lifecycle Management • Leverage existing documents, data sources and reporting content • Secure: Role-based, auditable access on desktop and mobile devices

Overview Operations Reviews Board Packages Project Funding Proposals Group Budget Reviews Regulatory Reporting Public Disclosures Audit Reports Stakeholders Report Owners Authors Approvers Enterprise Performance Reporting Cloud Signers Reviewers

Overview THE FIRST LEVEL OF SECURITY IS CREATED AT THE ORACLE CLOUD LEVEL System Administrators Report Administrators Application Administrators Library Administrators Users

What is a Report Package? A report package is a reporting construct that enables you to: Structure the Content of your report Assign Responsibilities to content creators and reviewers Manage their collaboration and workflow

What is a Report Package? With report packages, you can: Assign Content to multiple authors Gather Comments from reviewers Provide an Electronic Sign-off on the completed report Manage the report lifecycle Combine Data Points with textual narrative Secure and Control Access to the report content

Doclets and Sections Doclets: Report packages enable you to divide reports into subcomponents called doclets. Sections: Sections enable you to group doclets. Section 1 Section 2

Development Phases Author Compile the various report content and supporting details together into a cohesive report package. Review Gather commentary on multiple draft versions and revise the report content accordingly. Sign-off Gather electronic signatures from key constituents and secure report contents to prevent modifications.

Author Phase: Content Development Centralized: All content is developed by small group of users who contribute to content across the report. • Author phase is not enabled. • No workflow on doclets. OR Distributed: All content is assigned to users which contribute individual pieces of the report. • Author phase is enabled. • Collaborative with Workflow.

Authoring Doclets Two ways: • Via Web interface • Download to client • Author in Word • Upload to EPRCS • Perfect for authoring narrative content • Via Oracle Smart View for Office • Use the Performance Reporting extension • Perfect for integrating textual data with narrative

Embedding Refreshable Data in Doclets Ad hoc Sources via Smart View and Excel Smart View Sources Oracle Smart View SV Paste

Embedding Refreshable Data in Doclets Formatted Sources via Smart View Direct to Word EPM Sources Hyperion Financial Reporting Oracle Business Intelligence Oracle Smart View

Review Phase: Multiple Draft Review Process Review process may include: • Multiple review cycles • 1 st Draft > 2 nd Draft > 3 rd Draft • Vary review assignments – by draft • 1 st Draft for manager level • 2 nd Draft for executive level • 3 rd Draft for C-level • Vary review assignments – by area • Assign users to review entire report, section(s), doclet(s)

Review Phase: Other Benefits • Threaded Commentary • Multiple Platforms • Process Reporting

Sign-off Phase Secure content and gather electronic sign off • Requires all content be completed and locked down • Prevents all users from modifying the contents of the report • Gathers electronic sign off from key constituents • Notifications sent with link to final content • Allows online and downloaded review of report content • Secured sign off of report content

Technical Illustration Financial / Transactional System Integration PBCS Reporting 1 Data Management 1 Integration Load of Actual data, Plan data, and GL metadata from ERP to PBCS FRS & Smart. View EPRCS

Putting it all Together: Live Demo

Questions?

Stephanie. Popper@sierra-cedar. com | sierra-cedar. com