Oracle Hyperion Financial Management

1 Oracle Hyperion Financial ManagementUser's GuideRelease 2017 Oracle Hyperion Financial Management User's Guide, Release 2000, 2017, Oracle and/or its affiliates. All rights Author: EPM Information Development TeamThis software and related documentation are provided under a license agreement containing restrictions onuse and disclosure and are protected by intellectual property laws. Except as expressly permitted in yourlicense agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverseengineering, disassembly, or decompilation of this software, unless required by law for interoperability, information contained herein is subject to change without notice and is not warranted to be error-free. Ifyou find any errors, please report them to us in this is software or related documentation that is delivered to the Government or anyone licensing it onbehalf of the Government, then the following notice is GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on thehardware, and/or documentation, delivered to Government end users are "commercial computersoftware" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplementalregulations.

2 As such, use, duplication, disclosure, modification, and adaptation of the programs, includingany operating system, integrated software, any programs installed on the hardware, and/or documentation,shall be subject to license terms and license restrictions applicable to the programs. No other rights aregranted to the software or hardware is developed for general use in a variety of information Management is not developed or intended for use in any inherently dangerous applications, including applications thatmay create a risk of personal injury. If you use this software or hardware in dangerous applications, then youshall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure itssafe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of thissoftware or hardware in dangerous and Java are registered trademarks of Oracle and/or its affiliates.

3 Other names may be trademarks oftheir respective and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks areused under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron,the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced MicroDevices. UNIX is a registered trademark of The Open Group. Microsoft, Windows, PowerPoint, Word, Excel,Access, Office, Outlook, Visual Studio, Visual Basic, Internet Explorer, Active Directory, and SQL Server areeither registered trademarks or trademarks of Microsoft Corporation in the United States and/or software or hardware and documentation may provide access to or information about content, products,and services from third parties. Oracle Corporation and its affiliates are not responsible for and expresslydisclaim all warranties of any kind with respect to third-party content, products, and services unlessotherwise set forth in an applicable agreement between you and Oracle .

4 Oracle Corporation and its affiliateswill not be responsible for any loss, costs, or damages incurred due to your access to or use of third-partycontent, products, or services, except as set forth in an applicable agreement between you and About Financial ManagementFinancial Management Management Architect ..1-2 EPM Workspace ..1-2 Financial Management Elements ..1-42 Basic Financial Management ProceduresStarting Financial Management ..2-1 Opening Applications ..2-2 Closing Applications ..2-2 Setting User Preferences ..2-2 Specifying a Cluster ..2-2 Specifying Default Language for Descriptions ..2-3 Specifying Number Formatting ..2-3 Specifying File Extract Options ..2-3 Using Document Manager as the Default Page ..2-3 Setting User Preferences ..2-3 Enabling Multibyte Language Date and Time Financial Management Help ..2-5 Exiting Financial Management ..2-5 Using Financial Management ..2-5 Setting Point of View Bar Options.

5 2-5 Selecting Members for the Point of Multiple Members ..2-8 Finding Dimension Members ..2-9 Finding Selected Members ..2-10iiiSaving Favorite Favorite Members in Data Forms ..2-11 Viewing Member Active Entities ..2-12 Displaying Columns ..2-12 Reordering Tabs ..2-13 Using Filters ..2-13 Managing Up Links to Documents or Web Pages ..2-18 Copying Document Links ..2-18 Working with Custom Documents ..2-19 Accessing Related Task Lists ..2-20 Managing Managing DataWorking with Data Files ..3-1 Data File Groupings ..3-5 Data File ..3-6 Replace ..3-6 Replace by Security ..3-7 Accumulate ..3-7 Load Example ..3-8 Loading Data ..3-9 Viewing Data Load Progress ..3-10 Canceling Data Load Submission Drillable Region Definitions ..3-12 Extracting File Extract Options ..3-13 Extracting Data to a Flat Data ..3-15 Copying Line Item Detail ..3-17 Copying Intercompany Transactions ..3-18 Clearing Using Data GridsCreating Data Data Grids.

6 4-2 Viewing and Printing Data Grids as Charts ..4-2 Data Grid with Data Grids ..4-4 Setting Data Grid Rows and Columns ..4-4 Setting Grid Display Options ..4-5 Setting Grid Dimension Data Grid Settings ..4-7 Creating Data Grid Data Grids ..4-9 Loading Data Data Grids ..4-9 Entering or Editing Data into Summary-Level Time Periods ..4-10 Copying and Pasting Cell Values ..4-11 Clearing Data ..4-11 Using Data Cell Colors to Determine Status ..4-11 Refreshing Data ..4-13 Viewing Data in Data Grids ..4-13 Viewing Calculation Process Level ..4-15 Viewing Cell Cell Adjustments ..4-16 Adding Cell Text ..4-17 Viewing Cell Text ..4-18 Attaching Documents to Data Grids ..4-18 Adding Line Item Line Item Detail ..4-20 Line Item Detail Options ..4-20 Viewing Cell History ..4-21 Running Data Allocations ..4-21 Running Equity Pickup Calculations from Data Data ..4-22 Viewing Source and Destination Entity Detail the Entity Detail Report.

