Search Results rg_dss_seg_range_sets_u1

Overview

RG_DSS_SEG_RANGE_SETS is a table owned by the RG schema within Oracle E-Business Suite, documented under FND Design Data as RG.RG_DSS_SEG_RANGE_SETS. It is part of the Oracle Grants / ETRM (Enterprise Transaction and Reporting Model) infrastructure that supports flexible segmentation and dimensional filtering of grants and awards data. The table stores named filter definitions—referred to within the column comments as "Filter defining column," "Filter name," and "Filter description"—that describe which key flexfield segment or application column should be used to constrain data. Each row represents a range set definition: a reusable specification for selecting and partitioning dimensional values.

From a data modeling perspective, the heuristic Data Vault classification supplied for this object is hub-leaning. This suggests that RANGE_SET_ID functions as a durable business key hub, with dependent detail (the flexfield code, structure number, and descriptive attribute columns) carried alongside. In practice, RG_DSS_SEG_RANGE_SETS acts as a parent or reference table for several child tables that consume its RANGE_SET_ID.

Key Information Stored

The table contains 27 documented columns. The most significant are:

• RANGE_SET_ID (NUMBER 15, mandatory) — The surrogate primary key, defined by constraint RG_DSS_SEG_RANGE_SETS_PK. It also anchors the unique index RG_DSS_SEG_RANGE_SETS_U1.
• NAME (VARCHAR2 60) — The filter name. This is a business-key candidate, enforced by the unique index RG_DSS_SEG_RANGE_SETS_U2.
• APPLICATION_COLUMN_NAME (VARCHAR2 30) — The name of the column containing the segment used by the filter. It is indexed non-uniquely by RG_DSS_SEG_RANGE_SETS_N1.
• ID_FLEX_CODE — The key flexfield code identifying which flexfield structure the filter targets.
• ID_FLEX_NUM (NUMBER 15) — The key flexfield structure number, narrowing the filter to a specific structure.
• DESCRIPTION (VARCHAR2 240) — Human-readable description of the filter.
• CONTEXT (VARCHAR2 30) — Descriptive Flexfield context, used when the range set references DFF segments.
• ATTRIBUTE1 through ATTRIBUTE15 (VARCHAR2 150, with ATTRIBUTE12 truncated to 1 in the excerpt) — Descriptive Flexfield segment columns providing extensibility.
• Standard Who columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, and CREATED_BY provide audit tracking.

Common Use Cases and Queries

Because this table drives dimensional filtering within the RG schema, typical usage involves resolving a named filter to its underlying segment definition, or listing all range sets for a given flexfield structure. A common reporting pattern joins the parent to its segment children:

• Lookup by business key: SELECT range_set_id, name, id_flex_code, id_flex_num FROM rg.rg_dss_seg_range_sets WHERE name = :p_name;
• Segment discovery: query by APPLICATION_COLUMN_NAME using index N1 to find all filters touching a particular column.
• Structure enumeration: filter on ID_FLEX_CODE and ID_FLEX_NUM to list every range set defined for a structure.
• Child expansion: join to RG_DSS_DIM_SEGMENTS, RG_DSS_SEG_RANGES, and RG_DSS_VAR_SELECTIONS on RANGE_SET_ID to resolve the full filter definition.

Note the Oracle warning: this object is for internal use only, and access should occur through standard Oracle Applications programs rather than direct DML.

Related Objects

Three child tables carry the RANGE_SET_ID foreign key into this parent, making them the primary dependents:

• RG_DSS_DIM_SEGMENTS — joins on RANGE_SET_ID; holds dimension segment detail for a range set.
• RG_DSS_SEG_RANGES — joins on RANGE_SET_ID; holds the individual segment range entries.
• RG_DSS_VAR_SELECTIONS — joins on RANGE_SET_ID; holds variable selection definitions tied to the range set.

Together these constitute the RG_DSS_* family, which collectively implements the dimensional segmentation and range filtering model within Oracle Grants. Parent rows should be created and maintained through the standard Oracle application flows to preserve referential integrity with these children.