1 About EPM Automate

EPM Automate enables users to remotely perform tasks within Oracle Enterprise Performance Management Cloud environments.

EPM Cloud Service Administrators can automate many repeatable tasks including the following:

• Import and export metadata, data, artifact and application snapshots, templates, and Data Management mappings

• Upload files into environments, list files, and delete files from the service

• Download snapshots, reports, and metadata and data files from the service

• Run business rules on data, and refresh the application

• Copy data from one database to another; typically, from a block storage database to an aggregate storage database or from a block storage database to another block storage database

• Run a Data Management batch rule

• Generate Data Management reports, provisioning report, and user audit report

• Import pre-mapped balance data, currency rates, pre-mapped transactions, balances data, and profiles into Account Reconciliation

• Copy profiles to a period to initiate the reconciliation process

• Deploy the calculation cube of an Profitability and Cost Management application

• Clear, copy, and delete Point of Views in Profitability and Cost Management applications

• Replay Oracle Smart View for Office load on an environment to enable performance testing under heavy load

• Import supplemental data from a file into Financial Consolidation and Close

You can create scripts that are capable of completing a wide array of tasks and automate their execution using a scheduler. For example, you can create a script to download the daily maintenance backup from environments to create local backups of your artifacts and data.

Tutorial: How to execute Planning commands using EPM Automate