Thursday Sep 25, 2014

Focus on Oracle Data Relationship Management at Oracle Openworld 2014

We have an exciting line up of activities planned for Oracle Data Relationship Management (DRM) enthusiasts. 

Sunday, September 28, 2014

We begin on Sunday with the DRM Customer Advisory Board meeting. This is an invitation only event. If you are an existing DRM customer who is live in production and would like to join us this conversation, kindly email  to communicate your interest and availability. This event will be held in San Francisco between 1:00 - 4:00pm PT.  An Openworld 2014 pass is not required to attend this meeting.

Monday, September 29, 2014

We kick off the week with an Introduction and Update: Oracle Data Relationship Management [CON8535].  If you've never known but have always wanted to learn what a master data change management solution like Oracle DRM can do for your enterprise, don't miss this session.  We will give you a brief product introduction, share well known as well as emerging use cases, and give you a sense for product direction: what's new, what's coming, and what's planned. The centerpiece of this event will be a customer spotlight presentation by Gary Crisci of General Electric. GE has embarked on an sweeping, enterprise-wide financial chart of accounts standardization initiative that aligns a diverse set of business units (each having the heft of a large publicly traded company) with an enterprise standard chart of accounts that is set at the corporate level, while giving each business unit autonomy to maintain certain segments locally to operate most effectively.  If you are looking to harmonize financial systems across a large, diversified, multinational corporation, this might be the best 45 minutes you spend at Openworld 2014!

Demogrounds will be open from 9:45am -- 6:00pm on Monday and you can find the Oracle DRM team in Moscone West at Demopod: WLL-004. We will be available Mon-Wed to discuss your interest in Oracle DRM, do a live show-and-tell demonstration and answer any questions. Please do stop by!

Tuesday, September 30, 2014

The highlight of DRM activities on Tuesday is the 6th annual DRM Customer Roundtable.  Openworld offers a unique opportunity for us to meet with visiting customers from all over the world. It also gives Oracle DRM practitioners the unique opportunity to put a face to a name, expand one's network, exchange best practices, and quiz DRM product management on knotty design challenges, implementation best practices, features, roadmap items, and share your feedback. This year, we are hosting the DRM Customer Roundtable between 12 noon – 1:30pm PT, Tuesday, September 30, 2014, in Hotel Westin St. Francis, California East Room.  If you are an Oracle customer, please RSVP by emailing Space is limited. Our apologies in advance to Oracle partners and employees; however, this event is reserved for customers only.

The DRM Customer Roundtable ends just in time for you to catch THE keynote event of the entire conference. Make your way to Moscone North, Hall D to hear Larry Ellison, Executive Chairman and Chief Technology Officer, Oracle, deliver his address. 

At 5pm on Tuesday, be sure to stop by Moscone West 3010 to take An Oracle Data Relationship Governance Journey: ICAP Success Story [CON4936].  ICAP is a leading UK-based financial markets operator and provider of post trade risk mitigation and information services.  When Oracle introduced its new and innovative Oracle Data Relationship Governance module in 2013, ICAP blazed the trail with us to  federate the management of its chart of accounts to different business areas while retaining control over the impact of changes on business-critical financial applications. It replaced spreadsheet-based processes with automated, controlled, and audit-able workflows, leveraged our adaptive security and routing model to provide regional control over subsets of global hierarchies. Attend this session to learn the benefits delivered, challenges overcome, and lessons learned.

Oracle DRM is an industry leading multi-domain MDM solution and a core component of the Oracle MDM product family. As a DRM customer attendee, you are invited to the MDM Customer Appreciation Dinner. Invitations should be in your inbox! RSVP is requested. Reception begins promptly at 6pm.

Wednesday, October 1, 2014

The DRM Customer Panel takes center stage on Wednesday. Attend Customer Success: Transformative Governance with Oracle Data Relationship Management [CON8531] to learn from the success stories of four enterprises that have taken the journey with us. Presenters include Michael Manahan of ADM (Food Processing, Commodities), Chris Scala from Ameren Corporation (Utilities), Lisa Moran of MetLife (Financial Services), and Nikki Verhoff from Verizon Wireless (Communications).  Whenever enterprises are confronted with challenges that demand financial, organizational, or systems transformations to leapfrog and deliver enterprise information structures and processes that drive business agility, flexibility and adaptability with low risk to make the proverbial elephant dance, they have done well to invest in a foundation built upon DRM, with common terms and definitions, referential integrity, data quality, change control and compliance peace-of-mind.  Attend this session to learn how. Not from Oracle, but real-world practitioners who are leading such transformations and helping teach the proverbial elephant to dance.

Have a great conference! And, we look forward to seeing each of you soon! 

