Become a Certified FCCS Professional with Self-Paced Oracle Online Training

Page 1

SpiritSofts

Call / whatsapp +91 970 442 9989 / +91 789 304 0005

Mail to info@spiritsofts.com

Web: https://www.spiritsofts.com

Oracle FCCS Online Training: Affordable and Effective Learning

Unlock your potential with Oracle FCCS online training. Our courses are designed to provide a comprehensive and hands-on learning experience for financial consolidation and reporting using Oracle's cloud-based platform. With flexible scheduling and affordable pricing, our online training is accessible to anyone looking to advance their finance skills. Learn from industry experts and gain the knowledge needed to get certified in Oracle FCCS. Take the next step in your finance career and enroll now in our top-rated FCCS online training courses.

Financial Consolidation and Close Cloud Overview

Describe the financial consolidation and close processes

Describe Financial Consolidation and Close Cloud related components

Creating an FCCS Application

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

Explanation about the Essbase concepts

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

Consolidation Module - Dimensions

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

Data Management Module for Data Load

Product Orientation

o Data Management Overview

o Key Benefits and Features of Data Management

o Data Management Integration Process

o Processing Data Overview

o Accessing and Navigating in Data Management

Preparing Data Management Integrations

o Integration Setup Overview

o Setting Up the Application Root Folder

o Defining Profiles

o Setting Up Source Systems

o Registering Target Applications

Setting Up Import Formats for File Systems

o Import Formats Overview

o Creating Import Formats

o Defining Import Format Mappings

o Skipping Lines in Import Files

o Concatenating Fields

o Adding Import Expressions

Completing the Integration Setup

o Locations Overview

o Adding Locations

o Setting Location Details and Integration Options

o Periods and Categories Overview

o Defining Period Mappings

o Defining Category Mappings

o Point of View Overview

Setting Up Data Load Mappings

o Data Load Mappings Overview

o Defining Data Load Mappings

o Explicit Mappings

o Mapping Rules

o Processing Order

o Building Maps Externally

o Importing Mappings

o Sharing Mappings

Defining and Executing Data Load Rules

o Data Load Rules Overview

o Defining Data Load Rules for File-Based Data Loads

o Loading Data into Multiple Periods

o Running Data Rules and Checking Rule Status

o Viewing Imported Data

o Scheduling Data Load Rules

Processing Data in Data Load Workbench

o Processing Data Overview

o Importing Source Data

o Validating Dimension Mappings

o Fixing Validation Errors

o Intersection Check Reports

o Managing Data

o Loading Data to Target Applications

o Drilling Through from Target Applications

Setting Up Check Rules and Check Entities

o Check Rules and Reports Overview

o Creating Check Rule Groups and Check Rules

o Assigning Check Rules to Locations

o Verifying Check Rules

o Check Entities Overview

o Creating Check Entity Groups

o Verifying Consolidations

Processing Batches

o Batch Processing Overview

o Adding Batch Definitions

o Defining Batch Parameters

o Executing Batches

o Creating and Executing Open Batches

o Scheduling Batches

o Executing Batch Scripts

Setting up Security

o Data Management Security Overview

o Setting Up Data Management Security

o Defining Role, Report, and Batch Security

o Location Security

o Adding Groups for Location Security

o Assigning Users to Groups in Shared Services

o Provisioning Users in Shared Services

Using Smart View

Explain user tasks in Smart View

Analyze data using ad hoc and Smart Forms after uploading the data into FCCS

Consolidation Module - Consolidations and Translations

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

Managing Journals

Create the Journal Templates

Work flow to process the Journals

Upload bulk Journals

InterCompany - Eliminations

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

Consolidation Module - Building out a Financial Consolidation Application

Set up Financial Consolidation and Close security

Set up valid intersections for data entry and business rules

Create data forms

Manage the approval process

Financial Task Manager Module

Set up the close process

Manage task types and templates

Manage close schedules

Oracle EPM Cloud Foundation

Set up and configure Cloud security

Perform system maintenance

Build EPM Cloud automation routines - Job Scheduler, EPM Automate

Supplemental Data Module

Create data sets and dimension attributes

Enterprise reporting using FCCS

Design reports using Reporting Web Studio

Previewing Reports

Setting Preferences, Card,Cluster & Infolet

Printing Reports and Snapshots

Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.