Search Results rate_delivery2




Overview
Explore in AI Chat

Overview

FTE_FREIGHT_RATING_DLVY_GRP is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as a Group (GRP) API within the Oracle Transportation Management / ETRM (Freight and Transportation Execution) module. Its primary business function is to rate deliveries — that is, to determine applicable freight charges, service levels, and carrier assignments for outbound delivery records managed by Oracle Shipping Execution (WSH). The package acts as the central orchestration point that ties delivery data (delivery details, delivery legs, and trip assignments) to carrier service definitions, freight cost records, and the freight rating engine. It is validated and documented in both EBS 12.1.1 and 12.2.2, and it is referenced by other public APIs including FTE_DELIVERY_PUB, FTE_TRIP_RATING_GRP, and WSH_FTE_INTEGRATION, which confirms its role as a shared, cross-module rating utility rather than a private implementation detail.

Key Procedures and Functions

Six documented procedures and functions are exposed by the package:

  • RATE_DELIVERY — The primary entry point for rating a single delivery. It evaluates the delivery's legs, stops, carrier, and service requirements and produces freight cost records for the delivery.
  • RATE_DELIVERY2 — A variant of the rating routine, likely supporting an extended or alternate rating mode (for example, a different cost basis or additional return parameters) while preserving the original RATE_DELIVERY interface for backward compatibility.
  • CANCEL_SERVICE — Reverses or cancels a previously requested or rated service, such as removing freight costs or undoing an assignment when a delivery is cancelled or modified.
  • API_POST_CALL — A standard API-wrapper hook that executes post-processing logic after the main rating call, consistent with the FND_API pattern used across EBS public APIs.

The remaining documented entries cover the specification and body subobjects. Parameter lists should be confirmed against the actual package specification in the target instance.

Tables Accessed

The package reads and writes a broad set of WSH and FTE tables through APPS synonyms. Delivery-side data comes from WSH_DELIVERY_DETAILS, WSH_DELIVERY_ASSIGNMENTS, WSH_DELIVERY_LEGS, and WSH_NEW_DELIVERIES. Trip data comes from WSH_TRIPS and WSH_TRIP_STOPS, which supports trip-level rating performed by FTE_TRIP_RATING_GRP. Carrier and service configuration is drawn from WSH_CARRIERS, WSH_CARRIER_SERVICES, and WSH_ORG_CARRIER_SERVICES. Rating output is written to WSH_FREIGHT_COSTS. Reference and setup tables include FTE_VEHICLE_TYPES, HZ_PARTIES (for party/address context), MTL_PARAMETERS (inventory organization parameters), WSH_GLOBAL_PARAMETERS (system-wide defaults), and DBMS_UTILITY for generic PL/SQL utilities. These accesses confirm that the package both queries configuration and creates/updates freight cost records.

Usage Notes

FTE_FREIGHT_RATING_DLVY_GRP is typically invoked indirectly rather than called directly by end users. Oracle Shipping forms and the freight rating concurrent programs reach it through FTE_DELIVERY_PUB and WSH_FTE_INTEGRATION, while trip rating flows reach it through FTE_TRIP_RATING_GRP. In custom development, it should be called only through FND_API-compliant public entry points such as RATE_DELIVERY and RATE_DELIVERY2, with API_POST_CALL invoked after the main call and CANCEL_SERVICE used to unwind ratings. Because freight cost records are transactional, calls should participate in a proper transaction boundary with savepoints and rollback handling, and the package should not be modified in a supported EBS 12.1.1 or 12.2.2 installation.