Tuesday Sep 24, 2013

Oracle AppCast Series on Data Governance

As each of you engage in your own journey with implementing a data governance program in the enterprise, you are bound to be confronted with several questions. What is data governance? How can we harness our data governance program for maximum impact? What best practices can we leverage to get a head start?

Recently, Michelle Kimihira in Oracle MDM Marketing sat down with Kelle O’Neal of First San Francisco Partners and yours truly to discuss the topic of data governance over the course of three podcasts. For instant access to these podcasts, click on the links below.

Search for “Oracle's Appcast Data Governance Series” in the iTunes store to download them to your library.

Wednesday Aug 07, 2013

Introducing Oracle Data Governance

I had the pleasure of taking a front seat at the recently concluded MDM & Data Governance Summit 2013 in San Francisco’s Hyatt Fisherman’s Wharf.  The session was extremely well attended.  Of particular interest were speakers including Doug Cosby, VP Engineering for Oracle Data Relationship Management and Jeff Slatter, Associate Vice President, Finance at TD Bank.   

Doug Cosby presented a strong case for master data management in the face of change. He discussed how changes can emerge from a variety of sources ranging from IT complexity, process complexity, new product innovation, regulatory changes, and of course, management injectors such as corporate reorganizations or mergers and acquisitions.  He highlighted the use of Oracle Data Relationship Management (DRM) as an enabler of enterprise transformations: financial transformations as they relate to ERP/GL migration, consolidation, rationalization, or coexistence, etc., as well as business transformations including employee, organization, sales, or legal entity restructuring. 

At the summit, Oracle announced a new module named Oracle Data Relationship Governance (DRG).

This announcement is significant for a number of reasons. First, this represents Oracle’s response to considerable demand in a new and exciting area of new product innovation.  Hundreds of existing multi-national enterprise customers of Oracle Data Relationship Management (DRM) have long requested the ability to develop their own configuration-based workflow models to complement the implementation of multiple business entities for enterprise information management purposes.

Second, this module is a standalone data governance solution from the Oracle Master Data Management product family that helps companies model any business entity of their choice, specify its attribution, related business rules and then construct workflow models – through pure configuration – to create complex multi-stage workflows.  With this approach, front line business users can participate as co-creators via change management and remediation workflows alongside line-of-business approvers as well as data stewards who ultimately are responsible for promoting valid changes to downstream applications including front-office, back-office, finance, HR and business analytics. 

Jeff Slatter of TD Bank, the sixed largest bank in North America, gave a great testimonial of how change management and governance are critical for the finance function at this dynamic financial institution as it charts its growth path through both organic growth and acquisitions. 

Jeff described how implementing an enterprise dimension management program allowed TD Bank to reduce the number of touch points for changes by 72%. Prior maintenance processes were manual, intensive and error prone.  By consolidating, streamlining and aligning various user communities across operations and analytics, the bank was able to reduce the number of hierarchies and related attribution by over 80%. 

Business users – instead of creating their own version – now are inclined to consume either the master default hierarchy or select from a set of alternate hierarchies as have been ordained by the cross-functional governance organization to build reports that are guaranteed to reconcile correctly.  Custom hierarchies are clearly identifiable for specific needs that are not met by either the master or alternate hierarchies.  The whole change management process relies on an efficient, scalable and shared system of entry and source of truth.  Changes are processed with quick turnaround times, accuracy and data quality while new requests for hierarchies can be turned around within less than a day versus taking well over two weeks previously.  DRM enables a self-service MDM environment for business users, who are further able to run what-if scenarios on-demand to evaluate the impact of planned changes. Once finalized, these changes can then be committed to production in ‘real time’ – enabling flexible, agile, real-time business processes.

For more information on Oracle MDM solutions, visit us at

Monday Nov 12, 2012

Spotlight on Reference Data Management

Reference Data Management

Oracle Data Relationship Management (DRM) has always been extremely powerful as an Enterprise MDM solution that can help manage changes to master data in a way that influences enterprise structure, whether it be mastering chart of accounts to enable financial transformation, or revamping organization structures to drive business transformation and operational efficiencies, or mastering sales territories in light of rapid fire acquisitions that require frequent sales territory refinement, equitable distribution of leads and accounts to salespersons, and alignment of budget/forecast with results to optimize sales coverage. Increasingly, DRM is also being utilized by Oracle customers for reference data management, an emerging solution space that deserves some explanation.

What is reference data?

Reference data is a close cousin of master data. While master data may be more rapidly changing, requires consensus building across stakeholders and lends structure to business transactions, reference data is simpler, more slowly changing, but has semantic content that is used to categorize or group other information assets – including master data – and give them contextual value.

