Search Results rg_dss_seg_range_sets




Overview
Explore in AI Chat

Overview

The RG_DSS_SEG_RANGE_SETS table is a core data object within the Application Report Generator (RG) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It serves as a master definition table for reusable filter components known as range sets. In the context of the Report Generator's Decision Support System (DSS), a range set is a named collection of segment value ranges or selections. These sets provide a centralized mechanism for defining complex filtering criteria, such as lists of account numbers, cost centers, or product categories, which can be consistently applied across multiple financial reports, inquiries, and allocations. Its primary role is to enforce data integrity and promote reusability in the report definition and data selection process.

Key Information Stored

The table stores the fundamental metadata that defines a range set. While the full column list is not detailed in the provided excerpt, the documented primary and unique keys highlight the most critical fields. The RANGE_SET_ID column is the system-generated, numeric primary key that uniquely identifies each range set record. The NAME column holds the unique, user-defined identifier for the range set, which is used for selection and reference within the application's user interface and reporting definitions. Other typical columns in such a table, though not explicitly listed, would likely include creation date, created by, last update date, last updated by, and a description field to document the purpose of the range set.

Common Use Cases and Queries

The primary use case is the administration and auditing of defined range sets. System administrators or report developers query this table to understand available filters, diagnose reporting issues, or clean up unused definitions. A common query retrieves all range sets, often joined with related tables to see their full composition. For instance, to list all range sets and their associated segment ranges, one might use a query pattern such as:

  • SELECT rs.name, rs.range_set_id, sr.segment_value_low, sr.segment_value_high FROM rg_dss_seg_range_sets rs, rg_dss_seg_ranges sr WHERE rs.range_set_id = sr.range_set_id ORDER BY rs.name;

Another critical scenario involves impact analysis before modifying or deleting a range set. Developers would query the foreign key relationships to identify all dependent report components that would be affected by the change.

Related Objects

The RG_DSS_SEG_RANGE_SETS table is a central hub in the Report Generator's data model, with several key tables referencing its primary key. As documented in the provided relationship data:

  • RG_DSS_DIM_SEGMENTS: References this table via RG_DSS_DIM_SEGMENTS.RANGE_SET_ID. This links range sets to specific dimensions or segments used in report structures.
  • RG_DSS_SEG_RANGES: References this table via RG_DSS_SEG_RANGES.RANGE_SET_ID. This is the child table that stores the individual high and low value ranges that constitute the filter defined in the parent range set.
  • RG_DSS_VAR_SELECTIONS: References this table via RG_DSS_VAR_SELECTIONS.RANGE_SET_ID. This links range sets to variable selection criteria, allowing dynamic filtering based on user input or system variables.

These relationships illustrate that a single defined range set in RG_DSS_SEG_RANGE_SETS can be applied to multiple report dimensions, consist of multiple value ranges, and be utilized in variable reporting contexts.