Search Results gr_add_mandatory_risks




Overview
Explore in AI Chat

Overview

The GR_ADD_MANDATORY_RISKS table is a core data structure within the Process Manufacturing Regulatory Management (GR) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It is designed to manage regulatory compliance for products in the European market by storing mandatory European Hazard Classifications, specifically Risk (R) Phrases. The table operates in conjunction with the Additive table (GR_ADDITIVES_B), functioning as a child table within a calculation framework. Its primary role is to define and enforce the regulatory risk phrases that are compulsory for a given additive or substance based on its composition and concentration, as determined by a specific regulatory calculation.

Key Information Stored

The table's structure is defined by a composite primary key, which dictates the fundamental data it contains. The key columns are RISK_PHRASE_CODE and CALCULATION_ID. The RISK_PHRASE_CODE stores the unique identifier for a specific European hazard statement (e.g., R45 - May cause cancer). The CALCULATION_ID is a foreign key that links the mandatory risk phrase to a specific regulatory calculation instance stored in the GR_ADDITIVE_CALCS table. This linkage is critical, as it contextualizes the risk phrase, tying it to the precise formula, ingredient percentages, and regulatory rules that triggered its mandatory application for a product. The table does not store descriptive text for the risk phrases; that information is maintained in the related GR_RISK_PHRASES_B table.

Common Use Cases and Queries

The primary use case is generating regulatory documents, such as Safety Data Sheets (SDS) or product labels, that must legally declare all applicable hazard classifications. A typical query would join this table to retrieve a list of mandatory risk phrases for a specific product or additive calculation. For example, to report all mandatory risks for a given calculation ID, one might use:

  • SELECT rp.RISK_PHRASE_CODE, rp.DESCRIPTION
  • FROM GR_ADD_MANDATORY_RISKS amr,
  • GR_RISK_PHRASES_B rp
  • WHERE amr.RISK_PHRASE_CODE = rp.RISK_PHRASE_CODE
  • AND amr.CALCULATION_ID = :calc_id;

This data is also essential for compliance validation checks, ensuring that no mandatory classifications are omitted from finished product regulatory profiles.

Related Objects

The GR_ADD_MANDATORY_RISKS table is centrally connected within the GR module's schema through defined foreign key relationships. It is a child table to two key master tables:

  • GR_ADDITIVE_CALCS: Linked via the CALCULATION_ID column. This table holds the results of regulatory calculations performed on additives or formulations.
  • GR_RISK_PHRASES_B: Linked via the RISK_PHRASE_CODE column. This table is the master repository for all valid Risk (R) Phrase codes and their textual descriptions.

These relationships ensure data integrity, meaning a record in GR_ADD_MANDATORY_RISKS cannot exist without a valid, pre-existing calculation and a valid, pre-defined risk phrase. The table's data is ultimately sourced from and supports the additive definition in GR_ADDITIVES_B through the calculation engine.