You are browsing the archive for Oracle Transportation Execution.

Freight Payment and Audit Discrepancy Report (XML)

 

NAME: Freight Payment and Audit Discrepancy Report (XML)
SHORT CODE: FTEFPADP_XML
MODULE: Oracle Transportation Execution

Description:
Navigation: Oracle Transportation Execution Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Freight Bill Date From :
  • Freight Bill Date To :
  • Discrepancy Reason :
  • Carrier Name :
  • Sort By 1 :
  • Sort By 2 :
  • DebugFlag : DebugFlag

 

Freight Payment and Audit Discrepancy Report

 

NAME: Freight Payment and Audit Discrepancy Report
SHORT CODE: FTEFPADP
MODULE: Oracle Transportation Execution

Description:
Navigation: Oracle Transportation Execution Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Freight Bill Date From :
  • Freight Bill Date To :
  • Discrepancy Reason :
  • Carrier Name :
  • Sort By 1 :
  • Sort By 2 :

 

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