Oracle eTMF

With release 24.2.1, we are pleased to introduce Oracle Life Sciences eTMF.

Oracle eTMF provides life sciences organizations with a cloud-based electronic trial master file (eTMF) solution for maintaining and storing essential documents and content related to clinical trials for ensuring inspection readiness. Life sciences trial sponsors and CROs must adhere to the regulatory requirements for planning, managing and storing clinical trial documents and information in a Trial Master File (TMF) compliant with the industry standards defined and maintained by CDISC.

Since Oracle eTMF is built on the same platform as the Study Start Up Oracle Site Activate solution, customers will have the option to subscribe to the Oracle eTMF and Oracle Site Activate solutions independently or take advantage of using both Oracle Site Activate + eTMF together on a single platform. There are many innovative benefits with using both solutions, such as the same artifact, same file, and same workflow lifecycle can be leveraged end-to-end from the initial creation of the document placeholder for site activation, to uploading files, reviewing, and filing in the TMF. A single, unified Oracle Site Activate + eTMF process can provide earlier visibility to study documents for TMF users and reduce the time from initial receipt to filing in the TMF.

Oracle eTMF is a repository used to collect essential documents related to proper study conduct and the quality of the study’s data. When contracted for your account, users in your organization can manually upload documents, or the documents can be transferred via integration from other systems (e.g., CTMS). Oracle eTMF uses document metadata attributes and permission controls to govern document access.

The 24.2.1 release supports the industry-standard CDISC TMF Reference Model, version 3.3.1. As CDISC releases updated specifications, Oracle eTMF will maintain compliance with the standard through necessary product updates.

Business role permissions

Oracle eTMF has four related business role permissions:

  1. Enable access to Oracle eTMF: You can see the navigation from Oracle Site Activate to TMF pages and access TMF viewer URLs for TMF functionality.
  2. Enable access to unblinded documents: You can access an unblinded (restricted) document (i.e., a document with the lock icon in the user interface).
  3. Enable TMF status change: You can see the TMF status as an editable drop-down and you can change the status in the document modal and in the TMF viewer.
  4. Enable eTMF Export: You can see the Export button in the TMF viewer to generate a Study TMF export zip file.

TMF Viewer

When you have Enable access to Oracle eTMF business role permission, you can access the new TMF Viewer page, which is the hub for TMF document management. The viewer has two sections:

  1. A folder tree to the left includes the TMF folder levels listed below. You can adjust the folder tree to your preferred view using Expand/Collapse, Hide empty folders, and Hide folder tree options.
    1. TMF Zones: first-level folders
    2. TMF Sections: second-level folders
    3. TMF Artifacts: third-level folders that contain one or more documents. Each uploaded file will be associated with an artifact.
  2. A document grid to the right lists the documents and contracts contained in the folders of the TMF Viewer folder tree. You can adjust displayed columns by clicking the column selector Column selector button to show/hide available columns. The customized column selection will be saved per user. You can also sort columns by clicking the column header.

Between the two sections, you’ll see a divider line. Adjust the width of the tree and grid sections by grabbing the line with your cursor and sliding the divider left or right.


TMF viewer with tree structure visible on the left and document grid to the right

Search component

The TMF Viewer features an enhanced searching component displayed above the document grid. Search by any of the following methods:

  • Click the buttons below the text search field to use default filters. When you select a default filter, it gets pinned in the search bar. Click the filter again to display the available list of values. You can also search for a specific value to select.
    • Files Attached or Not Attached (default is Attached)
    • Activity (select multiple with search bar)
    • TMF Status (select multiple with search bar)
    • Country (select multiple with search bar)
    • More Filters drop-down list with Site Number or Investigator (select multiple with search bar)
  • Click the search bar to see a list of filterable columns:
    • Document Date
    • Revision
    • Document Status
    • Last Updated (user time zone)
    • File Upload date
  • You can look for a free text string among all the searchable columns by entering it in the search field. Searchable columns are:
    • Document Name
    • Document ID
    • File Name
    • Version ID
    • Protocol
    • Person
    • Last Updated By
    • File Uploaded By

TMF viewer enhanced search bar displays above the document grid

Open document modal from TMF Viewer

You can access the document model from the grid to see document information or complete activities. At any row in the TMF viewer’s document grid, click the document name or the action button in the Activity column (if available) to open the associated document modal.

