ORACLE FCCS

• Describe the financial consolidation and close processes
• Describe Financial Consolidation and Close Cloud related components

• Describe the workflow for creating a Financial Consolidation and Close application
• Create a Financial Consolidation and Close application
• Explain application features available to be enabled

• Data/Meta Data Explanation       
• BSO Application
• ASO Application
• Standard _Dimension     
• Dense_Dimension           
• Sparse_Dimension           
• Data Block Creation and Block size concepts         
• Attribute _Dimension     
• Generation Of Reference             
• Level Reference
• Parent/Child Reference  
• Consolidation  Properties             
• Data Storage Properties
• Data Types

• Explain system dimensions and pre-seeded members including requirements and restrictions              
• Design and set up the Account dimension              
• Explain Data Source dimension and guidelines for adding member hierarchies         
• Explain Consolidation dimension
• Explain the Currency dimension  
• Design and set up Entity dimension           
• Design and set up Intercompany dimension           
• Design Cash Flow reporting, FX calculations, and Currency Translation Adjustments using Movement dimension          
• Design GAAP and IFRS financial reporting using Multi-GAAP dimension        
• Design application framework (metadata and user-defined elements)         
• Design and implement importing and exporting metadata

Product Orientation        

• Data Management Overview
•  Key Benefits and Features of Data Management          
• Data Management Integration Process            
• Processing Data Overview     
• Accessing and Navigating in Data Management            

Preparing Data Management Integrations

• Integration Setup Overview
• Setting Up the Application Root Folder
• Defining Profiles
• Setting Up Source Systems
• Registering Target Applications

Setting Up Import Formats for File Systems

• Import Formats Overview
• Creating Import Formats
• Defining Import Format Mappings
• Skipping Lines in Import Files
• Concatenating Fields
• Adding Import Expressions

Completing the Integration Setup

• Locations Overview
• Adding Locations
• Setting Location Details and Integration Options
• Periods and Categories Overview
• Defining Period Mappings
• Defining Category Mappings
• Point of View Overview

Setting Up Data Load Mappings

• Data Load Mappings Overview
• Defining Data Load Mappings
• Explicit Mappings
• Mapping Rules
• Processing Order
• Building Maps Externally
• Importing Mappings
• Sharing Mappings

Defining and Executing Data Load Rules

• Data Load Rules Overview
• Defining Data Load Rules for File-Based Data Loads
• Loading Data into Multiple Periods
• Running Data Rules and Checking Rule Status
• Viewing Imported Data
• Scheduling Data Load Rules

Processing Data in Data Load Workbench

• Processing Data Overview
• Importing Source Data
• Validating Dimension Mappings
• Fixing Validation Errors
• Intersection Check Reports
• Managing Data
• Loading Data to Target Applications
• Drilling Through from Target Applications

Setting Up Check Rules and Check Entities

• Check Rules and Reports Overview
• Creating Check Rule Groups and Check Rules
• Assigning Check Rules to Locations
• Verifying Check Rules
• Check Entities Overview
• Creating Check Entity Groups
• Verifying Consolidations

Processing Batches

• Batch Processing Overview
• Adding Batch Definitions
• Defining Batch Parameters
• Executing Batches
• Creating and Executing Open Batches
• Scheduling Batches
• Executing Batch Scripts

Setting up Security

• Data Management Security Overview
• Setting Up Data Management Security
• Defining Role, Report, and Batch Security
• Location Security
• Adding Groups for Location Security
• Assigning Users to Groups in Shared Services
• Provisioning Users in Shared Services

• Explain user tasks in Smart View
• Analyze data using ad hoc and Smart Forms after uploading the data into FCCS

• Explain default currency translations for a multi-currency application and methods applied
• Uploading the FX rates and understand the FX rates forms
• Validate the Transaltions Methods
• Upload Historical Rates or Amounts for Equity Translation
• Validate the Equity accounts Translation
• Update the Ownership of each Entity
• Describe the sequence of events in the consolidation process
• Diagnose data flow of the consolidation process and the role of Consolidation dimension 
• Diagnose the anatomy of converting reporting currencies as it relates to Entity Currency and Parent Currency
• Describe calculation status and what actions can change them

• Create the Journal Templates
• Work flow to process the Journals
• Upload bulk Journals

• Setup the intercompany accounts and Entities
• Upload data for the intercompany accounts
• Diagnose anatomy of the elimination process and the role of Intercompany dimension 
• Execute intercompany matching reports with options

• Set up Financial Consolidation and Close security
• Set up valid intersections for data entry and business rules
• Create data forms
• Manage the approval process

• Set up the close process
• Manage task types and templates
• Manage close schedules

• Set up and configure Cloud security
• Perform system maintenance
• Build EPM Cloud automation routines - Job Scheduler, EPM Automate

• Create data sets and dimension attributes

• Design reports using Reporting Web Studio
• Previewing Reports
• Setting Preferences, Card,Cluster & Infolet
• Printing Reports and Snapshots