Search Results fte_sel_group_attributes




Overview
Explore in AI Chat

Overview

FTE_SEL_GROUP_ATTRIBUTES is a Transportation Execution (FTE) module table owned by the FTE schema. It provides the method of associating individual attributes defined in FTE_SEL_ATTRIBUTES for a specific object to a group also assigned to that object. Attributes and groups must be associated with the same object in order for the selection mechanism to resolve them correctly, which makes this table the binding construct between the attribute dictionary and the grouping layer used by FTE selection logic.

In Oracle EBS 12.1.1 and 12.2.2, the object is registered with status VALID and is exposed in the ETRM documentation under the Transportation Execution product. The documented physical schema contains eleven columns. Its primary key is defined by the constraint FTE_SEL_GROUP_ATTRIBUTES_PK1, keyed on GROUP_ATTRIBUTE_ID. One foreign key is documented: GROUP_ID references FTE_SEL_GROUPS.

From a heuristic Data Vault perspective, the FK topology suggests a satellite-leaning classification. The table is best modeled as an attribute-bearing dependent of the group entity, carrying descriptive values, default values, and unit-of-measure codes rather than acting as an independent hub or a pure many-to-many link. This classification is a modeling suggestion derived from the documented foreign key structure, not a statement of Oracle's internal design.

Key Information Stored

The most significant columns documented for this table include:

  • GROUP_ATTRIBUTE_ID — the surrogate primary key and the sole column comprising FTE_SEL_GROUP_ATTRIBUTES_PK1. It uniquely identifies each attribute-to-group assignment row.
  • GROUP_ID — the foreign key to FTE_SEL_GROUPS, identifying the group to which the attribute is assigned. This is the principal business-key candidate alongside the attribute reference.
  • ATTRIBUTE_ID — the reference to the individual attribute defined in FTE_SEL_ATTRIBUTES that is being associated with the group.
  • ATTRIBUTE_NAME — the descriptive name of the attribute as used within the selection context.
  • ATTRIBUTE_DEFAULT_VALUE — the default value applied to the attribute when the group is used, allowing seeded selections to resolve without explicit user input.
  • ATTRIBUTE_UOM_CODE — the unit of measure code associated with the attribute, relevant for numeric or measurable selection criteria.
  • CREATION_DATE, CREATED_BY — standard audit columns recording when and by whom the assignment row was created.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns recording the most recent modification and the login context of the updating user.

Because the only documented unique constraint is the primary key on GROUP_ATTRIBUTE_ID, the combination of GROUP_ID and ATTRIBUTE_ID functions as the practical business-key candidate for deduplication and lookup, even where no unique index is documented on that pair.

Common Use Cases and Queries

Typical reporting and integration scenarios resolve which attributes belong to a given selection group, or which groups carry a specific attribute. A representative query joins the table to FTE_SEL_GROUPS on GROUP_ID:

  • SELECT g.group_id, a.attribute_id, a.attribute_name FROM fte.fte_sel_group_attributes a, fte.fte_sel_groups g WHERE a.group_id = g.group_id;
  • Filtering by ATTRIBUTE_DEFAULT_VALUE to audit which selection attributes carry seeded defaults and which require user input.
  • Comparing ATTRIBUTE_UOM_CODE values across groups to validate consistency of units used in transportation selection criteria.
  • Auditing changes by reviewing LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN for compliance or troubleshooting.

These patterns support configuration validation, migration verification, and operational reporting on selection group definitions.

Related Objects

  • FTE_SEL_GROUPS — referenced through FTE_SEL_GROUP_ATTRIBUTES.GROUP_ID; the parent group definition.
  • FTE_SEL_ATTRIBUTES — the attribute dictionary from which ATTRIBUTE_ID values originate.
  • FTE_SEL_GROUP_ATTRIBUTES_PK1 — the primary key constraint enforcing uniqueness on GROUP_ATTRIBUTE_ID.
  • FTE_SEL_GROUP_ATTRIBUTES — the table itself as referenced by the documented foreign key relationship.
  • Additional FTE selection and transportation execution objects that consume group-attribute assignments through GROUP_ID lookups.