You are browsing the archive for FTE.

Oracle Transportation Execution Tables

Oracle Transportation Execution module – List of database tables:

Oracle Transportation is also known as GLOG.

  • FTE – Transportation Execution
  • FTE_BATCH_JOBS
  • FTE_BULKLOAD_DATA
  • FTE_BULKLOAD_FILE
  • FTE_CHRG_PRC_ATTRIBUTES
  • FTE_CHRG_PRC_ATTRIBUTES_TEMP
  • FTE_DELIVERY_PROOF
  • FTE_DOCUMENT_DEFINITION
  • FTE_DOCUMENT_PRINT_SETUP
  • FTE_DOCUMENT_STYLE_SHEET
  • FTE_FACILITY_CARRIERS
  • FTE_FAILURE_REASONS
  • FTE_FREIGHT_COSTS_TEMP
  • FTE_INTERFACE_LANES
  • FTE_INTERFACE_ZONES
  • FTE_INVOICE_HEADERS
  • FTE_INVOICE_HISTORY
  • FTE_INVOICE_LINES
  • FTE_JOB_ERRORS
  • FTE_LANES
  • FTE_LANES_DETAIL_INTERFACE
  • FTE_LANES_MASTER_INTERFACE
  • FTE_LANE_COMMODITIES
  • FTE_LANE_EQUIPMENTS
  • FTE_LANE_GROUPS
  • FTE_LANE_GROUP_COMPONENTS
  • FTE_LANE_RATE_CHARTS
  • FTE_LANE_SECURITY_SETTINGS
  • FTE_LANE_SERVICES
  • FTE_LANE_VEHICLES
  • FTE_LOAD_CHARGES
  • FTE_LOAD_CHARGES_INTERFACE
  • FTE_LOAD_CHARGES_TEMP
  • FTE_LOAD_CONTRACT_COMMITMENTS
  • FTE_LOAD_DETAILS
  • FTE_LOAD_DETAILS_INTERFACE
  • FTE_LOAD_HEADERS
  • FTE_LOAD_HEADERS_INTERFACE
  • FTE_LOAD_HISTORY
  • FTE_LOAD_PRC_ATTRIBUTES
  • FTE_LOAD_PRC_ATTRIBUTES_TEMP
  • FTE_LOAD_SCHEDULES
  • FTE_LOAD_SCHEDULES_INTERFACE
  • FTE_LOCATION_MILEAGES
  • FTE_LOCATION_PARAMETERS
  • FTE_MESSAGE_ADDRESS
  • FTE_MESSAGE_CONTACT
  • FTE_MESSAGE_LOCATION
  • FTE_MESSAGE_PARTNER
  • FTE_MILE_ATTRIBUTES
  • FTE_MILE_COLUMN_ATTRIBUTES
  • FTE_MILE_DOWNLOAD_FILES
  • FTE_MILE_DOWNLOAD_LINES
  • FTE_MILE_TEMPLATES
  • FTE_MILE_TEMPLATE_COLUMNS
  • FTE_MOVES
  • FTE_MOVES_INTERFACE
  • FTE_NOTIFICATION_ROUTINGS
  • FTE_PARTY_REGIONS
  • FTE_PA_SHIP_DETAILS
  • FTE_PRC_PARAMETERS
  • FTE_PRC_PARAMETER_DEFAULTS
  • FTE_PTRK_EVENTS
  • FTE_PTRK_PAGES
  • FTE_PTRK_PARAMS
  • FTE_PTRK_SOURCES
  • FTE_QP_CONTROL_REC_TEMP
  • FTE_QP_LINE_ATTR_TEMP
  • FTE_QP_LINE_DETAIL_TEMP
  • FTE_QP_LINE_TEMP
  • FTE_QP_QUAL_TEMP
  • FTE_REGIONS
  • FTE_REGIONS_INTERFACE
  • FTE_REGIONS_TL
  • FTE_REGIONS_TL_INTERFACE
  • FTE_SCHEDULES
  • FTE_SCHEDULES_INTERFACE
  • FTE_SEL_ATTRIBUTES
  • FTE_SEL_ATTRIBUTES_TMP
  • FTE_SEL_GROUPS
  • FTE_SEL_GROUP_ASSIGNMENTS
  • FTE_SEL_GROUP_ATTRIBUTES
  • FTE_SEL_OBJECTS
  • FTE_SEL_RESULTS
  • FTE_SEL_RESULT_ASSIGNMENTS
  • FTE_SEL_RESULT_ATTRIBUTES
  • FTE_SEL_RULES
  • FTE_SEL_RULE_RESTRICTIONS
  • FTE_SHIPMENT_STATUS_DETAILS
  • FTE_SHIPMENT_STATUS_EXCEPTIONS
  • FTE_SHIPMENT_STATUS_HEADERS
  • FTE_TARIFF_CARRIERS
  • FTE_TENDER_SNAPSHOT
  • FTE_TRACKING_PAGE_PARAMS
  • FTE_TRACKING_PAGE_SETUP
  • FTE_TRACKING_USER_SETUP
  • FTE_TRANSACTION_ACTIVITIES
  • FTE_TRANSACTION_DELETES
  • FTE_TRANSACTION_HISTORY
  • FTE_TRANSACTION_INTERFACES
  • FTE_TRANSACTION_PARAMETERS
  • FTE_TRANSACTION_RELATIONS
  • FTE_TRANSACTION_RENAMES
  • FTE_TRANSACTION_VARIABLES
  • FTE_TRIPS
  • FTE_TRIP_MOVES
  • FTE_TRIP_MOVES_INTERFACE
  • FTE_TX_ENGINE_PARAMETERS
  • FTE_VEHICLE_FEATURES
  • FTE_VEHICLE_TYPES
  • FTE_WORKFLOW_SETUP
  • FTE_WSH_TRIPS

