Search Results fte_rtg_globals




Overview
Explore in AI Chat

Overview

FTE_TL_CORE is a core PL/SQL package body owned by the APPS schema within the Oracle E-Business Suite transportation and logistics module (FTE). The "TL" component of the name denotes transportation and logistics, and the package serves as a central processing engine for translating freight pricing and routing decisions into executable logic within the Oracle Transportation Management and Order Management integration flows. In the context of releases 12.1.1 and 12.2.2, this package operates alongside FTE_FREIGHT_PRICING, FTE_FREIGHT_PRICING_UTIL, FTE_QP_ENGINE, and FTE_TL_CACHE to provide the freight rating and routing infrastructure that carriers, shippers, and distribution operations rely upon for cost calculation and shipment planning.

The package is classified as OTHER in API classifications, indicating it is an internal integration package rather than a formally published public API. It is documented as VALID and is referenced by one other package, making it a lower-level utility that supports higher-level freight processing routines.

Key Procedures and Functions

The ETRM metadata documents two procedures or functions within FTE_TL_CORE:

  • TL_CORE — The primary processing entry point. It encapsulates the central transportation-logistics logic, coordinating freight pricing lookups, routing evaluation, and the interaction between the QP (Advanced Pricing) engine and the FTE cache. It is the routine invoked for single-record or single-shipment processing scenarios.
  • TL_CORE_MULTIPLE — A bulk variant of the core routine. It supports processing of multiple records or shipments in a single call, reducing context-switching overhead and improving throughput for high-volume freight rating batches.

Neither procedure's parameter list is documented, so parameters must be obtained from the actual package specification in the database. Both leverage the FND_API error-handling framework and FND_MESSAGE for user-facing error text.

Tables Accessed

The documented table references through APPS synonyms include:

  • WSH_GLOBAL_PARAMETERS — The global parameters table for the Shipping execution module. FTE_TL_CORE reads this to obtain configuration values such as freight terms defaults and shipment cutoff tolerances that govern transportation-logistics behavior.
  • DBMS_UTILITY — A public PL/SQL utility package used for operations such as formatting error stacks, retrieving parameter lists, and performing name resolution within the PL/SQL environment.
  • PLITBLM — An internal PL/SQL table index-by table type used for collection handling inside the package body.

In addition, the dependency list confirms internal calls to FTE_FREIGHT_PRICING, FTE_FREIGHT_PRICING_UTIL, FTE_QP_ENGINE, FTE_RTG_GLOBALS, FTE_TL_CACHE, FTE_TL_CORE (recursive), QP_PREQ_GRP, and WSH_UTIL_CORE, indicating that table access and business logic are heavily delegated to these collaborating packages.

Usage Notes

FTE_TL_CORE is an internal engine package and is not designed for direct invocation by end users. It is typically called from within the FTE freight pricing and routing stack, including from FTE_FREIGHT_PRICING and FTE_QP_ENGINE, which in turn may be invoked by Order Management forms, Oracle Transportation Management interfaces, or concurrent programs that generate freight charges or evaluate routing rules.

The user search term "fte_rtg_globals" corresponds to FTE_RTG_GLOBALS, a dependency package that supplies rating globals and routing parameter values consumed by FTE_TL_CORE. Custom code that needs transportation-logistics core processing should invoke the documented higher-level FTE packages rather than calling FTE_TL_CORE directly, ensuring that initialization of globals, caches, and error handling provided by the surrounding stack is preserved. Because the package is ETRM-documented as referenced by only one other package, changes to its specification carry a correspondingly narrow, though potentially deep, blast radius within the FTE module.