PCMCS - Oracle Profitability and Cost Management Cloud Service

Profitability and Cost Management Cloud (PCMCS): Administrator (3 days)

About Oracle Profitability and Cost Management Cloud Service PCMCS

To enhance profitability, businesses need to accurately measure, allocate, and manage costs and revenue. Oracle Profitability and Cost Management Cloud (PCMCS) helps to manage the cost and revenue allocations that are necessary to calculate profitability by business segment, such as product, customer, region, division or branch.

Oracle's PCMCS enables the use cost decomposition, activity-based costing and the use of different scenarios to measure profitability for effective planning and decision support.

Audience for this training course

System Administrators, Financial Modellers and Financial Power Users

Learning objectives 

In this Oracle PCMCS training course you'll learn the concepts required to design and create Oracle Profitability and Cost Management Cloud Service (PCMCS) applications to identify and exploit profitability through the development of complex what-if scenarios and reporting.

Find out how to model structures, design calculation rule sets and rules, deploy applications and use PCMCS tools and Smart View to analyse and report on data.

Course description

The course focuses on the design, build, system administration and deployment of Oracle PCMCS (Profitability and Cost Management) applications. You’ll discover the tasks involved in preparing the structure and dimensionality of the allocation model, together with the strategies for the creation and deployment of applications.

Learn about the calculation rules and the rule sets required to effectively and efficiently model data within PCMCS. Discover how to execute the model and explore the use of manifold tools to view and analyse allocated data.This hands-on course provides everything you’ll need to design, build and maintain PCMCS models and applications.

Day summary

  1. Reviewing the models, understanding allocations, dimensions, attributes, data storage, hierarchy types, consolidation properties, aggregation operators, creating applications, Smart View data entry, loading data with Data Management (FDMEE).
  2. Creating rule sets, creating and executing rules, rule types, rule context, rule balancing, calculation options, advanced allocations, iterative execution, custom calculations, model view templates, analysis views, scatter analyses, profit curves, dashboards,
  3. Trace allocations, queries and KPIs, accessing and running Financial Reports, model validation, system reports, security and data grants, application backups, EPM Automate and an introduction to the REST APIs for PCMCS.

Major Topics

Introduction to PCMCS

  • Reviewing the models
  • Tracking profitability
  • Introducing dimensions
  • Understanding allocations
  • PCMCS data flows
  • The underlying database
  • Caclulation management
  • Data analysis
  • Reporting
  • Cloud services architecture

PCMCS Dimensions

  • Understanding dimensions and members
  • Application requirements
  • Balance and rule dimensions
  • Point of view dimensions
  • Business dimensions
  • Attribute dimensions
  • Data storage properties
  • Hierarchy types
  • Consolidation properties
  • Aggregation operators
  • Other member properties
  • Creating an application
  • Creating Points of View


  • Allocation fundamentals
  • Rules express editing and rules outline
  • Allocations vs custom calculations
  • Assembling allocations
  • Creating an allocation
  • Parallel, iterative and serial execution

Smart View Data Entry

  • Setup for Smart View Data Entry
  • Creating Data Entry Templates
  • Connecting to Smart View
  • Smart View Options
  • Methods of Entering or Loading Data

Data Management (FDMEE)

  • Overview and Learning Objectives
  • Introducing Data Management (FDMEE)
  • Loading Data
  • Understanding Data Management Setup
  • Source and Target Registration
  • Category and Period Maps
  • Import Formats
  • Locations
  • Data Load Rules
  • Mappings
  • Data Management Setup 

Rule Sets and Rules

  • Understanding Allocation Rules
  • Rules vs Rule Sets
  • Rule Types
  • Rule Context
  • Rule Set Calculation Options
  • Allocating Rent and Utilities
  • Executing Rules
  • Calculating Rule Sets and Reviewing the Results

Further Allocations

  • Copy Data Between Points of View
  • Adding Detailed Allocations
  • Allocating Cost of Goods to Products
  • Allocating Operating Expenses to Activities

Iterations and Custom Calculations 

  • Iterative Execution
  • Calculate Activity Allocations with Iterative Execution
  • Custom Calculation Rules
  • Using Calculations for Different Points of View
  • Copying Rule Sets and Rules

Data Analysis 

  • Understanding Model View Templates
  • Creating an Analysis View
  • Create Scatter Analyses and Profit Curves
  • Visual Representation Using Trace Allocations
  • Queries and KPIs

Financial Reports

  • Introducing Financial Reporting
  • Accessing and Running Reports
  • Creating Financial Reports

System Maintenance

  • Model Validation
  • System Reports
  • Security and Data Grants
  • Application Migration
  • Create an Application Backup
  • Restoring an Application Backup
  • Cloud Environment Update Cycle

EPM Automate

  • Overview and Learning Objectives
  • Introducing EPM Automate
  • Installation of EPM Automate
  • Connecting to EPM Automate and Getting Help

Introducing the REST APIs

  • Introducing Representational State Transfer
  • REST URLs and Method
  • Installing a REST Client
  • GET Requests
  • Retrieving Application Details via REST
  • POST Requests
  • Executing Jobs via REST Requests


Detailed course agenda / Justification for your manager

PCA Page 1 Page 1 

CPE Sponsors

Course title: PCMCS: Administrator

Duration: 2 days

Audience: System Administrators, Financial Modellers and Financial Power Users

Pre-requisites: An understanding of Essbase databases (particularly aggregate storage models) is useful, as is a working knowledge of Smart View

Delivery method: Classroom (group - live)

Advanced preparation: None

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

Oracle Profitability and Cost Management Cloud Service - PCMCS Training Course
PCMCS: Administrator (3 days)