Transportation Execution Profile Options

Oracle Transportation Execution Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
FTE_BULKLOAD_SOURCE_TYPE FTE: Bulkload Source Type
FTE_PRC_LOG_LEVEL FTE : Freight Rating Log Level
FTE_EFR_COMMODITY_CODE FTE: Freight Estimation default commodity code
FTE_EFR_SHOW_TL_RATES FTE: Freight Estimation default TL mode selection
FTE_EFR_VEHICLE_TYPE FTE: Freight Estimation default vehicle type
FTE_PRC_DEBUG_FLAG FTE: Debug Freight Rating
FTE_PRC_DEBUG_LOG_DIR FTE: Freight Rating Debug Log Directory
FTE_BULKLOAD_DIR FTE: Bulk Load Directory
FTE_EFR_SHOW_LTL_RATES FTE: Freight Estimation default LTL mode selection
FTE_EFR_SHOW_PARCEL_RATES FTE: Freight Estimation default Parcel mode selection
FTE_EFR_ORG_COUNTRY FTE: Freight Estimation Default Origin Country
FTE_EFR_DEST_COUNTRY FTE: Freight Estimation Default Destination country
FTE_FPA_NUM_OF_BILLS_PROCESSED FTE: Number of bills to be processed
FTE_DISTANCE_LVL FTE: Distance Level
FTE_LATESHIP_OFFSET_DAYS FTE: Late Ship Offset Days
FTE_ORIGIN_COUNTRY FTE: Default Country for Origin
FTE_DEST_COUNTRY FTE: Default Country for Destination
FTE_CARRIER_ARR_WINDOW FTE: Carrier On-time Arrival Window
FTE_PRC_MAX_LANES FTE: Max number of services to rate

Views in Transportation Execution Module

List of Views in Oracle Transportation Execution Module

FTE_CARRIER_VEHICLE_TYPES_V
FTE_FPA_BOLS_V
FTE_LANE_GROUPS_DFV
FTE_LOCATION_PARAMETERS_DFV
FTE_PRC_LANE_COMP_UI_V
FTE_PRC_VIEW_PRICE_UI_V
FTE_PTRK_TOKENS_V
FTE_SEL_GROUPS_DFV
FTE_STOP_FREIGHT_CLASS_V
FTE_STOP_HAZARD_CLASS_V
FTE_STOP_ORDER_NUMBERS_V
FTE_TRIP_STOP_ACTIVITIES_V