PATCH C-TMS P042

From Calidus HUB
Revision as of 09:37, 15 July 2022 by StylesC (talk | contribs)




Aptean Logo.png







{{{Client}}}

Release Notes

CALIDUS TMS

14th July 2022 - 1.0
Reference: P042











































SUMMARY INTRODUCTION

INTRODUCTION

The main aim of this document is to provide CALIDUS TMS users with the level of detail required to accurately test all software included in the patch. The document also contains set-up and configuration details to enable the user to configure the system correctly for the new functionality to work.


GLOSSARY OF TERMS

Term Meaning
C-TMS Transport Management System
C-WMS Warehouse Management System
CR Change Request
C-WCS Warehouse Control System
C-ePOD Electronic Proof of Delivery
C-MCS Mobile Control System
C-TTM Track and Trace Management
EDI Electronic Data Interchange
TID Testing Issue Development, or Log


TESTING PROCESS

TIDs AND RESOLUTION

If there are any areas of the functionality that are not acceptable or do not meet the requirement specified in the Change Request then these should be expressed by raising a TID.


FINAL 'END TO END' TESTING

Prior to release to a production database, a full 'End to End' test is required on the test system by all sites using the database. Once this is signed off, a release date can be arranged.


AUTHORISATION

Authorisation from nominated release personnel only will be required when requesting a release to a production environment


CHANGE REQUESTS

Customer Ref:

OBS Log Number: Reporter:
Summary of Call
Detail of Fix
Set-up and Configuration No set-up/configuration required

Customer Ref:

OBS Log Number: Reporter:
Summary of Call
Detail of Fix
Set-up and Configuration No set-up/configuration required


BUGS

Log Number: 01584585

Summary of Call CTL email notification
Detail of Fix Fixed package to check for from email address etc. Fix view to display email flag correctly.
Set-up and Configuration No set-up/configuration required


Log Number: 01929119

Summary of Call Label changes
Detail of Fix

CTMS A new system parameter called 'OMS_INVALID_SAME_LOCS' can be set to 'Y' or 'N' (default). If 'Y', the order status will be 'INVALID' when the 'from' and 'to' locations are the same for master or child locations. The user will be warned when an order is entered in the 'Orders' screen and the locations are the same. Customer labels will account for any contacts for the order when the 'from' and 'to' locations. One label will be printed per item with the first contact included for the 'to' location.

Portal Added check to OMS_INVALID_SAME_LOCS - if N then same allowed. If Y then Portal will give an error if user enters same to/from location. Checked printing labels OK with same location selected and multiple contacts. Amended Order Receipt to use Aptean logo instead of OBS.

Set-up and Configuration No set-up/configuration required


Log Number: 00279865

Summary of Call TMS Browserless
Detail of Fix Omitted Van Fleet, RIT and Carr ID because they are later additions and the current width will then be for those columns not ORDER_ID.

Then the default width would be 725 and within the stated limit.

Set-up and Configuration No set-up/configuration required


Log Number: 00281601

Summary of Call Planning Screen RIT code
Detail of Fix Add in DP_PAR_API to resolve RIT source information
Set-up and Configuration No set-up/configuration required


Log Number: 00260026

Summary of Call ORS Report - extending use of time zones
Detail of Fix The ORS extracts should include the time zone for the user for their queries and their columns of data.
Set-up and Configuration No set-up/configuration required


Log Number: 01976934

Summary of Call Split Messages
Detail of Fix Allow message types to be split into 2 jobs
Set-up and Configuration No set-up/configuration required


Log Number: 01985598

Summary of Call Code amendment to accommodate labels response greater then 32000
Detail of Fix Changes to the label format to accommodate large numbers of labels
Set-up and Configuration No set-up/configuration required


Log Number: 02042658

Summary of Call LFE POD files not updating orders in CTMS with delivered qty
Detail of Fix Advised that the setup can be changed to extract the data correctly.

Added extra auditing when a tracking reference is not found for the order to update.

Any double quotation marks will be removed.

Set-up and Configuration No set-up/configuration required


Log Number: 02065820

Summary of Call CTMS to EPOD interface
Detail of Fix The outbound messages to EPOD will enable transport units of up to 30 characters in length to be included in the 'EPL_CONTAINER_ID' tag for the order items.

An audit log will be written for any generic errors that occur during processing.

Set-up and Configuration No set-up/configuration required


Log Number: 02066885

Summary of Call Some items when scanned out count twice on the scanner and an item still showing as missing on the scanner after it has been scanned in.
Detail of Fix The new system parameter called 'WCS_441_CHECK_DAYS' can be set to a number of days in which to assess the prior loading messages for WCS. The default number of days will be 10 days prior to the system date.

Assesses if the '441' message should be sent to C-WCS to advise the loading of an item on a trip.

An item will not be sent for loading when it has been created for a new order on the same trip as the original order when that item is received into the depot on an unexpected trip.

An item will not be sent for loading when it has been created for a new order that has been loaded onto an unexpected trip.

An item will be sent for loading when it has been moved into a new despatch bay, or when it has had its previous loading message for the same despatch bay deleted in the meantime.

Set-up and Configuration No set-up/configuration required


Log Number: 02041304

