The Planning Quest › Capability Framework
📖 I–III ⚔ IV–V 👑 VI–IX 📘 Gr.I ⚡ Gr.II ⚙ Kernel 🔬 Labs 🏆 Engagement 🆕 New
EPBCS Practitioner Levels · The Planning Quest

Where Do You Stand?

Four levels. Honest criteria. A clear map of what separates a junior configurator from a senior architect — and exactly what this platform gives you at each stage.

Most EPBCS training tells you what the system can do. It does not tell you what you need to be able to do — under pressure, in a live project, when the CFO is waiting and the go-live is in three days.

This framework is honest. It reflects what distinguishes practitioners at each level on real Oracle EPM implementations — not what passes an Oracle certification exam. Levels are defined by judgment and delivery capacity, not by how many features you can describe.

The Planning Quest takes you from zero to solid Level 2. The Essbase Kernel and Groovy chapters push toward Level 3. The Engagement tests where you actually are. Use this framework to know what to focus on next.

Level 1
Implementer
0 – 18 months
→
Level 2
Practitioner
1 – 3 years
→
Level 3
Senior Practitioner
3 – 6 years
→
Level 4
Architect
6+ years
🌱
Level 1 · 0–18 Months
Implementer

You can build a functional EPBCS application under supervision. You understand what the system does and can configure what has been designed by someone else. You are reliable on known tasks but need direction on unknowns.

Quest Coverage
Parts I–IX
Full foundation
What a Level 1 Practitioner Can Do
Application Setup
Creates a Planning application with correct settings. Understands why monthly granularity and fiscal year start are irreversible decisions before creation.
Dimension Design
Builds the 7 core dimensions. Configures hierarchy structures, consolidation operators, and Smart Lists. Understands the difference between stored and dynamic calc members.
Forms
Builds input forms and composite dashboards in Forms 2.0. Configures suppression, page selectors, and action menus. Understands that Forms 2.0 is stateless.
Data Integration
Creates an Import Format, dimension maps, and a Load Rule. Runs a data load manually. Understands the difference between Replace and Accumulate load modes.
Groovy Basics
Can read and modify an existing Groovy rule. Understands the three execution hooks. Can use getCell() and setCell(). Knows why BigDecimal matters for financial values.
Security
Creates users and assigns Application Roles and Granular Roles. Understands the four-layer security model. Can configure data access via security filters.
Approvals
Configures a Planning Unit Hierarchy. Understands the approval states lifecycle. Can promote, approve, and reject via the UI. Knows how to unblock a stuck entity.
Reporting
Builds basic reports in Oracle Reports. Creates infolets and conditional formatting rules. Understands the difference between Oracle Reports and Financial Reporting Studio.
✓ Can deliver independently
Standard form and dashboard builds
DI load rule configuration from documented specs
Security group and role assignments
Approval hierarchy configuration
Simple business rules from a template
EPM Automate basic commands and scheduling
○ Still needs guidance on
Dense/sparse design decisions for a new cube
Diagnosing production performance issues
Writing complex Groovy from scratch safely
Block creation strategy for a new fiscal year
DI reconciliation control design
ASO cube design and BSO/ASO hybrid architecture
The Level 1 Test — Can you answer these without looking?
01What happens if you enable quarterly time periods at application creation and later need monthly? What is the recovery path?
02A planner reports that a form is showing all zero rows including empty ones. What Form 2.0 setting do you check first?
03What is the difference between Replace and Accumulate load modes in Data Integration — and when would using the wrong one cause a production problem?
04An entity is stuck Under Review 24 hours before budget cycle closes. The reviewer is on leave with no delegate. What are your options?
05A Groovy rule using setCell() is running correctly in test but timing out in production. What is the first thing you investigate?
→
Transition to Level 2 — What it actually takes
The jump from Level 1 to Level 2 is not more configuration experience. It is the ability to design, not just build. A Level 2 practitioner can look at a blank requirement and make defensible architectural choices — dimension design, Groovy engine selection, block creation strategy, Forms 2.0 composite architecture. That judgment comes from understanding why things work, not just that they work. The Essbase Kernel and Groovy Chapters I & II are the most direct path to this shift.
Quest Modules That Build Level 1All modules below are fully covered in the Quest
Parts I–III
Application creation, dimensions, hierarchies, Smart Lists, Data Integration architecture and load modes, substitution variables
Core
Part IV
Forms 2.0 design, rolling forecast, action menus, composite dashboard architecture, Apply Context
Core
Part V
Groovy basics, getCell/setCell, beforeSave/afterSave hooks, simple allocation and validation rules
Core
Parts VI–IX
Security model, valid intersections, approval workflow, dashboards, FRS vs Oracle Reports, EPM Automate CLI
Core
Enterprise Labs 1–2
Annual budget build, rolling forecast transition — step-by-step with production code and verification
Core
⚔
Level 2 · 1–3 Years
Practitioner

