Thursday, June 11, 2026

Improving Governance Visibility in Oracle EDM with Approval and Commit Policy Filtering

 

One of the most overlooked challenges in metadata governance isn't workflow design—it's workflow visibility.

Oracle Enterprise Data Management (EDM) provides robust governance capabilities that allow organizations to define Approval Policies and Commit Policies across Applications, Hierarchy Sets, and Node Types. These capabilities help ensure that metadata changes follow established governance processes before they are committed to downstream systems.


https://community.oracle.com/customerconnect/discussion/964165/add-request-filtering-by-approval-and-commit-policy


However, as organizations scale their governance programs, a common operational challenge begins to emerge:

How do governance teams quickly identify every request currently waiting on a specific approval or commit policy?

Today, the answer is often far more difficult than it should be.

Governance Is More Than Individual Approvals

In many EDM implementations, policies are not assigned to individual users. Instead, they are assigned to governance groups such as:

  • Finance Data Stewards

  • Product Master Governance

  • Enterprise Data Governance

  • Regional Data Owners

  • Corporate Accounting

This approach makes sense because governance responsibilities are typically shared across teams rather than tied to a single individual.

The problem is that while EDM allows users to filter requests by Application, Viewpoint, Request Owner, and Request ID, it does not currently provide a way to filter requests based on the Approval Policy or Commit Policy currently processing the request.

As a result, governance administrators often find themselves manually reviewing workflow details to answer relatively simple questions.

Questions such as:

  • What requests are waiting for Finance Data Steward Approval?

  • Which governance group currently has the largest backlog?

  • Are any approval policies becoming workflow bottlenecks?

  • How many requests are awaiting commit approval before month-end processing?

These are operational governance questions that should be easy to answer.

A Real-World Governance Scenario

Consider an organization that maintains a policy called:

Finance Data Steward Approval

This policy is responsible for reviewing chart of accounts changes, cost center updates, and financial hierarchy modifications.

Throughout the month, requests are submitted from multiple business units and routed through various workflow paths. Some requests reach the Finance Data Steward Approval stage immediately, while others arrive later after passing through multiple governance checkpoints.

A governance lead wants visibility into all requests currently waiting for action from the Finance Data Steward team.

Today, that visibility does not exist through a simple filter.

Instead, administrators must manually investigate individual requests, review workflow histories, or navigate multiple screens to understand current workload and request status.

As request volumes increase, this process becomes increasingly inefficient.

Why Policy-Based Filtering Matters

Adding Approval Policy and Commit Policy as standard request filters would provide immediate value to governance teams.

With policy-based filtering, users could:

  • View all requests awaiting a specific approval policy

  • View all requests awaiting a specific commit policy

  • Combine policy filters with existing request criteria

  • Monitor workload across governance teams

  • Identify approval bottlenecks before service levels are impacted

More importantly, governance visibility would shift from reactive investigation to proactive management.

Instead of searching for problems, governance teams could immediately see where work is accumulating.

Unlocking Better Workflow Analytics

The value extends beyond request management.

If Approval Policy and Commit Policy were exposed as common request filters, organizations could leverage the same capability within EDM workflow dashboards and reporting.

Imagine dashboards that display:

  • Requests awaiting Finance Data Steward Approval

  • Average approval time by policy

  • Aging requests by governance team

  • Commit policy workload trends

  • Approval bottlenecks across the enterprise

These insights would help governance leaders better allocate resources, improve processing times, and identify opportunities for workflow optimization.

Aligning Governance with Operational Reality

As EDM adoption expands, organizations increasingly treat metadata governance as an operational discipline rather than a technical process.

Success is no longer measured solely by governance controls. It is measured by how efficiently governance teams can process requests while maintaining compliance and accountability.

Providing request filtering by Approval Policy and Commit Policy would be a relatively small enhancement with a disproportionately large operational impact.

It would improve transparency, reduce administrative effort, strengthen workload management, and provide governance teams with the visibility needed to effectively manage growing request volumes.

As an Oracle ACE working with EDM governance implementations across large enterprises, I've seen firsthand how quickly governance complexity can outgrow the visibility tools available to manage it.

