1 About the EPM Automate Utility

The EPM Automate Utility enables Service Administrators to remotely perform tasks within environments of these Oracle Enterprise Performance Management Cloud service:

  • Oracle Planning and Budgeting Cloud

  • Oracle Enterprise Planning and Budgeting Cloud

  • Oracle Financial Consolidation and Close Cloud

  • Oracle Tax Reporting Cloud

  • Oracle Profitability and Cost Management Cloud

  • Oracle Account Reconciliation Cloud

  • Oracle Enterprise Data Management 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 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 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 an environment 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 environments 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