You can design and build independently. You make defensible architectural decisions and explain your reasoning. You write production-safe Groovy. You understand block logic well enough to avoid disasters. You are the person a client trusts to work unsupervised.

Quest Coverage
Parts I–IX
+ Groovy I & II
+ Kernel
Solid Level 2
What a Level 2 Practitioner Can Do
Block Architecture
Calculates block size for a given dimension profile. Makes dense/sparse assignment with written rationale. Understands the Empty Space problem and chooses the correct block creation weapon for each scenario.
Groovy Production Code
Writes Groovy rules from scratch with explicit typing, BigDecimal arithmetic, null-safe navigation, and the 4-layer error wrapper. Uses DataGridBuilder for reads and setDataCellValues() for batch writes.
Performance Diagnosis
Can diagnose a slow Groovy rule in under an hour. Knows the 9 Hourglass levers ranked by impact. Understands the difference between round-trip cost and calculation cost. Can quantify the improvement.
Integration Design
Designs a DI integration from a source system spec. Builds field mappings, dimension maps, and exception handling. Implements a reconciliation control account with materiality threshold and alert mechanism.
Forms 2.0 Architecture
Designs composite dashboards within the 12-component limit. Configures Apply Context master/detail relationships. Understands the stateless architecture and the RTP silent failure pattern.
Release Awareness
Tracks monthly EPM releases and their practitioner impact. Can identify when a client's issue is a known release change. Managed the Forms 1.0 → 2.0 transition and the DI Job Scheduler migration.
Batch Automation
Designs and maintains a nightly EPM Automate batch. Sequences operations correctly. Implements error handling, abort-on-failure, and Finance Admin alerting. Uses Platform Job Scheduler.
Stakeholder Communication
Can explain block explosion risk to a CFO without jargon. Can justify an architectural decision to a skeptical client. Can translate a Finance BP requirement into a specific technical design.
✓ Can deliver independently
Full implementation from design through UAT
Dense/sparse design with documented rationale
Production Groovy automation suite
SAP/ERP to EPBCS integration with reconciliation
Nightly batch architecture and EPM Automate scripts
CFO Dashboard with Forms 2.0 composite design
○ Still developing
ASO/BSO hybrid architecture design
Leading a technical design review with senior client stakeholders
Multi-implementation pattern recognition
Workforce Planning module architecture
Mentoring and technical quality review of junior staff
Client-side ownership and vendor management
The Level 2 Test — Five questions, no reference material
01Vision Corp has 600 Account members and 25 Period members. Calculate the block size, state whether it is in range, and explain what happens if the CFO requests 200 additional accounts for a new product segment.
02A Groovy allocation rule runs 38 minutes in production. It calls getCell() 12 times and setCell() 12 times inside a loop. Without touching the business logic, reduce it to under 2 minutes. Name every lever you applied.
03The nightly SAP actuals load completed successfully but the Finance Controller's P&L shows revenue 4% below what SAP reports. Walk through your complete diagnostic — in the order you would actually run it at 6am.
04Camille wants her rolling 12-month forecast to advance automatically on the first of each month. Describe the complete mechanism — the substitution variables, the EPM Automate commands, and what a planner sees if the advance hasn't run yet.
05The CFO Dashboard has 8 grids and 4 charts. When the entity changes in Grid 1, only Grid 1 updates. The other 11 components stay on the previous entity. What is the cause and exactly how do you fix it?
→
Transition to Level 3 — The hardest jump
Level 2 to Level 3 is the steepest transition in the Oracle EPM career path. It is not primarily about more technical knowledge — it is about pattern recognition across implementations. A Level 3 practitioner has seen enough to know what will break before it breaks. They understand ASO/BSO hybrid design. They lead technical design reviews. They mentor. The technical gap is ASO — every senior practitioner must understand hybrid architecture. The behavioural gap is leadership under pressure.
Quest Modules That Build Level 2All available now in the Quest
Groovy Chapter I
Explicit typing, BigDecimal, null safety, guard chains, the 4-layer error wrapper, the universal 10-line skeleton
Essential
Groovy Chapter II
DataGridBuilder, setDataCellValues(), the Hourglass Principle, 9 performance levers, REST API integration, 24 interview questions
Essential
NODE s — Essbase Kernel
Block anatomy, block size formula, the Empty Space problem, DATACOPY vs @CREATEBLOCK vs SET CREATENONMISSINGBLK, FIX scope discipline
Essential
Enterprise Labs 3–5
Groovy automation suite, CFO Board Pack automation, ERP/SAP integration with reconciliation control and exception reporting
Essential
What's New 25.06–26.01
Forms 1.0 end of support, DI scheduler migration, IP allowlist removal, Java 17 requirement, Groovy engine changes
Essential
The Engagement
Live project simulation — 5 stakeholder challenges, 13 SDLC decisions, AI-evaluated Practitioner Signal
Tests Level 2→3
🔭
Level 3 · 3–6 Years
Senior Practitioner

