Posts Tagged ‘EPMAUTOMATE’

In Oracle Cloud Infrastructure (OCI) / Gen 2 architecture, OAuth 2 access tokens are used to issue REST APIs on EPM Cloud to fulfill the requirement of avoiding the use of passwords in the environment. After the REST client has been registered the Refresh token is obtained using the Identity Cloud Service URL (IDCS URL), […]

Automation is a critical aspect of any mature technological platform. Oracle’s recent updates to their EPM Cloud offerings include several new and exciting automation capabilities. Continue to read below for explanation on several of the noteworthy enhancements.   New and Improved EPM Automate Commands cloneEnvironment – Provides ability to clone the environment.  The UsersAndPreDefinedRoles optional […]

Oracle’s support for composite forms will be stopped from May 2021 according to oracle’s update for future.  There are dashboard features that you can take advantage of to convert your composite forms sooner than later. And also if you are executing rulesets using Automate command “runBusinessRule” – you may want to explore “runRuleset” command as […]

There are a few things I would like to add to clarify the usage of the CopySnapshotFromInstance command.  As the documented definition goes, it mentions as a current snapshot in one place but an existing snapshot in another. I would like to confirm that it works on both current and existing snapshots.   CopySnapshotFromInstance is […]

Using substitution variables to store folder directories and then referencing the variables in calc scripts/business rules has long been a best practice in the world of on-prem applications. For example, using a variable to store the path to a shared folder for a dataexport command. DATAEXPORT “File” “|” “&ExportServer/Sample.TXT” “#mi”; But cloud applications do not […]

Oracle continues to update EPM Automate on a regular basis. Today, we’re going to take a look at what some of recent updates have to offer Oracle Enterprise Performance Management Cloud customers.   What is EPM Automate? Before we touch on the latest enhancements, let’s explain EPM Automate’s purpose. EPM Automate is a command line […]

About EPM Automate 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 […]

One of the things that organizations tend to want or need during and after an implementation are application refreshes. In this blog post, I have two environments, PROD (Source) and TEST (Target), which I have developed a script to facilitate end users to refresh TEST environment. This script should be run where EPMAUTOMATE was installed […]

Introduction EPM Automate plays a vital role in automating many admin and user tasks in Oracle Hyperion Cloud. This blog post demonstrates how EPM Automate can help in troubleshooting the issues during support phase. Basically, this method is useful when we have more than one instance like Development and a SIT/UAT/Prod instance. The following explains […]

In one of my previous blog posts, the EPMAUTOMATE encrypt command was used to encrypt the administrator’s password on a batch script. Here, I describe the process for how to encrypt the password when used on a batch file. Before continuing, ensure the EPMAUTOMATE has been installed on the computer from which you are running […]

Amazon Web Services’ (AWS) low-cost S3 cloud storage provides a cost-efficient solution to archive snapshot files extracted from Oracle Planning and Budgeting Cloud Service (PBCS). In the following paragraphs, I will use the AWS Command Line interface (CLI) to upload to the Amazon S3 bucket to archive backup files pulled down from a PBCS instance. […]

Oracle Backup Policy “Oracle Planning and Budgeting Cloud creates the snapshot by backing up artifacts of all service components and Essbase data present in your service instance during the maintenance window. Because Oracle stores only the snapshots created in the most recent maintenance window, the artifacts and data available for restoration depend on their state […]