Search Results rg_dss_var_selections_u1

Overview

RG.RG_DSS_VAR_SELECTIONS is a transactional configuration table owned by the RG schema within Oracle E-Business Suite releases 12.1.1 and 12.2.2. It stores the selections that link a "variable" definition to a "range set" filter, thereby governing how row-level data security and filter criteria are resolved for the Oracle Applications data security (DSS) framework. In practical terms, each row represents one accepted pairing of a variable with a range set, together with the flexfield context required to evaluate that pairing at runtime.

The table resides in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10, and its indexes are held in APPS_TS_TX_IDX. The ETRM design data designates it as RG.RG_DSS_VAR_SELECTIONS, and the standard Oracle warning applies: the object is internal, VALID, and is not supported for direct customer access except through standard Oracle Applications programs.

Under a heuristic Data Vault classification mined from the foreign-key structure, this object is best modeled as a link table. It resolves a many-to-many-style association between the variable entity (RG_DSS_VARIABLES) and the filter/range-set entity (RG_DSS_SEG_RANGE_SETS), while carrying its own descriptive attributes and a surrogate selection identifier. It is not a pure hub, because its principal role is to record the association; it is not a satellite, because it holds independent business keys and immediate filter columns rather than only descriptive history for a single parent key.

Key Information Stored

The most significant columns in RG_DSS_VAR_SELECTIONS are the association keys and the flexfield context columns. The surrogate primary key is SELECTION_ID, defined by the unique index RG_DSS_VAR_SELECTIONS_U1 on APPS_TS_TX_IDX. SELECTION_ID is the selection defining column and is the business-key candidate documented by the ETRM metadata; the primary key constraint is RG_DSS_VAR_SELECTIONS_PK (SELECTION_ID).

• SELECTION_ID — Surrogate primary key and selection defining column; uniquely identifies each selection row via RG_DSS_VAR_SELECTIONS_U1.
• VARIABLE_ID — Variable defining column; foreign key to RG_DSS_VARIABLES. Identifies which variable participates in the selection.
• RANGE_SET_ID — Filter defining column; foreign key to RG_DSS_SEG_RANGE_SETS. Identifies the range set applied as the filter.
• APPLICATION_COLUMN_NAME — Name of the column containing the segment; used to map the selection onto the application data column being filtered.
• ID_FLEX_CODE — Key flexfield code that qualifies the flexfield context of the selection.
• ID_FLEX_NUM — Key flexfield structure number, pairing with ID_FLEX_CODE to identify the flexfield structure.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — Standard Who columns providing audit and concurrency information.
• CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield context and segments available for customer-defined descriptive data.

The composite non-unique index RG_DSS_VAR_SELECTIONS_N1 covers VARIABLE_ID and APPLICATION_COLUMN_NAME, supporting lookups by variable and target column. The indexes therefore distinguish the surrogate key (SELECTION_ID) from the documented business-key candidate, while the foreign keys establish the link to the variable and range-set parents.

Common Use Cases and Queries

The primary operational use case is resolving which filter applies to a given variable when the DSS engine evaluates data access. Reporting and diagnostic queries typically join this table to its two parents to obtain human-readable descriptions. A representative pattern follows:

• List all selections for a specific variable: SELECT SELECTION_ID, RANGE_SET_ID, APPLICATION_COLUMN_NAME, ID_FLEX_CODE, ID_FLEX_NUM FROM RG.RG_DSS_VAR_SELECTIONS WHERE VARIABLE_ID = :p_variable_id;
• Join to the parent variable and range-set tables: SELECT v.VARIABLE_NAME, s.RANGE_SET_NAME, s.APPLICATION_COLUMN_NAME FROM RG.RG_DSS_VAR_SELECTIONS s, RG_DSS_VARIABLES v WHERE s.VARIABLE_ID = v.VARIABLE_ID;
• Locate selections by the target application column using the N1 index: SELECT SELECTION_ID, VARIABLE_ID FROM RG.RG_DSS_VAR_SELECTIONS WHERE VARIABLE_ID = :p_var AND APPLICATION_COLUMN_NAME = :p_col;
• Audit recent configuration changes via the Who columns: filter on LAST_UPDATE_DATE to review newly created or modified selections.

Because the object is flagged Oracle Internal Use Only, these queries should be treated as diagnostic and reporting aids rather than as a supported integration interface. Any data change should be delivered through Oracle Applications programs, and read-only access is the appropriate posture for custom reporting.

Related Objects

The ETRM relationship data establishes the following dependencies and participates in the surrounding DSS configuration model:

• RG.RG_DSS_VARIABLES — Parent of VARIABLE_ID; defines the variable used in the selection.
• RG.RG_DSS_SEG_RANGE_SETS — Parent of RANGE_SET_ID; defines the filter applied to the variable.
• RG_DSS_VAR_SELECTIONS_PK — Primary key constraint on SELECTION_ID; enforces row uniqueness.
• RG_DSS_VAR_SELECTIONS_U1 — Unique index on SELECTION_ID in APPS_TS_TX_IDX; the documented business-key candidate.
• RG_DSS_VAR_SELECTIONS_N1 — Non-unique index on VARIABLE_ID and APPLICATION_COLUMN_NAME; supports common lookups.

Other DSS configuration objects in the RG schema, including variable definitions and range-set definitions, are referenced indirectly through these parents. The standard Oracle Applications data security programs are the supported consumers of this table, and no public API or view is documented in the supplied ETRM metadata for direct external use.