Skip to main content


Featured post

Clear target data in Oracle EPM - ERP integrations using a Data Exchange Clear Region

Recent posts

FAQs answered for the new Clone Environment Planning Cloud feature!

This is a very quick, no frills, 'what you need to know' blog about the latest new Planning Cloud feature: Clone Environment. This feature arrived in our Test environments in March 2021. The new tool is used to clone the entire Planning application between environments. Here is what I have discovered; not all of the below was clear to me from reading the Oracle Documentation. What is the source for cloning? You cannot select a Snapshot to use. Nor does the tool create a clone of the environment at the point of running the clone. It uses the Artifact Snapshot created from the latest Daily Maintenance. You can see the time that it was created on the Clone Environment tab before launching: I tried to rename the Artifact Snapshot and perform a Repeat Export, naming this Artifact Snapshot. The Clone Snapshot tool still links to the original & renamed Artifact Snapshot. The only way to update the source Snapshot in-between scheduled maintenance is to use the EPM Automate RunDaily

EPM Automate Migrating large Snapshots using: copysnapshotfrominstance

Create a simple script to manage your migration process between environments. This script will give you peace of mind that, no matter how large your Snapshots grow, you can effortlessly migrate them across environments. Key benefits: The migration of Snapshots can be scheduled , The command can handle large Snapshot sizes, Significantly faster than manual Download / Upload process, Less risk of storing sensitive Snapshots locally, Less storage space required locally. Points to note:          A separate command importsnapshot could be used to Import the Snapshot, if desired.         The Snapshot will be copied from the Migration area in the Source environment to the Target Environment The source password will need to be encrypted, whereas this is not a requirement for the target password Here are the building blocks for your script: 1.        Set Variables  I use the following variables in my script:  -   Location of epmautomate.bat f

Connecting to multiple Oracle Cloud Environments

Connect to multiple EPBCS environments via Smart View Shared Connections XML Switching environments, changing domains, logging in, logging out… Why not save valuable time by creating a Smart View environments short-cut? Here’s how! First, gather the following details for each environment that you would like to add to your drop-down list: 1. Environment URL (PBCS/EPBCS) :  Recently provisioned environments: https:// epm-exampleDoM .epm. exampleDC. Environments provisioned before 2020: (If unsure, check your web URL - does it start with planning or epm, match URL) https://planning- exampleDoM .pbcs. exampleDC                (where Domain name = exampleDoM and Data centre = exampleDC) 2. Chosen Shortcut Name : ie. Finance PBCS Production Tip 1: Other Oracle Provider Types I have only included the PBCS connection as an example here. See the Oracle Documentation for e

Transfer of Smart List Values to Members in Calculation Manager

  This blog features instructions for retrieving and transforming a Smart List entry (stored against a dimension member) into a member name to be used within a calculation script. This member name is in a valid format for use with cross dimensional operators. This functionality is particularly useful for Staff Costing models. It can be used to retrieve a grade or payscale point from a staff member and lookup its relevant base salary. I came across this trick when writing a calculation script that would pass through each employee in a Staff Cost model and retrieve their pay scale point – a Smart List value – and then transform this into a member in order to retrieve the corresponding base pay associated to that pay scale point. Pay scale points are members in my ‘Employee’ dimension. Upon configuration of the pay scale Smart List, I selected ‘Create from Members’. This is compulsory in order for the trick to work! I have attached this Smart List to a member in the Metric dim