1 About the EPM Automate Utility

The EPM Automate Utility enables Service Administrators to remotely perform tasks within Oracle Enterprise Performance Management Cloud instances. EPM Cloud includes Oracle Planning and Budgeting Cloud, Oracle Enterprise Planning and Budgeting Cloud, Oracle Financial Consolidation and Close Cloud, Oracle Profitability and Cost Management Cloud, Oracle Account Reconciliation Cloud, Oracle Tax Reporting Cloud, and Oracle Enterprise Performance Reporting Cloud.

Note:

This guide does not apply to Oracle Enterprise Performance Reporting Cloud.

EPM Automate Utility enables Service Administrators to automate many repeatable tasks including the following:

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

  • Upload files into service instances, 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 Oracle Account Reconciliation Cloud

  • Copy profiles to a period to initiate the reconciliation process

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

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

  • Replay Oracle Smart View for Office load on a service instance to enable performance testing under heavy load

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

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 service instances to create local backups of your artifacts and data.

Video icon Video overview of the EPM Automate Utility

Video icon Tutorial: How to execute Oracle Planning and Budgeting Cloud commands using EPM Automate Utility