Search Results fte_tl_rating




Overview
Explore in AI Chat

Overview

FTE_FREIGHT_RATING_PUB is a public PL/SQL API within the Oracle E-Business Suite Transportation Management (formerly ETRM) module, owned by the APPS schema. Its purpose is to expose freight rating logic — the calculation of carrier freight charges for a given shipment, order release, or pricing request — to external callers such as concurrent programs, forms, and other PL/SQL packages. The package encapsulates the rating engine that determines applicable carrier services and cost types, retrieves pricing data, and returns computed freight costs to the calling application.

In the context of Oracle EBS 12.1.1 and 12.2.2, this package is a stable, VALID object and is classified as a public API (PUB). It builds on the foundational FND_API error-handling framework and depends on FTE_PROCESS_REQUESTS, the package that manages freight rating and carrier selection requests. The package is referenced by other APPS objects, including FTE_PROCESS_REQUESTS, FTE_TL_RATING, and itself, indicating that it participates centrally in the transportation rating workflow.

Key Procedures and Functions

The documented API surface includes one entry point:

  • GET_FREIGHT_COSTS — Returns the freight costs calculated for a given rating request. Callers invoke this procedure or function to obtain the monetary freight charges derived from the rating engine, covering base charges, accessorials, and related cost components associated with a carrier service. The procedure relies on the standard FND_API message and return-status conventions for error reporting and does not expose an inventable parameter list here.

Tables Accessed

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

  • FTE_PRICING_COMP_REQUEST_S — Stores pricing computation requests; used to persist and retrieve the request context for which freight costs are being computed.
  • WSH_CARRIERS — Carrier master data used to resolve the carrier associated with a rating request.
  • WSH_CARRIER_SERVICES — Defines the services offered by each carrier, used to determine which service applies to the shipment being rated.
  • WSH_FREIGHT_COST_TYPES — Defines valid cost type codes (e.g., base charge, fuel surcharge, accessorial) so that returned costs are properly categorized.
  • WSH_ORG_CARRIER_SERVICES — Maps operating units or organizations to the carrier services enabled for them, restricting rating to valid combinations.
  • DBMS_UTILITY and PLITBLM — Oracle-supplied utilities used for PL/SQL diagnostics and PL/SQL table manipulation.

Usage Notes

FTE_FREIGHT_RATING_PUB is typically invoked during the freight rating and carrier selection process. The most common caller is FTE_PROCESS_REQUESTS, which orchestrates rating requests on behalf of concurrent programs, shipment workflows, and the Transportation Manager responsibility. FTE_TL_RATING also references the package to drive rate lookup and cost computation for transportation lanes.

Because the API is public, custom code should call it rather than modifying the package directly. Relevant considerations include:

  • Confirm that the required carrier service, org-carrier-service mapping, and cost type records exist before invoking the API.
  • Always check the API’s return status and message stack (per FND_API conventions) before consuming returned costs.
  • In 12.2.2, the object remains valid and unchanged in classification; no patches alter its public signature documented here.

The object is depended upon by at least two other packages, reinforcing that customization or extension should occur through supported extension points rather than direct edits to this package’s specification or body.