Adding policy-based request filtering would be a practical enhancement that helps bridge that gap and provides governance teams with the operational insight they need to keep workflows moving efficiently.

Why Oracle EDM Needs Targeted Workflow Push Back

 

One of the strengths of Oracle Enterprise Data Management (EDM) is its governance framework. Organizations can design approval workflows that ensure changes are reviewed, validated, and approved before they are committed to downstream systems. As EDM adoption matures, however, governance workflows often become significantly more sophisticated than the simple submit-review-approve model many organizations start with.

https://community.oracle.com/customerconnect/discussion/963884/allow-workflow-push-back-to-a-specific-prior-approval-stage


This raises an important question:

What happens when an approver finds an issue that should be corrected by a previous governance stage, but not by the original submitter?

Today, Oracle EDM provides a Push Back action that returns a request directly to the submitter. While this works well for straightforward workflows, it creates inefficiencies in larger enterprise governance processes.

The Challenge with Complex Governance Workflows

Consider a workflow that includes multiple approval layers:

  • Data Steward Review

  • Domain Owner Approval

  • Regional Approval

  • Global Governance Approval

  • Executive Approval

At first glance, this seems like a typical enterprise governance model. However, real-world reviews are rarely linear.

Imagine an Executive Approver identifies a concern with the business justification provided during Global Governance Approval. The issue does not require the request to return to the submitter. It simply requires clarification or adjustment from the Global Governance team.

Unfortunately, EDM's current workflow model offers only one push-back destination: the original submitter.

As a result:

  • The request must restart unnecessarily.

  • Previously completed approvals are repeated.

  • Governance teams spend time re-approving work they already reviewed.

  • Cycle times increase.

  • Users become frustrated with redundant approval activity.

In highly regulated environments, these inefficiencies compound quickly as request volumes grow.

A Better Approach

Oracle EDM would benefit from the ability to push a workflow back to a specific prior approval stage or policy.

Instead of returning every rejected request to the submitter, EDM could allow approvers to select from previously completed workflow stages.

For example:

  • Executive Approval → Global Governance Approval

  • Global Governance Approval → Domain Owner Approval

  • Regional Approval → Data Steward Review

The workflow would resume from the selected stage while preserving completed workflow history and maintaining a full audit trail.

Why This Matters

This enhancement would provide several significant benefits:

Reduced Rework

Organizations would avoid repeating approvals that remain valid and unaffected by the requested change.

Faster Governance Cycles

Requests would move directly to the team best positioned to resolve the issue, reducing overall processing time.

Better User Experience

Approvers could collaborate more effectively without forcing unnecessary workflow restarts.

Support for Enterprise Governance Models

Many organizations operate complex governance frameworks with multiple serial and parallel approval policies. EDM should provide workflow controls that align with these realities.

Preserved Auditability

Every push-back action could be fully logged, including:

  • User initiating the push back

  • Destination stage

  • Timestamp

  • Required comments or justification

This maintains EDM's strong governance and compliance posture while increasing flexibility.

Configuration Options Oracle Could Consider

To support different governance requirements, Oracle could make the capability configurable.

Possible options include:

  • Allow push back to any prior completed stage

  • Allow push back only to the immediately preceding stage

  • Define approved push-back destinations by workflow stage

  • Require comments when pushing back

  • Include push-back activity in workflow reporting and analytics

This would give organizations the flexibility to balance efficiency with control.

Alignment with Modern Workflow Platforms

Targeted push-back capabilities are common in enterprise BPM and workflow management solutions. Users expect workflows to move to the appropriate point of correction rather than restarting entirely.

As Oracle continues to enhance EDM governance capabilities, this feature would represent a natural evolution of the platform's workflow engine.

The goal is not to weaken controls. The goal is to make governance smarter.

When an issue is identified, organizations should be able to route the request back to the team responsible for resolving it—not automatically back to the beginning of the process.

For enterprises managing thousands of governed changes each year, that distinction can significantly improve governance efficiency, user adoption, and overall workflow effectiveness.

As an Oracle ACE working with EDM implementations across complex governance environments, this is one enhancement that would deliver immediate value while preserving the auditability and control that make Oracle EDM such a powerful governance platform.