Topic
Planning
Planning REST API
A one-page reference listing all Oracle EPM Cloud Planning REST API resources documented as of version 25.02, including jobs, members, planning units and connections.
"GREPort" Script Is Depreca-Dead!
Oracle's 23.05 update added a native DataExporter class that covers what the custom Greport Groovy script used to do. Was the custom code worth it? It depends.
Thoughts on Why Groovy Can Be a Game Changer for Your Oracle EPM Apps
A real migration story: how Groovy replaced a fragile VB script workaround, and the two support tickets it took to make DLR error handling actually work.
Playground #1 with Pipeline
A first hands-on exploration of Oracle EPM Cloud's Pipeline feature (Data Exchange), using the File Operations job type to copy and delete files between folders.
Data Integration Implementation Methods with Flat Files
A step-by-step walkthrough to load a flat file into Oracle EPM Cloud Planning via Data Integration: registering an application, mappings, import format, location, and the Data Load Rule.
My 10 Groovy Commandments — Sharing My 10 Personal Guidelines to Succeed on Groovy Scripts
Ten personal guidelines for writing better Groovy rules in Oracle EPM Cloud: from knowing when to avoid Groovy altogether, to commenting, indenting, and staying minimalist.
Boost Your Productivity Around the Analysis of Calculation Manager Log
Calculation Manager's Log Messages tab exports to CSV, but the format resists filtering in Excel. A personal VBA macro utility to load, filter, and analyze it faster.
Build Your Own "Greport" Script
A Groovy neologism (Groovy + Report): how to export Oracle EPM Cloud data to CSV using member aliases instead of raw codes, with a clean fallback when no alias exists.
Conditional Data Export with Groovy
A Groovy pattern that lets key users flag rows in a data form as "Complete", then triggers a conditional CSV export of only the flagged data.
Work Around the 20k Characters Limit When Debugging Your Groovy Rule
The Oracle EPM Cloud job console truncates output around 20,000 characters. Here's how to route println debug output to a CSV file instead, to keep debugging past that limit.
Improve the Quality of Your Application & UX by Declaring Whitelisted Data Forms in a Groovy Rule
A Groovy pattern to restrict a rule's execution to a whitelist of data forms, with clear, explicit error messages when it's triggered from the wrong place.
"Member Name and Alias" Option Now Available in SmartView 22.100
Since the 22.08 update, Oracle EPM Cloud lets you display both member name and alias in separate columns in an Excel Ad Hoc grid — no more manual alias-table workarounds.