Search Results gr_euro_mandatory_risks




Overview
Explore in AI Chat

Overview

The GR_EURO_MANDATORY_RISKS table is a core data structure within the Oracle E-Business Suite (EBS) Process Manufacturing Regulatory Management (GR) module, specifically for releases 12.1.1 and 12.2.2. Its primary function is to enforce regulatory compliance by defining the mandatory Risk Phrase (R-phrase) codes that must be associated with a specific chemical hazard during its classification under European Union directives, such as CLP (Classification, Labelling and Packaging). This table acts as a rule set, ensuring that product safety data sheets and hazard communications generated by the system adhere to the precise legal requirements of the European regulatory framework by automatically linking hazards to their compulsory risk statements.

Key Information Stored

The table's structure is designed to map mandatory risk phrases to specific hazard concentration thresholds. Its primary key is a composite of two columns, establishing a unique rule. The RISK_PHRASE_CODE column stores the code for the risk phrase that is legally required. The CONCENTRATION_SEQNO column holds a sequence number that acts as a foreign key to concentration-level data, linking the mandatory risk phrase to a specific concentration range or threshold defined for the hazard. This two-part key ensures that for a given hazard at a defined concentration level, the correct set of mandatory risk phrases is unequivocally applied.

Common Use Cases and Queries

The primary use case is the automated generation of compliant hazard classifications and safety documentation. When a user classifies a substance or mixture within the GR module, the system queries this table to determine which risk phrases must be appended to the hazard, preventing omissions. A typical reporting query would join this table to its referenced lookups to produce a list of all enforced rules. For example:

  • Listing All Mandatory Risk Rules: SELECT m.risk_phrase_code, r.phrase_text, m.concentration_seqno FROM gr_euro_mandatory_risks m, gr_risk_phrases_b r WHERE m.risk_phrase_code = r.risk_phrase_code;
  • Validating Classifications: The system internally uses this table to validate that a hazard classification proposal includes all mandatory phrases before finalization.
  • Regulatory Reporting: Data from this table underpins reports that demonstrate compliance with specific EU directives for internal audits or regulatory submissions.

Related Objects

The GR_EURO_MANDATORY_RISKS table is centrally connected to two key reference tables via foreign key constraints, forming a critical part of the regulatory data model.

  • GR_RISK_PHRASES_B: This table is referenced via the RISK_PHRASE_CODE column. It contains the master list of all risk phrases, providing the full textual description (e.g., "Flammable liquid") for the codes stored in GR_EURO_MANDATORY_RISKS.
  • GR_EURO_DEFAULT_CONCS: This table is referenced via the CONCENTRATION_SEQNO column. It defines the default concentration ranges or thresholds for substances, allowing the system to determine which mandatory risk phrases apply based on the concentration level of a hazardous component in a mixture.