Search Results combination_group_number




Overview
Explore in AI Chat

Overview

The GR_SAFETY_COMBINATIONS table is a core data object within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Process Manufacturing Regulatory Management (GR) module. It serves a critical function in managing complex regulatory and safety documentation for manufactured products. The table's primary role is to define the logical rules for combining multiple, discrete safety phrases into coherent, formatted statements. This enables the system to generate comprehensive safety data sheets (SDS) or product labels that accurately reflect the aggregated hazards and precautions associated with a material by specifying the grouping and sequencing of individual safety phrase codes.

Key Information Stored

The table stores metadata that governs the assembly of safety phrases. Its structure is defined by a composite primary key and foreign key relationships to ensure data integrity. The most important columns include:

The dual foreign key design indicates the table manages relationships between safety phrases themselves, not just a simple list.

Common Use Cases and Queries

A primary use case is the automated generation of regulatory documents. When the system compiles safety information for a product ingredient, it queries this table to determine if any of the applicable safety phrases have predefined combination rules. A typical query would retrieve all combination rules for a given set of safety phrase codes to pre-format label text. For example: 

SELECT combination_group_number, combination_sequence_number,
       safety_phrase_code, safety_phrase_code_combo
FROM gr.gr_safety_combinations
WHERE safety_phrase_code IN ('H318', 'H410')
ORDER BY combination_group_number, combination_sequence_number;
This would reveal if phrases 'H318' and 'H410' are part of a defined combination group and their required sequence. Reporting use cases include auditing combination rules for compliance with regional regulatory updates or validating that all active safety phrases in the system have proper combination logic defined.

Related Objects

The GR_SAFETY_COMBINATIONS table has direct, documented dependencies within the GR module schema, primarily with the master safety phrase table.

  • GR_SAFETY_PHRASES_B: This is the master table for safety phrase definitions. GR_SAFETY_COMBINATIONS has two foreign key relationships to it:
    • From SAFETY_PHRASE_CODE to GR_SAFETY_PHRASES_B
    • From SAFETY_PHRASE_CODE_COMBO to GR_SAFETY_PHRASES_B
    These relationships ensure that only valid, registered safety phrase codes can be used in combination rules. The table is central to the regulatory engine, and its data is likely referenced by various product safety and labeling APIs within the GR module to construct final output text.