7 4-24 Accessing the Entity Detail Report using an External URL ..4-24 Report Point of Rows and Columns for the Report ..4-25vDisplaying Line Item Detail ..4-26 Displaying Base Details ..4-26 Displaying Source and Destination to Journal Detail ..4-27 Printing Entity Detail Reports ..4-27 Drilling Through to Intercompany Transactions ..4-27 Drilling Through to Source Data ..4-27 Launching Oracle Financial Management Analytics ..4-28 Process Management Options ..4-295 Consolidating DataConsolidation Process ..5-1 Entering Currency Percent Consolidations ..5-6 Calculating Options ..5-9 Consolidating Data ..5-10 Viewing Consolidation Consolidation Tasks ..5-11 Consolidation Using Data FormsWorking with Data Forms ..6-1 Opening Data Forms ..6-2 Using the Data Form Data Form Instructions ..6-3 Viewing Data Forms as Charts ..6-4 Opening Data Forms in Smart View ..6-5 Entering Data in Data Menu Commands.

8 6-6 Working with Cell Cell Text in Data Cell Text in Data Forms ..6-9 Editing Cell Text in Data Forms ..6-10 Attaching Documents to Data Forms ..6-11 Entering Line Item Detail in Data Forms ..6-12 Viewing Line Item Detail in Data Line Item Detail in Data Forms ..6-13 Using Linked Forms ..6-13 Changing the Point of View in Data Forms ..6-13 Calculating Data in Data Forms ..6-14 Running On-Demand Rules in Data Forms ..6-14viSuppressing Data in Data Forms ..6-15 Adding Members to Data Forms ..6-16 Printing Data Through to Intercompany Transactions ..6-17 Drilling Through to Source Data ..6-177 Managing OwnershipManaging Ownership ..7-1 Changing the Point of Display Ownership Information ..7-3 Copying and Pasting Ownership Values ..7-4 Ownership Calculation Process ..7-5 Calculating Ownership ..7-68 Managing Equity PickupAbout Equity Pickup ..8-1 Examples of Equity Pickup 1: Direct 2: Direct Ownership with Translation.

9 8-3 Example 3: Cascading Ownership and Subholdings ..8-4 Example 4: Cross-Ownership ..8-7 Managing Equity Pickup ..8-9 Modifying the Display of the Manage Equity Pickup Table ..8-10 Calculating Equity Pickup Adjustments ..8-11 Printing Equity Pickup Reports ..8-12 EPU Calculation Reporting on Financial Management DataCreating Reports ..9-1 Opening Reports ..9-1 Formatting System Reports ..9-2 Editing Reports ..9-3 Saving Reports ..9-3 Drilling Through to Intercompany Transactions ..9-4 Printing Reports ..9-4 Deleting Reports ..9-410 Processing Intercompany TransactionsIntercompany Transaction Module Transaction Security Roles ..10-2 Sample Intercompany Transactions Task Flow ..10-3 Intercompany Transaction Load Files ..10-6viiIntercompany Transaction Load Methods ..10-8 Loading Intercompany Transactions ..10-9 Extracting Intercompany Transaction Files ..10-10 About Managing Intercompany Intercompany Intercompany Transactions.

10 10-15 Selecting Intercompany Transactions ..10-18 Editing Intercompany Intercompany Transactions ..10-19 Assigning Reason Codes to Intercompany Intercompany Transactions ..10-20 Intercompany Transaction Auto-Match Process ..10-21 Auto-Matching Intercompany Transactions ..10-24 Using Auto-Match Templates ..10-25 Manually Matching Transactions with Tolerance Amount ..10-26 Manually Matching Transactions without Tolerance Amounts ..10-28 Generating Adjustments for Transaction Differences ..10-28 Matching Status ..10-28 Match Code ..10-29 Unmatching Intercompany Intercompany Intercompany Transactions ..10-32 Viewing Intercompany Transaction Progress ..10-33 Deleting Intercompany on Intercompany Intercompany Transaction Reports ..10-34 Displaying IC Transaction Report Columns ..10-36 Displaying IC Transaction Report Rows ..10-37 Running Matching Reports ..10-37 Selecting Matching Report Options ..10-38 Running a Matching Report by Account.