FDMEE Data Management for EPM Cloud (2 days)


System administrators and implementation consultants

Learning objectives

Learn the various approaches for loading source data into Oracle EPM Cloud applications using Data Integration (Data Management). Data Management is available with all Oracle EPM Cloud subscriptions and provides a comprehensive toolset for integrating source data with Cloud applications.

PLEASE NOTE: This training is designed for new EPM Cloud administrators who are not familiar with the ‘on-premises’ FDMEE solution.

Course description

Explore the look, feel and functionality of Data Management for the Oracle EPM Cloud. Find out how to load data and discover how to synchronise data seamlessly across various systems. This course explores the creation and management of mapping tables and examines the process of building import formats to capture source data in a variety of formats. We’ll investigate the available data load options, such as loading data to multiple periods, adding trial balance and journal data and scheduling import jobs, allowing them to be run automatically.

We’ll also look at how to enhance the standard workflow by building in complexity through the use of import format expressions, logic accounts and advanced mapping techniques. This course is ideal for Oracle EPM Cloud administrators who are looking to maximize the potential of their cloud environments.

Day summary

Day 1: Data Management Process Overview, System Settings, Source & Target Registration, Category & Period Mapping, Import Formats, Locations & Load Rules, Mapping Tables, Importing & Validating Source Files, Import Format Expressions

Day 2: Check Rule Groups, Simple & Complex Logic Accounts, Journals, Batches, Format Mask Mappings, Multi-Dimension Mapping, Multi-Period Loads, Source & Target Options

Detailed course agenda / Justification for your manager 

DMA Page 1 

CPE Sponsors

Course title: Data Integration (Data Management) for Oracle EPM Cloud (2 days)

Duration: 2 days

Audience: Implementation consultants, developers and technical system administrators

Pre-requisites: None

Delivery method: Classroom (group - live)

Advanced preparation: None

Recommended CPE credits: 14 credits - specialised knowledge 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: www.learningmarket.org

Oracle Data Management (FDMEE) for EPM Cloud (2 days)
Data Management Training Courses