Search Results get_ranked_results_wrapper




Overview
Explore in AI Chat

Overview

FTE_SS_INTERFACE is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the sourcing and selection of carrier services within Oracle Transportation Management’s integration with EBS. The package name prefix “FTE” designates the Freight and Transportation Execution module family, while the “SS” segment denotes the “Service Selection” area. Accordingly, FTE_SS_INTERFACE acts as the service-selection interface layer that ranks, sorts, and returns candidate carrier services for a given shipment or tender, then optionally assigns the resulting service as a tender. It is classified under the ETRM API classification OTHER, indicating that it is an internal integration utility rather than a public, documented open interface. The package is reported as VALID in the APPS schema and exists in both 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

Four documented entry points are exposed by the package:

  • SEARCH_SERVICES — The core search routine. It evaluates candidate services against the supplied criteria and returns the matching set, drawing on carrier ranking and rate-sorting logic defined elsewhere in the FTE module.
  • SEARCH_SERVICES_UIWRAPPER — A UI-facing wrapper around SEARCH_SERVICES. It adapts the core search for invocation from an Oracle Forms or OA Framework page, so that service-selection results can be presented interactively to a user.
  • GET_RANKED_RESULTS_WRAPPER — Returns the search results in ranked order, applying the carrier ranking list defined by the referenced FTE_CARRIER_RANK_LIST_PVT package. This wrapper supports consumers that require sorted, prioritized output rather than the raw result set.
  • ASSIGN_SERVICE_TENDER — Takes a selected service and assigns it to a tender, completing the service-selection flow by binding the chosen carrier service to the transportation execution record.

Parameter lists for these routines are not documented in the ETRM metadata and should be inspected directly in the package specification before use.

Tables Accessed

The package operates against two tables, accessed through APPS synonyms:

  • FTE_CARRIER_RANK_LIST — The carrier ranking list table. It stores the ordered preferences used to rank candidate carriers and services, and is read during ranked-result processing to determine the priority sequence in which matches are returned.
  • PLITBLM — A standard Oracle EBS PL/SQL associative-array (index-by table of VARCHAR2) type used for in-memory collections. It is not a physical application table but an in-memory data structure referenced by the package for passing and buffering lists of values, such as service identifiers, between procedures.

Usage Notes

FTE_SS_INTERFACE is referenced by only one other package, FTE_TENDER_WF, indicating that it is invoked primarily from the tender workflow rather than being called broadly across the application. It also references the following FTE components: FTE_CARRIER_RANK_LIST_PVT (for ranking logic), FTE_SS_ATTR_REC and FTE_TENDER_ATTR_REC (record type definitions for service and tender attributes), and FTE_SS_RATE_SORT_TAB_TYPE (a collection type used for rate sorting). In practice, this package is triggered from the service-selection user interface and from the tender workflow when a shipment requires a carrier service to be selected and then committed as a tender. Because it is an internal integration package rather than a public API, custom code should avoid direct invocation; extensions should instead use supported open interfaces or the FTE_TENDER_WF workflow entry points. Developers inspecting this object should review the package specification for exact parameter signatures, as the ETRM record does not enumerate them.