EMA London Building

On-boarding of users to SPOR data services (updated document)

EMA Update Document

02 October 2018 version 2
Information Management Division

On-boarding of users to SPOR data services  (document published (02 October 2018 version 2))

In a Nutshell:

RMS and OMS data services were open to industry stakeholders in December 2017. Stakeholders were invited to start registering their SPOR users. As of today we have 604 Registered Industry Super Users and 336 Industry Users.

The registration of SPOR users is predominantly driven by the business process using the referential and/or organisation master data. The organisation in question should decide, depending on their circumstances (e.g. business process using the master data, organisational structures, etc.), how many users they need to register in SPOR.
This document starts with a brief introduction to the type of SPOR roles users can request, highlighting the role of the Super User and what companies should take into consideration when setting up user populations. The scenarios provided in this document may help you to consider the best options for your organisations.

Dieter Schlaps, ITCLS

Masterdata Management for IDMP – How to keep SPOR OMS and Internal Systems in Sync?

By Dieter Schlaps for IDMP1-News October 2018

Introduction to Masterdata Management IDMP SPOR OMS Sync

The spectrum of possible IDMP solution architectures ranges from web-tool, “EVWeb”-type solutions where (a potentially huge amount of) data will have to be entered manually to large-scale integrated solutions which include “Master Data Management” components to extract, transform and load data from source systems for IDMP submissions.

IDMP Solution Architectures

Figure 1: Range of IDMP Solution Architectures; from left to right:
Web-tool based solution, RIMS[1]-centered (or also “integral”) solution, RIMS with separate IDMP submission tool and Master Data Management based solution

As the European Medicines Agency (EMA) is implementing the SPOR (Substances-Products-Organisations-Referentials) databases, Master Data Management (MDM) based approaches are gaining much more attention, as MDM-based systems would already provide functionalities and tools to cope with the growth and changes of SPOR’s OMS-, RMS-, PMS- and SMS-databases[2].

This newsletter looks specifically at the Masterdata Management IDMP SPOR OMS Sync, i.e. Marketing Authorization Holders (MAHs), Marketing Authorization Applicants (MAA), Clinical Trial Sponsors (CTS) and Contract Manufacturer Organisations (CMOs). It shows whether and how Master Data Management can support the management of the address data and company information associated with these organisations that are used in the context of regulatory submissions and what the challenges are.

  1. The Organisation Management System (OMS) of EMA’s SPOR System

When EMA published its roadmap (in April 2015) towards her vision of an integrated Masterdata Management System that would manage pharmaceutical data about Substances, Products, Organisations and Referentials (“SPOR”) and would not only become the basis of Europe’s future IDMP implementation, but would also include a revision of the current EMA portfolio of systems and databases (e.g. EUDRAGMPD).

The targets of the Masterdata Management IDMP SPOR OMS Sync implementation were defined as follows:

  • Implement an integrated and harmonised MDM solution which will deliver standards compliant master data for Substances, Products, Organisations and Referentials (SPOR).
  • Data will be collected, managed and made available to the network, industry and wider stakeholder community, in compliance with legislative requirements and relevant standards for privacy, data protection and security.
  • Implement a new portfolio of services which will be supported by standardised data governance and lifecycle management.
  • Maximise the benefits realised throughout the implementation of the roadmap by involving and engaging effectively with stakeholders, leading to operating model simplification and efficiency improvements.

Through the SPOR Masterdata Management Solution, especially the “Organisations”, “Referentials” and “Substances” modules, EMA intends to collect basic data about the Organisations (Marketing Authorisation Holders (MAH), Marketing Application Applicants (MAA), Contract Manufacturers (CMO) and Clinical Trial Sponsor (CTS) Organisations) and Substances in order to provide unique IDs for these entities that shall be used in the IDMP submissions (“Products” module) to follow later in the five iterations. The “Referentials” module shall provide the controlled vocabularies that are needed in each iteration for the description of the products.

