Search Results fte_sel_groups




Overview
Explore in AI Chat

Overview

FTE_SEL_GROUPS is a Transportation Execution (FTE) transactional configuration table in Oracle E-Business Suite 12.1.1 and 12.2.2. It defines selection groups, which are logical containers used to consolidate selection rules against a specific business entity — a customer, customer site, shipping organization, or shipping enterprise. Rather than attaching rules individually to every entity, Oracle Transportation Execution allows rules to be gathered into a named group, and the group is then associated with one or more entities through the FTE_SEL_GROUP_ASSIGNMENTS table. This indirection permits a single rule set to be maintained once and reused across many customers or organizations.

Within the schema, FTE_SEL_GROUPS acts as the anchor for rule selection behavior. Groups are scoped to a parent object in FTE_SEL_OBJECTS via OBJECT_ID, meaning that a group is always defined relative to an entity type and entity instance. The heuristic Data Vault classification supplied in the metadata is hub-leaning: the table carries a single-column surrogate primary key and a small set of descriptive and business attributes, with several dependent tables referencing it by GROUP_ID. In a Data Vault model this would typically be represented as a hub keyed on GROUP_ID, with the descriptive columns and effectivity dates held in a satellite, and the assignment and rule relationships modeled as links.

Key Information Stored

The table is owned by the FTE schema and contains 29 documented columns. The most significant are:

  • GROUP_ID — the surrogate primary key (FTE_SEL_GROUPS_PK1) and the value propagated to all child tables.
  • NAME — the group name, paired with OBJECT_ID as unique index FTE_SEL_GROUPS_U1, making it the principal business-key candidate.
  • OBJECT_ID — foreign key to FTE_SEL_OBJECTS, identifying the entity type or instance the group belongs to.
  • DESCRIPTION — free-text description of the group's purpose.
  • START_DATE and END_DATE — the effectivity window controlling when the group is active.
  • ASSIGNED_FLAG — indicates whether the group has been assigned to an entity.
  • GROUP_STATUS_FLAG — the current lifecycle status of the group.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard Oracle WHO audit columns.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the DFF/descriptive flexfield segment set, supporting customer-specific extensions without schema change.

A second unique index, FTE_SEL_GROUPS_U2, exists on GROUP_ID alone and serves as an alternate uniqueness guarantee on the surrogate key.

Common Use Cases and Queries

The most frequent operational need is answering which groups apply to a given customer, customer site, or shipping organization, and which rules those groups carry. Because assignment is externalized, reporting joins must pass through FTE_SEL_GROUP_ASSIGNMENTS.

  • Listing groups for a parent object: SELECT group_id, name, description FROM fte_sel_groups WHERE object_id = :object_id AND (end_date IS NULL OR end_date > SYSDATE);
  • Resolving assigned groups for an entity: join FTE_SEL_GROUPS to FTE_SEL_GROUP_ASSIGNMENTS on GROUP_ID, filtering by the entity identifier.
  • Auditing rule coverage: join FTE_SEL_RULES to FTE_SEL_GROUPS on GROUP_ID to determine whether any group lacks rules, or which rules resolve for a downstream shipment.
  • Extracting flexfield data: query ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 where custom rule-context attributes are stored.
  • Effectivity reporting: filter on START_DATE and END_DATE to reconcile historical versus current group membership.

Status-oriented reporting should also inspect GROUP_STATUS_FLAG and ASSIGNED_FLAG, since an active group that has never been assigned will not influence transportation selection outcomes.

Related Objects

FTE_SEL_GROUPS is central to the selection-rule data model and is referenced by four child tables and one parent table:

  • FTE_SEL_OBJECTS — parent object definition; FTE_SEL_GROUPS.OBJECT_ID references it.
  • FTE_SEL_GROUP_ASSIGNMENTS — maps groups to entities; joined on GROUP_ID.
  • FTE_SEL_GROUP_ATTRIBUTES — stores group-level attribute assignments; joined on GROUP_ID.
  • FTE_SEL_RULES — holds the actual selection rules consolidated by the group; joined on GROUP_ID.

Because FTE_SEL_RULES.GROUP_ID is the pivot between rule definitions and entity assignment, FTE_SEL_GROUPS should be treated as the junction through which Transportation Execution resolves which rules apply to which customer or organization. Any customization, extract, or diagnostic query touching selection behavior will typically start from this table.