PATCH C-TMS P046

From Calidus HUB
Revision as of 02:23, 5 April 2024 by StylesC (talk | contribs)




Aptean Logo.png










Release Notes

CALIDUS TMS

5th Apr 2024 - 1.0
Reference: P046











































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


SUPPORT INCIDENTS

Customer Ref:

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


TID CHANGES

OBS Log Number:

Cust Ref: Reporter:
Summary of Call
Detail of Fix
Set-up and Configuration


PRODUCT DEVELOPMENT

OBS Log Number:

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


MODULES DELIVERED

Module Name Version No Description Log Number
ACC_CTRL.fmx 2.57 Access control maintenance 02766658
ACC_CTRL.fmx 2.59 Access control maintenance 00538105
ACC_CTRL.fmx 2.63 Access control maintenance 02578219
ADM.sql 5.16 Administrator package containing various DB utils 02578219
AT_GEO_CONTACT_469937.sql 1.1 AT Script 00469937
AT_GEO_ROUTE_DTLS_00528718.sql 1.1 AT Script 00528718
AT_INT_XML_CONTROL_543998.sql 1.1 AT Script 00543998
AT_INT_XML_ORD_DETAILS_0271399 1.1 AT Script 02713995
AT_SCH_ORD_INFORMATION_469937.sql 1.1 AT Script 00469937
AT_SCH_ORD_ITEMS_02713995.sql 1.1 AT Script 02713995
AT_SCH_ORD_ITEMS_498981.sql 1.1 AT Script 00498981
BDM.fmx 2.110 Business Data Form 00548540
CHANGE_PW.fmx 2.12 Change Password 02578219
CHANGE_PW.fmx 2.13 Change Password 00538105
CT_SECURITY_PROFILES_02578219.sql 1.1 CT Script 02578219
DATA_ADM_FUNCTION_540719.sql 1.1 Data Script 00540719
DATA_ADM_MSEL_FORM_PARAM_02713995.sql 1.1 Data Script 02713995
DATA_ADM_SYSTEM_PARAM_00510487.sql 1.1 Data Script 00510487
DATA_ADM_SYSTEM_PARAM_00547839.sql 1.1 Data Script 00547839
DATA_ADM_SYSTEM_PARAM_02578219.sql 1.1 Data Script 02578219
DATA_ADM_SYSTEM_PARAM_02683404.sql 1.1 Data Script 02683404
DATA_ADM_SYSTEM_PARAM_02713995.sql 1.1 Data Script 02713995
DATA_ADM_SYSTEM_PARAM_02910494.sql 1.1 Data Script 02910494
DATA_ADM_SYSTEM_PARAM_469937.sql 1.1 Data Script 00469937
DATA_ADM_SYSTEM_PARAM_513456.sql 1.3 Data Script 00553397
DATA_ADM_SYSTEM_PARAM_516374.sql 1.2 Data Script 00516374
DATA_ADM_SYSTEM_PARAM_525182.sql 1.1 Data Script 00525182
DATA_ADM_SYSTEM_PARAM_527603.sql 1.1 Data Script 00527603
DATA_ADM_SYSTEM_PARAM_533620.sql 1.1 Data Script 00533620
DATA_ADM_SYSTEM_PARAM_543998.sql 1.1 Data Script 00543998
DATA_ADM_SYSTEM_PARAM_550047.sql 1.1 Data Script 00550047
DATA_ADM_SYSTEM_PARAM_572113.sql 1.1 Data Script 00572113
DATA_ADM_SYSTEM_PARAM_580395.sql 1.1 Data Script 00580395
DATA_ADM_SYSTEM_PARAM_CONFIG_516374.sql 1.2 Data Script 00516374
DATA_ADM_SYSTEM_PARAM_CONFIG_525182.sql 1.1 Data Script 00525182
DATA_ADM_USER_PARAM_TYPE_02578219.sql 1.3 Data Script 02578219
DATA_EDI_PROCESS_TRIGGERS_00538191.sql 1.1 Data Script 00538191
DATA_EDI_PROCESS_TRIGGERS_545159.sql 1.1 Data Script 00545159
DATA_EDI_PROCESS_TRIGGERS_562331.sql 1.1 Data Script 00562331
DATA_IMP_FIELD_00520087.sql 1.1 Data Script 00520087
DATA_ORACLE_PROFILES_02578219.sql 1.3 Data Script 02578219
DATA_ORS_MASTER_DATA_02713995.sql 1.3 Data Script 02713995
DATA_ORS_MASTER_DATA_524191.sql 1.1 Data Script 00524191
DATA_ORS_SQL_524191.sql 1.1 Data Script 00524191
DATA_SECURITY_PROFILES_02578219.sql 1.1 Data Script 02578219
DP_3PL_SCHED.sql 5.11 3PL Scheduling Engine Database Package 00527603
DP_3PL_SCHED.sql 5.12 3PL Scheduling Engine Database Package 00533067
DP_3PL_SCHED.sql 5.13 3PL Scheduling Engine Database Package 00510487
DP_3PL_SCHED.sql 5.14 3PL Scheduling Engine Database Package 00537843
DP_3PL_SCHED.sql 5.15 3PL Scheduling EngineDatabase Package 00550569
DP_3PL_SCHED.sql 5.16 3PL Scheduling Engine Database Package 00555143
DP_CSV_DUN.sql 5.56 Client specific CSV extracts 02690067
DP_CTMS_IMPORT.sql 5.35 API Import Database Package 00514663
DP_CTMS_IMPORT.sql 5.36 API Import Database Package 00527152
DP_CTMS_IMPORT.sql 5.37 API Import Database Package 00530171
DP_CTMS_IMPORT.sql 5.38 API Import Database Package 00529028
DP_CTMS_IMPORT.sql 5.40 API Import Database Package 00542256
DP_CTMS_IMPORT.sql 5.42 API Import Database Package 02713995
DP_CTMS_IMPORT.sql 5.43 API Import Database Package 00545159
DP_CTMS_IMPORT.sql 5.44 API Import Database Package 00551639
DP_CTMS_IMPORT.sql 5.45 API Import Database Package 00562054
DP_CTMS_IMPORT.sql 5.46 API Import Database Package 00563001
DP_CTMS_IMPORT.sql 5.47 API Import Database Package 00564569
DP_CTMS_IMPORT.sql 5.48 API Import Database Package 00543919
DP_CTMS_IMPORT.sql 5.49 API Import Database Package 00570437
DP_CTMS_IMPORT.sql 5.50 API Import Database Package 00571947
DP_CUST_SERV.sql 1.86 Customer Service Package 00524586
DP_CUST_SERV.sql 1.87 Customer Service Package 00546323
DP_CUST_SERV.sql 1.89 Customer Service Package 00469937
DP_CUST_SERV.sql 1.91 Customer Service Package 00572795
DP_EPOD_WEB_SERVICE.sql 1.216 EPOD Web Service 00524462
DP_EPOD_WEB_SERVICE.sql 1.217 EPOD Web Service 00524481
DP_EPOD_WEB_SERVICE.sql 1.218 EPOD Web Service 00517921
DP_EPOD_WEB_SERVICE.sql 1.220 EPOD Web Service 00527142
DP_EPOD_WEB_SERVICE.sql 1.221 EPOD Web Service 00527274
DP_EPOD_WEB_SERVICE.sql 1.222 EPOD Web Service 00498981
DP_EPOD_WEB_SERVICE.sql 1.223 EPOD Web Service 00528183
DP_EPOD_WEB_SERVICE.sql 1.224 EPOD Web Service 00528738
DP_EPOD_WEB_SERVICE.sql 1.225 EPOD Web Service 00528842
DP_EPOD_WEB_SERVICE.sql 1.226 EPOD Web Service 00528762
DP_EPOD_WEB_SERVICE.sql 1.227 EPOD Web Service 00524586
DP_EPOD_WEB_SERVICE.sql 1.228 EPOD Web Service 00533991
DP_EPOD_WEB_SERVICE.sql 1.230 EPOD Web Service 00538855
DP_EPOD_WEB_SERVICE.sql 1.231 EPOD Web Service 02713995
DP_EPOD_WEB_SERVICE.sql 1.232 EPOD Web Service 00536498
DP_EPOD_WEB_SERVICE.sql 1.233 EPOD Web Service 00479903
DP_EPOD_WEB_SERVICE.sql 1.234 EPOD Web Service 00544876
DP_EPOD_WEB_SERVICE.sql 1.235 EPOD Web Service 00549717
DP_EPOD_WEB_SERVICE.sql 1.236 EPOD Web Service 00469937
DP_EPOD_WEB_SERVICE.sql 1.238 EPOD Web Service 00516374
DP_EPOD_WEB_SERVICE.sql 1.239 EPOD Web Service 00554263
DP_EPOD_WEB_SERVICE.sql 1.241 EPOD Web Service 00552783
DP_EPOD_WEB_SERVICE.sql 1.242 EPOD Web Service 00542530
DP_EPOD_WEB_SERVICE.sql 1.243 EPOD Web Service 00560125
DP_EPOD_WEB_SERVICE.sql 1.244 EPOD Web Service 00561946
DP_EPOD_WEB_SERVICE.sql 1.245 EPOD Web Service 00563558
DP_EPOD_WEB_SERVICE.sql 1.246 EPOD Web Service 00567195
DP_EPOD_WEB_SERVICE.sql 1.247 EPOD Web Service 00532043
DP_EPOD_WEB_SERVICE.sql 1.248 EPOD Web Service 00569051
DP_EPOD_WEB_SERVICE.sql 1.249 EPOD Web Service 00539653
DP_EPOD_WEB_SERVICE.sql 1.250 EPOD Web Service 00570824
DP_EPOD_WEB_SERVICE.sql 1.251 EPOD Web Service 00573163
DP_EXPORT_EVENTS.sql 5.34 API Export Events Database Package 00528842
DP_EXPORT_EVENTS.sql 5.35 API Export Events Database Package 00530050
DP_EXPORT_EVENTS.sql 5.36 API Export Events Database Package 00537198
DP_EXPORT_EVENTS.sql 5.37 API Export Events Database Package 00538804
DP_EXPORT_EVENTS.sql 5.38 API Export Events Database Package 00538191
DP_EXPORT_EVENTS.sql 5.40 API Export Events Database Package 00543998
DP_EXPORT_EVENTS.sql 5.41 API Export Events Database Package 00559726
DP_EXPORT_EVENTS.sql 5.42 API Export Events Database Package 00580395
DP_NOKIA_LOC_PLAT.sql 1.41 Nokia Location Platform Interface 00553397
DP_ORS_FUNCS.sql 5.30 Change to DOOD status function 00524191
DP_PAR_API.sql 5.19 Paragon API Database Package 00548540
DP_PAR_API.sql 5.20 Paragon API Database Package 00562303
DP_PAR_API.sql 5.21 Paragon API Database Package 00565562
DP_PAR_API.sql 5.22 Paragon API Database Package 00575228
DP_PAR_API_STP.sql 5.21 STP Paragon API Database Package 00527157
DP_PAR_API_STP.sql 5.22 STP Paragon API Database Package 00528195
DP_PAR_API_STP.sql 5.23 STP Paragon API Database Package 00527603
DP_PAR_API_STP.sql 5.24 STP Paragon API Database Package 00528718
DP_PAR_API_STP.sql 5.25 STP Paragon API Database Package 00534416
DP_PAR_API_STP.sql 5.26 STP Paragon API Database Package 00539920
DP_PAR_API_STP.sql 5.27 STP Paragon API Database Package 00540264
DP_PAR_API_STP.sql 5.28 STP Paragon API Database Package 00542201
DP_PAR_API_STP.sql 5.29 STP Paragon API Database Package 00554583
DP_PAR_API_STP.sql 5.30 STP Paragon API Database Package 00555143
DP_PAR_API_STP.sql 5.31 STP Paragon API Database Package 00562303
DP_PAR_API_STP.sql 5.33 STP Paragon API Database Package 00563001
DP_PAR_API_STP.sql 5.34 STP Paragon API Database Package 00560600
DP_PAR_API_STP.sql 5.35 STP Paragon API Database Package 00567392
DP_PAR_API_STP.sql 5.36 STP Paragon API Database Package 00568624
DP_PAR_API_STP.sql 5.37 STP Paragon API Database Package 00484537
DP_PAR_API_STP.sql 5.38 STP Paragon API Database Package 00578389
DP_TOMTOM.sql 1.46 TomTom Package 02710742
DP_WEB_SERVICE_ORD.sql 1.33 Web Service Package 03008712
DP_WEB_SERVICE_ORD.sql 1.35 Web Service Package 03529183
EPOD_WSA.fmx 1.13 EPOD Web Service Audit Form 00522350
IMP.sql 5.234 CSV Imports Package 00520087
IMP.sql 5.235 CSV Imports Package 00536205
INT_XML_IN.sql 5.241 Order Import Package 02769136
INT_XML_IN.sql 5.242 Order Import Package 00562331
INT_XML_MIC.sql 5.158 MIC interface 02728730
INT_XML_OUT2.sql 5.336 Outbound XML Package 02818748
INT_XML_OUT2.sql 5.337 Outbound XML Package 00546768
INT_XML_OUT2.sql 5.338 Outbound XML Package 00469937
INT_XML_OUT2.sql 5.339 Outbound XML Package 00554263
LOAD_MAN.fmx 1.29 Load Management Form 02683404
LOCATION.fmx 2.207 Location Maintenance 00528195
LOCATION.fmx 2.209 Location Maintenance 00469937
LOCATION.fmx 2.209 Location Maintenance 00564461
nokmap.html 1.11 Maps Interface 00534889
OF_INT.sql 5.75 Oracle Financials interface 02792680
OMS.sql 5.334 Order package 00527603
ORDERS.fmx 2.456 Order Screen 02713995
ORDERS_WIDE.fmx 1.53 Orders Screen 02713995
ORI_MAIN.fmx 2.18 Login Screen 02578219
PAR.sql 5.115 Paragon Interface 02683404
PAR.sql 5.116 Paragon Interface 02910494
PAR_INT.fmx 10.43 Paragon Interface form 02691631
PLANNING.fmx 1.146 Planning Screen 02742281
PLANNING.fmx 1.147 Planning Screen 00547839
PLANNING.fmx 1.148 Planning Screen 00550047
PLANNING.fmx 1.149 Planning Screen 00554721
PLANNING.fmx 1.150 Planning Screen 00561665
PLANNING.fmx 1.151 Planning Screen 00540719
RESOURCE.fmx 2.200 Resource Maintenance form 02764788
T_SCH_HAULAGE_ACTIVITY_BIU.sql 1.8 Trigger 00527157
TI_SCH_ORD_STATUS.sql 1.29 Trigger on SCH_ORD for status change 00527152
TI_SCH_ORD_STATUS.sql 1.30 Trigger on SCH_ORD for status change 00554568
TI_SCH_ORD_STATUS.sql 1.31 Trigger on SCH_ORD for status change 00563001
TRG_LOCATIONS_UID.sql 5.2 Trigger 00527152
TRG_LOCATIONS_UID.sql 5.3 Trigger 00469937
TRG_LOCATIONS_UID.sql 5.4 Trigger 00554568
TRG_LOCATIONS_UID.sql 5.5 Trigger 00563001
TRG_SCH_ORD_AUDIT_LOCS.sql 1.4 Trigger 00543948
TRG_SCH_ORD_AUDIT_LOCS.sql 1.5 Trigger 00563001
TRG_SCH_ORD_AUDIT_LOCS.sql 1.6 Trigger 00540719
TRG_SCH_ORD_CURRENT_DEPOT.sql 5.6 Trigger 00527152
TRG_SCH_ORD_CURRENT_DEPOT.sql 5.7 Trigger 00550047
TRG_SCH_ORD_CURRENT_DEPOT.sql 5.8 Trigger 00554568
TRG_SCH_ORD_CURRENT_DEPOT.sql 5.9 Trigger 00563001
TRG_SCH_ORDER_LINE_PAR.sql 5.4 Trigger 00527152
TRG_SHA_TRUNK_TRIP.sql 5.4 Trigger 00577244
TRG_SOL_XML.sql 5.51 Trigger 00525182
TRG_SOL_XML.sql 5.52 Trigger 00527274
TRIP_OVERVIEW.fmx 1.76 Trip Waterfall 00555144
TRIP_OVERVIEW.sql 5.17 Trip Waterfall 00533620
TRM.sql 5.230 Trip manipulation package 00577244
V_CURRENT_DRIVER_LIST.sql 1.4 View 00525198
V_DRIVER_ORDERS.sql 1.4 View 00525198
V_GEO_CONTACT.sql 1.2 View 00469937
V_ORD_ORDER_CONTACT.sql 1.5 View 00469937
V_ORD_ORDER_HEADER.sql 1.24 View 00538412
V_ORD_ORDER_HEADER.sql 1.25 View 00544876
V_ORD_ORDER_HEADER.sql 1.26 View 00555163
V_ORD_ORDER_HEADER_CS.sql 1.2 View 00558723
V_TRIP_OVERVIEW.sql 1.24 Trip View 00555144
V_TRIP_OVERVIEW_ORD.sql 5.15 Trip/Order View 00555144
V_VEHICLE_DETAILS.sql 5.7 View 00534016
V_VEHICLE_DETAILS.sql 5.8 View 00544876


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_P046&oldid=11107’