Search Results gr_disclosures




Overview
Explore in AI Chat

Overview

The GR_DISCLOSURES table is a core data object within Oracle E-Business Suite Release 12.1.1 and 12.2.2, specifically for the Process Manufacturing Regulatory Management (GR) module. It functions as the master repository for defining disclosure rules and thresholds for chemical ingredients or substances. The table's primary role is to standardize and centralize the regulatory reporting criteria—such as minimum reporting levels and required label text—that must be applied when generating safety data sheets (SDS), labels, or other compliance documents for products containing these ingredients across different jurisdictions.

Key Information Stored

While the full column list is not detailed in the provided metadata, the description explicitly states the table contains disclosure information along with specific reporting levels. Based on standard module functionality and the description, the table is anchored by a DISCLOSURE_CODE (the primary key) which uniquely identifies each disclosure rule set. For each code, the table stores quantitative and qualitative thresholds, including the Minimum Reporting Level, Text Reporting Level, Label Reporting Level, Exposure Reporting Level, and Toxicity Reporting Level. These columns define the concentration thresholds at which an ingredient triggers various disclosure requirements on regulatory documents.

Common Use Cases and Queries

The primary use case is determining if and how an ingredient must be disclosed on a document for a specific country or recipient type. A common query involves joining GR_DISCLOSURES to item-specific tables to assess compliance. For example, to list all disclosure rules, a basic SELECT statement such as SELECT disclosure_code, minimum_reporting_level, label_reporting_level FROM gr.gr_disclosures; is used. More operationally, to validate an item's formulation against disclosure rules, one would join GR_DISCLOSURES with GR_ITEM_DISCLOSURES and product ingredient tables, comparing the ingredient's percentage concentration to the stored reporting levels to determine the required disclosure actions.

Related Objects

The GR_DISCLOSURES table is a central reference point within the Regulatory Management schema, as evidenced by its multiple foreign key relationships. The documented relationships are:

  • GR_COUNTRY_PROFILES: Links via GR_COUNTRY_PROFILES.DISCLOSURE_CODE to associate disclosure rules with specific country regulations.
  • GR_DOCUMENT_PRINT: Referenced twice, via GR_DOCUMENT_PRINT.DISCLOSURE_CODE_COUNTRY and GR_DOCUMENT_PRINT.DISCLOSURE_CODE_RECIPIENT, to determine the applicable disclosure rules based on destination country and document recipient type during document generation.
  • GR_ITEM_DISCLOSURES: Links via GR_ITEM_DISCLOSURES.DISCLOSURE_CODE to assign specific disclosure rule sets to individual inventory items or ingredients.
  • GR_RECIPIENT_INFO: Links via GR_RECIPIENT_INFO.DISCLOSURE_CODE to define disclosure rules for categories of recipients (e.g., consumer, industrial).

These relationships illustrate how the master data in GR_DISCLOSURES governs regulatory logic at the country, item, recipient, and document printing levels.