Search Results fte_dist_int_pkg




Overview
Explore in AI Chat

Overview

FTE_DIST_INT_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the distance calculation and mileage logic used by Oracle Transportation Execution / Fleet Management (FTE) functionality. Its primary business purpose is to determine distance and elapsed travel time between locations and to log diagnostic or trace messages generated during those computations. The package acts as an internal integration layer ("INT" denoting integration) that bridges FTE location data with externally maintained mileage and geographic reference information, allowing the application to derive driving distance and time values required for planning, rating, and routing decisions.

The object is classified as VALID in the ETRM metadata for 12.1.1 and 12.2.2, and its API classification is recorded as OTHER, indicating it is not a formally published public API but an internal utility invoked by other FTE components. It is referenced by the FTE_TL_CACHE package, which caches transportation lead-time data, and by itself, confirming that it is consumed by higher-level FTE caching logic rather than called directly by end users.

Key Procedures and Functions

The documented interface exposes two procedures or functions:

  • GET_DISTANCE_TIME — Retrieves the distance and associated travel time between two locations. This routine is the core computation entry point invoked by FTE caching and lead-time logic to resolve mileage and transit duration for a given origin/destination pair.
  • LOG_DISTANCE_MESSAGES — Records diagnostic, informational, or error messages produced during distance determination. This supports troubleshooting and audit of distance-time resolution when source mileage data is missing or ambiguous.

The metadata does not publish parameter lists for either routine; callers should treat them as internal and not assume a stable signature across releases.

Tables Accessed

The package reads and writes against the following tables through APPS synonyms:

  • FTE_LOCATION_MILEAGES — Stores predefined mileage values between location pairs. GET_DISTANCE_TIME consults this table as the primary source of stored distance data.
  • WSH_REGION_LOCATIONS — Holds shipping region and location definitions used to validate, resolve, or default origin and destination locations when a direct mileage entry is not available.
  • PLITBLM — A standard Oracle character/string manipulation table (PL/SQL table of lines) used internally for message buffering and text handling, typically supporting LOG_DISTANCE_MESSAGES.

Usage Notes

FTE_DIST_INT_PKG is not intended for direct invocation from forms or concurrent programs by end users. It is invoked internally by FTE_TL_CACHE and comparable FTE lead-time and caching components whenever distance and time values must be derived or refreshed. A dependency on SYS.STANDARD confirms only standard PL/SQL functionality is used. Customizations should not call these routines directly, because the signature and behavior are undocumented and may change between 12.1.1 and 12.2.2. Integrations requiring distance-time resolution should instead use supported FTE or Transportation Management APIs that encapsulate this package.