erp integration with epm
TRANSCRIPT
<Insert Picture Here>
Integrating Oracle ERP with Oracle Hyperion EPM - overview and updateMichael van der MerweDirector, Financial Close Solutions
2
Oracle EPM and Hyperion sessions at SAOUG
• Monday 14:30-15:15 Track 7• Oracle Financial Close Management Overview
• Tuesday 13:35-14:20 Track 7• Integrating Oracle ERP with Oracle Hyperion EPM
• Tuesday 14:30-15:15 Track 7• Oracle Disclosure Management Overview
3
Agenda
• Financial Data Quality Management (FDM) Overview• Feature Review• FDM Roadmap• Customer Case Study
– The Macerich Company
• Questions and Answers
4
EPM Data Quality Customer Challenges - Data
• Errors in financial data and meta data collection
• Inconsistent account structures• Heterogeneous sources• Increasing data volumes
OLTP & ODSSystems
Data WarehouseData Mart
PackagedApplications
(Oracle, SAP, Others)
ExcelXML/OfficeOLAP
SourcesExadata Unstructured
& Semi-Structured
Strategy Management
Financial Close and Reporting
Planning & Forecasting
Profitability Management
5
EPM Data Quality Customer Challenges - Process
• Lack of automated support for financial restatements
• Limited or non-existent audit trails• Weak controls around data &
meta data collection• Business function owned by IT
Data Management can become a real headache!
6
What is Financial Data Quality Management (FDM)?
• Combines four functions/processes– Collection and transformation of financial data– Management of periodic process to collect and
transform data– Documentation of internal controls to support
compliance– Investigation of audit trails, drill through and write
back to source• Data Quality is no longer an optional feature,
but a requirement
7
Oracle EPM System Delivers Confidence with FDM
Audit Trails• Integrated Control questions• Store current and historical
mapping definitions, docs• Allow dynamic drill through
to source ERP and files• “Defendable” Data
Data Collectionand Transformation
• Read and interpret G/L trial balance files and ERP sources
• Mapping validation againsttarget system dimensions
• Data & meta data integrity checking against data validation rules
Internal Controls• Source financial document
archival• Prepackaged audit and
internal control reports• Comprehensive role based
security
RepeatableProcesses• Single standard and
defined solution for any target application
• Standardized database schema• Standard upward data certification process• Fast turn around times
FDM
8
FDM offers unique ERP Integration for EPM
File ExcelXML
Other Systems
Oracle EBS, PeopleSoft, SAP R/3
Data WarehouseData Mart
FDMStrategic Planning
Financial Close
Planning & Forecasting
Profitability Management
EPM WorkSpace
Financial Reports
SmartView
Data & Meta data Data
Drill-through & Write-back
9
Feature Review
10
FDM Supported Sources and Application Types
• Sources– Any flat file, xls, database source– E-business Suite 11i, 12.0.6, 12.1.x General Ledger– Peoplesoft 9.0 GL and Human Capital Management– SAP R/3 4.6c, ECC 6.0. 4.7 for version 11.1.1.3
• Target Applications– Financial Management– Planning– Essbase– Strategic Finance– HPCM via Essbase cube– Enterprise– Generic tax applications. (Tax Stream)
Strategy Management
Financial Close and Reporting
Planning and Forecasting
ProfitabilityManagement
11
End users “Import” their source financial data (from files, DB’s or ERP)
into FDM eliminating all manual changes ensuring complete accuracy.
Import from Any Source
12
Invalid dimension mapping problems are identified for easy correction. FDM allows for
simple or complex cross-dimensional and conditional mapping of data.
Smart Dimensional Mapping
13
End users are given feedback on the quality, accuracy, and completeness of the data that they loaded to their
application, so they are accountable, and can participate in
the data integrity management process. Additional adjustment data may be loaded via flat or Excel files.
User Driven Data Validation Rules
14
FDM Reports
The Intersection drill-down report allows for a view of all current source to target
maps for all dimensions in one view, with values. The report is available in
PDF, Word, Excel, HTML and RTF formats by default.
15
Visibility Through Dashboards
The Close and Controls documentation status report provides further visibility into the process. See quickly who has loaded data into the application and full status of the data
load portion of the close process.
16
Sarbanes Oxley control questionnaires allow end users to attest to the validity of
financial data.
Business process areas are grouped into sections and questions can be tied to
activities for monitoring and testing. Built in workflow allows for promotion of responses to the next review level.
These questions apply to Section 302 Review Certification, as well as monitoring
the 404 control framework.
Supports Sarbanes Oxley Certifications and Assessment Requirements
17
Drill-Through to Source System to Audit Data
• From HFM, Planning, Financial Reports and Smartview
*Drill through from Enterprise 6.5.1 to FDM only
18
Planning to GL Write-backGoing beyond just drill-back…
• Write data from Planning, back into the General Ledger– Data used to generate plan vs. actual reporting details– GL interface tables populated as result of process– Standard journal import process used to load into ERP
• Budget Source– EPM version 11.1.2 – Planning, ASO and/or BSO
• Write-back GL Targets– PeopleSoft 9.0– EBS 11.5.10 cu2– EBS 12.0.6– EBS 12.1.x– Budgets, or Journals
19
Public Sector Planning Support
• Data, metadata, GL drill-through and write-back supported• Integration of Peoplesoft HR data
– Employee / Position Member Properties– Position / Employee Assignments– Position / Employee Earning Distributions– Job Codes / Salary Grades / Salary Steps– Map source PSFT HR fields to target PSB accounts
20
Seamless Integration to the Financial Close Process
• Run by hand, or schedule as a monthly batch• Integrated directly with the Financial Close Management
ApplicationFrom notification
to task
From task to FDM
21
Enhanced Essbase Support• Load metadata and data for ASO/BSO cubes• Drill through to ERP source system from Smartview
or Financial Reporting
File ExcelXML
Other Systems
Oracle EBS, PeopleSoft, SAP R/3
Data WarehouseData Mart
FDM EssbaseASO/BSO
Financial Reports
SmartView
Data & Meta data Data
Drill-through
22
Roadmap
23
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.
24
Financial Data Quality Roadmap
• Application Integration– Expand source system integration breadth and depth
• Fusion, JD Edwards, Enhanced SAP support– Integration with Data Relationship Management (DRM)
• FDM becomes a metadata source adapter for DRM• Allows easy implementation of DRM with many ERP’s
• Enhanced Functionality– HR write-back from Public Sector Planning– Commitment control integration– Journal write-back from Financial Management– HR data load to generic planning applications
25
The Macerich Company
26
Who Is Macerich?
NYSE: MAC
Headquarters in Santa Monica, Ca.
Public Real Estate Investment Trust (REIT)
3rd largest retail landlord in U.S.
Own and operate about 80 regional shopping malls
$1.7 billion in managed revenue
2,600 employees
400 legal entities - 150 actively managed in Hyperion Planning
250 Hyperion users
The Solution
Hyperion Planning v.11.1.1.3
ERPi v.11.1.1.3
Oracle eBusiness Suite v.11.5.10.2
3 plan types (P&L, Wrkforce, CapEx)P&L – Revenue and SG&A planning
Actuals in the Projections scenario are “drillable” to sub-ledger detail
Wrkforce – Headcount, salary, benefits, taxes, etcOracle HR is not yet compatible with ERPi – used ODI and SQL load rules
CapEx – Capital asset, depreciation, and amortization planningOracle Fixed Assets is not yet compatible with ERPi – used ODI and SQL load rules
How ERPi was used in the solutionBuild Account, Department, LocationCC, and Property (Entity) dimensions
Load last year and current year-to-date actual data27
The Software
The Design
The Benefits
1. Operational Accountability and Accurate Measurements
2. Simplified Tool and Solutions Reduced account combination footprint for budgets from 2,000 to 150.
Integration of key data points for billing/CRM leasing pipeline, human resources, capital expenditures, and general ledger.
Automatic calculations and seeding of budget data.
Simple UI’s
Actual to Budget Variance Explanation Functionality
3. Drilldown from Hyperion Planning to Underlying Transaction
28
The Architecture
29
ERPi Drill Through from Data Input Forms
30
Two options for accessing Drill Through
Edit->Drill Through->Drill Through to ERPi (above)
Select the cell (red oval), click the drill through icon (red circle)
ERPi Drill Through
31
ERPi launch page
Drill through to eBS1. Clicking on the cell value connects to
eBS to show the eBS ledger2. Clicking the PTD value shows the
ledger detail3. Journal entry detail
1
2
3
ERPi Drill Through from Reports
32
Drill through to eBSEach drillable cell value is hyper-linkedClicking on the cell value launches a ledger detail screen to show the ledger detailFrom the ledger detail, it follows the same functionality as from a data form
33
For More Information go to:www.Oracle.com/epm
www.Oracle.com/demos
34