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 Profitability and Cost Management applications
  • Clear, copy, and delete Point of Views in Enterprise Profitability and Cost Management and Profitability and Cost Management applications
  • Replay Oracle Smart View for Office or REST API 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.

Video icon Tutorial: How to execute Planning commands using EPM Automate