Summary of Call Order XML not updating lines
Detail of Fix The DSPD messages will add all the advised tracking references to orders that are being packed and despatched at that time from the warehouse.
Set-up and Configuration No set-up/configuration required


Log Number: 01984366

Summary of Call Items flagging as unknown items on the scanner when it comes to outbound scan
Detail of Fix The system parameter 'TRM_MOVE_ITEM_TO_DESP_BAY' can be used to move an item to the despatch bay when it is added to the order on the trip or its order is assigned to the trip.

'Adding Orders to Trips':

The system parameter 'TRM_MOVE_ITEM_TO_DESP_BAY' can be used to move an item without a current location, from the grid, or from another despatch bay in the depot to the despatch bay when its order is added to the trip.

It will be moved to the despatch bay for its planned trip out of the depot when 'TRM_MOVE_ITEM_TO_DESP_BAY' is 'Y'.

It will not be moved to the despatch bay for its planned trip out of the depot when 'TRM_MOVE_ITEM_TO_DESP_BAY' is 'N'.

Set-up and Configuration No set-up/configuration required


Log Number: 02117529

Summary of Call Access Control - Resources tab
Detail of Fix Tab following pages are enabled to authorise for user groups in the 'Resource Maintenance' screen:

1. Carriers

2. Carrier Groups

3. Carrier Lanes

4. Carrier Types

5. Carrier Service Level

6. Service Types

7. Fixed Charges

8. Trailer Types

9. Trailer Group

10. Trailers

11. Drivers

12. Loc Prd Conv

13. Despatch Unit Types

14. Standardised Du's

15. RPE's

16. RPE Cust

17. Load Rates

18. Tractors

19. Vessels

20. Resource Availability

21. Carrier Routing

22. Carrier Routing UKMail

23. Carrier Formats

24. Carrier Tracking

25. Carrier Config

26. Vehicles

27. Carrier Hazard Qty

28. Own Charges

29. Carrier Formats Mapping

30. Prd DU Load

31. Equipment

Set-up and Configuration No set-up/configuration required


Log Number: 02126440

Summary of Call Missing ORS Fields
Detail of Fix Missing ORS fields. Add inactive flag (from 359779) and free text fields (from dev 373170)
Set-up and Configuration No set-up/configuration required


Log Number: 02112923

Summary of Call Portal - Order Entry
Detail of Fix Changed the route query to use a distinct set of values.

Added ROLLBACK for when an order fails to auto-plan to a trip.

Set-up and Configuration No set-up/configuration required


Log Number: 02069996

Summary of Call Deadlocks between EPOD & TomTom
Detail of Fix Any changes will be rolled back when an EPOD job detects a locked record or another error has occurred during processing.
Set-up and Configuration No set-up/configuration required


Log Number: 02123480

Summary of Call CTMS Orders which should have autoscheduled to trips went on Express
Detail of Fix Orders will be resubmitted later should an error occur in the standard scheduling engine for parcel carriers due to record locking or unique constraints being detected due to concurrent user activity in the Planning screen.

Then the order will not assess the next route for the same carrier or a route for the next carrier.

Set-up and Configuration No set-up/configuration required


Log Number: 02131348

Summary of Call API import to check order status
Detail of Fix Only write PAR record for amendments based on status, RIT, vehicle and manual schedule check
Set-up and Configuration No set-up/configuration required


Log Number: 02124954

Summary of Call Reporting suite edi COMMENTS_BIOSTRMEL - contact name
Detail of Fix The contact name for the orders in the ORS extracts can contain the forename and the surname.
Set-up and Configuration No set-up/configuration required


Log Number: 02110684

Summary of Call Order Entry - Delivery Type
Detail of Fix The standard and fast order entry screens will exclude inactive delivery types and service levels from the lists of values for selection.
Set-up and Configuration No set-up/configuration required


Log Number: 02121883

Summary of Call BASED_AT preventing search results
Detail of Fix The forms(ORDERS and ORDERS_WIDE) are modified to include UNSCHEDULED orders based on FROM and TO locations.
Set-up and Configuration No set-up/configuration required


Log Number: 00242929

Summary of Call EDI Maintenance displays a password
Detail of Fix In EDI_MAINT screen, the text attribute which was holding passwords is concealed so that it's not visible now.

Added 'Conceal/Reveal' button to 'FTP_DETAILS' screen. The text attribute which was holding passwords is concealed so that it’s not visible at default state, when the authorized user clicks the reveal button it is displayed and can be concealed again by clicking conceal button.

Added 'Save' Button to the 'FTP_DETAILS' screen. Added 'Validation' to both 'FTP_DETAILS' and 'DEVICE_WIN' screens, to check whether the user enters the required info for an FTP connection. Added new amendments should activate both the 'Save and Cancel' buttons on the 'EDI_MAINT' screen.

Set-up and Configuration No set-up/configuration required


Log Number: 00256553

Summary of Call REA - Interface Errors - Correction screen not always displaying the extracted data.
Detail of Fix Temp Combo Field has been modified from Poplist to LOV, thereby Error correction field is able to extract all the data from the record being processed
Set-up and Configuration No set-up/configuration required


Log Number: 00322735

Summary of Call ORS report update
Detail of Fix ORS update for date fields following an update for timezones
Set-up and Configuration No set-up/configuration required



