Search Results c_ranklist_source_tp




Overview
Explore in AI Chat

Overview

WSH_FTE_INTEGRATION is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that acts as the integration layer between Oracle Transportation Management (OTM) and the EBS Order Management, Shipping, and Transportation execution flow. The package is part of the Freight and Transportation Execution (FTE) functionality delivered with Oracle EBS 12.1.1 and 12.2.2, and it exposes the application programming interfaces that allow EBS to hand off shipment, trip, and delivery information to external transportation planning engines and to receive rating, routing, and carrier selection results back into the EBS data model. Its header, originally shipped under WSHFTEIS.pls (version 120.4), declares the record and table types used to marshal carrier selection input and output between the two systems, along with constants such as C_RANKLIST_SOURCE_TP that identify the source of a rank list.

Key Procedures and Functions

The package exposes seventeen documented procedures and functions grouped into three functional areas: carrier selection and rating, trip and shipment execution, and referential lookups.

  • CARRIER_SELECTION — drives the carrier selection process for a delivery or set of deliveries, applying transportation rules and rank lists to determine eligible carriers.
  • RATE_DELIVERY and RATE_TRIP — invoke rating logic to price a delivery or an entire trip against the configured freight rates.
  • CREATE_RANK_LIST_BULK — bulk-creates rank list entries, allowing multiple carrier ranking records to be inserted in a single call. This is the object most commonly sought by developers searching for create_rank_list_bulk.
  • RANK_LIST_ACTION — performs actions against an existing rank list, such as invoking, releasing, or updating rank list state.
  • SHIPMENT_PRICE_CONSOLIDATE — consolidates shipment pricing results returned from the transportation engine.
  • CARRIER_SEL_CREATE_TRIP — creates a trip from the outcome of a carrier selection run.
  • TRIP_ACTION and TRIP_STOP_VALIDATIONS — execute trip-level actions and validate stop sequences and attributes.
  • CANCEL_SERVICE — cancels a transportation service associated with a shipment or trip.
  • GET_TRIP_MOVE, GET_VEHICLE_TYPE, GET_VEHICLE_ORG_ID, GET_CC_OBJECT_NAME, and GET_ORG_ORGANIZATION_INFO — lookup utilities returning trip moves, vehicle types, owning organizations, object names, and organization information for a given entity (trip, stop, delivery, or detail).

Tables Accessed

The package reads and writes the core FTE and shipping tables via APPS synonyms:

  • FTE_TRIP_MOVES — stores the movement segments of a trip, used by GET_TRIP_MOVE and trip actions.
  • FTE_VEHICLE_TYPES — defines the vehicle types available for trip planning; referenced by GET_VEHICLE_TYPE.
  • WSH_DELIVERY_LEGS — holds delivery leg details used during rating and carrier selection.
  • WSH_TRIPS — the master trip table, written during trip creation and actions.
  • WSH_TRIP_STOPS — stores stop-level details validated by TRIP_STOP_VALIDATIONS.
  • PLITBLM — the standard EBS PL/SQL index-by table of messages, used to return error and status messages.

Usage Notes

WSH_FTE_INTEGRATION is normally invoked from the Oracle Transportation Management integration concurrent programs, from the Shipping Transactions and Transportation forms, or from custom PL/SQL wrappers that extend EBS transportation processing. Because it is referenced by seventeen other packages, direct modification is not advisable; customizations should call the documented procedures. The CREATE_RANK_LIST_BULK and RANK_LIST_ACTION entries are the standard entry points for populating and managing carrier rank lists programmatically. All calls are subject to the standard EBS API conventions: initialization of the message list, commit or rollback by the caller, and validation of the returned message table.