Provn
    How it worksBrowse jobsFor companiesBlogLog in

    © 2026 Provn Inc. All rights reserved.

    About•Blog•Terms of Service•Privacy Policy

    Made with love in Seattle

    Challenges/Collabera/General/Oracle EDM Cloud Consultant Skills Challenge

    Oracle EDM Cloud Consultant Skills Challenge

    Oracle EDM
    Oracle Cloud
    FCCS
    Data Migration
    Master Data
    Financial Services
    Hierarchy Management
    Stakeholder Communication
    Estimated Time:
    45 minutes
    Status:Not started

    What You'll Be Doing

    Oracle EDM Cloud Migration — Meridian Financial Group

    Engagement Overview

    You are an Oracle EDM Cloud Consultant engaged by a mid-size financial services firm (Meridian Financial Group) to lead their migration from on-premise Oracle EDM (Primous) to Oracle EDM Cloud.


    Background

    Meridian Financial Group is a diversified financial services company with operations across commercial banking, wealth management, and insurance. They have used on-premise Oracle EDM (Primous) for the past 8 years to manage their master data hierarchies — primarily the Chart of Accounts (CoA) hierarchy and the Entity/Legal Entity hierarchy. These hierarchies feed directly into Oracle FCCS (Financial Consolidation and Close Service) for their monthly and quarterly financial close process.


    Current State

    • On-premise Oracle EDM (Primous) manages two primary hierarchies:
      • Chart of Accounts — ~4,200 nodes across 8 segments
      • Entity — ~320 legal entities across 12 countries
    • EDM hierarchies are the single source of truth for FCCS — any change to a CoA node or entity mapping in EDM flows downstream to FCCS consolidation rules, intercompany eliminations, and regulatory reporting
    • The current Primous environment contains 6+ years of hierarchy versions (quarterly snapshots) — approximately 90 versioned hierarchy snapshots total
    • Three business teams interact with EDM daily:
      • Corporate Accounting (CoA changes)
      • Treasury (entity/legal entity changes)
      • Financial Planning (hierarchy views for PBCS budgeting)
    • The on-premise infrastructure is end-of-life — Meridian's Oracle license renewal requires cloud migration by Q1 of next fiscal year

    The Problem

    Meridian needs to migrate from on-premise Primous to Oracle EDM Cloud while maintaining uninterrupted financial close operations. Key constraints:

    • Migration window: 12 weeks
    • Fiscal year-end close begins: Week 14 — there is no room for slippage
    • The migration must preserve data accuracy, maintain governance workflows, and ensure FCCS continues to receive correct hierarchy data throughout the transition

    Your Role

    You have been brought in as the Oracle EDM Cloud Consultant to lead this migration end-to-end. Meridian's internal team has Oracle EPM experience but limited EDM Cloud-specific knowledge. They are relying on you for:

    • The technical migration plan
    • The EDM Cloud configuration design
    • Stakeholder coordination through go-live

    Constraints

    Honor these constraints in your deliverables. They reflect Meridian's real operating environment.


    FCCS Dependency

    Meridian's Chart of Accounts and Entity hierarchies feed directly into Oracle FCCS for financial consolidation. Any hierarchy change in EDM must be validated against FCCS mapping requirements before going live. You cannot treat EDM as a standalone system — every configuration and migration decision must account for downstream FCCS impact.


    Governance Workflow

    Meridian's data governance team requires all hierarchy changes to go through a formal approval workflow:

    Request → Review → Approve → Publish

    The migration cannot bypass existing governance processes. Your EDM Cloud solution must replicate or improve the current approval workflow — not eliminate it.


    12-Week Migration Window

    PhaseWeeksActivities
    Analysis & Design1–4Requirements gathering, current-state assessment, EDM Cloud design
    Migration Execution5–8Data migration, configuration build, integration setup
    Testing & Stabilization9–12UAT, parallel validation, go-live readiness
    Fiscal Year-End Close14+No buffer — migration must be complete

    There is no buffer. Your plan must be scoped to fit this window — if something cannot be completed in 12 weeks, explicitly state what gets deferred and why.


    Historical Versioning

    The Primous environment contains 90+ quarterly hierarchy snapshots spanning 6+ years. Migrating all versions to EDM Cloud is neither required nor practical. You must define:

    • What migrates vs. what gets archived
    • A rationale that accounts for both business continuity and regulatory audit requirements in a financial services context

    What You'll Accomplish

    Design an Oracle EDM Cloud configuration with production-grade governance controls for a financial services hierarchy

    Build a 12-week migration plan from Primous to EDM Cloud that maintains FCCS integration continuity

    Define a versioning and archival strategy for 90+ historical hierarchy snapshots under regulatory requirements

    Communicate migration impacts to technically diverse business stakeholders

    Demonstrate critical evaluation and iterative use of AI tools in an Oracle EDM context

    How Your Work Will Be Scored

    Oracle EDM Technical Execution — 35%Migration Planning & Execution — 25%Stakeholder Communication & Knowledge Transfer — 15%AI Fluency — 15%Resume & Background — 10%

    What to Submit

    No submission guidelines provided.

    On this page

    Top of Page
    What You'll Be Doing
    How It's Scored
    What to Submit