Oracle Smart View for Financial Consolidation and Close Cloud (FCCS) Training Course


1 day (7 CPE credits)


Key user 

Course Summary

Learn to view, import, manipulate, distribute and share data in Microsoft Office from Oracle data sources. Gain experience writing functions and developing ad-hoc queries and discover how to use Smart View to query, analyze and report on data from Oracle Financial Consolidation and Close Cloud.

How Can I Take this Course? 

You can search for scheduled course dates for your time zone or request a private class for your team:


Learning Objectives

By the end of this course learners will be able to:

  • Explore the Smart View Panel to distinguish between the different connection methods to the host application
  • Appraise the use of Ad Hoc reporting to understand how the data can be explored
  • Contrast the use of Smart View functions with free-form ad hoc reporting to learn how to build data form-like reports
  • Analyse the use of Sets and Set Filters when building Smart Queries
  • Practice the use of Data Forms, opened within Smart View, from Financial Consolidation and Close Cloud (FCCS)
  • Investigate the use of Smart View to open reports with Word and PowerPoint

Course Description

Using Oracle Smart View for Office, you can view, import, manipulate, distribute, and share data from various data sources using Microsoft Excel, Word, Outlook, and PowerPoint. Learn to set up the Smart View connection manager, member selection and using data forms for entering, calculating and processing data.

Analyse data using ad-hoc features such as pivot, drill-down, keep only and remove only. Find out more about using data forms and task lists from within Smart View and how to integrate queries with Microsoft Office products. Gain experience in writing functions to read data and retrieve dimension labels and descriptions.

Explore the ribbons and learn how to set user variables, run business rules, check the job console and examine approvals within Oracle's Financial Conslidation and Close Cloud. 

Scheduled Course Dates

There are currently no scheduled courses. Please use the link below to request a private closed class for your team.

private horizontal

NASBA CPERegistry logo blue transparent

Course title: Oracle Smart View: Key User for Financial Consolidation and Close Cloud

Duration: 1 day

Audience: Key user

Pre-requisites: None

Delivery method: Group Live and Group Internet-Based

Advanced preparation: None

Recommended CPE credits: 7 credits - computer software and applications

Programme level: Intermediate

Keyteach is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. Registration ID No 115820. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Any complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:

Connect with us

3 Station View
Rhino Court Business Park, Hazel Grove
Stockport, Cheshire, United Kingdom, SK7 5ER

  • USA +1 855 563 6723

  • UK +44 161 408 7722


Enter your email and we'll send you more information

© Copyright Keyteach Ltd 2023


UK +44 161 408 7722
USA +1 855 563 6723