INCIDENTS

Log Number: 00282311

Summary of Call ORS screen not always displaying a new report in the list of reports when the list is refreshed
Detail of Fix Modified 'clear_form_safely' and 'pop_rep_list' in the ORS.fmb Form to mitigate the scrolling problem.
Set-up and Configuration No set-up/configuration required


Log Number: 01988611

Summary of Call CTMS - allow SFTP
Detail of Fix Added general SFTP to product. Added to MIS processing so this can be sent out via SFTP.
Set-up and Configuration No set-up/configuration required


Log Number: 00319844

Summary of Call SRV: File failures in MIXMOVE
Detail of Fix Files will be archived for MIXMOVE failures.
Set-up and Configuration No set-up/configuration required



PRODUCT DEVELOPMENT

Log Number: 00233816

Summary of Call Oracle testing
Detail of Fix System parameter DEFAULT_ORACLE_DIRECTORY can be set to 'TMS_DIR' to activate the new functionality for 19c databases.

UTL_FILE has been modified to create a new directory for 19c changes in databases.

​Able to generate both FTP and receive mail for EXPORTS, REPORTS and ORS in individual screens and EDI maintenance screen.

Oracle system directories will need to be created for the database.

Set-up and Configuration
New Parameters
Parameter Name Config Level Setting Value Result
DEFAULT_ORACLE_DIRECTORY SYSTEM TMP_DIR The database will use system directories for file handling in 19c databases.
DEFAULT_ORACLE_DIRECTORY SYSTEM NONE The standard file handling will apply.



MODULES DELIVERED