Today, SPOR OMS is live and contains approximately 5,700 organisations with a total of 48,318 location data records. Each record contains at least the English language version of the address, plus GPS coordinates and sometimes address data also in other local languages. The vast majority of these organisations are pharmaceutical companies (99% resp. 5,625 organisations), but there are also 52 EEA and 4 non-EEA Regulatory Authorities, plus 11 other industry organisations.

The following table shows where the organisations are located: Approximately 13.68% (779) are located in the United Kingdom and approx. 11.75% in Germany (669); the shares of the each of the other countries are lower than 10%. Indian, Chinese and US companies are obviously underrepresented currently with only 0.3%, 0.02% and 2,35%, respectively.

Table 1: Listing of countries where OMS organisation are located

When a product submission is to be carried out, then it must refer to the OrganisationID as well as the LocationID given in the OMS for the MAH, MAA, CTS or the CMO companies, as is described above. If there is no data available, or the data is incomplete or wrong, the MAH has to request a corresponding OMS data change (which may take some time…).

Therefore, to avoid any delays in the submission process, the MAH has to make sure, that all the organisations (manufacturers, MAH, MAA; CTS) that are referred to in the product documentation/ dossier are already available in the OMS system long before the product is to be submitted and that the data are correct!

  1. How to Align Internal and External Organisation Databases

Assuming that an hypothetical MAH company uses a RIMS system to collect the data about products that are to be/ have been submitted and registered world-wide, and an internal company database, within which the data about the worldwide sites of the MAH company are kept, the process to synchronise the organisation data that resides in RIMS and/or the Organisaton Database looks very much like the sketch in the following figure:

Synchronisation of organisations external with internal data

Figure 1: Synchronization of Organisation between internal and the OMS system with the process flows for the registration of a new MAH company site (I) or adding a new external manufacturer/CMO (II)

  • When a newly founded site of the MAH’s company is to be included, e.g. as a manufacturer for a product or as a MAH/MAA, then the internal Organisation Database should first contain the details about that site, especially the address information. Therefore the Internal OrgDB is “the source of truth”, and the IDMP Office which coordinates the MAHs IDMP data maintenance activities has to make sure that the new site is entered into OMS as new organisation/location. The Organisation ID/ Location ID is to be retrieved and to be stored in the Internal systems (Internal OrgDB and RIMS).
  • When within the product dossier, specifically in module 3.2.P.3.1 – the Manufacturers document – a new (external) Contract Manufacturer is listed, then it needs to be located in EMA’s OMS system. The address details described there need to be verified against the dossier document, and, when the data is correct, the Organisation and Location Ids of the organisation should be entered into the RIMS system (and eventually other internal systems where the data about external manufacturing partners are kept…).
    So, in this case, the OMS system is “the source of truth”, and the internal systems “only” refer to that OMS data record.
    Should the CMO not be available in OMS, the MAH needs o request the addition of the CMO company, providing documented evidence about the respective CMO, e.g. a copy of the companies’ registration record, a copy of the Manufacturing or GMP license.
  1. The Potential Role of Masterdata Management IDMP SPOR OMS Sync in the Alignment of Internal and External Systems

When the number of organisations are low (< 50), the processes as described in the previous chapter might still be managed “manually”, e.g. combining and analysing periodical reports as well as change notifications from the internal and external systems, e.g. using Excel. But when the number of companies to be handled exceeds 150, or there is a large base of product registrations with distributed product responsibilities (and a large pool of RIMS users), then a more sophisticated solution will be needed.

Commercially available Master Data Management (MDM) systems are made to handle situations like these. The following abilities and features qualify MDM systems to be used for the purpose of organisation data synchronisation between the internal systems (RIMS and Internal OrgDB) with the external systems (SPOR-OMS, RMS etc.):

  • Carry out comparisons between organisations stored in internal and external systems, by comparing company names and address details, using exact and fuzzy matching.
  • Set up rules to accept or to reject a match based on the measures of similarity, with the option to define “acceptable” and “non-acceptable” deviations.
  • Keep an MDM internal list of the matching data tuples from internal and external systems.
  • Define workflows, roles and permissions to handle deviations, e.g. to correct a data error in an internal system, to request a missing CMO or MAH in OMS.
  • Use interfaces to directly access the internal and the SPOR OMS systems via APIs.
  • Set up recurring processes to look for changes in the internal and external systems that require updates in OMS or the internal systems.
    accept and handle notifications coming from internal and/or external systems making aware of a change in the data records stored in the respective system(s).
    start workflows to handle the detected discrepencies and/or deviations.
  • Allow to track the progress of the handling of deviations, completed and open tasks throughout the enterprise.

