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.