Search Results g_no_params_found

Overview

FTE_FREIGHT_PRICING_SPECIAL is an Oracle Applications (APPS) PL/SQL package within the Oracle Freight and Transportation Execution (FTE) module, which is delivered as part of Oracle E-Business Suite. Its status is documented as VALID in the ETRM repository, confirming it is a compiled, active database object. The package functions as a specialized pricing engine that extends the core freight rating logic housed in the companion package FTE_FREIGHT_PRICING. Where the parent package applies general rate shopping and carrier selection, FTE_FREIGHT_PRICING_SPECIAL encapsulates the conditional and exception-handling rules that govern less-than-truckload (LTL), parcel, and flat-rate shipment rating.

The package depends directly on FTE_FREIGHT_PRICING and is in turn referenced by it, indicating a tightly coupled design in which the special-rating routines are called from the main pricing flow when standard rate determination cannot satisfy the shipment's characteristics. It is classified in the ETRM registry as an OTHER API, meaning it is not intended for direct external invocation by customers, unlike formal public APIs. The package exposes thirteen documented procedures and functions that together implement dimensional weight calculation, mode-specific processing, minimum charge enforcement, and weight distribution across containers.

Key Procedures and Functions

• INITIALIZE — Performs package-level setup and initialization, establishing working state and any session-level variables required before pricing logic executes.
• APPLY_DIMENSIONAL_WEIGHT — Computes and applies dimensional (volumetric) weight for a shipment, a standard carrier practice that charges on the greater of actual or dimensional weight.
• ISLTL / ISPARCEL — Boolean-style evaluation routines that determine whether the shipment qualifies as less-than-truckload or parcel traffic, routing execution to the correct downstream logic.
• APPLY_MIN_CHARGE — Enforces the carrier's minimum charge threshold, ensuring the calculated rate is never below the contracted floor.
• PROCESS_LTL, PROCESS_PARCEL, PROCESS_OTHERS — Mode-specific rating processors that apply the appropriate freight pricing rules for LTL, parcel, and other shipment classifications.
• PROCESS_SPECIAL_CONDITIONS — Evaluates and applies exception rules and special pricing conditions that override or modify the base rate.
• RATE_CONTAINER_ALL — Rates all containers associated with the shipment in a single pass.
• DISTRIBUTE_LTL_CONTAINER_WT — Allocates LTL weight across containers to support accurate rating of consolidated loads.
• PROCESS_SHIPMENT_FLATRATE — Handles flat-rate shipment pricing, bypassing weight-based calculation.
• LOAD_CARRIER_DIM_WEIGHT_PARAMS — Retrieves carrier-specific dimensional weight parameters used by the weighting routines.

Tables Accessed

The package reads configuration and master data through APPS synonyms. FTE_PRC_PARAMETERS and FTE_PRC_PARAMETER_DEFAULTS supply pricing parameters and their fallback values, forming the input backbone for rate determination. MTL_SYSTEM_ITEMS and MTL_CATEGORIES provide item master and category attributes used in dimensional weight and item-level rule evaluation. WSH_CARRIERS, WSH_CARRIER_SERVICES, and WSH_GLOBAL_PARAMETERS deliver carrier, service-level, and global logistics configuration. The package also invokes DBMS_UTILITY and PLITBLM, the standard Oracle utilities used for PL/SQL table handling and structural operations.

Usage Notes

FTE_FREIGHT_PRICING_SPECIAL is invoked indirectly through FTE_FREIGHT_PRICING during the freight rating cycle, which is triggered from shipping confirmation transactions, freight rating concurrent programs, and the transportation management forms. Because it is a dependent implementation package rather than a published API, customizations should not call its procedures directly; instead, extend pricing behavior through supported configuration in FTE_PRC_PARAMETERS or by wrapping the parent FTE_FREIGHT_PRICING package. Both Oracle EBS 12.1.1 and 12.2.2 environments include this package as part of the FTE schema delivered under the APPS account.