Search Results gr_additive_calcs




Overview
Explore in AI Chat

Overview

The GR_ADDITIVE_CALCS table is a core data object within the Process Manufacturing Regulatory Management (GR) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as a master repository for regulatory calculation definitions, specifically those used to determine the hazard classification and risk phrases for chemical substances or mixtures based on additive rules. This table is central to the system's ability to automatically assign and apply standardized hazard and risk information in compliance with regulations such as the European CLP (Classification, Labelling and Packaging) regulation. Its primary role is to store the foundational calculation records that are referenced by various subsidiary tables containing specific concentration limits and mandatory risk phrases.

Key Information Stored

The table's structure is designed to hold the essential identifiers and classification codes for a regulatory calculation. The primary and most critical column is CALCULATION_ID, which uniquely identifies each additive calculation rule. Two other key optional columns store the regulatory codes to be applied: HAZARD_CLASSIFICATION_CODE, which represents the hazard class (displayed as "Hazard to Assign"), and RISK_PHRASE_CODE, which represents the associated risk phrase (displayed as "Apply Risk Phrase"). The optional nature of these codes indicates that a calculation record may define a rule that is later linked to specific hazards or risks through related child tables.

Common Use Cases and Queries

This table is primarily accessed for regulatory reporting, data validation, and process automation within the GR module. A common use case is generating a list of all defined additive calculations to audit the regulatory rule base. Another critical scenario involves tracing the complete regulatory profile for a substance by joining this master table with its related detail tables on CALCULATION_ID. For example, to retrieve all calculations along with their linked mandatory risk phrases, a query would join GR_ADDITIVE_CALCS to GR_ADD_MANDATORY_RISKS. A typical reporting query pattern is:

  • SELECT calc.calculation_id, calc.hazard_classification_code, calc.risk_phrase_code FROM gr.gr_additive_calcs calc WHERE calc.hazard_classification_code IS NOT NULL;

This table is also pivotal in backend processes where the system evaluates a product's composition against stored additive rules to determine its final regulatory classification for safety data sheets and labels.

Related Objects

The GR_ADDITIVE_CALCS table has defined foreign key relationships with several other GR module tables, forming a key hub in the regulatory data model. It references the GR_EUROHAZARDS_B table via its HAZARD_CLASSIFICATION_CODE column to validate and obtain details on the specific hazard class. More significantly, its primary key (CALCULATION_ID) is referenced as a foreign key by three important child tables:

  • GR_ADD_MANDATORY_RISKS: Links calculations to specific mandatory risk phrases that must be applied (join column: CALCULATION_ID).
  • GR_EIN_ASL_CONCS: Stores concentration limits for specific substances (join column: CALCULATION_ID).
  • GR_EURO_DEFAULT_CONCS: Stores default concentration limits used in calculations (join column: CALCULATION_ID).

These relationships confirm that GR_ADDITIVE_CALCS acts as a parent table, with child tables providing the detailed parameters and results that complete the additive calculation rule.