You architect full implementations from discovery through go-live. You understand ASO/BSO hybrid design. You lead technical design reviews and push back on client decisions that will create production problems. You mentor junior practitioners. You diagnose production issues under pressure without external help.

Quest Coverage
Full Quest
+ ASO Module
Coming next
What a Level 3 Practitioner Can Do
Hybrid Architecture
Designs BSO/ASO hybrid implementations. Knows when a reporting cube is mandatory, how to design the ASO dimension order, how data flows from BSO via Smart Push, and where currency translation should live.
Design Review Leadership
Runs technical design reviews. Identifies risks in a proposed design before build begins. Can veto a decision that will cause a production problem — and explain why in terms the CFO understands.
Cross-Implementation Patterns
Recognises that a client's current problem is a pattern seen before. Has a mental library of what breaks and when. Can distinguish a configuration issue from an architectural one without running a diagnostic.
Workforce Planning
Architects OEP_WFP integrations. Understands the employee cube design, monthly salary calculations, the HCP_Element hierarchy, and how headcount cascades into compensation across entity and period dimensions.
Mentorship
Identifies when a junior practitioner's design will cause a production problem and can teach them why — without redoing the work for them. Writes design constraints documents that juniors can follow independently.
Release Strategy
Advises clients on Oracle EPM release upgrade risk. Can assess a release's impact on an existing implementation and recommend a testing strategy. Has a process for monitoring Customer Connect for early warnings.
Estimation Accuracy
Produces implementation estimates that are accurate within 15%. Knows which tasks have hidden complexity and buffers accordingly. Can identify scope creep early and communicate it before it becomes a delivery risk.
Production Crisis Response
When a batch fails at 3am and Finance needs numbers by 7am, this practitioner leads the recovery — diagnosis, decision-making, communication — without escalating to someone more senior.
✓ Delivers independently
Complete enterprise implementation from RFP to go-live
BSO/ASO hybrid architecture with currency translation
Workforce Planning module with HCM integration
Technical design review and sign-off
Production incident diagnosis and recovery
Junior practitioner mentoring and quality review
○ Still developing
Platform-level architectural standards across a portfolio
Client EPM strategy and roadmap advisory
Evaluating Oracle product direction and advising on investment
Bid leadership and technical proposal writing
Building and managing a practice-wide competency standard
The Level 3 Test — These require experience, not just knowledge
01Vision Corp's CFO wants to add a consolidated P&L report showing all 12 entities with currency translation in a single view. The BSO cube has a multi-currency setup. Should this report run against BSO or ASO — and what would you need to build to make ASO the right choice?
02A junior architect has proposed marking Entity as dense to reduce block count. The cube has 12 entity members. Explain to them — in writing, as if it were a design review comment — why this is wrong and what the correct assignment is.
03At 3:15am the nightly batch alerts that the master calc rule timed out. Finance needs actuals numbers by 7am. Walk through your complete response — diagnosis, decision points, what you communicate to the Finance Controller and at what time.
04A client is on EPM 25.10 and asks whether they should upgrade to 26.01 or wait for 26.02. They have a custom Groovy automation suite, an SAP DI integration, and Forms 2.0. What is your recommendation and what specifically do you test before advising go-ahead?
05You are reviewing a junior practitioner's Groovy design. They have written a headcount cascade rule that calls getCell() 50 times in a loop across 12 entities and 12 months. It runs in 22 minutes. Rewrite the critical section and explain to them, in teaching terms, the principle that makes your version faster.
→
Transition to Level 4 — What cannot be taught in a course
Level 4 Architect is not a technical threshold. It is a strategic and leadership threshold. The technical knowledge of a Level 3 and Level 4 practitioner is similar — what differs is the scope and nature of their judgment. A Level 4 Architect thinks about the Oracle EPM platform as a whole, across multiple client environments, over years. They have seen enough implementations succeed and fail to advise clients on whether to invest in EPBCS at all — and what conditions make that investment succeed. This level comes from time and variety of experience, not from additional courses.
Quest Modules That Build Toward Level 3Some content coming — marked below
Full Quest Curriculum
Complete foundation — all Parts I–IX, Groovy I & II, Essbase Kernel, Labs, What's New, The Engagement
Available Now
Workforce Planning Module
OEP_WFP architecture, employee cube, salary calculations, HCM integration, Groovy patterns for headcount cascade
Available Now
ASO Module
BSO vs ASO decision framework, ASO dimension design, hybrid architecture, Smart Push, currency translation in ASO
Coming Next
Architecture Decision Tree
Interactive decision tool — BSO vs ASO, Groovy vs calc script, Valid Intersections vs beforeSave, and more
Coming Soon
👑
Level 4 · 6+ Years
Architect

