KScope16 and FDMEE: Everything You Need to Know

KScope16 BadgeKScope, ODTUG’s annual conference for Oracle Developers, was held just a couple of weeks ago.  And Oracle product managers were out en masse to reveal new offerings, application features, and product roadmaps.

The Oracle mantra was pretty simple: cloud, cloud, cloud, and more cloud. In fact, if you drank a shot every time you heard the word “cloud” at KScope16, you would have been in a drunken stupor 5 minutes into Sunday’s EPM Symposium. Really, though, this is no surprise. Cloud services was the centerpiece of Larry Ellison’s Oracle OpenWorld 2015 keynote address.

So, if you’re a Hyperion customer or implementation specialist using FDMEE what does all of this cloud rhetoric mean for you?  Here’s what you need to know.

FDMEE and Hybrid Support

Oracle mothership doesn’t see companies taking all of their EPM applications to the cloud right away. In fact, Oracle expects most companies will go for a hybrid approach – a mix of cloud-based applications and on-premises or hosted applications – for the foreseeable future.  In a hybrid world, companies need a simple, efficient solution to collect, transform and load data to all of their EPM applications.  This is where FDMEE comes into play.

FDMEE Hybrid Support
As of Release, on-premises FDMEE can integrate with on-premises and cloud-based EPM applications.  So, now you can use on-prem FDMEE to load your actuals data to Hyperion Financial Management (HFM) and to load your budgeting and forecast data to Oracle Planning and Budgeting Cloud Service (PBCS).  Yeah, this is kind of a big deal. It’s so significant that we re-worked our Peloton FDMEE Hands-on Training for this year’s KScope to highlight cloud integration.
So you might be wondering: Why would we want to use on-premises FDMEE to integrate data with our cloud apps anyway?  Here are 3 good reasons.

  • Direct Integration with ERP Systems – On-premises FDMEE can connect directly to ERP systems.  FDMEE for Cloud (the version that comes with PBCS) cannot.
  • Data Synchronization – With on-premises FDMEE you can easily synchronize data between your cloud and on-premises EPM applications.
  • Scripting – FDMEE scripting is used to extend and customize product functionality to suit your needs.  (Think automation and email notification.)  For security reasons, you don’t get scripting with FDMEE for Cloud.

If you already have on-premises FDMEE licensed and you’re implementing PBCS, it’s a no-brainer.  With on-prem FDMEE you can have one application as hub for all Oracle EPM data integrations, from on-premises to cloud.   If you’re a cloud-only customer you’d have to make the case for one or more of the above purposes to justify additional licensing for on-prem FDMEE.

While the cloud and hybrid support was definitely the big FDMEE takeaway at KScope16, there were some other noteworthy items.

What’s New to On-prem FDMEE

The Oracle product team highlighted what’s new to on-premises FDMEE for Release

  • Data Synchronization (introduced in – Feature allows you to easily copy data from a source EPM application to a target EPM application.
  • Universal Data Adapter (introduced in – This new adapter is used to directly integrate with a source database table or view.  UDA is an alternative to the open interface adapter.
  • Direct Integration with EPM Cloud (introduced in – See FDMEE and Hybrid Support above.
  • FDMEE and Data Relationship Management (DRM) Integration (introduced in and requires DRM or above) – You can now use FDMEE as the mechanism to extract hierarchies form Orcale EBS and PeopleSoft and push the metadata to DRM. With FDMEE and DRM integration you can also use DRM to manage FDMEE data load mappings.

What’s Coming to FDMEE

Now, here’s what’s coming to FDMEE in the near future… maybe. Well, we’re pretty sure. (See disclaimers below.)

  • Text-based Data Loading to Planning – (Finally!) FDMEE will be able to load text-based values to a Planning application.  This is great for Planning Smart Lists.
  • Metadata Loading – Soon users will be able to use FDMEE to consume file-based metadata and push metadata updates to downstream EPM target apps.  (This will be a welcome replacement to the EPMA interface tables and custom solutions using ODI.)
  • Direct File Loading to Target Apps – Using this new data load method, end users will be able to skip data transformation logic altogether for highly optimized data loading. Think flat file loads to Essbase in Native Essbase format.
  • Mapping Review Mode – The ability to grant read-only privileges to data load mappings in FDMEE.
  • Support for additional cloud services, such as Oracle Financial Consolidation and Close Cloud (FCCCS).

And now the caveats…
The Oracle Safe Harbor; we all know this one by now.  When it comes to roadmap stuff, Oracle makes no promises as to when a new feature will be available; Oracle even reserves the right to deep-six it for whatever reason. Next, the Oracle product team has their marching orders: it’s cloud first, baby.  Therefore, if a feature is shared by both on-premises FDMEE and FDMEE for Cloud expect to see it in the cloud version first and on-prem a few months later.

FDMEE There’s Still Life in the Old Dog Yet

It’s safe to expect new features every 3-to-4 months for on-premises FDMMEE, by way of past set updates (PSUs). Oracle’s next version of on-premises EPM software will be Release 12, a major update to the EPM platform. (That’s right. no more 11.x releases.) But we’re hearing Release 12 isn’t expected until the latter half of 2017. (Safe Harbor! Safe Harbor!) Even though debuted nearly 18 months ago, it has plenty of life ahead of it. And with increased demand and functionality for hybrid support, expect lots of new features for FDMEE.


  1. Hi Doug,

    Very interesting information noted out in the blog. I got a quick question, what’s the plan for Oracle to re-introduce the Task Flows from FDM to FDMEE? I been trying all other alternate methodologies but not the same old school mechanism that we have all in one plate.

    Do let me know if any insight on the Task Flows on FDMEE, just in case I missed any note.

    • Hi Satya, the FDMEE equivalent to FDM Classic Task Flows is Script Execution. This should get you the functionality you’re looking for. See Executing a Custom Script in the FDMEE Admin Guide. Good luck.


Submit a Comment

Your email address will not be published. Required fields are marked *