Search Results rrs_site_group_versions




Overview
Explore in AI Chat

Overview

RRS.RRS_SITE_GROUP_VERSIONS is a table within the Oracle E-Business Suite Release 12.1.1 / 12.2.2 RRS – Site Management module (also referenced in the Oracle ETRM / eTRM Technical Reference Manual). It stores versioned records associated with site groups, allowing the system to retain historical or staged copies of site group definitions. Each row represents a discrete version of a site group, keyed by a surrogate identifier and linked back to its parent site group.

From a data-modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification under Data Vault heuristics. In other words, this table behaves more like a satellite — capturing descriptive, versioned attributes that depend on a business key (the site group) — rather than a hub or a pure link. This is a modeling suggestion only, derived from the FK relationships and column layout, and should be validated against actual usage patterns.

The table is owned by the RRS schema, carries a status of VALID, and is documented with 10 physical columns. Its primary key is defined as SITE_GROUP_VERSION_ID and is exposed through the unique index RRS_SITE_GROUP_VERSIONS_U1.

Key Information Stored

The table's most significant columns fall into three functional groups:

  • SITE_GROUP_VERSION_ID — The surrogate primary key. Sourced from the sequence RSN_PK. This is the unique, system-generated identifier for each version record and is the column exposed in the RRS_SITE_GROUP_VERSIONS_U1 unique index.
  • SITE_GROUP_ID — The foreign key back to RRS_SITE_GROUP_VERSIONS (self-referencing per the documented FK). This ties each version record to its owning site group, forming the business-key lineage. It is the primary join column for any query reconstructing site group history.
  • VERSION_NUMBER — The ordinal version indicator for the site group. Distinguishes successive revisions and supports ordered retrieval of the latest or prior version.
  • SOURCE_VERSION_ID — References the version from which this record was copied or derived, enabling version lineage tracing.
  • OBJECT_VERSION_NUMBER — The standard Oracle EBS optimistic-locking column used for concurrent update control across the application framework.

The remaining columns are the standard EBS "Who" audit set — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — which provide ownership and change-tracking metadata for every version row.

Common Use Cases and Queries

Typical scenarios for this table include:

  • Retrieving the current version of a site group — selecting the row with the highest VERSION_NUMBER for a given SITE_GROUP_ID.
  • Auditing version history — listing all versions of a site group ordered by VERSION_NUMBER along with the audit columns to establish who changed what and when.
  • Tracing version lineage — following SOURCE_VERSION_ID chains to determine which prior version a record descended from.

A representative query retrieves the latest version per site group:

SELECT sgv.SITE_GROUP_VERSION_ID,
       sgv.SITE_GROUP_ID,
       sgv.VERSION_NUMBER,
       sgv.LAST_UPDATED_BY,
       sgv.LAST_UPDATE_DATE
FROM   RRS.RRS_SITE_GROUP_VERSIONS sgv
WHERE  sgv.VERSION_NUMBER = (
         SELECT MAX(v.VERSION_NUMBER)
         FROM   RRS.RRS_SITE_GROUP_VERSIONS v
         WHERE  v.SITE_GROUP_ID = sgv.SITE_GROUP_ID);

For historical reporting, remove the MAX restriction and order by SITE_GROUP_ID, VERSION_NUMBER. Because OBJECT_VERSION_NUMBER supports optimistic locking, reporting extracts should filter on it only when analyzing concurrency, not as a key.

Related Objects

The following objects are significant to RRS_SITE_GROUP_VERSIONS:

  • RRS_SITE_GROUP_VERSIONS (self-reference) — The documented FK SITE_GROUP_ID points back into this table, supporting version lineage and hierarchical version grouping.
  • RRS_SITE_GROUP_VERSIONS_U1 — The unique index on SITE_GROUP_VERSION_ID, enforcing the primary key and serving as the business-key candidate index.
  • RSN_PK — The sequence/adapter that supplies SITE_GROUP_VERSION_ID values.
  • Site Group master objects — The parent site group definition tables that the SITE_GROUP_ID logically relates to; these provide the descriptive context for each version.
  • Standard EBS audit framework — The FND-based audit columns and concurrent manager processes that populate CREATED_BY, LAST_UPDATED_BY, and related fields.

Note that the documented metadata is limited to the FK SITE_GROUP_ID and the unique index, so additional relationships should be confirmed against the RRS site-management data model in the implementation's ETRM.