1 About EPM Automate

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

Cloud EPM 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