EPM

November 2025 Patch Update - LocalHost supported in External Web Service Connections again!

In the November EPM Planning patch update a new version of the Groovy engine, which has stricter validation rules, is being released. The Groovy Script Validator indicated that a rule I wrote about in a previous blog post needed updating so I thought I would add a post to show what needed to change and to provide an updated example. When I ran the validator the results showed that the date functions I had used were being deprecated and were not validating: Groovy Validator R

Image 1: Business rule containing Smart List Run Time Prompt This blog has been migrated from my old blog* Smart Lists are very powerful...

This blog has been migrated here from my older blog * Create a simple script to manage your migration process between environments. This...

Good to know tips for beginners using REST API via Groovy in EPM Planning

In EPM Reports, formulas can be used to perform simple calculations, such as a variance calculation. Formulas require references to rows...

*** September 2025 Update *** - Oracle have changed URL limits for the Connection set up so the localhost:9000 URL will no longer work to dynamically create your local connection. Now you will need to use the full URL in the format: https:// planning-domain .oraclecloud.com for example. Original Blog Each Oracle Planning Cloud environment has a Daily Maintenance window in which Oracle perform routine maintenance. During this automated process, the system will create a syst

Automate EPM Data Load Rules without the need to install any automation software on a server. Entirely within the cloud. Make life easier, by kicking of one or more data load rules from the click of a button, using a Business Rule, which can be added to a Task List or a Data Form in EPM Planning. Define periods for loading via prompts at run time, or utilise substitution variables. Business Rule for running integrations - with Run Time Prompts Below is a step by step guide on

By default, Data Management assumes that the currencies will be associated with the Entity or Location when loading any data into Oracle...

------------------------------------------------------------------------------------------------------------------------ *** Update...

Connect to multiple EPBCS environments via Smart View Shared Connections XML Switching environments, changing domains, logging in,...

This blog features instructions for retrieving and transforming a Smart List entry into a member name to be used within a calculation...