You can upload a file, adjust metadata, specify dates, etc., within the modal. You’ll also see the “TMF Status” field in the gray document activities panel or under the document info. When you have Enable TMF status change business role permission, you can update the status to any one of the available statuses:

  • Not Applicable
  • Not Started
  • Received from Site
  • Collected
  • Ready for Review
  • Approved
  • Rejected
  • TMF Ready
  • Inspection Ready
  • Obsoleted
  • Superseded

You can choose to turn on or off any of the statuses and you can also update the display name of any statuses with the help of your service lead.

By design, if you don’t have Enable access to unblinded documents permission, you cannot open the document modal from the TMF Viewer, and the file link will not be clickable for any item marked as unblinded. If you don't have the permission, you can still view blinded (unrestricted) items.


Document modal showing enabled TMF Status drop-down list

TMF Export

When you have the Enable TMF export business role permission, you can export documents for the entire study using the TMF viewer’s Export button.

The export feature generates a comprehensive export of all available files in the documents across the entire study and relevant metadata information in ZIP file format. Your permission to access unblinded documents further restricts export content. For example, if you have Enable TMF export permission and Enable access to unblinded documents permission, the export contains the files on all documents, including the unblinded documents. However, if you don’t have access to unblinded documents, the export includes the files on all the documents EXCEPT the unblinded documents.

When you click Export, a drawer control opens from the TMF viewer’s right side. In this drawer, you’ll see your available exports (if any) and the export’s upcoming expiration (seven days from the creation date). When an export is available for download (i.e., not currently processing), the drawer's Download button will be enabled for use. At the bottom of the drawer, you’ll see the option to create a New Export, including a check box option to include Files. Click the Files check box to enable the Create button. Note that creating an export will overwrite an existing export.

By design, you can create only one export at a time. You’ll know the export is in progress by the status shown inside the drawer and by the TMF Viewer’s Export button icons, which update to show in progress or completed.

The exported ZIP file will include all current versions of the file on the documents for a study regardless of document status (“current” as of the datetime of the request). The generated file will be in the same structure as the TMF study folder structure, and will be split up into study/country/site/staff/PI folders accordingly, but will not include folders without files.


Study TMF export drawer showing one unexpired export available for download and the controls required to create a new replacement export

Access TMF documents outside of the TMF viewer

Oracle eTMF permission controls are in place to allow feature access and prevent access to unblinded (restricted) TMF documents if appropriate. You can identify restricted documents by the lock icon Locked padlock, which displays on all unblinded documents regardless of your access permission. To interact with unblinded documents, you must have the Enable access to unblinded documents business role permission.

When you have permission to access unblinded documents, you can click the documents to open or select them from any area where you see the document name (e.g., your Document activities list). When you do not have permission, you will have access to the document only if it has sub-items that are not unblinded. For instance, within a contract document modal, sub-item tabs that require unblinded documents permission are locked (grayed out), and you can’t interact with them. In other areas, such as the Study home page “Your Tasks” list, the Activity name will not be clickable, and you’ll see the lock next to the name.

Please get in touch with your organization’s account administrator to request access to unblinded documents if appropriate to your role.

Navigate to other areas

When you sign into Oracle eTMF, the TMF Viewer displays by default. At the top left, click menu Menu to expand a list of navigational links to other functional areas. Navigation options in the left menu reflect your business role permissions. For example, you’ll see Quarantined Files in the new menu’s More section only if you have been granted permission to access that area.


Oracle eTMF vertical navigation menu with all permissioned areas displayed

You'll also see a menu under your user badge at the upper right of your screen. Again, options available to you in this drop-down menu reflect your assigned business role permissions (i.e., you will see Admin and Settings options only if you have been granted permissioned access to these areas).


Oracle eTMF user badge menu

Unblinded document access audit

Oracle eTMF audits all user access to unblinded document file attachments. When you preview or download the file attachment for an unblinded document, it records the following information:

  • User email
  • Timestamp
  • Artifact ID
  • File name
  • Action (preview or download)

The creation of the access audit record applies only to unblinded documents. It is triggered when an authorized user accesses the file from any access point in Oracle Site Activate.

Note:

With release 24.2.1, the access audit is available to your organization upon request. Please get in touch with your Oracle services representative to request the audit report.