Results for “fte_sel_rule_restrictions”

50+ results




Overview
Explore in AI Chat

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

Overview

The FTE_SEL_RULE_RESTRICTIONS table is a core configuration object within the Oracle EBS Transportation Execution (FTE) module. It stores the individual attribute restrictions that, taken together, define the conditions of a selection rule. Each restriction is associated with a parent rule through the RULE_ID foreign key, so that all restrictions grouped under a single RULE_ID collectively describe the criteria a shipment, order, or movement must satisfy in order to produce an outcome. That outcome is then recorded separately in FTE_SEL_RESULTS, which the FTE selection engine evaluates against the restrictions defined here.

From a Data Vault modeling perspective, the metadata's heuristic classification is satellite-leaning. This is consistent with a table whose primary key is a surrogate identifier (RULE_ATTRIBUTE_ID) and whose foreign key (RULE_ID) points to the hub or parent rule definition in FTE_SEL_RULES. The attributes captured here describe the changing condition details of that parent rule rather than serving as an independent business entity or a pure relationship link between two hubs.

Key Information Stored

The table contains 16 documented columns. The most operationally significant are described below.

  • RULE_ATTRIBUTE_ID — The surrogate primary key (FTE_SEL_RULE_RESTRICTIONS_PK1) that uniquely identifies each restriction row.
  • RULE_ID — Foreign key to FTE_SEL_RULES; the business grouping key that associates each restriction with its owning rule.
  • ATTRIBUTE_NAME — Identifies the shipment or order attribute being constrained (for example, a carrier, service level, or weight criterion).
  • DATA_TYPE — Indicates whether the restriction is numeric or character in nature, governing which value columns are populated and which comparison logic applies.
  • ATTRIBUTE_VALUE_FROM / ATTRIBUTE_VALUE_TO — Character-based range or equality boundaries for the restriction.
  • ATTRIBUTE_VALUE_FROM_NUMBER / ATTRIBUTE_VALUE_TO_NUMBER — Numeric counterparts used when DATA_TYPE specifies a numeric restriction, supporting threshold and range comparisons.
  • GROUPING_NUMBER — Groups related restrictions together, allowing the rule engine to evaluate clustered conditions as a logical unit.
  • RANGE_OVERLAP_FLAG — Controls how overlapping value ranges are handled during rule evaluation.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, GROUP_ID — Standard EBS audit and concurrency columns. GROUP_ID is used by the concurrent-manager-based selection and purge processes.

The primary surrogate key is RULE_ATTRIBUTE_ID. RULE_ID functions as the principal business-key candidate, as it is the column through which restrictions are grouped and retrieved.

Common Use Cases and Queries

Typical reporting and diagnostic scenarios include auditing rule definitions, tracing why a particular selection result occurred, and validating that restriction ranges do not conflict.

Retrieve all restrictions for a given rule:

  • SELECT attribute_name, data_type, attribute_value_from, attribute_value_to, attribute_value_from_number, attribute_value_to_number FROM fte.fte_sel_rule_restrictions WHERE rule_id = :p_rule_id ORDER BY grouping_number;

List only numeric constraints for threshold analysis:

  • SELECT r.rule_id, r.attribute_name, r.attribute_value_from_number, r.attribute_value_to_number FROM fte.fte_sel_rule_restrictions r WHERE r.data_type = 'NUMBER';

Join restrictions to their parent rule to produce a readable rule definition report:

  • SELECT ru.rule_name, re.attribute_name, re.attribute_value_from, re.attribute_value_to FROM fte.fte_sel_rules ru, fte.fte_sel_rule_restrictions re WHERE ru.rule_id = re.rule_id ORDER BY ru.rule_id, re.grouping_number;

Detecting overlapping ranges and reviewing grouping structure are common data-quality checks performed before activating rule changes in production.

Related Objects

  • FTE_SEL_RULES — The parent table referenced by FTE_SEL_RULE_RESTRICTIONS.RULE_ID; holds the rule definition these restrictions belong to.
  • FTE_SEL_RESULTS — Stores the outcome produced when the selection engine matches a set of restrictions; read together with this table to understand full rule behavior.
  • FTE_SEL_RESULTS columns referencing RULE_ID — Enables tracing a result back to the restriction set that generated it.
  • FTE_SEL_CRITERIA / attribute definition views — Provide the valid ATTRIBUTE_NAME and DATA_TYPE domain values consumed by this table.
  • FTE selection engine PL/SQL packages — Query this table at runtime to evaluate rule conditions and determine results.