Oracle EPM Cloud Groovy Function Library

Standard Function Reference

Click any function card to expand the full reference — parameters, example code, output, error handling, and release notes. Every function is production-ready and SaaS-compliant.

// "I didn't hack the EPM API. I just read the documentation nobody else bothered to read."

Groovy Function Cheat Sheet ✓ API Validated 25.11

All 40 functions at a glance — name, category, what it does, and when to use it.

// "If you know the system's inventory, you own it."

What Was Fixed — and Why

Every snippet in this library was audited against the Oracle Cloud EPM Groovy Scripting Reference (25.11). Below is the complete record of API mismatches corrected from earlier published versions.

Optimize, Benchmark & Stay 26.05-Ready

Three things every EPM Groovy practitioner needs in 2026: fast rules, accurate benchmarks, and a clean Validator report before the May 26.05 mandatory engine upgrade.

// ✗ Slower — dynamic
def getSubstitutionVariable(varName) { ... }

// ✓ Faster — static dispatch
String getSubstitutionVariable(String varName) { ... }

def benchmark(String label, Closure action) {
  long start = System.nanoTime()
  def result = action.call()
  long ms = (System.nanoTime() - start) / 1_000_000
  println("[BENCH] ${label}: ${ms} ms")
  return result
}

def warmBenchmark(String label,
                    Closure code,
                    int runs = 10) {
  // Discard first 3 — JVM warmup noise
  3.times { code() }
  long total = 0
  runs.times {
    long t = System.nanoTime()
    code()
    total += System.nanoTime() - t
  }
  println("[BENCH] ${label} avg (${runs}x): " +
    "${total / runs / 1_000_000} ms")
}