Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Its all about DRG(Data Relationship Governance)

Posted on July 22nd, 2016 by Sanjit Anand ||Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

You know, Oracle Data Relationship Management (DRM) is a web-based user-friendly platform for users to manage enterprise dimensions.

The application provides many features such as SOX-compliant auditing, powerful and highly customizable business rule enforcement, versioning capabilities for storing historical views of dimensions, and multiple integration formats.

Within DRM , DRG adds configurable, collaborative workflow to help automate master data change management.

Oracle Data Relationship Governance provides the change management and data quality remediation workflows essential for front-line business users, subject matter experts and signing

Oracle Data Relationship Management delivers timely, accurate and consistent master data to drive ongoing operational execution, business intelligence and performance management.

Moreover , Oracle Enterprise Data Governance solutions ensure data quality, policy compliance, repeatable business processes, cross functional collaboration and change awareness throughout the enterprise.

DRG is a fully configurable, out-of-the-box governance workflow. It is very good alternative to BPEL and Third Party workflow tools.

  • Native to DRM Platform
  • Metadata aware
  • Pure configuration, no coding
  • Existing DRM Administration skills should suffice
  • Lowest TCO
  • Email notifications

Unique Features of DRG:

  • Provides an easy to use tool to help manage requests and approvals for master data changes.
  • Integrated workflow with DRM enhances existing DRM implementations and can re-use DRM (hierarchies, properties, validations, and security).
  • Configurable tasks and workflows can be designed and deployed by business users.
  • Workflows can be configured to handle simple or complex requests, multi-line items, various actions (Add, Update/Enrich, etc.).
  • Email notifications and web interface provide information for tracking activity, history, and other audit needs.

Benefits – What’s in it for you?

  • Provides workflow for DRM, enhancing any DRM implementation.
  • Compliments any Data Governance Council, providing the tool to achieve master data alignment.
  • No coding required: Business users can drive the process and have direct participation in building the solution.
  • Flexible: Workflows can be adjusted or modified to suit the needs of the business.
  • Fully Integrated: Avoid time consuming efforts to leverage DRM outside of the tool, DRG works with the existing features of DRM.
  • Provides fully transparent activity trail compliance and audit, as well as email notifications.

The Core

DRG is a component within Oracle’s Data Relationship Management , act as a tool that allows DRM users to easily make changes to their data hierarchies.

It also allows users to communicate within the DRM system, which means users can view, request, and approve data changes all in the same place.

Those , who need more details, can understand DRG has four main focal points:

  1. User Roles
  2. Access Levels
  3. Workflow Tasks
  4. Workflow Stages.

User Role

There are several DRG User Role Permissions that can be assigned to DRM users. The permission with the most freedom is the “Workflow Participant”. This permission allows users to Request and/or Approve changes to the data hierarchies. The next level down in the DRG permissions is “Browse Versions”, which allows DRM users to navigate through different versions within the DRM system, but doesn’t allow them to request and/or approve changes to the data structures. Finally, there are three more permission levels: “Browse Hierarchies”, “Browse Categories”, and “Browse Properties”. These three permissions are the lowest level of permissions and there names describe what the user is able to navigate through.

Access Level:

In Data Relationship Governance, there are six different Access Levels that users can be given. All of these access levels build on each other, so, for example, level 3 includes all of the access rights that level 1 and 2 have. Level 6 has all of the access rights that levels 1 through 5 have. The six Access Levels in DRG are: Read, Limited Insert, Edit, Insert, Inactivate, and Add. Read access only allows users to view the data. Any user with this Access Level cannot make any changes. Limited Insert is allowed to insert a node, but only if that node has Global Properties. The Edit access level allows users to modify property values. The Insert access level grants users the ability to insert, move, and remove nodes. Inactivate allows users to deactivate and reactivate nodes. Lastly, the Add access level allows users to do all of the previous tasks, plus add or delete nodes.

Workflow Tasks

A workflow task represents a change action to be performed along with a set of properties to be displayed, edited, and required during the task.

Workflow tasks are defined outside of workflow models and can be used by multiple models to ensure consistency of common tasks performed in different business processes

Workflow Tasks are made up of an action type, properties that need to be reviewed, and validations.

There are eight different Action Types a Workflow Task can use: Add Leaf, Add Limb, Delete, Inactivate, Insert, Move, Remove, and Update.

These Action Types are self-explanatory and they are named for exactly the action that they perform.

Workflow Tasks must be created in the Administer tab within DRM before any user can Request and/or Approve any data changes.

Workflow Stages

A workflow model consists of multiple workflow stages. When a stage is defined for a workflow model, the stage type defines the level of participation for users in that stage of the workflow. A workflow model has:

  • A single Submit stage which is defined by a list of allowable workflow tasks that can be used to submit changes
  • An optional series of Approval or Enrichment stages, each consisting of a single workflow task
  • A single Commit stage used for final approval and commitment of all workflow tasks performed

There are four stages in total, but only three of them are required.

The Workflow stages include: Submit, Enrich, Approve, and Commit.

The Submit stage is where the requests for any sort of data change take place. All of the Action Types are associated with this stage except for the Update action.

The Enrich stage is used to update requests that have already been submitted. This is the stage that is not always necessary to be included, and includes the Update, Insert, and Move Action Types.

The third stage is the Approve stage, which is where all requests are viewed and managed. The Update Action Type is also a part of this Workflow Stage, which is why the Enrich Workflow Stage does not always need to be included.

Finally, the Commit stage is where requests are approved or rejected. Only a user with the access to approve a request may view the Commit stage.

These four components of Data Relationship Governance, User Roles, Access Levels, Workflow Tasks, and Workflow Stages, are what make DRG so useful in DRM.

Related Posts

Posted in MDM | No Comments »Email This Post Email This Post |

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.