Module Name Version No Description Log Number
AT_ACC_SERVICES_00278514.sql 1.1 Data Script 00278514
AT_CNT_DEL_TYPE_239646_440451.sql 1.1 Data Script 00239646
AT_CNT_SERVICE_LEVEL_00308136.sql 1.1 Data Script 00308136
AT_EPOD_WEB_SERVICE_AUDIT_00266101.sql 1.1 Data Script 00266101
AT_GEO_LOCATION_01909696.sql 1.1 Data Script 01909696
AT_GEO_LOCATION_239646_440451.sql 1.1 Data Script 00239646
AT_INT_ORD_XML_DETAILS_0026610 1.1 Data Script 00266101
AT_INT_XML_ORD_HEADER_00266101 1.1 Data Script 00266101
AT_ORD_TYRE_INSPECTION_287638.sql 1.1 Data Script 00287638
AT_ORG_CUSTOMER_00273451.sql 1.1 Data Script 00273451
AT_ORS_SQL_260441.sql 1.1 Data Script 00260441
AT_PAR_API_STAGING_00266101.sq 1.1 Data Script 00266101
AT_RES_CARRIER_01966393.sql 1.1 Data Script 00287229
AT_RES_TRACTOR_239646_440451.sql 1.1 Data Script 00239646
AT_RES_TRAILER_239646_440451.sql 1.2 Data Script 00239646
AT_RES_TRAILER_TYPE_01966393.s 1.1 Data Script 00287229
AT_RES_TRAILER_TYPE_296022.sql 1.1 Data Script 00296022
AT_RES_VEHICLE_TYRE_310663.sql 1.1 Data Script 00310663
AT_SCH_ORD_239646_440451.sql 1.1 Data Script 00239646
AT_SCH_ORD_ITEMS_00266101.sql 1.2 Data Script 00266101
AT_SCH_ORD_ITEMS_239646_440451.sql 1.2 Data Script 00239646
AT_SCH_ORD_ITEMS_265284.sql 1.1 Data Script 00265284
AT_SCH_ORD_ITEMS_294874.sql 1.1 Data Script 00294874
AT_SCH_ORD_TRACKING_01899265.sql 1.1 Data Script 01899265
AT_SCH_ORD_VEHICLE_287638.sql 1.1 Data Script 00287638
AT_SCH_TRIP_00266101.sql 1.1 Data Script 00266101
AT_SCH_TRIP_02108659.sql 1.1 Data Script 02108659
AT_TOMTOM_ETA_EVENTS_00530148.sql 1.1 Data Script 00530148
AT_TOMTOM_STOP_EVENTS_00530148.sql 1.1 Data Script 00530148
AT_WMS_PRODUCT_XREF_00278514.sql 1.1 Data Script 00278514
AT_WMS_PRODUCT_XREF_239646_440451.sql 1.1 Data Script 00239646
AT_WMS_PRODUCT_XREF_265284.sql 1.1 Data Script 00256955
AT_WMS_PRODUCT_XREF_265284.sql 1.1 Data Script 00265284
AT_WMS_PRODUCT_XREF_278514.sql 1.1 Data Script 00256955
BDM.fmx 2.103 Business Data Form 00244856
BDM.fmx 2.104 Business Data Form 00308136
CNT.sql 5.54 Contracts package 00287229
CT_API_LABEL_RESPONSE_01899265.sql 1.1 Data Script 01899265
CT_AUDIT_SEQ_CAR_API_01899265.sql 1.1 Data Script 01899265
CT_INT_XML_CUST_ADDRESS.sql 1.1 Data Script 00266101
CT_ORD_TYPE_INSPECTION_239646_440451.sql 1.2 Data Script 00239646
CT_PAR_API_STAGING_00266101.sql 5.1 Data Script 00266101
CT_PAR_CALL_API_00266101.sql 1.1 Data Script 00266101
CT_PAR_CUST_API_00266101.sql 1.1 Data Script 00266101
CT_PAR_JSON_IN.sql 1.2 Data Script 02124442
CT_PAR_JSON_IN_00266101.sql 1.1 Data Script 00266101
CT_PAR_KEYS_00266101.sql 1.1 Data Script 00266101
CT_PAR_TRIP_API.sql 1.2 Data Script 02124442
CT_RES_VEHICLE_AXLE_239646_440451.sql 1.2 Data Script 00239646
CT_RES_VEHICLE_CONFIG_239646_440451.sql 1.1 Data Script 00239646
CT_RES_VEHICLE_CONFIG_AXLE_239646_440451.sql 1.1 Data Script 00239646
CT_RES_VEHICLE_CUST_LOC_239646_440451.sql 1.3 Data Script 00239646
CT_RES_VEHICLE_TYRE_239646_440451.sql 1.2 Data Script 00239646
CT_SCH_ORD_VEHICLE_265284.sql 1.1 Data Script 00265284
CT_SEQ_API_FILE_IN.sql 1.1 Data Script 00266101
CT_SEQ_ETA_EVENT.sql 1.1 Data Script 00530144
CT_SEQ_ORD_TYRE_INSPECTION_239646.sql 1.1 Data Script 00239646
CT_SEQ_PAR_JSON_IN_00266101.sql 1.1 Data Script 00266101
CT_SEQ_RES_VEHICLE_AXLE_239646.sql 1.1 Data Script 00239646
CT_SEQ_RES_VEHICLE_CONFIG_239646.sql 1.1 Data Script 00239646
CT_SEQ_STOP_EVENT.sql 1.1 Data Script 00530144
CT_SFTP_UNKNOWN_HOSTS_01988611.sql 1.1 Data Script 01988611
CT_TOMTOM_ETA_EVENTS.sql 1.1 Data Script 00530144
CT_TOMTOM_STOP_EVENTS.sql 1.1 Data Script 00530144
CT_TOMTOM_VEHICLES.sql 1.1 Data Script 00530144
CT_TRM_CARRIER_COST.sql 1.1 Data Script 00287229
CT_VEHICLE_SEQ.sql 1.1 Data Script 00530144
DATA_1_IMP_IMPORT_TYPE_256955.sql 1.2 Data Script 00256955
DATA_1_MSG_EVENT_TYPE_02108654.sql 1.1 Data Script 02108654
DATA_1_ORS_MASTER_DATA_260441.sql 1.2 Data Script 00260441
DATA_1_ORS_MASTER_DATA_287039.sql 1.1 Data Script 00287039
DATA_1_ORS_SQL_00278514.sql 1.1 Data Script 00278514
DATA_1_ORS_SQL_260441.sql 1.4 Data Script 00260441
DATA_1_ORS_SQL_287039.sql 1.1 Data Script 00287039
DATA_2_IMP_IMPORT_TYPE_REC_TYPE.sql 1.2 Data Script 00256955
DATA_2_MSG_TYPE_02108654.sql 1.1 Data Script 02108654
DATA_2_ORS_MASTER_DATA_00278514.sql 1.1 Data Script 00278514
DATA_2_ORS_MASTER_DATA_260441.sql 1.2 Data Script 00260441
DATA_2_ORS_MASTER_DATA_287039.sql 1.1 Data Script 00287039
DATA_2_ORS_SQL_260441.sql 1.1 Data Script 00260441
DATA_2_ORS_SQL_287039.sql 1.1 Data Script 00287039
DATA_3_IMP_FIELD_256955.sql 1.3 Data Script 00256955
DATA_3_MSG_REQ_02108654.sql 1.1 Data Script 02108654
DATA_3_ORS_MASTER_DATA_260441.sql 1.3 Data Script 00260441
DATA_3_ORS_MASTER_DATA_287039.sql 1.1 Data Script 00287039
DATA_3_ORS_SQL_260441.sql 1.3 Data Script 00260441
DATA_3_ORS_SQL_287039.sql 1.1 Data Script 00287039
DATA_4_IMP_IMPORT_TYPE_256955.sql 1.2 Data Script 00256955
DATA_4_ORS_MASTER_DATA_260441.sql 1.3 Data Script 00260441
DATA_4_ORS_SQL_260441.sql 1.2 Data Script 00260441
DATA_5_IMP_IMPORT_TYPE_REC_TYPE.sql 1.2 Data Script 00256955
DATA_5_ORS_MASTER_DATA_260441.sql 1.2 Data Script 00260441
DATA_5_ORS_SQL_260441.sql 1.2 Data Script 00260441
DATA_6_IMP_FIELD_256955.sql 1.2 Data Script 00256955
DATA_6_ORS_MASTER_DATA_260441.sql 1.5 Data Script 00260441
DATA_6_ORS_SQL_260441.sql 1.2 Data Script 00260441
DATA_ADM_FORM_TAB_02117529.sql 1.1 Data Script 02117529
DATA_ADM_FORM_TAB_249891.sql 1.2 Data Script 00249891
DATA_ADM_FUNCTION_02030242.sql 1.1 Data Script 02030242
DATA_ADM_FUNCTION_242929.sql 1.1 Data Script 00242929
DATA_ADM_LOG_PROG_NAME_0198861.sql 1.1 Data Script 01988611
DATA_ADM_SYSTEM_PARAM_00244856.sql 1.1 Data Script 00244856
DATA_ADM_SYSTEM_PARAM_00266101.sql 1.1 Data Script 00266101
DATA_ADM_SYSTEM_PARAM_00273451 1.1 Data Script 00273451
DATA_ADM_SYSTEM_PARAM_00278514.sql 1.1 Data Script 00278514
DATA_ADM_SYSTEM_PARAM_00308136.sql 1.1 Data Script 00308136
DATA_ADM_SYSTEM_PARAM_00530144.sql 1.1 Data Script 00530144
DATA_ADM_SYSTEM_PARAM_00530148.sql 1.1 Data Script 00530148
DATA_ADM_SYSTEM_PARAM_01826171.sql 1.1 Data Script 00308136
DATA_ADM_SYSTEM_PARAM_01899265.sql 1.1 Data Script 01899265
DATA_ADM_SYSTEM_PARAM_01909696.sql 1.1 Data Script 01909696
DATA_ADM_SYSTEM_PARAM_01929119.sql 1.1 Data Script 01929119
DATA_ADM_SYSTEM_PARAM_01968623.sql 1.2 Data Script 00287384
DATA_ADM_SYSTEM_PARAM_01984366.sql 1.1 Data Script 01984366
DATA_ADM_SYSTEM_PARAM_01988611.sql 1.1 Data Script 01988611
DATA_ADM_SYSTEM_PARAM_02011793.sql 1.1 Data Script 02011793
DATA_ADM_SYSTEM_PARAM_02066885.sql 1.1 Data Script 02066885
DATA_ADM_SYSTEM_PARAM_02108654.sql 1.1 Data Script 02108654
DATA_ADM_SYSTEM_PARAM_02108659.sql 1.1 Data Script 02108659
DATA_ADM_SYSTEM_PARAM_02112078.sql 1.1 Data Script 02112078
DATA_ADM_SYSTEM_PARAM_233816.sql 1.1 Data Script 00233816
DATA_ADM_SYSTEM_PARAM_250543.sql 1.1 Data Script 00250543
DATA_ADM_SYSTEM_PARAM_261979.sql 1.1 Data Script 00261979
DATA_ADM_SYSTEM_PARAM_274077.sql 1.1 Data Script 00274077
DATA_ADM_SYSTEM_PARAM_279282.sql 1.1 Data Script 00279282
DATA_ADM_SYSTEM_PARAM_287638.sql 1.1 Data Script 00287638
DATA_ADM_SYSTEM_PARAM_CONFIG_261979.sql 1.1 Data Script 00261979
DATA_ADM_SYSTEM_PARAM_CONFIG_279282.sql 1.1 Data Script 00279282
DATA_ADM_SYSTEM_PARAM_CONFIG_287638.sql 1.1 Data Script 00287638
DATA_CNT_CONDITION_01966393.sq 1.1 Data Script 00287229
DATA_CNT_CONDITION_VALUE_01966 1.1 Data Script 00287229
DATA_EDI_FLOW_TYPES_01909696.sql 1.1 Data Script 01909696
DATA_EDI_PROCESS_TRIGGERS_296022.sql 1.1 Data Script 00296022
DATA_IMP_DECODE_02108654.sql 1.1 Data Script 02108654
DATA_IMP_FIELD_01899265.sql 1.1 Data Script 01899265
DATA_IMP_FIELD_02023242.sql 1.1 Data Script 02023242
DATA_IMP_FIELD_287950.sql 1.1 Data Script 00287950
DATA_IMP_IMPORT_TYPE_01899265.sql 1.1 Data Script 01899265
DATA_ORS_MASTER_DATA_02126440.sql 1.1 Data Script 02126440
DATA_ORS_MASTER_DATA_260026.sql 1.3 Data Script 00260026
DATA_ORS_MASTER_DATA_322735.sql 1.1 Data Script 00322735
DATA_ORS_USER_DETAILS_322735.sql 1.1 Data Script 00322735
DATA_REP_REPORT_02069048.sql 1.1 Data Script 02069048
DATA_REP_REPORT_PARAM_02069048 1.1 Data Script 02069048
DP_ASKGEO.sql 1.2 AskGEO Interface 00274074
DP_CARRIER.sql 1.95 Carrier Management 01929119
DP_CARRIER_API.sql 5.1 Carrier API 01899265
DP_CARRIER_API.sql 5.2 Carrier API 01970111
DP_CARRIER_API.sql 5.3 Carrier API 00284500
DP_CARRIER_API.sql 5.5 Carrier API 01985598
DP_CARRIER_API.sql 5.6 Carrier API 02011793
DP_CARRIER_API.sql 5.7 Carrier API 00274074
DP_CARRIER_API.sql 5.8 Carrier API 00311975
DP_CARRIER_API_JSON_stub.sql 1.1 Carrier API 01899265
DP_CSV6.sql 1.43 CSV Extract package 02069048
DP_CTMS_IMPORT.sql 5.1 API Import Database Package 00266101
DP_CTMS_IMPORT.sql 5.2 API Import Database Package 00273451
DP_CTMS_IMPORT.sql 5.4 API Import Database Package 00296022
DP_CTMS_IMPORT.sql 5.5 API Import Database Package 02131348
DP_CUST_SERV.sql 1.35 Customer Service Package 01584585
DP_CUST_SERV.sql 1.37 Customer Service Package 00260047
DP_CUST_SERV.sql 1.38 Customer Service Package 00308136
DP_EPOD_WEB_SERVICE.sql 1.135 EPOD Web Service 00244856
DP_EPOD_WEB_SERVICE.sql 1.136 EPOD Web Service 00252522
DP_EPOD_WEB_SERVICE.sql 1.137 EPOD Web Service 00261979
DP_EPOD_WEB_SERVICE.sql 1.138 EPOD Web Service 00265284
DP_EPOD_WEB_SERVICE.sql 1.139 EPOD Web Service 00287638
DP_EPOD_WEB_SERVICE.sql 1.140 EPOD Web Service 00294874
DP_EPOD_WEB_SERVICE.sql 1.141 EPOD Web Service 00295843
DP_EPOD_WEB_SERVICE.sql 1.142 EPOD Web Service 00301831
DP_EPOD_WEB_SERVICE.sql 1.143 EPOD Web Service 02065820
DP_EPOD_WEB_SERVICE.sql 1.144 EPOD Web Service 00310665
DP_EPOD_WEB_SERVICE.sql 1.145 EPOD Web Service 00310663
DP_EPOD_WEB_SERVICE.sql 1.146 EPOD Web Service 02124442
DP_EPOD_WEB_SERVICE.sql 1.147 EPOD Web Service 02069996
DP_EPOD_WEB_SERVICE.sql 1.149 EPOD Web Service 00323040
DP_EPOD_WEB_SERVICE.sql 1.150 EPOD Web Service 02131420
DP_EXPORT_EVENTS.sql 5.10 API Export Database Package 02131420
DP_EXPORT_EVENTS.sql 5.2 API Export Database Package 01969607
DP_EXPORT_EVENTS.sql 5.3 API Export Database Package 00266101
DP_EXPORT_EVENTS.sql 5.4 API Export Database Package 00274074
DP_EXPORT_EVENTS.sql 5.5 API Export Database Package 00273451
DP_EXPORT_EVENTS.sql 5.7 API Export Database Package 00296022
DP_EXPORT_EVENTS.sql 5.9 API Export Database Package 00321455
DP_IMP.sql 5.42 Imports Package 01899265
DP_INT_XML_CFX.sql 1.6 Database Package 01969399
DP_LFE_POD.sql 5.1 LFE POD Database package 01899265
DP_LFE_POD.sql 5.2 LFE POD Database package 01970111
DP_LFE_POD.sql 5.4 LFE POD Database package 02042658
DP_LFE_POD.sql 5.5 LFE POD Database package 02023242
DP_MIS.sql 5.7 MIS Interface Package 01988611
DP_NOKIA_LOC_PLAT.sql 1.36 Nokia Location Platform Interface 00274077
DP_ORS_FUNCS.sql 5.27 Change to DOOD status function 00287039
DP_ORS_FUNCS.sql 5.28 Change to DOOD status function 00278514
DP_PAR_API.sql 5.1 Database Package 00281601
DP_PAR_API.sql 5.3 Database Package 02124442
DP_PAR_API.sql 5.7 Database Package 02131420
DP_PORTAL.sql 5.19 Portal Package 02112923
DP_RDT_FAST_LOAD.sql 5.32 Load confirmation message procedure 02066885
DP_REPORTS.sql 5.65 Reports package 00260058
DP_REPORTS.sql 5.66 Reports package 00278514
DP_REPORTS.sql 5.68 Reports package 02124442
DP_SCHEDULING_ENGINE.sql 5.178 Scheduling Package 02123480
DP_SFTP.sql 5.1 SFTP processing 01988611
DP_TOMTOM.sql 1.34 TomTom Package 00274074
DP_TOMTOM.sql 1.35 TomTom Package 00530144
DP_TOMTOM.sql 1.36 TomTom Package 02116783
DP_TOMTOM.sql 1.37 TomTom Package 02131420
DP_WEB_SERVICE_ENQUIRY.sql 1.6 Web Service Package 00530148
DP_WEB_SERVICE_ORD.sql 1.29 Web Service Package 01984366
DP_XML_EPOD.sql 1.2 XML Database Package 00265284
DP_XML_EPOD.sql 1.3 XML Database Package 00273451
EDI_MAINT.fmx 10.16 EDI Maintenance Screen 00242929
EPOD_WSA.fmx 1.8 EPOD Web Service Audit Form 00273451
EPOD_WSA.fmx 1.9 EPOD Web Service Audit Form 02108654
IMP.sql 5.210 CSV Imports Package 00256955
IMP.sql 5.212 CSV Imports Package 00287950
IMP.sql 5.213 CSV Imports Package 00266101
IMP.sql 5.214 CSV Imports Package 00294849
INT_ERR_ORD.fmx 2.9 Interface error correction 00256553
INT_XML_IN.sql 5.232 Order Import Package 01899265
INT_XML_IN.sql 5.234 Order Import Package 01909696
INT_XML_IN.sql 5.235 Order Import Package 02041304
INT_XML_IN.sql 5.236 Order Import Package 02064763
INT_XML_IN.sql 5.237 Order Import Package 00319844
INT_XML_IN_REFS.sql 1.14 Openfield Order upload procedures 02108659
INT_XML_OUT2.sql 5.321 Outbound XML Package 01909696
INT_XML_OUT2.sql 5.323 Outbound XML Package 00279282
INT_XML_OUT2.sql 5.324 Outbound XML Package 02064763
INT_XML_OUT2.sql 5.325 Outbound XML Package 02133144
LFS_LABEL.rep 1.24 Label Report 01929119
LFS_LABEL_MULTI.rep 1.12 Label Report 01929119
LOAD_MAN.fmx 1.28 Load Management Form 01984366
LOCATION.fmx 2.200 Location Maintenance 00249891
LOCATION.fmx 2.201 Location Maintenance 01909696
MSG_CONSTRUCTOR.sql 5.20 E-mail construction 02112078
MSG_CONSTRUCTOR.sql 5.21 E-mail construction 02131420
MSG_JOB.sql 5.12 Message job functionality 01976934
MSG_PROCESSING.sql 5.72 Message Processing package 02112078
MSG_PROCESSING.sql 5.73 Message Processing package 02108654
MSG_PROCESSING.sql 5.74 Message Processing package 02131420
OMS.sql 5.248 Order package 01929119
OMS.sql 5.249 Order package 00266101
OMS.sql 5.250 Order package 02124954
ORDERS.fmx 2.446 Order Screen 01929119
ORDERS.fmx 2.447 Order Screen 01899265
ORDERS.fmx 2.448 Order Screen 01967222
ORDERS.fmx 2.449 Order Screen 02030242
ORDERS.fmx 2.450 Order Screen 02110684
ORDERS.fmx 2.451 Order Screen 02121883
ORDERS_WIDE.fmx 1.42 Orders Screen 01929119
ORDERS_WIDE.fmx 1.43 Orders Screen 01899265
ORDERS_WIDE.fmx 1.44 Orders Screen 01967222
ORDERS_WIDE.fmx 1.45 Orders Screen 02030242
ORDERS_WIDE.fmx 1.46 Orders Screen 02110684
ORDERS_WIDE.fmx 1.47 Orders Screen 02121883
ORS.fmx 1.32 Oracle Reporting suite 00282311
ORS.fmx 1.34 Oracle Reporting suite 00287894
ORS.fmx 1.35 Oracle Reporting suite 00278514
ORS.sql 5.11 Oracle Reporting suite 02124442
PLANNING.fmx 1.123 Planning Screen 00287229
PLANNING.fmx 1.124 Planning Screen 00287384
PLANNING.fmx 1.125 Planning Screen 01970111
PLANNING.fmx 1.126 Planning Screen 00279865
PLANNING.fmx 1.127 Planning Screen 02108659
RATE.sql 5.162 Rates Tariff database package 00287229
RATE.sql 5.163 Rates Tariff database package 00266101
RATE.sql 5.164 Rates Tariff database package 02124442
RESOURCE.fmx 2.195 Resource Maintenance form 00287229
T_SCH_ORD_AUDIT.sql 5.19 Trigger for SCH_ORD_AUDIT 00265284
TI_SCH_ORD_STATUS.sql 1.22 Trigger on SCH_ORD for status change 00266101
TI_SCH_ORD_STATUS.sql 1.23 Trigger on SCH_ORD for status change 00273451
TI_SCH_ORD_STATUS.sql 1.24 Trigger on SCH_ORD for status change 02124442
TRG_EPOD_WEB_SERVICE_AUDIT.sql 1.4 Trigger 02108654
TRG_EPOD_WEB_SERVICE_AUDIT.sql 1.5 Trigger 02131420
TRG_GEO_LOCATION_UID.sql 5.2 Trigger 00266101
TRG_LOCATIONS_UID.sql 5.1 Trigger 02124442
TRG_ORD_TYRE_INSPECTION_BIU.sql 1.1 Trigger 00239646
TRG_ORD_TYRE_INSPECTION_BIU.sql 1.2 Trigger 00265284
TRG_ORD_TYRE_INSPECTION_BIU.sql 1.3 Trigger 00287638
TRG_RES_VEHICLE_AXLE_BIU.sql 1.1 Database Trigger 00239646
TRG_RES_VEHICLE_CONFIG_AXLE_BIU.sql 1.1 Database Trigger 00239646
TRG_RES_VEHICLE_CONFIG_BIU.sql 1.1 Database Trigger 00239646
TRG_RES_VEHICLE_CONFIG_EPOD.sql 1.1 Trigger 00293881
TRG_RES_VEHICLE_CUST_LOC_BIU.sql 1.1 Database Trigger 00239646
TRG_RES_VEHICLE_TYRE_BIU.sql 1.1 Database Trigger 00239646
TRG_SCH_ORD_CURRENT_DEPOT.sql 5.2 Trigger 00266101
TRG_SCH_ORD_CURRENT_DEPOT.sql 5.3 Trigger 02124442
TRG_SCH_ORD_INFORMATION_IU.sql 1.6 Trigger 00266101
TRG_SCH_ORD_ITEMS_REASONS.sql 5.15 Trigger 00266101
TRG_SCH_ORD_REFERENCE_AI.sql 1.4 Trigger on SCH_ORD_REFERENCE 01969607
TRG_SCH_ORD_REFERENCE_AI.sql 1.5 Trigger on SCH_ORD_REFERENCE 02108659
TRG_SCH_ORD_TRACKING.sql 1.1 Trigger 01970111
TRG_SCH_ORD_TRACKING.sql 1.2 Trigger 02023242
TRG_SCH_ORD_VEHICLE_BIU.sql 1.1 Trigger 00265284
TRG_SCH_ORD_VEHICLE_PAR.sql 5.2 Trigger 02124442
TRG_SCH_ORDER_LINE_PAR.sql 5.1 Trigger 02124442
TRG_SCH_TRIP_CARRIER_ID_U.sql 5.3 Trigger 02112078
TRG_SCH_TRIP_CARRIER_ID_U.sql 5.4 Trigger 02131420
TRG_SCH_TRIP_MTM_COST.sql 1.1 Trigger 00266101
TRG_SCH_TRIP_STOP_ACPT.sql 5.1 Trigger 02124442
TRG_SCH_TRIP_XML_INT.sql 5.36 Trigger 00266101
TRG_SCH_TRIP_XML_INT.sql 5.37 Trigger 00273451
TRG_SCH_TRIP_XML_INT.sql 5.38 Trigger 02112078
TRG_SCH_TRIP_XML_INT.sql 5.39 Trigger 02131420
TRG_SCH_TRIP_XML_MX.sql 1.1 Trigger 01909696
TRG_SHA_LOTS.sql 5.8 Trigger 00266101
TRG_SOI_XML.sql 5.23 Trigger 00273451
TRG_SOL_XML.sql 5.47 Trigger 00266101
TRG_SOL_XML.sql 5.48 Trigger 00273451
TRG_SONC_DELETE_MIS.sql 5.7 Trigger 00266101
TRG_STS_AI.sql 1.2 Trigger 00530144
TRG_STS_XML.sql 5.24 Trigger 00266101
TRG_STS_XML.sql 5.25 Trigger 00530144
TRG_STS_XML_OUT.sql 5.36 Trip Stop Trigger 00266101
TRG_TOMTOM_ETA_EVENTS_INSERT.sql 1.1 Trigger 00530148
TRG_TOMTOM_STOP_EVENTS_INSERT.sql 1.1 Trigger 00530144
TRG_TRIP_COST.sql 1.3 Trigger 02124442
TRG_TT_EVENTS_STORE.sql 1.1 Trigger 00530144
TRG_TT_EVENTS_STORE.sql 1.2 Trigger 00530148
TRG_TT_EVENTS_STORE.sql 1.3 Trigger 02124442
TRM.sql 5.204 Trip manipulation package 00261979
TRM.sql 5.205 Trip manipulation package 00287229
TRM.sql 5.206 Trip manipulation package 00265284
TRM.sql 5.207 Trip manipulation package 00287384
TRM.sql 5.208 Trip manipulation package 01984366
TRM.sql 5.209 Trip manipulation package 02011793
TRM.sql 5.210 Trip manipulation package 02124442
UTL_FILE.sql 5.3 UTL File Package 00233816
V_CTL_CUSTLOC.sql 5.3 View 00260047
V_CTL_MENUS.sql 5.2 View 00260047
V_DRIVER_LIST.sql 5.1 View 00308136
V_JOB_TYPE.sql 5.3 View 00260047
V_JOB_TYPE.sql 5.4 View 00308136
V_ORD_ORDER_CONTACT.sql 1.4 View 00308136
V_ORD_ORDER_HEADER.sql 1.11 View 00260047
V_ORD_ORDER_HEADER.sql 1.12 View 00308136
V_ORD_REQUIREMENT.sql 1.8 View 01584585
V_PRODUCT_CTL.sql 1.1 View 00308136
V_SCH_TRIP_AUDIT.sql 1.1 View 02064838
V_TRP_TRIP_STOP.sql 1.3 View 00260047
V_TRP_TRIP_STOP.sql 1.4 View 00308136
V_VEHICLE_DETAILS.sql 5.1 View 00301397
XML.sql 5.15 XML file upload 00266101


ADDITIONAL CHANGES

WCS

A WCS change is required for the following logs:

  • Log

OR

There are no WCS changes required.

EPOD/T2A

An ePOD/T2A change is required for the following logs:

  • Log

OR

There are no ePOD/T2A changes required.

MCS

An MCS change is required for the following logs:

  • Log

OR

There are no MCS changes required.

PORTAL/TTM

A Portal change is required for the following logs:

  • Log

OR

There are no Portal changes required.

EDI

An EDI change is required for the following logs:

  • Log

OR

There are no EDI changes required.


Retrieved from ‘https://calidusassist.adcservices.apteancloud.com/calidus-assist/OBS/index.php?title=PATCH_C-TMS_P042&oldid=10130’