Results for “rrs_trade_area_groups_b_u1”

10 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

RRS.RRS_TRADE_AREA_GROUPS_B is a core transactional table in the Oracle E-Business Suite Trade Management (formerly ETRM / Energy Trading) module, owned by the RRS schema. It stores the header-level definition of Trade Area Groups — logical groupings of geographic trade areas that share a common geometry type and unit of measure. A Trade Area Group acts as the parent record for one or more individual trade areas, which are linked through the RRS_GROUP_TRADE_AREAS intersection table.

From a Data Vault modeling perspective, this table is classified as hub-leaning. The metadata mining indicates that RRS_TRADE_AREA_GROUPS_B functions primarily as a hub: GROUP_ID is the surrogate primary key, and the table is referenced by downstream child tables rather than referencing them itself. The column set is narrow and identity-oriented, with a small number of descriptive attributes (GROUP_TYPE_CODE, STATUS_CODE, UNIT_OF_MEASURE_CODE). This structure is consistent with a hub table in a hub-and-satellite pattern, where descriptive detail would normally be split into satellites. The heuristic classification is a modeling suggestion only and does not alter the physical EBS schema.

The table is registered in FND Design Data as RRS.RRS_TRADE_AREA_GROUPS_B and is marked VALID in the documented 12.2.2 schema.

Key Information Stored

  • GROUP_ID — NUMBER. The unique identifier and primary key (RRS_TRADE_AREA_GROUPS_PK) for each Trade Area Group. This is the surrogate key that anchors all downstream relationships.
  • GROUP_TYPE_CODE — VARCHAR2(30). Specifies the geometry type of the Trade Area Group (for example, the spatial model applied to the member trade areas such as radius or polygon constructs).
  • NUM_OF_TRADE_AREAS — NUMBER. A denormalized count of the Trade Areas belonging to the group; useful for validation and reporting without aggregating the child table.
  • STATUS_CODE — VARCHAR2(30). Lifecycle status of the group, where A denotes Active and I denotes Inactive. This column governs whether the group is available for selection in trade area lookups.
  • UNIT_OF_MEASURE_CODE — VARCHAR2(30). The unit of measure applied to the radii defined for the member trade areas (for example, miles or kilometers).
  • OBJECT_VERSION_NUMBER — NUMBER. The optimistic locking sequence used by self-service (OA Framework) applications to detect concurrent updates.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Who audit columns that record insert and update provenance, supporting audit trails and incremental ETL extraction.

The unique index RRS_TRADE_AREA_GROUPS_B_U1 on GROUP_ID reinforces GROUP_ID as both the surrogate primary key and the principal business-key candidate in the documented physical schema.

Common Use Cases and Queries

Trade Area Groups are typically used when a trading application must associate counterparties, deals, or pricing rules with a set of geographic areas. Reporting scenarios include counting active groups, auditing geometry and unit-of-measure consistency, and verifying that NUM_OF_TRADE_AREAS aligns with the child rows in RRS_GROUP_TRADE_AREAS.

A simple lookup retrieves active groups:

  • SELECT group_id, group_type_code, num_of_trade_areas, unit_of_measure_code FROM rrs.rrs_trade_area_groups_b WHERE status_code = 'A' ORDER BY group_id;

A reconciliation query compares the stored count with the actual number of linked trade areas:

  • SELECT g.group_id, g.num_of_trade_areas, COUNT(a.*) FROM rrs.rrs_trade_area_groups_b g, rrs.rrs_group_trade_areas a WHERE g.group_id = a.group_id GROUP BY g.group_id, g.num_of_trade_areas HAVING g.num_of_trade_areas <> COUNT(a.*);

Incremental extraction for a data warehouse relies on LAST_UPDATE_DATE to bound the change set, and the Who columns support lineage reporting.

Related Objects

  • RRS.RRS_GROUP_TRADE_AREAS — Child (intersection) table; joins via GROUP_ID and defines which individual trade areas belong to each group.
  • RRS.RRS_TRADE_AREA_GROUPS_TL — Translated (language) table for the group; joins via GROUP_ID and supplies language-specific descriptions.
  • RRS.RRS_TRADE_AREA_GROUPS_B# — The underlying Base Table synonym/reference associated with this object.
  • RRS_TRADE_AREA_GROUPS_PK — Primary key constraint on GROUP_ID, enforcing uniqueness and supporting joins to child tables.
  • RRS_TRADE_AREA_GROUPS_B_U1 — Unique index on GROUP_ID in the APPS_TS_TX_IDX tablespace, used by the optimizer for key lookups.

No foreign keys are documented as originating from this table; all documented dependencies flow inward from the child tables RRS_GROUP_TRADE_AREAS and RRS_TRADE_AREA_GROUPS_TL, confirming the table's hub-leaning role in the model.