Search Results gr_safety_categories_b




Overview
Explore in AI Chat

Overview

The GR_SAFETY_CATEGORIES_B table is a core reference data object within the Process Manufacturing Regulatory Management (GR) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the master repository for safety category codes, which are integral to the European chemical classification and labeling process. This table underpins regulatory compliance by providing standardized codes that define hazard categories for substances and mixtures, enabling consistent application of safety rules and generation of compliant labels across the enterprise.

Key Information Stored

While the provided metadata does not list specific columns beyond the primary key, the structure of the table is designed to hold reference information for each safety category. The primary column is SAFETY_CATEGORY_CODE, which uniquely identifies each category. Typically, such a table would also contain descriptive columns, such as a name or description (potentially in a related GR_SAFETY_CATEGORIES_TL translation table for multilingual support), and possibly an effective date range or enabled flag. The data stored in this table is foundational, acting as a controlled list of valid codes that other transactional and regulatory tables must reference.

Common Use Cases and Queries

The primary use case for this table is the maintenance and validation of regulatory safety data. Administrators use it to define the universe of permissible safety categories. Common operational queries involve listing all active categories for setup purposes or validating a code before assigning it to a substance. A typical reporting query might join this table to related label or rule data to analyze which categories are in use.

  • Basic Lookup: SELECT safety_category_code FROM gr.gr_safety_categories_b WHERE enabled_flag = 'Y';
  • Reporting Join: SELECT sc.safety_category_code, lb.label_code FROM gr_safety_categories_b sc, gr_labels_b lb WHERE sc.safety_category_code = lb.safety_category_code;

Related Objects

The GR_SAFETY_CATEGORIES_B table is centrally linked to key regulatory entities via foreign key relationships, as documented in the ETRM metadata. Its primary key is referenced by the following tables:

  • GR_LABELS_B: The GR_LABELS_B.SAFETY_CATEGORY_CODE column references this table. This relationship ensures that labels generated for products are associated with a valid, predefined safety category.
  • GR_SAFETY_RULES: The GR_SAFETY_RULES.SAFETY_CATEGORY_CODE column references this table. This links specific regulatory safety rules and thresholds to the appropriate hazard category, forming the basis for automated classification.

These relationships enforce data integrity, ensuring that safety classifications on labels and within rules are always based on an authorized master list of categories.