ICAP Gains Robust Control Over Financial Master Data with Oracle Enterprise Data Governance Solution

Seismi are excited to share a recent press release announced by Oracle about our successful implementation of Oracle Data Relationship Management (DRM) and Oracle Data Relationship Governance (DRG) at ICAP. Oracle confirms that the ICAP implementation of DRG is the first in the United Kingdom.

You can find the press release here.

Tagged , , , , , ,

Seismi presenting at 10th annual MDM Summit – London 2015

Come and join Seismi at the Master Data Management Summit, Europe’s premier event dedicated specifically to MDM, CDI and Data Governance, on the 19th and 20th May. James Gordon will be speaking on Wednesday, 20 May (16:35–17:20) about how De Beers Group of Companies have used effective Financial Master Data Management to help them mitigate key risks that they had around financial process and control. James will be explain how their implementation of Oracle DRM has improved Data Transparency whilst also simplifying and standardising their approach to mapping between financial applications. James will be co-presenting with Doug Cosby, Oracle VP of MDM Development.

James will also be sitting on an experts panel analysing the Best Practises in MDM of Reference Data (Tuesday, 19 May, 16:40–17:25).

Seismi will be at the Oracle exhibition ​stand if you ​would like to explore details of our customer case studies or would like to discuss how we can help with implementing Financial master data management and governance solutions for your organisation.

For further details on the MDM Summit and how to register please click on the following link.

We look forward to seeing you there.

Tagged , , , , ,

Oracle 'Office of Financial Solutions' Live Webcast - Unleashing the Power of Financial Master Data Governance

Join us for a live webcast on Thursday May 21 as we examine the critical area of financial data governance and how a controlled and organised approach to financial master data will improve the quality and subsequently the confidence in the numbers an organisation reports. James Gordon, Managing Director at Seismi will share recommendations on how to approach financial master data implementations: explaining when and how to initiate your project and help you understand the balance of reward vs risks with these decisions. Finally he will examine some common pitfalls associated with financial master data governance.

Please click here for further details and to register to attend the webinar.

Tagged , , , , , ,

Seismi Sponsor Oracle DRM SIG

Event date: 24th March 2015Seismi Clients_Blog_Sidebar_DeBeers
Event Location: Oracle City Office, One South Place, London EC2M 2RB

We are pleased to announce our continued support for the Oracle DRM Special Interest Group (SIG).

Oracle is hosting the event and Seismi will be presenting a customer use case. The De Beers Group of Companies is in the process of implementing Oracle DRM and FDM to optimise the relationship between their extensive collection of general ledgers and their consolidation tool, HFM. They will be sharing their story to date, outlining their use case, their solution and the benefits they are expecting the solution to bring. They will also highlight any pitfalls and lessons learnt from their project.

For further information on, and to register for the event, please click here.

Spaces are limited so please register as soon as possible to join us.

Tagged , , , , , , ,

Seismi Case Study | Anglo American plc

Firstly apologies that 3 weeks have passed since we last updated our weekly blog.  Like many others Seismi’s team have been taking some well earned leave, as well as meeting other development deadlines.

We wanted to bring to your attention a case study that Oracle has published on their website that highlights an example of a project that we have recently delivered. Our client was Anglo Copper a USD4 billion division of Anglo American plc and the environment was relatively complex with many applications and over 200,000 account codes.

The case study is a good example of the type of project that Seismi team have delivered for their clients. It also provides a good example of the flexibility of Oracle Hyperion Data Relationship Manager (DRM) tool and how it can be adapted to meet key business issues.

Not only were Seismi able to allow Anglo Copper to resolve some significant issues within their finance applications architecture but it has also provided their finance team with a robust and flexible platform that will be able to adapt to Anglo Copper’s business as its strategy evolves, including the ability to integrate acquisitions effectively.

In addition we were able to implement the solution over a rapid a 6-month timetable. Seismi are continuing to provide second line support to Anglo Copper’s user base.

You can read the brief case study here and please get in touch if you would like to hear more of the detail.

Also if there any specific topics you would like us to cover then do reach out. 

Tagged , , , , ,

Oracle Hyperion DRM Tips & Tricks | Quicker Navigation

A quick one this week we just thought we should share a small Oracle Hyperion DRM (Data Relationship Manager) feature that can be helpful and most importantly save time and raise your productivity.

Whenever you are working within a tab, you can right-click on the tab bar and see the different sections of the Home menu. This allows you to navigate directly from one module of Oracle Hyperion DRM to another, rather than having to click on Home then the name of the module you want. In the long run, this sav

140122_Seismi Blog_DRM Tips & Tricks_Quicker Navigation

es not just time but also frustration…

Tagged , , ,

Success Case (Financial Services) | ICAP plc

