Search Results fte_sel_groups_u2

Overview

FTE.FTE_SEL_GROUPS is a transaction-data table within the Oracle E-Business Suite FTE (Freight and Transportation Execution / Transportation Management selection) schema. Its purpose is to define selection groups, which serve as logical containers that consolidate selection rules against a specific business entity, such as a customer, customer site, shipping organization, or shipping enterprise. A group acts as the binding point between rule definitions and the entity they are evaluated for: rules are attached to the group, and the group is assigned to one or more entities through the FTE_SEL_GROUP_ASSIGNMENTS table.

The table stores header-level information for each group, including its name, description, the object it belongs to, effective and expiry dates, and status flags that control how and where the group is applied. Records are stored in the APPS_TS_TX_DATA tablespace, with indexes in APPS_TS_TX_IDX. The documented primary key is FTE_SEL_GROUPS_PK1 on GROUP_ID.

Under the heuristic Data Vault classification supplied in the metadata, this object is hub-leaning. In Data Vault terms it can be modeled as a hub for the selection-group business key, with surrounding descriptive columns behaving like satellite attributes; this is a modeling suggestion rather than a physical implementation in EBS.

Key Information Stored

The most operationally significant columns are:

• GROUP_ID — Surrogate primary key for the table. It is also the column of unique index FTE_SEL_GROUPS_U2, making it both the PK and a unique access path.
• NAME — Name of the group, up to 30 characters. Together with OBJECT_ID it forms unique index FTE_SEL_GROUPS_U1, which is the business-key candidate: a group name must be unique within its owning object.
• OBJECT_ID — The object the group belongs to, with a foreign key to FTE_SEL_OBJECTS. The second half of the U1 business key.
• DESCRIPTION — Free-text description of the group's intended use, up to 240 characters.
• ASSIGNED_FLAG — Indicates the entity type the group is assigned to: 'N' (not assigned), 'O' (organization), 'C' (customer), 'S' (customer site), or null for enterprise.
• GROUP_STATUS_FLAG — Indicates whether the group is in Draft ('D') or Active ('A') status.
• START_DATE and END_DATE — Define the effective interval during which the group applies; END_DATE marks obsolescence.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Who columns used for audit and change tracking.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield (DFF) columns provided for extensibility without schema changes.

Common Use Cases and Queries

The primary use case is resolving which selection rules apply to a given customer, site, organization, or enterprise. A typical lookup retrieves the active group for an entity:

• Retrieve a group by primary key: SELECT * FROM fte.fte_sel_groups WHERE group_id = :p_group_id;
• Find a group by business key: SELECT * FROM fte.fte_sel_groups WHERE name = :p_name AND object_id = :p_object_id;
• List only active, currently effective groups: SELECT group_id, name, assigned_flag FROM fte.fte_sel_groups WHERE group_status_flag = 'A' AND TRUNC(SYSDATE) BETWEEN start_date AND NVL(end_date, SYSDATE);
• Locate groups by assignment scope, for example all site-level groups: SELECT * FROM fte.fte_sel_groups WHERE assigned_flag = 'S';
• Resolve rules for an entity by joining the group to its assignments and then to FTE_SEL_RULES: SELECT r.* FROM fte_sel_group_assignments a, fte_sel_groups g, fte_sel_rules r WHERE a.group_id = g.group_id AND r.group_id = g.group_id AND a.<entity_column> = :p_entity_id;

Reporting uses include auditing draft versus active groups, identifying groups approaching expiry, and listing groups that are not yet assigned to any entity (ASSIGNED_FLAG = 'N'). The DFF attribute columns are frequently queried for client-specific extensions.

Related Objects

The following objects are directly related through documented foreign-key relationships:

• FTE.FTE_SEL_OBJECTS — Referenced by FTE_SEL_GROUPS.OBJECT_ID; defines the object a group belongs to.
• FTE.FTE_SEL_GROUP_ASSIGNMENTS — References FTE_SEL_GROUPS.GROUP_ID; maps groups to customers, sites, organizations, or enterprises.
• FTE.FTE_SEL_RULES — References FTE_SEL_GROUPS.GROUP_ID; holds the selection rules consolidated by each group.
• FTE.FTE_SEL_GROUP_ATTRIBUTES — References FTE_SEL_GROUPS.GROUP_ID; stores additional attribute rows associated with a group.

Together these tables form the selection-group model: FTE_SEL_GROUPS is the header, FTE_SEL_RULES and FTE_SEL_GROUP_ATTRIBUTES are dependent detail tables, and FTE_SEL_GROUP_ASSIGNMENTS links groups to the business entities they serve.