NAME: DTT Bulk Loader
SHORT CODE: FTE_BULK_DTT_LOADER
MODULE: Oracle Transportation Execution

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

Report Parameters:

• p_load_id : Load Id for Bulk Load
• p_src_filename : File name of DTT Loader file
• p_src_filedir : Directory of DTT Loader file
• p_user_debug : Turns debug output on or off

NAME: DTT Bulk Download
SHORT CODE: FTE_BULK_DTT_DOWNLOAD
MODULE: Oracle Transportation Execution

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

Report Parameters:

• p_load_id : Load ID for Bulk Download
• p_src_filename : Filename of DTT Download File
• p_src_filedir : Directory of DTT Download File
• p_user_debug : Turns Debug Output on or off
• p_template_id : Template Identifier used for download
• p_origin_facility_id : Origin location id
• p_origin_region_id : Origin Region Id
• p_origin_all_fac_flag : Flag for all origin locations
• p_all_fac_no_data_flag : Flag for all locations with no DTT data
• p_dest_facility_id : Destination facility Id
• p_dest_region_id : Destination Region Id
• p_dest_all_fac_flag : Flag for all destination facilities
• p_file_extension : file extension of download file

NAME: FTE BulkLoad Concurrent Program
SHORT CODE: FTE_BULKLOADER
MODULE: Oracle Transportation Execution

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

Report Parameters:

• p_load_id : Load ID for Bulk Load
• p_src_filename : Filename of Rate Chart File
• p_currency : Currency of Rate Chart
• p_uom_code : UOM of Rate Chart
• p_orig_country : Origin Country Code
• p_dest_country : Destination Country Code
• p_service_code : Service Level Code
• p_action_code : Action Code
• p_tariff_name : Tariff Name
• p_user_debug : Turns debug output on or off