Results for “fte_rtg_globals”

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

Overview

FTE_RTG_GLOBALS is a global constants package within the Oracle E-Business Suite Freight and Transportation Execution (FTE) module, part of the Oracle Transportation Management and Logistics family. Its sole purpose is to centralize and expose the internal code values, basis identifiers, and pricing attribute mapping constants used throughout the FTE rating and cost allocation engine. Rather than scattering numeric and character literals across the rating packages, Oracle developers consolidated them here so that every dependent package references a single, authoritative source. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema and performs no privileged operations of its own — it is a passive container of declarations.

The package sits at the foundation of the FTE rating stack. It carries no business logic, no exception handling, and no data manipulation; it simply publishes named constants that drive rate basis selection, cost allocation assignments, carrier unit conversions, and the mapping between FTE pricing attributes and Oracle Advanced Pricing (QP) attribute columns.

Key Procedures and Functions

The ETRM documentation records zero procedures or functions in this package. This is consistent with its design: FTE_RTG_GLOBALS is a specification-only package that declares public constants and variables. No callable API surface is exposed beyond the constant values themselves. Consumers reference the constants directly, for example FTE_RTG_GLOBALS.G_WEIGHT_BASIS or FTE_RTG_GLOBALS.G_A_TL_RATE_BASIS, rather than invoking a subroutine.

The constants fall into four documented groups:

• Internal basis codes — numeric identifiers (G_WEIGHT_BASIS through G_FLAT_BASIS) representing weight, volume, container, pallet, distance, time, and flat rating bases.
• Cost allocation basis codes — single-character codes (W, V, P, D, A) denoting weight, volume, pickup stop, delivery stop, direct distance, and total distance allocation methods.
• Carrier unit basis codes — descriptive strings (WEIGHT, VOLUME, CONTAINER, PALLET) used when interfacing with carrier-supplied rating data.
• TL rating pricing attributes and contexts — paired constants mapping FTE rating concepts (rate basis, discount flag, deadhead rate variance, distance type, rate type, service type, vehicle, origin/destination zone) to the logistics context ('LOGISTICS') and the corresponding Advanced Pricing attribute columns (PRICING_ATTRIBUTE7 through PRICING_ATTRIBUTE19).

Tables Accessed

The ETRM metadata documents no referenced tables for this package. This is expected, as the package contains only declarations and performs no SQL. The constants it publishes are, however, used by dependent packages that do access rating and pricing tables. The metadata indicates FTE_RTG_GLOBALS is referenced by six other packages, which form the consuming layer of the FTE rating engine.

Usage Notes

FTE_RTG_GLOBALS is not invoked directly by end users, forms, or concurrent programs in the conventional sense. It is compiled and referenced at runtime by the FTE rating packages that depend upon it. Practically, the package is exercised whenever the transportation rating engine evaluates a shipment, builds a rate request to Oracle Advanced Pricing, or applies a cost allocation rule. The PRICING_ATTRIBUTE mappings are of particular operational significance: they define which seeded QP attribute columns carry FTE logistics context values, so any customization that repurposes those attribute columns risks conflicting with FTE rating behavior.

The version header (115.8, dated 2004) indicates the package has been stable across releases and is shared between EBS 12.1.1 and 12.2.2 without functional change. Because it is a constants-only package, it carries negligible runtime cost, but its values are load-bearing: altering them would cascade into every dependent rating package. Note that the search term "Tourgy support" does not correspond to any documented FTE feature; it is unrelated to this object.