Search Results range_set_id




Overview
Explore in AI Chat

Overview

The RG_DSS_SEG_RANGE_SETS table belongs to the RG (Application Report Generator) product within Oracle E-Business Suite, and its documented purpose is to store filter definitions. In EBS 12.1.1 and 12.2.2, the Application Report Generator provides the flexible reporting infrastructure used by Oracle's standard reporting tools, and range sets represent named collections of key flexfield or dimension segment ranges that constrain the data returned by a report. Each row in RG_DSS_SEG_RANGE_SETS defines a reusable filter — a named range set — that can be applied against a dimension segment, an account structure, or a report variable selection. The table therefore acts as the central definition point for filtering logic that downstream dimension segments, segment range lines, and variable selections reference by foreign key.

The documented physical schema in ETRM 12.2.2 shows the table owned by RG with 27 columns and a primary key named RG_DSS_SEG_RANGE_SETS_PK on RANGE_SET_ID. Two unique indexes exist: RG_DSS_SEG_RANGE_SETS_U1 on RANGE_SET_ID and RG_DSS_SEG_RANGE_SETS_U2 on NAME. Based on the foreign-key topology, the heuristic Data Vault classification of this table is hub-leaning: RANGE_SET_ID serves as the durable business key around which dependent satellite-style rows for range lines, dimension segments, and variable selections cluster.

Key Information Stored

The most significant columns in RG_DSS_SEG_RANGE_SETS are:

  • RANGE_SET_ID — surrogate primary key (RG_DSS_SEG_RANGE_SETS_PK) and also the target of all three foreign keys that reference this table.
  • NAME — the user-visible range set name; it is a business-key candidate enforced by unique index RG_DSS_SEG_RANGE_SETS_U2.
  • APPLICATION_COLUMN_NAME — identifies the application column or context against which the range set applies.
  • ID_FLEX_CODE — the key flexfield code the range set is associated with.
  • ID_FLEX_NUM — the specific flexfield structure number used to resolve the range set's segment semantics.
  • DESCRIPTION — free-text description of the filter's purpose.
  • CONTEXT — descriptive flexfield context value governing which attribute columns are active.
  • ATTRIBUTE1 through ATTRIBUTE15 — the standard descriptive flexfield segment columns used to store additional filter metadata.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — the standard EBS audit columns.

The surrogate key (RANGE_SET_ID) and the business key (NAME) are both uniquely indexed, so either can be used for lookup, though joins across the dependent tables should rely on RANGE_SET_ID.

Common Use Cases and Queries

Typical scenarios involve resolving a range set by name and then retrieving its associated segments, range lines, or variable selections for reporting. A common pattern is:

  • Listing all range sets for a given flexfield: SELECT RANGE_SET_ID, NAME FROM RG_DSS_SEG_RANGE_SETS WHERE ID_FLEX_CODE = :code;
  • Resolving range set ranges for report output: joining RG_DSS_SEG_RANGE_SETS to RG_DSS_SEG_RANGES on RANGE_SET_ID.
  • Auditing recently modified filters using LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, and CREATED_BY.
  • Reporting on descriptive flexfield context values by grouping on CONTEXT and ATTRIBUTE columns.

Related Objects

The most significant dependent objects, based on the documented foreign keys, are:

  • RG_DSS_DIM_SEGMENTS — references RG_DSS_SEG_RANGE_SETS via RANGE_SET_ID.
  • RG_DSS_SEG_RANGES — references RG_DSS_SEG_RANGE_SETS via RANGE_SET_ID; holds the individual range lines.
  • RG_DSS_VAR_SELECTIONS — references RG_DSS_SEG_RANGE_SETS via RANGE_SET_ID; binds range sets to report variables.

Together these three tables form the dependent layer around the RG_DSS_SEG_RANGE_SETS hub, and any reporting or data-migration work on range sets should account for all three foreign-key references to maintain referential integrity.