Data Integration (Data Management) for EPM Cloud (2 days)
System administrators and implementation consultants
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.
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 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
Course title: Data Integration (Data Management) for Oracle EPM Cloud (2 days)
Duration: 2 days
Audience: Implementation consultants, developers and technical system administrators
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