Search Results fte_sel_group_attributes_s

Overview

FTE_SEL_GROUPS_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. The FTE prefix associates it with the Freight and Transportation Execution (FTE) module, which is part of the Oracle Transportation Management integration within EBS and provides the foundation for carrier selection, routing, and freight cost determination. The package encapsulates the business logic governing selection groups — the reusable containers that bundle selection rules, attributes, and assignments used by the freight execution engine to choose carriers, service levels, and routing outcomes for a shipment. Its companion specification, FTE_SEL_GROUPS_PKG, exposes the public API surface, while this body implements the corresponding logic and validation.

The object is documented as VALID in the ETRM repository for release 12.2.2, and is also present in 12.1.1. Its API classification is OTHER, indicating that it is an internal supporting package rather than a formal, published public API such as those registered in the FND_API framework. Nevertheless, the dependency listing confirms that the package itself consumes FND_API, the standard EBS error-handling and message-stack utility, which is a strong indicator that its procedures are designed to be called programmatically and to return structured error information rather than raising raw exceptions.

Key Procedures and Functions

The package exposes seven documented procedures and functions. Their names, and the naming conventions of the tables they touch, imply the following responsibilities:

• VALIDATE_GROUP — Validates a selection group definition prior to save or release, ensuring required attributes, rules, and assignments are consistent and complete.
• COPY_GROUP — Duplicates an existing selection group, including its attributes, rules, restrictions, and assignments, to support rapid creation of similar configurations.
• VALIDATE_SHIPMETHOD — Validates the ship method (carrier, service level, and mode combination) associated with a selection group against the carrier service definitions available in the shipping tables.
• VALIDATE_ASSIGNMENT — Confirms that an assignment linking a selection group to its target entity (such as a region or result) is valid and non-conflicting.
• DELETE_RESULTS — Removes selection result records and their dependent child rows once they are no longer required, maintaining referential integrity across the result tables.
• SAVE_RESULTS — Persists the outcome of a selection evaluation, writing the winning group, assignments, and attributes into the FTE_SEL_RESULTS family of tables.
• IS_VALID_REGION — A boolean-style check that determines whether a supplied region is valid for the purposes of group or result assignment, drawing on the region view sourced from the shipping schema.

No parameter signatures are documented in the repository metadata, and none are asserted here.

Tables Accessed

The package references a broad, cohesive set of selection tables through APPS synonyms. The base group tables — FTE_SEL_GROUPS and its translation table FTE_SEL_GROUPS_S — store the group header and language-dependent descriptions. FTE_SEL_GROUP_ATTRIBUTES and FTE_SEL_GROUP_ATTRIBUTES_S hold the attributes that qualify a group, while FTE_SEL_GROUP_ASSIGNMENTS links groups to the entities to which they apply.

The rule side is represented by FTE_SEL_RULES, FTE_SEL_RULES_S, and FTE_SEL_RULE_RESTRICTIONS (with its _S translation), which together define the conditional logic governing selection. The result side is covered by FTE_SEL_RESULTS, FTE_SEL_RESULTS_S, FTE_SEL_RESULT_ASSIGNMENTS, FTE_SEL_RESULT_ASSIGNMENTS_S, FTE_SEL_RESULT_ATTRIBUTES, and FTE_SEL_RESULT_ATTRIBUTES_S, which record evaluated outcomes, the assignments made, and the attribute values that produced them. The package also reads WSH_CARRIER_SERVICES and WSH_REGIONS_V, shipping tables used respectively by VALIDATE_SHIPMETHOD and IS_VALID_REGION, and utiliZes WSH_UTIL_CORE and FTE_ACS_RULE_UTIL_PKG as supporting utilities. DUAL and STANDARD are incidental references.

Usage Notes

FTE_SEL_GROUPS_PKG is not referenced by any other database object per the ETRM metadata, meaning it is not an internal dependency of another shipped package. It is therefore invoked directly — typically from the Oracle EBS forms or OAF pages used to set up and maintain freight selection groups, from concurrent programs that evaluate and persist selection results, or from custom PL/SQL extensions that call the package to validate, copy, or save group configuration. Because it consumes FND_API, callers should expect standard EBS error-handling behaviour and should inspect the message stack where a procedure reports failure. Direct invocation should be limited to the documented entry points; the package is not intended as a supported public API, and custom code depending on it should be regression-tested during upgrades between 12.1.1 and 12.2.2.