You set technical direction across multiple implementations. You advise clients on platform strategy, not just configuration. You evaluate Oracle's product roadmap and advise on investment risk. You define competency standards for other practitioners. Your judgment at the start of a project determines its outcome.

Quest Role
Reference &
Currency
Stay sharp
What Distinguishes a Level 4 Architect
Platform Strategy
Advises clients on whether EPBCS is the right investment for their planning maturity level. Defines the implementation sequencing across years — what to build first, what to defer, and why the order matters.
Portfolio Governance
Sets architectural standards that apply across multiple client environments. Identifies when a pattern that worked in one implementation will fail in another. Defines the conditions under which exceptions are permitted.
Oracle Relationship
Engages with Oracle product management directly. Raises client issues as product gaps rather than support tickets. Participates in beta programmes. Advises clients on Customer Connect engagement and how to influence Oracle's roadmap.
Risk Advisory
When a client makes a technical decision that will fail in production, this practitioner stops the project — not just flags the risk. They have the standing and the track record to override a client's preference when the cost of proceeding is higher than the cost of stopping.
Practice Building
Defines hiring criteria, career progression, and technical competency standards for an EPBCS practice. Identifies the difference between a practitioner who can be developed and one who cannot. Builds the training infrastructure that accelerates junior staff.
Commercial Judgment
Understands what an implementation costs versus what the client has budgeted — and can design an approach that delivers core value within constraint without compromising architectural integrity. Can scope a phased delivery that is both commercially viable and technically sound.
The Level 4 Questions — No course answers these
01A mid-market CFO with $800M revenue and 8 entities asks whether they should implement Oracle EPBCS or a lighter planning tool. Their current process is entirely in Excel. What questions do you ask before making a recommendation — and what would make you advise against EPBCS?
02You are reviewing a proposal from a competitor for a $1.4M EPBCS implementation. The timeline is 6 months, the team is 3 consultants, and the scope includes Workforce Planning and a full ASO reporting cube. What specific risks in this proposal would you raise with the client?
03Oracle announces that a feature your client's implementation depends on will be deprecated in 3 releases. The client has 18 months of budget runway. How do you structure the migration, what do you communicate to the CFO, and how do you sequence the work to minimise business disruption?
04A junior architect on your team has built a technically correct implementation that the Finance team refuses to adopt. User adoption is at 15% six months after go-live. The architecture is not the problem. What is your diagnosis and what do you do next?
How The Quest Serves Level 4 PractitionersCurrency and reference
What's New Tracker
Monthly release intelligence — Forms 1.0 deprecation, Groovy engine changes, Java requirements, IP allowlist removal. Stay current without reading Oracle release notes manually.
Monthly Reference
The Engagement
Use as a benchmark and screening tool. Have a candidate complete The Engagement before an interview. Their decisions and reasoning tell you more than a CV.
Screening Tool
Groovy Chapter II
The 9 Hourglass levers, DataGridBuilder patterns, and the 24-question interview toolkit are useful reference even for experienced practitioners building new rules.
Reference
Interview Prep
59 questions with model answers — useful for calibrating what Level 1 and Level 2 candidates should know before joining your project.
Hiring Reference
Know Your Level. Build the Next One.

The Planning Quest is free, complete, and built by practitioners for practitioners.

⚔ Begin the Quest 🏆 Test Your Level ⚙ Essbase Kernel 🆕 Stay Current