Besides these features the MDM solution also must allow to handle different regulatory environments, i.e. the European scenario including SPOR, but also an upcoming US scenario and other regions where other external databases (Dun and Bradstreet Database (DUNS)?) will or could be used as reference databases.
In the interest of better product data quality and reduced compliance risks, it probably is wise to implement the process of Organisation Management with a worldwide perspective and these other, non-European scenarios in the minds from the beginning.

  1. Conclusions and Outlook to the Masterdata Management IDMP SPOR OMS Sync

In the preparation for the upcoming IDMP standard a company needs to understand which internal and external data stores are be the sources-of-truth that shall be used for IDMP submissions. Once the sources are identified, a data governance process needs to be set up that includes the nomination of an IDMP office and the implementation technology tools, e.g. Master Data Management, in order to guarantee completeness and correctness data throughout the product’s lifecycle. When e.g. organisation data is missing or incorrect at the time of submission, it may mean that the IDMP product data record cannot be submitted technically or will be rejected as being incomplete. As this may result in a delay of the go-to-market of a new product, very significant financial losses might occur.


[1] RIMS: Regulatory Information Management System

[2] RMS: Referentials Management System, OMS: Organisations Management System, PMS: Products Management System and SMS: Substance Management System

Dieter Schlaps, ITCLS

Text Mining for IDMP – Kill or Cure?

Logo EMA

EMA Webinar Using OMS data in eAF (14.6.2018) Download

Using OMS data in eAF

(EMA SPOR webinar, 14 June 2018)


  1. About OMS
  2. Using OMS in eAF/CESP
  3. Submission of OMS Change Requests (CRs)
  4. Key messages
  5. OMS support & guidance
  6. Download Webinar (PDF)

1.) About OMS

2.) Using OMS in eAF/CESP

3.) Submission of OMS Change Requests (CRs)

4.) Key messages to Using OMS data in eAF

Using OMS data in eAF in a nutshell:

  • OMS dictionary (list of organisations with associated physical locations) can be used to support regulatory business processes
  • OMS content is growing and data quality is expected to improve over time
  • Business owner of the process using OMS data decides how/when to use it and mandates its use. OMS team will work closely with the business process owners
  • eAF will not mandate the use of OMS data, free text will still be available
  • CESP will mandate the use of OMS data in the form. Organisation data will have to be pre-registered in OMS and can be selected in CESP. This is not planned before Q3-2019 for Initial MA Applications
  • Applicants are advised to familiarise themselves with the use of OMS data and with the process before the use of OMS data will be mandated
  • Applicants and MAHs are responsible to register/update organisation data in OMS before regulatory submissions (e.g. Initial MAA, Var, Renewal)
  • Submission of OMS Change Requests for Veterinary MAH & MAAs for NAPs starts from September 2018

5.) OMS support & guidance

Reference documents accessible from the SPOR portal

  • OMS web user manual – guidance on OMS services, e.g. searching, exporting data, requesting CRs
  • SPOR user registration manual (how to register for SPOR)
  • SPOR affiliation template (to register the first industry super user)
  • Change Request  (CR) Validation in OMS
  • Organisation data quality standards in OMS
  • SPOR SLAs (SLA are indicative and will be reviewed in future)

Training videos

OMS training videos available to view on the @emainfo channel

EMA Website

EMA corporate website also includes SPOR related information, documents and material from webinars.

EMA Account Management Portal

To create a new EMA account in order to obtain access to EMA systems (including SPOR). To request SPOR user role.

Account Management Portal.

EMA Service Desk Portal

Service requests, issues, requests for technical support shall be submitted through the Service Desk Portal.

