Extensibility and Integrations Framework

Use this utility to develop and deploy business extensions and cloud integrations into Oracle Argus Cloud Service.

What does it do?

The Extensibility and Integrations Framework allows you to develop business extensions and cloud integrations in the Oracle Argus Cloud using PL/SQL code.

With this utility, you can deploy and utilize custom database objects through a special customized schema, by leveraging the reporting and ETL extensibility without impacting the out-of-the-box database objects supplied by Oracle Argus Safety.

Extensibility and Integrations Use Cases

The following use case examples provide a high level overview of what you can do with this framework:

• Cloud Integration. You can directly access your database to push periodic updates to the central repository to downstream applications such as Oracle Argus Safety to maintain compliance.

  Master Data Load	When you maintain a central repository (custom and/or 3rd party such as SAP or Oracle Agile PLM etc.) to store master data, you can push periodic updates for the following field types to maintain compliance: Company products and licenses Study information Datasheets Product lot numbers Product distribution data.
  Reference Data Load	When you maintain a central repository to reference data, you can push updates for: MEDDRA - Synonym list, Event list, etc. Reporter data and institution data load.
  Argus Configuration Data Load	Reduces the effort required to manually configure data load through the Oracle Argus Safety application. Argus accelerators built by customers and partners automate the Argus Configuration data loading process. For example, Codelist, Reporting rules, Product-Study data load, Case Processing rules, Workflow rules etc.

• Business Extensions. You can now directly extend business rules by writing your own packages using the following extensions:

  Pre/Post Case Save Business Extension

  You can configure extensions in the Case Save extension hooks to: Add Validation Logic. Update Case Data – user defined fields, generate Action Items, Event Assessment. Populate custom tables for Reporting/Analysis. Use PL/SQL functions, Procedures, or Packages. Audit Case Data.

  Case Processing Automation

  Medical Narrative Placeholders Summarize all relevant clinical and related information, including patient demographics, therapy details, medical history, clinical course of the event(s), relevant laboratory evidence, and any other information that contributes to an adverse event (AE) assessment. Contain adequate information to serve as a comprehensive stand-alone “medical story”. Have a corresponding SQL statement to be executed by the respective narrative. Letter Templates Placeholders: Letter templates are defined by the Safety department to perform Case Queries or/and follow-up Case Processing via email. Specialized letter templates are created for specific Products and/or Events such as Cancer therapies, Pregnancy cases etc. Placeholders have a corresponding SQL statement to be executed by the respective letter template. They are important to Argus Case processing, save manual effort, and enable good PV practices. Case Data Update as per changes in the Master Data: Datasheet changes trigger Event Assessment.

How do I get it?

You need to create a change request (CR) in Life Sciences Customer Support Portal, asking for access to the Argus Cloud Extensibility and Integrations Framework utility.

Where can I find more information?

Log in to My Oracle Support and search for the following article: 2682378.1. Locate the Release Notes for Extensibility and Integrations Framework.