Search Results fte_sel_group_assignments




Overview
Explore in AI Chat

Overview

FTE_SEL_GROUP_ASSIGNMENTS is a Transportation Execution (FTE) table in the Oracle E-Business Suite 12.1.1 and 12.2.2 environments. It stores the association between selection groups and the individual business entities that belong to those groups. A selection group is the mechanism used to bundle entities—customers, customer sites, shipping organizations, and locations—so that they can be processed collectively during planning, carrier selection, rating, and other transportation execution activities.

The table belongs to the FTE schema and is classified as VALID in the ETRM data model. Its documented role is to provide the method by which entities such as customer, customer site, and shipping organization are assigned to one or more groups. One notable exception is documented: the shipping enterprise group is not assigned through this table, because the shipping enterprise itself is not defined as a group member in the same manner as other entity types.

The heuristic Data Vault classification mined from the foreign key structure is satellite-leaning. In modeling terms, GROUP_ASSIGNMENT_ID behaves as a unique row identifier equivalent to a satellite key, while the GROUP_ID foreign key anchors each row to its parent group. This suggests the table functions primarily as a descriptive satellite attached to FTE_SEL_GROUPS rather than as a standalone hub or a pure link between two equal-weight hubs.

Key Information Stored

The documented physical schema for 12.2.2 contains eleven columns. The most important columns are:

  • GROUP_ASSIGNMENT_ID — the surrogate primary key, uniquely identifying each assignment row. It is the anchor of primary key constraint FTE_SEL_GROUP_ASSIGNMENTS_PK1.
  • GROUP_ID — the foreign key to FTE_SEL_GROUPS. It identifies the selection group that the assigned entity belongs to. This is the essential business join column and the most frequently used predicate in queries against this table.
  • CUSTOMER_ID — identifies a customer entity assigned to the group.
  • CUSTOMER_SITE_ID — identifies a customer site (ship-to or bill-to location) assigned to the group.
  • ORGANIZATION_ID — identifies the shipping organization assigned to the group.
  • LOCATION_ID — the location identifier associated with the assignment, used where the assigned entity is location-based.

The remaining columns are standard EBS who-columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN. These support auditing and concurrent-program tracking but carry no transportation-specific business meaning.

Business-key candidates relate to the combination of GROUP_ID with one of the entity identifier columns (for example, GROUP_ID plus CUSTOMER_ID, or GROUP_ID plus ORGANIZATION_ID), depending on the entity type being assigned. The documented surrogate key remains GROUP_ASSIGNMENT_ID; the entity columns act as the semantic discriminator describing what has been assigned.

Common Use Cases and Queries

Typical reporting use cases include determining which customers or organizations belong to a given selection group, and conversely, finding all groups to which a particular customer, site, or organization has been assigned. A basic listing query:

SELECT group_assignment_id, group_id, customer_id,
       customer_site_id, organization_id, location_id
FROM   fte.fte_sel_group_assignments
WHERE  group_id = :p_group_id;

Resolving group membership for a specific customer or organization:

SELECT g.group_id, g.group_name, a.customer_id, a.organization_id
FROM   fte.fte_sel_group_assignments a,
       fte.fte_sel_groups g
WHERE  a.group_id = g.group_id
AND    a.customer_id = :p_customer_id;

These queries support carrier assignment validation, planning group maintenance, and reconciliation of transportation setup during implementations or data migration audits.

Related Objects

The documented foreign key relationship is to FTE_SEL_GROUPS via GROUP_ID. This parent table holds the group definition (such as group name and type) and is the principal dependency for this object. Join columns for reporting are FTE_SEL_GROUP_ASSIGNMENTS.GROUP_ID to FTE_SEL_GROUPS.GROUP_ID.

Beyond this documented relationship, related objects in the FTE transportation execution model include the entity master tables referenced by CUSTOMER_ID, CUSTOMER_SITE_ID, ORGANIZATION_ID, and LOCATION_ID, together with the planning and carrier-selection components that consume selection group membership. Any process that resolves a selection group to its constituent entities reads this table as the authoritative assignment source, excluding shipping enterprise groups, which are handled outside this table per the documented description.