6.) Download Webinar







Logo EMA

Download SPOR API Documentation (version 1.14 published 9.1.2018)

Download SPOR API Documentation

Download SPOR API Documentation new edition ((version 1.14 published 9.1.2018) API schemas, OMS & RMS message formats and HL7) is accessible for interested parties for a free download in this website:

The latest version of the API specification incorporates the following additional information:

  • A description of how an implementing system must retain rowid elements in the creation, and later management, of change requests in RMS.
  • A description on the fields that have to be conditionally provided when dealing with both OMS and RMS change requests depending on the status and the data of such requests.
  • An explanation on how OMS retains compatibility for searching elements based on identifiers, even after they have been merged, and how the current identifier, of an element, is highlighted in the response data.
  • A description on what kind of change requests can be filed in OMS depending on the status of the referred organisation and/or location.
The API specification covers both RMS and OMS. This has been taken through consultation during April to July 2016 and the feedback has been incorporated in the specification (consultation is now closed).

Please note that in the SPOR API specification, the services are set out in Section 6 and those that are OMS-specific are marked 'O', RMS-specific are marked 'R', and services shared by both RMS and OMS are marked as  'RO'.

The documents have been shared with the SPOR Task Force and UAT testers.

For more details on IDMP SPOR please see the IDMP1 Wiki on IDMP SPOR

Download SPOR-API-Specification-1.14 published 09 January 2018 (PDF)



    Logo EMA

    Clinical Trials Portal

    Logo EMA

    EMA launched Referentials Management Service (RMS)

    EMA launched Referentials Management Service

    The European Medicines Agency (EMA) has launched the Referentials management service (RMS) and Organisations management service (OMS) to support EU-wide regulatory activities.

    The RMS and OMS manage two of the four domains of substance, product, organisation and referential (SPOR) master data in pharmaceutical regulatory processes. They lay the data foundations for delivering the substance and product data management services.

    The SPOR services support the implementation of ISO IDMP standards in the European Union (EU).

    Users can access information to these data services directly online via the SPOR portal.

    User registration

    EMA will invite national competent authorities and industry stakeholders to register their RMS and OMS users, starting with ‘super users’ who can authorise the registration of further users from the same organisation.

    However, the timetable is different for different stakeholders:

    National competent authorities:

    EMA invited national competent authorities to begin registering their super users and to use the RMS from June 2017;


    Update: EMA will invite industry stakeholders to begin registering their ‘super users’ from 15 December 2017 and other users from January 2018.

    For more information see the Referentials Management Service (RMS) and Organisations Management Services (OMS) user on-boarding plan.

    Logo EMA

    EMA Update IDMP SPOR September 2017

    EMA Update on IDMP SPOR September 2017

    4 September 2017, EMA/580454/2017, Information management division

    The EMA update IDMP SPOR September 2017 envisaged additional post implementation releases of RMS and OMS data services to enhance functionality (please see the plan below). The first improvements to these data services were released on 10 August 2017 (release notes are available from the SPOR portal). Two more releases of RMS and OMS are planned for 2017:

    • RMS & OMS version 2.2, planned for 16 October 2017;
    • RMS & OMS version 2.3, planned for 17 November 2017.

    Prior to the version 2.2 the EMA will run another round of OMS user acceptance testing (UAT), commencing 15 September 2017. The scope of this round of the OMS UAT will cover functional areas not tested, or which were unsuccessful, in the previous UAT held in March/April 2017.


    Participation in this UAT is open only to those testers who participated in the previous round of UAT, plus those Industry Vendors who submitted a request during the recent Call for Expressions of Interest (closed Thursday 31 August).
    The results of this round of UAT should be issued formally before the end of October 2017. Defects reported are expected to be fixed and included in version 2.3, due for release in November 2017.
    A slide deck from the OMS UAT preparatory webinar held on 1 September 2017 can be accessed here (choose documents / view).

    Following the October 2017 release (version 2.2), EMA will invite industry stakeholders to begin registering their Super Users and Users. Precise date will be communicated during October.