With the team having returned from a well-earned break, we thought it was time to share another success case with you. The client is ICAP, a leading markets operator and provider of post trade risk and information services. With a local footprint in 32 countries, more than 70 locations worldwide and an average daily transaction volume of US$1.3 trillion, ICAP can truly be considered a global company.

ICAP recognised that they needed a strategic approach to masterdata to underpin a comprehensive Financial Transformation Programme. They looked to us to “improve ICAP’s approach to masterdata governance, help improve the end-to-end visibility of data and help improve our ability to automate interfaces.”

We are glad to announce that ICAP have realised the benefits of a strategic approach to masterdata and this is evidenced by the following case study – ICAP Case Study.pdf.

If you would like to find out more about what we did and how we did it, then please do not hesitate to get in contact.

Tagged , , , ,

Oracle Hyperion DRM Tips & Tricks | Clearing a Property Value

If you ever need to clear all values of a defined property within a hierarchy (prior to blending in a completely fresh set of property values, say), it can be done in a few brief steps.

Firstly select the top node of the hierarchy and choose the tab the property is on. If the top node does not normally show this property, you will have to select Show All Properties on the property viewer. Only administrators can do this but then again, only administrators should be doing this.

Next, right-click on the property label and choose Clear All Below, followed by Save. This removes all explicitly defined values from each node below the selected node. (This is a useful little option in itself.)

131211_Seismi Blog_Clear Property Value in Oracle DRM

Finally, right-click on the property label and choose Remove Value, then Save. This removes the property value from the top node.

There are action script equivalents of these two commands, so if you have a whole set of properties to clear an action script is probably the way to go:

131211_Seismi Blog_Clear Property Value in Oracle DRM_2

Tagged , , , , ,

Oracle EPMA | Error on import

We are doing a fair amount of work with Oracle Enterprise Performance Management Architect (EPMA) application at the moment. We came across the following error message recently. (In the spirit of paying it forward we thought we should share it with you.)

“EPMA Error on import – Member cannot be inserted because the parent member has another child member with the same name.”

It took me some time to understand this one although in the end the cause was quite simple. I hope that this can save you some time…

One of my imports to EPMA was failing and returning the error “This member cannot be inserted because the parent member has another child member with the same name.”

130802_Seismi_EPMA Error on Import_1


130802_Seismi_EPMA Error on Import_2


At first this seemed like a simple mistake in my load file. After checking, I was disappointed to discover the error message was misleading. My file contained the correct structure:



The member ASSET_ACC was not repeated in the hierarchy section. The import profile was set to replace the current dimension so the fact that the member ASSET_ACC was already in EPMA should not have been an issue.

This article from Oracle’s Knowledge Base gave me a hint as to the source of the issue in the document EPMA Error “This member cannot be inserted because the parent member has another child member with the same name” [ID 1361635.1]

The issue was that in my current dimension, the member BALSHT was written BalSht. It looks like EPMA is only partially case sensitive so it was partly recognizing BALSHT and BalSht as being the same member but it was not updating that member correctly. As soon as I renamed BALSHT to BalSht in the file, the import worked.

The root cause to keep in mind is that EPMA does not handle subtle differences in cases well.

Tagged , ,

HFM Redeploy from EPMA – Unspecified Error

When redeploying an Oracle Hyperion Financial Managemenent (HFM) application from Oracle Enterprise Performance Management Architect (EPMA), the deploy operation can fail and return a very unhelpful error message “Unexpected Error”. Although not immediately obvious, this error usually indicates there is an issue within the outline however, if the application has data, it may simply be that the data is being reorganized.

The screen shot below shows the EPMA summary:

130726_Seismi_HFM Redeploy from EPMA_1

The EPMA error log only is not much help either.  It returns the following information:

Error Reference Number: {5AD32CB5-7E26-4A48-A98C-5DC4870698E7}

Num: 0x80004005;Type: 0;DTime: 05/07/2013 13:54:20;Svr: UK1WHYPAPP11Q;File: CHsvMetadata.cpp;Line: 1056;Ver:;

Num: 0x80004005;Type: 0;DTime: 05/07/2013 13:54:20;Svr: UK1WHYPAPP11Q;File: AgentHelper.cpp;Line: 1237;Ver:;

Num: 0x80004005;Type: 0;DTime: 05/07/2013 13:54:21;Svr: UK1WHYPAPP11Q;File: CHfmAwbAgent.cpp;Line: 665;Ver:;

To solve this, in the deploy screen uncheck the “Check Referential Integrity” option and check the “Full Deploy”.

130726_Seismi_HFM Redeploy from EPMA_2

Changing these options should allow you to deploy the HFM Application.

WARNING – Deploying without the option “Check Referential Integrity” means that data can be affected. Before doing so, be sure you have a backup of the application and a point of comparison to review any changes.


Tagged , , ,