The following table contains an illustrative list of examples of reference data by type. Reference data types may include types and codes, business taxonomies, complex relationships & cross-domain mappings or standards.

Types & Codes


Relationships / Mappings


Transaction Codes

Industry Classification Categories and Codes, e.g.,
North America Industry Classification System (NAICS)

Product / Segment; Product / Geo

Calendars (e.g., Gregorian, Fiscal, Manufacturing, Retail, ISO8601)

Lookup Tables
(e.g., Gender, Marital Status, etc.)

Product Categories

City à State à Postal Codes

Currency Codes (e.g., ISO)

Status Codes

Sales Territories
(e.g., Geo, Industry Verticals, Named Accounts, Federal/State/Local/Defense)

Customer / Market Segment; Business Unit / Channel

Country Codes
(e.g., ISO 3166, UN)

Role Codes

Market Segments

Country Codes / Currency Codes / Financial Accounts

Date/Time, Time Zones
(e.g., ISO 8601)

Domain Values

Universal Standard Products

and Services Classification (UNSPSC), eCl@ss

International Classification of Diseases (ICD) e.g.,
à IC10 mappings

Tax Rates

Why manage reference data?

Reference data carries contextual value and meaning and therefore its use can drive business logic that helps execute a business process, create a desired application behavior or provide meaningful segmentation to analyze transaction data. Further, mapping reference data often requires human judgment.

Sample Use Cases of Reference Data Management

Healthcare: Diagnostic Codes

The reference data challenges in the healthcare industry offer a case in point. Part of being HIPAA compliant requires medical practitioners to transition diagnosis codes from ICD-9 to ICD-10, a medical coding scheme used to classify diseases, signs and symptoms, causes, etc. The transition to ICD-10 has a significant impact on business processes, procedures, contracts, and IT systems. Since both code sets ICD-9 and ICD-10 offer diagnosis codes of very different levels of granularity, human judgment is required to map ICD-9 codes to ICD-10. The process requires collaboration and consensus building among stakeholders much in the same way as does master data management. Moreover, to build reports to understand utilization, frequency and quality of diagnoses, medical practitioners may need to “cross-walk” mappings -- either forward to ICD-10 or backwards to ICD-9 depending upon the reporting time horizon.

Spend Management: Product, Service & Supplier Codes

Similarly, as an enterprise looks to rationalize suppliers and leverage their spend, conforming supplier codes, as well as product and service codes requires supporting multiple classification schemes that may include industry standards (e.g., UNSPSC, eCl@ss) or enterprise taxonomies. Aberdeen Group estimates that 90% of companies rely on spreadsheets and manual reviews to aggregate, classify and analyze spend data, and that data management activities account for 12-15% of the sourcing cycle and consume 30-50% of a commodity manager’s time. Creating a common map across the extended enterprise to rationalize codes across procurement, accounts payable, general ledger, credit card, procurement card (P-card) as well as ACH and bank systems can cut sourcing costs, improve compliance, lower inventory stock, and free up talent to focus on value added tasks.

Change Management: Point of Sales Transaction Codes and Product Codes

In the specialty finance industry, enterprises are confronted with usury laws – governed at the state and local level – that regulate financial product innovation as it relates to consumer loans, check cashing and pawn lending. To comply, it is important to demonstrate that transactions booked at the point of sale are posted against valid product codes that were on offer at the time of booking the sale. Since new products are being released at a steady stream, it is important to ensure timely and accurate mapping of point-of-sale transaction codes with the appropriate product and GL codes to comply with the changing regulations.

Multi-National Companies: Industry Classification Schemes

As companies grow and expand across geographies, a typical challenge they encounter with reference data represents reconciling various versions of industry classification schemes in use across nations. While the United States, Mexico and Canada conform to the North American Industry Classification System (NAICS) standard, European Union countries choose different variants of the NACE industry classification scheme. Multi-national companies must manage the individual national NACE schemes and reconcile the differences across countries. Enterprises must invest in a reference data change management application to address the challenge of distributing reference data changes to downstream applications and assess which applications were impacted by a given change.


This blog is intended to discuss how Oracle Hyperion Data Relationship Management can address an enterprise's master data management needs in the face of change driven by business events over the enterprise life cycle. Bookmark this blog if you care about the following topics: enterprise dimension management, reference data management, Enterprise MDM, Financial MDM, Analytical MDM, master data management, MDM, RDM, hierarchy management, chart of accounts, reporting reconciliation, regulatory compliance, mergers, acquisitions, reorganizations, re-statements, financial transformation, business transformation, performance management, financial alignment, BI alignment, sales territory mastering, organization alignment, approval groups, purchase authorization limits, corporate B2B hierarchies, et al.


« July 2016