FDQM

Course Contents:

Product Orientation

• Oracle’s Enterprise Performance Management System
• Benefits and Features of FDM
• ERP Integrator
• Processing Data Overview

Navigating FDM

• Accessing FDM
• Working with the POV
• Locking Out Users for Maintenance
• Running Reports
• Viewing Graphical Timelines

Creating FDM Applications

• About FDM Applications
• Creating Applications
• Managing Applications

Setting Up Control Tables And Locations

• Viewing Control Tables
• Managing Control Tables
• Viewing Locations
• Managing Locations
• Setting Location Attributes
• Searching Control Trees

Setting Up Mapping Tables

• Mapping Dimension Members
• Building Maps
• Map Types
• Processing Order
• Building Maps Externally
• Copying Maps
• Sharing Dimension Maps
• Setting Up Conditional Mapping

Integrating Applications

• Integration Overview
• Importing, Registering, and Configuring Adapters
• Adding Machine Profiles
• Configuring Application Settings
• Configuring Integration Settings
• Testing Integrations
• Setting Up Standard Reports and Templates

Building Import Formats

• About Import Formats
• Creating Import Groups
• Creating Import Formats
• Assigning Import Formats
• Adding Import Expressions

Loading Data

• About Loading Data
• Importing Source Data
• Working with Records
• Validating Dimension Mappings
• Loading Data to Target Systems
• Drilling into Data
• Drilling Through from Target Applications

Building Validation Rules

• About Validation Rules and Reports
• Creating Validation Rule Groups
• Creating Validation Rules
• Creating Validation Rules with Validation Editor
• Assigning Validation Rules to Locations
• Checking Validation Rules

Setting Up Validation Entities

• About Validation Entities
• Creating Validation Entity Groups
• Creating Validation Entities
• Assigning Validation Entity Groups to Locations
• Verifying Consolidations

Processing Batch Files

• About Batch Processing
• Setting Up Batch-Load Files
• Processing Batches
• Creating Batch Scripts
• Scheduling Batch Scripts in Task Manager

Creating Logic Accounts

• About Logic Accounts
• Creating Logic Groups
• Creating Simple Logic Accounts
• Creating Complex Logic Accounts
• Assigning Logic Groups to Locations

Loading FDM Journals

• About FDM Journals
• Creating Journal Templates
• Adding Metadata Tags
• Loading Journal Templates

Loading Data With Multiload Files

• About Multiload Files
• Creating Multiload Excel Templates
• Creating Multiload Text Files
• Loading Multiload Files
• Viewing Errors

Setting Up Security

• About FDM Security
• Security Levels
• Setting Up Object Security
• Setting Up User Security
• Locking and Unlocking the Local POV Mode
• Setting Up Report Group Security

Working With Financial Controls

• About Financial Controls
• Creating Controls Groups, Sections, and Questions
• Deleting and Restoring Controls Groups, Sections, and Questions
• Assigning Reviewer, Submitter, and Proxy Rights
• Accessing Financial Controls
• Selecting Application Settings for Financial Controls

Working With Import Scripts

• About Scripting in FDM
• Working with Scripting Components
• Creating Import Scripts
• Assigning Import Scripts to Import Formats
• Applying Scripting Functions to Import Scripts
• Working with Temporary Variables
• Manually Executing Custom Custom Web Scripts

Working With Import Integration Scripts

• About Import Integration Scripts
• Creating Import Integration Scripts
• Assigning Import Integration Scripts to Import Formats

Working With Event Scripts

• About Event Scripts
• Creating Event Scripts
• Changing Import Formats Dynamically