If you’ve been considering a move to Oracle’s EPM Cloud, you’ve probably seen or heard something about this thing called “EPM Automate.” This utility allows Hyperion admins to complete tasks remotely as well as automate repeatable tasks in Oracle EPM cloud applications.
In this blog post, we’ll cover the repeatable tasks you can automate, prerequisites for running commands, and default file locations.
A huge reason for implementing an EPM tool is, obviously, automation. Getting bogged down by manual tasks and too many spreadsheets just doesn’t work for a growing business. But, after implementing these applications, tasks can cause Hyperion admins to become bogged down too. This is where EPM Automate comes in.
The following repeatable tasks can be automated:
For a complete list of automatable tasks, download the EPM Automate Guide.
First things first: you must be a Service Administrator to execute commands (sorry, Power Users). The Service Administrator executing these commands should also note:
For Oracle’s Planning and Budgeting Cloud Service (PBCS), you’ll need to pay attention to jobs. Many of the commands you’ll be using in PBCS will require jobs, which are actions — like importing or exporting data — that can be started immediately or scheduled later.
Within the jobs console, you need to create appropriate jobs to perform operations, such as:
Download the guide for a list of commands by application.
If you plan to use a command or a process native to an application — PBCS, EPBCS, ARCS, or FCCS — you must upload files to the default location.
To browse the files stored in the default location, use the Inbox/Outbox Explorer. Files that need to be processed using Data Management must be available in the inbox or a folder within the inbox. By default, files exported using Data Management are stored in the outbox, while Data Management report outputs are stored in the Data Management outbox/report folder.
If you’re reading this, chances are you’re an admin who’s new to the cloud. There are still numerous tedious tasks you must complete to maintain your cloud applications. To learn more about those tasks, read the blog post.