Skip to main content


Key Features Recently Made Available in Oracle Enterprise Data Management

Azure Databricks

The most recent release of new features for Oracle Enterprise Data Management contain some great capabilities. Continue reading below to find out more!


Viewpoint Querying

The ability to search for nodes within Oracle EDM has been greatly enhanced with the recent addition of Viewpoint Queries. Now, users can easily find nodes within a viewpoint where properties match specified criteria. Below are some important considerations for those users looking to use this feature.

  • All of the nodes in any viewpoint or only those below a selected node in a hierarchy viewpoint can be queried.
  • Filters can be added to narrow the scope and limit the number of query results returned for each query.
  • Queries are limited to the following properties:
    • Properties with defined values which use a Default Type = None
    • All property data types except for the Node data type
    • Certain properties in the Core and CoreStats namespaces which have stored values (e.g., WHO columns, name, description, alternate name)
    • Derived and Inherited properties are not available for selection  (bummer! hopefully this is enhanced in later releases)

Edm Query


User-Friendly History for Data Integrations

Logging the execution of data integrations is a long-standing best practice for any data management solution. Oracle has taken EDM’s ability to the next level by displaying the historical executions of imports, exports, and extracts directly to the end user.

Edm Exporthistory


Uniqueness Constraint Expanded to Node Types

Oracle EDM now provides the ability to ensure property values are unique across Nodes Types (previously uniqueness constraints were available for only application and dimensions). This feature can be used to prevent duplication across descriptions, aliases, or any other defined property.

A few things to note:

  • Planning, Planning Modules, and Financial Consolidation and Close applications already have application-specific validations that check for node name uniqueness across node types at the application level. Customers do not need to create a constraint to enforce this data rule for those application types.
  • Oracle Financials Cloud General Ledger applications already have application-specific validations that check for node name uniqueness across node types at the dimension level. Customers can add a constraint at the application level if desired to apply the node name uniqueness rule across segment value sets.
  • Properties referenced by constraints must be a node level property, must be string data type, cannot have a derived default value nor be an inherited value.


Subscription Requests Item Limit Increased

Until now, the item limit within a request, regardless of request type (interactive or subscription-generated) was been 10,000. However, the limit for requests generated from subscriptions is now 12,000. This will help to ensure the synchronization of descendant nodes between source & target viewpoints when parent nodes are moved/inserted.

Enhanced Controls on Email Notifications

There’s few things more annoying than being flooded with emails/notifications which you care little about. This is especially true in our professional lives. EDM now provides several new system settings to help organizations better manage emails originating from requests in the application.

  • Enabled/disabled emails entirely.
  • Auto-add a prefix to email subjects to identify the environment from which a notification has been sent.
  • Identify a substitute recipient who should receive all notifications instead of the primary recipient(s). (Really useful for testing workflows within a development environment and helps to avoid confusion for end users).

Edm Emailsettings1

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Steve Bogner, Project Manager

Steve Bogner is Project Manager with 15+ years experience within Perficient’s Corporate Performance Management practice. He is certified in several technologies including Oracle Data Relationship Management and Oracle Enterprise Data Management. He is constantly striving to ensure successful experiences with CPM technologies for his clients.

More from this Author

Follow Us