PATCH C-TMS P045
CTMS
Release Notes
CALIDUS TMS
17th Oct 2023 - 1.0
Reference: P045
Contents
- 1 SUMMARY INTRODUCTION
- 2 DEVELOPMENT
- 2.1 Log Number: 00478672
- 2.2 Log Number: 00480177
- 2.3 Log Number: 02595605
- 2.4 Log Number: 00474273
- 2.5 Log Number: 00464750
- 2.6 Log Number: 00464795
- 2.7 Log Number: 02592042
- 2.8 Log Number: 00479896
- 2.9 Log Number: 00477098
- 2.10 Log Number: 00487971
- 2.11 Log Number: 00467382
- 2.12 Log Number: 00469939
- 2.13 Log Number: 00479895
- 2.14 Log Number: 00479887
- 2.15 Log Number: 00479899
- 2.16 Log Number: 00484535
- 2.17 Log Number: 00491708
- 2.18 Log Number: 00479894
- 2.19 Log Number: 00479897
- 2.20 Log Number: 00493457
- 2.21 Log Number: 02665941
- 2.22 Log Number: 00499175
- 2.23 Log Number: 00498787
- 2.24 Log Number: 00467514
- 2.25 Log Number: 00504598
- 2.26 Log Number: 00497703
- 2.27 Log Number: 00495690
- 2.28 Log Number: 00512651
- 2.29 Log Number: 00510378
- 2.30 Log Number: 00515979
- 2.31 Log Number: 00481577
- 2.32 Log Number: 00517175
- 2.33 Log Number: 00515770
- 2.34 Log Number: 00516754
- 2.35 Log Number: 00507384
- 2.36 Log Number: 00517964
- 2.37 Log Number: 00517796
- 2.38 Log Number: 00518000
- 2.39 Log Number: 00516565
- 2.40 Log Number: 00492872
- 2.41 Log Number: 00346696
- 2.42 Log Number: 00521650
- 2.43 Log Number: 00516019
- 2.44 Log Number: 00501535
- 2.45 Log Number: 00488390
- 3 SUPPORT INCIDENTS
- 4 BUGS
- 4.1 Log Number: 02657296
- 4.2 Log Number: 00481350
- 4.3 Log Number: 00482360
- 4.4 Log Number: 00490822
- 4.5 Log Number: 00484500
- 4.6 Log Number: 02680480
- 4.7 Log Number: 00496683
- 4.8 Log Number: 00495952
- 4.9 Log Number: 00495483
- 4.10 Log Number: 00498233
- 4.11 Log Number: 00481913
- 4.12 Log Number: 00305414
- 4.13 Log Number: 00499449
- 4.14 Log Number: 00505522
- 4.15 Log Number: 00505975
- 4.16 Log Number: 00506725
- 4.17 Log Number: 00508400
- 4.18 Log Number: 00469910
- 4.19 Log Number: 00505586
- 4.20 Log Number: 00510701
- 4.21 Log Number: 00512122
- 4.22 Log Number: 00512100
- 4.23 Log Number: 00510599
- 4.24 Log Number: 00512119
- 4.25 Log Number: 02694314
- 4.26 Log Number: 00516061
- 4.27 Log Number: 00510181
- 4.28 Log Number: 02722382
- 4.29 Log Number: 00499590
- 4.30 Log Number: 00517612
- 4.31 Log Number: 00517795
- 4.32 Log Number: 00517913
- 4.33 Log Number: 00517899
- 4.34 Log Number: 00517783
- 4.35 Log Number: 00517813
- 4.36 Log Number: 00518292
- 4.37 Log Number: 00519173
- 4.38 Log Number: 00518660
- 4.39 Log Number: 00519909
- 4.40 Log Number: 00521007
- 4.41 Log Number: 00520185
- 4.42 Log Number: 00518002
- 4.43 Log Number: 00519864
- 4.44 Log Number: 00518589
- 4.45 Log Number: 00520332
- 4.46 Log Number: 00520335
- 4.47 Log Number: 00521914
- 4.48 Log Number: 00522359
- 4.49 Log Number: 00521338
- 4.50 Log Number: 00522300
- 4.51 Log Number: 00522955
- 4.52 Log Number: 02737619
- 4.53 Log Number: 00522214
- 4.54 Log Number: 00524609
- 4.55 Log Number: 00524544
- 4.56 Log Number: 00525198
- 4.57 Log Number: 00525976
- 4.58 Log Number: 02466153
- 4.59 Log Number: 02719799
- 5 PRODUCT DEVELOPMENT
- 6 MODULES DELIVERED
- 7 ADDITIONAL CHANGES
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
DEVELOPMENT
Log Number: 00478672
Summary of Call | REF: 19874 - 3PL Scheduling Engine failing with a null stop number |
Detail of Fix |
1. Any depot that is listed in the system parameter 'AUTO_SCHED_INACTIVE_DEPOTS' will not be processing its orders in the 3PL scheduling engine. These orders will be marked for manual scheduling and they will have an audit message 'The depot is inactive for scheduling, order cannot be scheduled'. 2. If a drop number cannot be derived for the location for the route, then an order for that location will not be scheduled. A default drop number cannot be applied for the position of the trip stop. These orders will be marked for manual scheduling and they will have an audit message 'Cannot pre-plan no drop number available'. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00480177
Summary of Call | REF: 19538 - API orders timing out and taking too long to process |
Detail of Fix | An index has been added to the order import process for the customer reference. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 02595605
Summary of Call | Tractor Information for BI |
Detail of Fix | Scripts prepared for MIS_EXTRACT data to include RES_TRACTOR |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00474273
Summary of Call | REF: 19873 - Failures in STP API orders and 3PL scheduling |
Detail of Fix | The orders are assigned by the 3PL scheduling engine to trip stops based on their activity at those stops.
The orders will be loaded or unloaded at a stop. DP_CTMS_IMPORT is modified the error message where it said DEP/DEL address cannot be NULL when ext_ref is not found be reported with a better message. Corrected the logic which caused unique constraint violated error. The API for the orders will prevent an attempt to create duplicate locations. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00464750
Summary of Call | SCR 05: Show vehicle and technician |
Detail of Fix | Display driver name in CTL |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00464795
Summary of Call | SCR 44: Job Ticket to display a free-text field to add to service report to add "Actual Customer" |
Detail of Fix | Development to display the 'Actual Customer' in CTL and on the epod pod note. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 02592042
Summary of Call | SCR 13: Add Default Vehicle to Driver |
Detail of Fix | A new column is added to RES_PERSON to store Default vehicle ID.
The CTMS system is modified to allow the technicians to have a default vehicle. The CTL Call Logging screen will use this information to default the vehicle for the driver, if that driver has no current trip. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00479896
Summary of Call | SCR 21: Top-Up Transfers |
Detail of Fix | Development for Top-up transfers. Allows the creation of Top-up transfer orders. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00477098
Summary of Call | Generate Warehouse Charges from Contracts |
Detail of Fix | The 'WAREHOUSE' non-standard tariffs will depend on a condition of 'MANUAL' or 'MONTHLY FEE'.
A 'MANUAL' condition means that the charge will apply only in the 'Warehouse' screen. A 'MONTHLY FEE' condition means that the charge will apply only in the monthly generation of the charges. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00487971
Summary of Call | Ref: 20145 - Mismatches in Waterfall Screen |
Detail of Fix | The orders on the TMP trips for the routes that are being planned by the Paragon API for version STP will be reset to UNSCHEDULED status before they are replanned or not planned. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00467382
Summary of Call | SCR 20: New Vehicle - don't specify type |
Detail of Fix | CTMS will create the vehicle axles and tyres when the job is completed and create the inspections based on the callout. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00469939
Summary of Call | SCR 16: Allow searching for local tyres when offline. |
Detail of Fix | The CTMS part master data will be updated whenever the parts are selected or used in CTMS and EPOD. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00479895
Summary of Call | SCR 17: Add Vehicle ODO details to send to Elucid |
Detail of Fix | This change will change the way that the CTL books jobs for adding taking stock to a technician whilst on a job.
Link with SCR-17 & 28 |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00479887
Summary of Call | SCR: 28 Vehicles Unique per Customer |
Detail of Fix | This change will change the way that customer vehicle data is stored. This will now be by customer.
Link this with SCR-17 - 479895 and SCR-21 - 479896 and SCR- 20 - 467382 and SCR- 16 - 469939 |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00479899
Summary of Call | SCR: 35 Services Supplied at Job Level |
Detail of Fix | This change will change the way that CTMS stores and generates services supplied.
Currently, the EPOD device has been configured to prompt for some services supplied at a vehicle level, as opposed to at the tyre position level (i.e. Installation or Other Work). CTMS will recognise this and add the services supplied from vehicle-level entries. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00484535
Summary of Call | EDI Parameter PREVENT_RESEND_ORDER |
Detail of Fix | EDI parameter used to prevent rebooked order being sent if the original order has already been sent |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00491708
Summary of Call | Release task to for SCR-28 and 17 |
Detail of Fix | Amendments to SCR 17 & 28 |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00479894
Summary of Call | SCR:42 Outside Stores/Depot Hubs to be used |
Detail of Fix | This change will change the CTL Call Logging screen to identify the start of the technician's trip based on their own defined hub location, and to identify the pickup location of the order based on the product selected. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00479897
Summary of Call | SCR: 29 Enter Van Stock |
Detail of Fix | Change to add new Item types for Van Stock, Fit Other and Services only etc. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00493457
Summary of Call | Release task for additional changes to SCR 28 |
Detail of Fix | Created for re-release of SCR-28 for the issue reported of missing location in RTC which needs a fix in DP_CUST_SERV.pck and DP_EPOD_WEB_SERVICE to update the current_location_id on RTC |
Set-up and Configuration | No set-up/configuration required |
Log Number: 02665941
Summary of Call | Set system parameter CFX_CARRIER so it can be configured at a cost centre level |
Detail of Fix | CFX_CARRIER is changed to make it configurable by CARRIER instead of SYSTEM. The programs using the parameter are also changed accordingly.
User can configure CARRIER level data instead of SYSTEM level. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00499175
Summary of Call | CTL Top-up transfers |
Detail of Fix | Release views for ctl Top-up transfers |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00498787
Summary of Call | Amendment to TYRE_INSP for SCR-28 |
Detail of Fix | The ORS type TYRE_INSP has been amended to join the tractor specifically to the tractor for the customer of the order at all levels of the report. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00467514
Summary of Call | Report required in ORS for trips. Need to be able to stipulate start location and end location. |
Detail of Fix | New ORS type has been created called 'TRIP_LOCS' which has 5 columns
SCHED_NAME - Range - Required TRIP_ID LOAD_LOC - Value - Required UNLOAD_LOC - Value - Required ROUTE_CODE
User Notes :In order to get unique records, user can use the sort and group_by tick box in the screen. As Load and Unload locations are the selection criteria they can be discarded from the report by not including them, it can be done by unticking the Inc tick box. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00504598
Summary of Call | SCR29 Fix for 479897 |
Detail of Fix | Fix to send ePod collections correctly. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00497703
Summary of Call | Release for DEV-20 for 02592042 |
Detail of Fix | CTMS will create the vehicle axles and tyres when the job is completed and create the inspections based on the callout.
The CTMS part master data will be updated whenever the parts are selected or used in CTMS and EPOD. EDI Jobs creation is needed for the triggers. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00495690
Summary of Call | WREQ0087544: Finance File Interfaced to Oracle v1.00 |
Detail of Fix | Program change, new fields added to extract |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00512651
Summary of Call | The Paragon ID is not updated for the locations via the API |
Detail of Fix | New EDI parameter called UPDATE_PARAGON_ID is created for API process when set to Y will update the Pargon_ID for geo_location as per the creation of new location. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00510378
Summary of Call | Add all the preferences at the order level to the Trip Waterfall screen |
Detail of Fix | The preferences in order level is made available for configuration. 10 order status are added to PREFERENCE_STATUS table if not already present before. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00515979
Summary of Call | Ref: 20978: Paragon inactive depots |
Detail of Fix | The ORD and LOC records will not be sent to Paragon when they are for an inactive depot. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00481577
Summary of Call | Management of the Hub Locations and the Empty Trip Stops |
Detail of Fix | New functionality added to prevent the deletion of empty stops and depot locations |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00517175
Summary of Call | INT_XML_CONTROL |
Detail of Fix | Add new index to table |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00515770
Summary of Call | Audit customers in import |
Detail of Fix | The customer and order import processes via the API will include a message in the audit log when a process starts and when some data has been extracted. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00516754
Summary of Call | Update the PARAGON_ID for the main location for a customer |
Detail of Fix | The 'PARAGON_ID' for the location can be set when the customer itself is updated without any address information being provided via the customer API.
This functionality requires the EDI parameter 'UPDATE_PARAGON_ID' to be set to 'Y' for the 'API' process. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00507384
Summary of Call | Provide authorisation for the required field for the ORS |
Detail of Fix | Removed the existing Req All and Req None buttons. Created a new function called 'Ors_Edit_Req_field' which can be made accessible by user groups to enable the user to edit the 'Req' field. When an authorized user tries to edit the 'Req' field then a warning will appear to the unauthorised user of the possible consequences and advise the user to confirm the amendment of report with the system manager. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00517964
Summary of Call | Paragon API updates |
Detail of Fix | The tractor will be updated for an existing trip without restriction based on the end time of the shift. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00517796
Summary of Call | Include decode STOP_TYPE in Trip Waterfall |
Detail of Fix | The decoded values of 'STOP_TYPE' will be used in the Trip Waterfall screen to replace the codes for the stop types with descriptions, for example, 'Start Up' for 'SU'.
The codes will be used by default when the decoded values do not exist. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00518000
Summary of Call | Amend Trip Locations in Trip Waterfall |
Detail of Fix | Trip Locations in waterfall is amended to use Location when stop is RDC or town when others.
Stop Type is removed from Trip Locations as its already present in Trip Stops. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00516565
Summary of Call | Post Trigger error in Planning |
Detail of Fix | Delivery_type_id is updated to length 35 in Orders and Planning screen to avoid the POST-QUERY trigger error. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00492872
Summary of Call | Development for Supporting Documentation |
Detail of Fix | New columns for consumer and carton packaging are added for the Supporting Documentation for the invoicing.
These documents will include the new columns: Added the 'Pick Qty' to these formats and the export file: Cargowise Detail SD1 Cargowise Detail SD2 Cargowise Detail SD3 Cargowise Detail SD5 Cargowise Detail SD6 Payment Details
Cargowise Detail SD1 Cargowise Detail SD2 Cargowise Detail SD6 Payment Details |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00346696
Summary of Call | Inspection Required Issue |
Detail of Fix | Updated f_last_inspection function to set a default date when it is NULL. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00521650
Summary of Call | Additional changes for 492872 - Development for Supporting Documentation |
Detail of Fix | PAYMENT_DTLS export type has been modified to display SCREENING Charge as last column with corresponding value which was missing in previous version. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00516019
Summary of Call | Update Paragon keys |
Detail of Fix | Keys updated with correct dates and master key values |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00501535
Summary of Call | Include auditing for Paragon API |
Detail of Fix | Added auditing to packages to know what's been sent to paragon through API and also when the RUN_NUMBER is changed. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00488390
Summary of Call | Rating-Invoicing Requirements |
Detail of Fix |
Invoice Screen: Refreshes the data for the Adhocs tick box. Warehouse Screen: Commits the changes when the New button is pressed like the Save button for the ad-hoc services. Uses the condition of MANUAL for Warehouse charges. Accounts for multiple valid non-standard tariffs by condition. Customers Screen: Introduces Consumable Service Charges and Carton Service Charges for the customer. Contracts Screen: Adds SERVICE conditions for CONSUMPAK and CTNPAK. Charges and payments will use these conditions when the Consumable Service Charges and Carton Service Charges are active for the customer. Rating Process: Sets the status of the payments to A not F. Retains ORD_LINE payments not PICK_PACK for the PICKPACK tariff. Activates the system parameter ACC_CONTRACT_SERVICES for the SERVICES tariff for the CONSUMPAK and CTNPAK payments. |
Set-up and Configuration | No set-up/configuration required |
SUPPORT INCIDENTS
Log Number: 00470712
Summary of Call | Invoice Generation for Parties |
Detail of Fix | Invoices can be created for payments that have been created for orders for customers for rating parties. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 02588754
Summary of Call | Trip Tree Data Loading |
Detail of Fix | The PLANNING screen has been modified to include the user's time zone instead of the default system date |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00464118
Summary of Call | TI Order Import - Validate Date Formats |
Detail of Fix | The package is modified. So, when an invalid date format is imported, it's been reported with a valid error message. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 02660730
Summary of Call | Unable to set order back to planned |
Detail of Fix | Trip header update for external cost value |
Set-up and Configuration | No set-up/configuration required |
Log Number: 02595529
Summary of Call | Routes pulling through to AX as Manual carriers and open not 'firm-planned' |
Detail of Fix | Routes pulling through to AX as Manual carriers and open not 'firm-planned' HAULIER fields > 6 and last 3 are a depot code then trim so passes 6 char code to AX. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00340478
Summary of Call | Include a locking strategy and error handling in the Paragon import API process |
Detail of Fix | Added locking to the paragon packages to allow records to be skipped if locked. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00375203
Summary of Call | Main version for Webfleet |
Detail of Fix | Main version 1.45 of the TomTom/Webfleet process for the branched version 1.37.1.4. |
Set-up and Configuration | No set-up/configuration required |
BUGS
Log Number: 02657296
Summary of Call | Unable to copy tariff |
Detail of Fix | Change is made to Contract's copy functions to display the currency dropdown to enable copying. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00481350
Summary of Call | Encountered error in planning, missing Unload activities (no cl and no date/times) |
Detail of Fix | Various changes to set the stop IDs and the stop numbers, to account for missing SU and empty stops.
Control records will be created for 'PAR_API' when the order is scheduled to 'DSK' or 'PCL' trips. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00482360
Summary of Call | Ref: 19909: Invalid orders sent from TMS to Paragon |
Detail of Fix | Any new order lines should trigger an update to the Paragon API when the order is UNSCHEDULED not INVALID. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00490822
Summary of Call | 3PL trips not rating |
Detail of Fix | Improve efficiency of rating for 3PL carriers |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00484500
Summary of Call | Fixed Route Template |
Detail of Fix | All fields added to the Import |
Set-up and Configuration | No set-up/configuration required |
Log Number: 02680480
Summary of Call | CTMS- On time items (Assets) report is displaying 'DG' exception code incorrectly |
Detail of Fix | The 'On Time Items', 'On Time Items (Assets)' and 'On Time Returns' exports have been changed because they include the reason code for the item itself.
The 'On Time Arrivals' and 'On Time Drops' exports have not been changed because they include a reason code for an item for the order. The selected item may not have one of the reason codes that are included for the order itself. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00496683
Summary of Call | Set system parameter CFX_CARRIER so it can be configured at a carrier level |
Detail of Fix | CFX_CARRIER is changed to make it configurable by CARRIER instead of SYSTEM, The programs using the parameter are also changed accordingly.
User can configure CARRIER level data instead of SYSTEM. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00495952
Summary of Call | Payment Type Testing |
Detail of Fix | The 'CTNPAK' and 'CONSUMPAK' charge conditions can be assessed independently of each other for the 'SERVICE' tariff.
'Consignee' is included as the column heading on the extract for Cargowise. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00495483
Summary of Call | Unschedule orders for new run numbers for STS |
Detail of Fix | Change is made so that the orders should be unscheduled from the trips for the route when the run number is readvised, and scheduled back to another trip or create new when scheduling engine is running. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00498233
Summary of Call | Testing issues |
Detail of Fix | Correction to the following ORS reports HAULIER, INTERFACE, CARR_ALLOC and ORD_STATS. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00481913
Summary of Call | Paragon - Run Keys |
Detail of Fix | New process added to procedure to allow the keys to be manually updated |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00305414
Summary of Call | Cancellation emails not showing in message monitoring |
Detail of Fix | The database script will remove the constraint and replace it as a normal index.
To resolve issue with cancellation emails not showing in the message monitoring |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00499449
Summary of Call | Autorefresh in TMS not working |
Detail of Fix | Some logic has been added to Waterfall screen to make it more dynamic when Auto refresh functionality has been made enabled for the user group. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00505522
Summary of Call | Drop the constraint for the audit messages |
Detail of Fix | The constraint by created date and time that exists for the audit messages will be removed. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00505975
Summary of Call | Missing drop numbers |
Detail of Fix | The locations for the routes will be uploaded from Paragon. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00506725
Summary of Call | SCR29 Issues. |
Detail of Fix | Fixed CTMS package to set line/item qtys differently. Retrieve product description when using default products. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00508400
Summary of Call | Add new vehicle failure for Fleet Inspection |
Detail of Fix | Fixed the issue of the addition of new vehicles to the fleet inspections. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00469910
Summary of Call | Webfleet Integration |
Detail of Fix | Various fixes for the TomTom interface. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00505586
Summary of Call | Actual times being overwritten |
Detail of Fix | Only populate actual time if not currently set in the TomTom interface |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00510701
Summary of Call | EDI Failure Notification |
Detail of Fix | Changes made to in_xml_in package to build the location id using an alpha/numeric suffix. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00512122
Summary of Call | Fix for SCR - 29 |
Detail of Fix | The CTMS package is fixed to mitigate the change in work type and prevent collection jobs from being sent to ePod when the store location and job's destination location match. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00512100
Summary of Call | Validation error |
Detail of Fix | The problem relates to the lat-long calculation failing for an address in Jersey.
The country code was GB not the required JE. Once the country code had been amended, the lat-long could be calculated. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00510599
Summary of Call | Duplicate unload records in trip PAR-00013894 |
Detail of Fix | Prevents the order being added to the trip multiple times by the STP Paragon API. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00512119
Summary of Call | Unschedule orders for new delivery date |
Detail of Fix | A new EDI parameter called 'UNSCHED_NEW_DATE' has been introduced for the 'API' process to import the order.
When it is set to 'Y', the order will be unscheduled from any incomplete trips when the order has a new schedule. It will work for earlier and later schedules for the order. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 02694314
Summary of Call | Planning screen error |
Detail of Fix | When user has a specific cost centre set then the schedule from trip tree is defaulted to from schedule of the order well screen. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00516061
Summary of Call | Ref: 21507: Trip resource not updating |
Detail of Fix | The tractor as well as the driver for the trip will be stored as advised by Paragon via the API. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00510181
Summary of Call | Ref: 20978: Scheduling engine performance |
Detail of Fix | Queries changes to have better execution paths, removing full table scans |
Set-up and Configuration | No set-up/configuration required |
Log Number: 02722382
Summary of Call | Order API interface |
Detail of Fix | Fix has been made as the main version 5.25 had a flaw while inserting the value into CLOB after trimming the carrier ID to 6 when it's a 3PL carrier. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00499590
Summary of Call | Waterfall Screen Updates - following release of 495483 |
Detail of Fix | If there are less than 2 stops for a trip then the distance of the trip is made to zero, which can be viewed in waterfall screen. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00517612
Summary of Call | Can't enter default vehicle for a driver |
Detail of Fix | Issue with Resource Form versions 2.196-2.197, corrected in version 2.198. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00517795
Summary of Call | Services supplied from Other Work and Vehicle lines have not been added to the order |
Detail of Fix | Added the qty_to_deliver - will be updated for the order items when null.
Prevented the creation of VEHICLE/INSPECT items. Omited WPX_PRODUCT_ID from the update of the order items. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00517913
Summary of Call | Not including TO_DELIVER quantities |
Detail of Fix | The COL message will be generated for the API events.
Updates the despatched quantity for a product when an item is collected |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00517899
Summary of Call | CTL Call Logging - No services displayed in Services Only table |
Detail of Fix | Includes RIGID and VEHICLE types of vehicles.
Excludes 'CANCELLED', 'DELETED', 'ABANDONED', 'REJECTED' trips. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00517783
Summary of Call | Order Vehicles section not exported to Elucid. |
Detail of Fix | The messages for the API events will include the <ORDER_VEHICLES> section when a vehicle exists for an order. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00517813
Summary of Call | Services Supplied not populated on order items |
Detail of Fix | The services for the order will be created when the item for the VEHICLE SERVICE is added as well as when it is updated.
EPOD will provide the service for the vehicle in the EPL_FAULT item for this purpose. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00518292
Summary of Call | Vehicle Search - Customer Vehicles are showing NOT INSPECTED when they are. |
Detail of Fix | Modified the code so that, Vehicle Inspection will now show the correct status. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00519173
Summary of Call | EPOD Interface - Adding installs to fleet inspection is missing customer vehicle |
Detail of Fix | The customer vehicle will be stored for the order items when the item is created for the serviced product based on the EPL_CODE_2 when the EPL_CUST_VEHICLE is not provided.
Separate items will be created for VEHICLE-SERVICE by customer vehicle. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00518660
Summary of Call | CTMS Import - Tyres import fails. |
Detail of Fix | Amended IMP package to process LOAD_INDEX as a character value |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00519909
Summary of Call | Reset the Send to Paragon flag in Routes Maintenance |
Detail of Fix | The 'Send to Paragon' flag in the 'Routes Maintenance' screen will have a default value of 'Y' to send the route to Paragon when Paragon is implemented.
The box may be unticked to prevent the route being used in Paragon. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00521007
Summary of Call | Customer/Cost Centre shows error when entering the screen |
Detail of Fix | Updated the CUSTOMER_NAME and CONTACT_NAME in form to 50 to match the database column and to stop the error prompt when opened the Customer/cost centre maintenance screen. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00520185
Summary of Call | Customer Vehicle Import fails |
Detail of Fix | The CUST_FLEET import will use a mandatory CUSTOMER_ID to maintain the vehicle information for the tractors, axles, tyres and locations.
Types of locations may be BRANCH and INV. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00518002
Summary of Call | CTL Call Logging - Subsequent job booked onto already completed stop |
Detail of Fix | System parameter TRM_PREVENT_ORD_ON_COMP_STOP when set to Y this prevent any order being planned onto a completed stop |
Set-up and Configuration |
New Parameters | |||
---|---|---|---|
Parameter Name | Config Level | Setting Value | Result |
TRM_PREVENT_ORD_ON_COMP_STOP | SYSTEM | Y | Prevent orders being added to completed stops |
Log Number: 00519864
Summary of Call | Booking job onto already existing job result sin trip end time being reset |
Detail of Fix | Add system parameter TRM_SHIFT_TIMES_FOR_TRIP to prevent end time of trip being updated to not be the end of a drivers shift |
Set-up and Configuration |
New Parameters | |||
---|---|---|---|
Parameter Name | Config Level | Setting Value | Result |
TRM_SHIFT_TIMES_FOR_TRIP | SYSTEM | Y | Use start and end time of shift for start and end times on trip |
Log Number: 00518589
Summary of Call | CTL Call Logging - Cancel/Delete order does not prompt for reason code |
Detail of Fix | Development done on CTL and CTMS, reason codes added to order in CTMS and status set to CANCELLED |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00520332
Summary of Call | CTMS EPOD Interface - Main address does not include Lat/Long |
Detail of Fix | Lat/longs added to Job node |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00520335
Summary of Call | CTMS-PORTAL TTM Interface - Orders still showing as part-delivered in Order Visibility |
Detail of Fix | Van stock items debriefed at collection |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00521914
Summary of Call | Treat FAILED jobs as a cancellation message to outbound API. |
Detail of Fix | Update the status of FAILED orders to CANCELLED within the message for outbound API messages |
Set-up and Configuration |
New Parameters | |||
---|---|---|---|
Parameter Name | Config Level | Setting Value | Result |
INCLUDE_FAILED_ORDERS | COST CENTRE | Y | Send Failed orders to Outbound API and change the status in the message to CANCELLED |
Log Number: 00522359
Summary of Call | EPOD Device - Vehicle search produced many tyres |
Detail of Fix | Update cursors to include customer details |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00521338
Summary of Call | Lat Longs not created |
Detail of Fix | Fixed issue which was avoiding the population of Lat/Long. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00522300
Summary of Call | Use actual times if present when determining arrive/depart times when new order applied to trip |
Detail of Fix | Use actual times from previous stop to calculate arrival at next stop |
Set-up and Configuration |
New Parameters | |||
---|---|---|---|
Parameter Name | Config Level | Setting Value | Result |
TRM_USE_ACTUALS_FOR_STOP_TIMES | SYSTEM | Y | Use actual times to derive new stop times |
Log Number: 00522955
Summary of Call | Pass work type and position on all work types to Portal and update order line correctly |
Detail of Fix | Pass work type and position to portal for all records |
Set-up and Configuration | No set-up/configuration required |
Log Number: 02737619
Summary of Call | Waterfall not displaying Weight on RPLS |
Detail of Fix | Package changed to obtain weights correctly |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00522214
Summary of Call | Unable to parse the Load Planning Request |
Detail of Fix | The address information for the trip stops and the orders will convert an '&' to '& amp;' |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00524609
Summary of Call | Generate van stock line for every Fit New install |
Detail of Fix | Added item identifier to epod message, created new V type record on orders |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00524544
Summary of Call | API Export - COL sent after DEL |
Detail of Fix | Change to trigger to stop second COL message being created |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00525198
Summary of Call | CTL Call Logging - Can't raise a top-up transfer against a service-only job |
Detail of Fix | Fixed refresh of driver list for Top-Up transfers. Filtered out inactive drivers. Filtered out DELIVERED and FAILED orders from the Orders list. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00525976
Summary of Call | Cannot create services only without a product |
Detail of Fix | Change is made to functionality that will enable to create a service when product is not provided without an error. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 02466153
Summary of Call | Release Task |
Detail of Fix | Performance issue - correct selection criteria |
Set-up and Configuration | No set-up/configuration required |
Log Number: 02719799
Summary of Call | Webfleet integration |
Detail of Fix | Extended the field t_ext_ref length to VARCHAR2(50). Amended the EDI process name to the dp_reports audit message. |
Set-up and Configuration | No set-up/configuration required |
PRODUCT DEVELOPMENT
Log Number: 00474454
Summary of Call | Missing auditing for COL export events in the API |
Detail of Fix | The web service audit records will be created for the COL events as well as the VLI, VLD and VUI events. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00489063
Summary of Call | Revert tier for pallet storage |
Detail of Fix | The tier for the 'Warehouse' screen will revert to 'WAREHOUSE'. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00482059
Summary of Call | Enable RET orders to be added to PCL trips in the 3PL scheduling engine |
Detail of Fix | Code change - changed the DP_3PL-SCHED package to allow RET orders to be added to PCL trips |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00489611
Summary of Call | Duplication with TMS Orders |
Detail of Fix | Any orders that are locked will not be submitted to the 3PL scheduling engine until they have been unlocked. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00481867
Summary of Call | Include the Send to Paragon flag in the import process for Fixed Routes |
Detail of Fix | Send To Paragon flag added to Import
Any new order lines should trigger an update to the Paragon API when the order is UNSCHEDULED not INVALID. |
Set-up and Configuration | No set-up/configuration required |
Log Number: 00497948
Summary of Call | Main version for DP_CARRIER_API |
Detail of Fix | Changes from branched version incorporated into main version
The functionality that is controlled by the system parameter 'CARRIER_API_MANIFEST_READY_TIME': setting it to a time will allow the bookingDate to refer to the packed date or the created date of the order instead of the late delivery date. |
Set-up and Configuration | No set-up/configuration required |
MODULES DELIVERED
Module Name | Version No | Description | Log Number |
---|---|---|---|
ACC.sql | 5.84 | Accounts package | 00477098 |
ACC.sql | 5.86 | Accounts package | 00488390 |
AT_INT_XML_CONTROL_517175.sql | 1.1 | AT Script | 00517175 |
AT_INT_XML_ORD_HEADER_480177.sql | 1.1 | AT Script | 00480177 |
AT_MSG_SMS_AUDIT_305414.sql | 1.1 | AT Script | 00305414 |
AT_MSG_SMS_AUDIT_505522.sql | 1.1 | AT Script | 00505522 |
AT_ORG_CUSTOMER_00488390.sql | 1.2 | AT Script | 00488390 |
AT_PAR_KEYS_481913.sql | 1.1 | AT Script | 00481913 |
AT_PAR_KEYS_481913_1.sql | 1.1 | AT Script | 00481913 |
AT_RES_PERSON_02592042.sql | 1.1 | AT Script | 02592042 |
AT_RES_VEHICLE_AXLE_479887.sql | 1.1 | AT Script | 00479887 |
AT_RES_VEHICLE_TYRE_479887.sql | 1.1 | AT Script | 00479887 |
AT_SCH_ORD_464795.sql | 1.2 | AT Script | 00464795 |
AT_SCH_ORDER_LINE_482360.sql | 1.1 | AT Script | 00482360 |
BDM.fmx | 2.109 | Business Data Form | 00481913 |
CNT.sql | 5.58 | Contracts package | 00470712 |
CNT.sql | 5.59 | Contracts package | 00488390 |
CONTRACT.fmx | 2.83 | Contracts Form | 02657296 |
CT_RES_TRACTOR_CUSTOMER_479887 | 1.1 | CT Script | 00479887 |
CT_TOMTOM_DEBUG.sql | 5.2 | CT Script | 00469910 |
CUST_COST.fmx | 2.144 | Customer Maintenance form | 00488390 |
CUST_COST.fmx | 2.145 | Customer Maintenance form | 00521007 |
DATA_1_IMP_DECODE_TYPE_512100.sql | 1.1 | Data Script | 00512100 |
DATA_1_MIS_EXTRACT_HEADER_02595605.sql | 1.1 | Data Script | 02595605 |
DATA_2_IMP_DECODE_512100.sql | 1.1 | Data Script | 00512100 |
DATA_2_MIS_EXTRACT_DETAIL_02595605.sql | 1.1 | Data Script | 02595605 |
DATA_3_IMP_DECODE_ENTRY_512100.sql | 1.1 | Data Script | 00512100 |
DATA_ADM_FORM_TAB_481913.sql | 1.2 | Data Script | 00481913 |
DATA_ADM_FUNCTION_507384.sql | 1.1 | Data Script | 00507384 |
DATA_ADM_SYSTEM_PARAM_02665941.sql | 1.1 | Data Script | 02665941 |
DATA_ADM_SYSTEM_PARAM_340478.sql | 1.1 | Data Script | 00340478 |
DATA_ADM_SYSTEM_PARAM_479897.sql | 1.1 | Data Script | 00479897 |
DATA_ADM_SYSTEM_PARAM_482059.sql | 1.1 | Data Script | 00482059 |
DATA_ADM_SYSTEM_PARAM_518002.sql | 1.2 | Data Script | 00518002 |
DATA_ADM_SYSTEM_PARAM_519864.sql | 1.1 | Data Script | 00519864 |
DATA_ADM_SYSTEM_PARAM_521914.sql | 1.1 | Data Script | 00521914 |
DATA_ADM_SYSTEM_PARAM_522300.sql | 1.1 | Data Script | 00522300 |
DATA_ADM_SYSTEM_PARAM_524609.sql | 1.1 | Data Script | 00524609 |
DATA_ADM_SYSTEM_PARAM_CONFIG_02665941.sql | 1.1 | Data Script | 02665941 |
DATA_ADM_SYSTEM_PARAM_CONFIG_482059.sql | 1.1 | Data Script | 00482059 |
DATA_ADM_SYSTEM_PARAM_CONFIG_521914.sql | 1.1 | Data Script | 00521914 |
DATA_ADM_SYSTEM_PARAM_CONFIG_524609.sql | 1.1 | Data Script | 00524609 |
DATA_CNT_CHARGE_PARAM_00488390.sql | 1.1 | Data Script | 00488390 |
DATA_CNT_CONDITION_00447098.sql | 1.1 | Data Script | 00477098 |
DATA_CNT_CONDITION_00488390.sql | 1.1 | Data Script | 00488390 |
DATA_CNT_CONDITION_VALUE_00447098.sql | 1.1 | Data Script | 00477098 |
DATA_CNT_CONDITION_VALUE_00488390.sql | 1.1 | Data Script | 00488390 |
DATA_EDI_PROCESS_TRIGGERS_501535.sql | 1.1 | Data Script | 00501535 |
DATA_EDI_PROCESS_TRIGGERS_512651.sql | 1.1 | Data Script | 00512651 |
DATA_GEO_LOC_TYPE_479894.sql | 1.1 | Data Script | 00479894 |
DATA_IMP_FIELD_479887.sql | 1.2 | Data Script | 00479887 |
DATA_IMP_FIELD_479887.sql | 1.2 | Data Script | 00491708 |
DATA_IMP_FIELD_479894.sql | 1.1 | Data Script | 00479894 |
DATA_IMP_FIELD_481867.sql | 1.1 | Data Script | 00481867 |
DATA_IMP_FIELD_484500.sql | 1.2 | Data Script | 00484500 |
DATA_ORG_CUST_ORD_REV_CHG_TYPE_521007.sql | 1.1 | Data Script | 00521007 |
DATA_ORS_MASTER_DATA_467514.sql | 1.1 | Data Script | 00467514 |
DATA_ORS_MASTER_DATA_479887.sq | 1.1 | Data Script | 00479887 |
DATA_ORS_MASTER_DATA_479887.sql | 1.2 | Data Script | 00493457 |
DATA_ORS_MASTER_DATA_498233.sql | 1.2 | Data Script | 00498233 |
DATA_ORS_MASTER_DATA_498233_1.sql | 1.2 | Data Script | 00498233 |
DATA_ORS_MASTER_DATA_498233_2.sql | 1.2 | Data Script | 00498233 |
DATA_ORS_MASTER_DATA_498233_3.sql | 1.2 | Data Script | 00498233 |
DATA_ORS_MASTER_DATA_498787.sq | 1.2 | Data Script | 00498787 |
DATA_ORS_SQL_467514.sql | 1.1 | Data Script | 00467514 |
DATA_ORS_SQL_479887.sql | 1.1 | Data Script | 00479887 |
DATA_ORS_SQL_498787.sql | 1.1 | Data Script | 00498787 |
DATA_PREFERENCE_STATUS_510378.sql | 1.1 | Data Script | 00510378 |
DP_3PL_SCHED.sql | 5.10 | 3PL Scheduling Engine Database Package | 00510181 |
DP_3PL_SCHED.sql | 5.5 | 3PL Scheduling Engine Database Package | 00474273 |
DP_3PL_SCHED.sql | 5.6 | 3PL Scheduling Engine Database Package | 00478672 |
DP_3PL_SCHED.sql | 5.7 | 3PL Scheduling Engine Database Package | 00481350 |
DP_3PL_SCHED.sql | 5.8 | 3PL Scheduling Engine Database Package | 00482059 |
DP_3PL_SCHED.sql | 5.9 | 3PL Scheduling Engine Database Package | 00489611 |
DP_CARRIER_API.sql | 5.12 | Carrier API Database Package | 00497948 |
DP_CSV6.sql | 1.44 | CSV Extract package | 02680480 |
DP_CTMS_IMPORT.sql | 5.28 | API Import Database Package | 00474273 |
DP_CTMS_IMPORT.sql | 5.29 | API Import Database Package | 00480177 |
DP_CTMS_IMPORT.sql | 5.30 | API Import Database Package | 00512651 |
DP_CTMS_IMPORT.sql | 5.31 | API Import Database Package | 00512119 |
DP_CTMS_IMPORT.sql | 5.32 | API Import Database Package | 00515770 |
DP_CTMS_IMPORT.sql | 5.33 | API Import Database Package | 00516754 |
DP_CTMS_IMPORT.sql | 5.34 | API Import Database Package | 00501535 |
DP_CUST_SERV.sql | 1.67 | Customer Service Package | 00464795 |
DP_CUST_SERV.sql | 1.68 | Customer Service Package | 02592042 |
DP_CUST_SERV.sql | 1.69 | Customer Service Package | 00479896 |
DP_CUST_SERV.sql | 1.70 | Customer Service Package | 00479887 |
DP_CUST_SERV.sql | 1.72 | Customer Service Package | 00479894 |
DP_CUST_SERV.sql | 1.74 | Customer Service Package | 00493457 |
DP_CUST_SERV.sql | 1.77 | Customer Service Package | 00479897 |
DP_CUST_SERV.sql | 1.78 | Customer Service Package | 00506725 |
DP_CUST_SERV.sql | 1.79 | Customer Service Package | 00517899 |
DP_CUST_SERV.sql | 1.82 | Customer Service Package | 00518589 |
DP_CUST_SERV.sql | 1.84 | Customer Service Package | 00524609 |
DP_CUST_SERV.sql | 1.85 | Customer Service Package | 00525976 |
DP_EPOD_WEB_SERVICE.sql | 1.193 | EPOD Web Service | 00479887 |
DP_EPOD_WEB_SERVICE.sql | 1.194 | EPOD Web Service | 00479899 |
DP_EPOD_WEB_SERVICE.sql | 1.195 | EPOD Web Service | 00479897 |
DP_EPOD_WEB_SERVICE.sql | 1.196 | EPOD Web Service | 00493457 |
DP_EPOD_WEB_SERVICE.sql | 1.197 | EPOD Web Service | 00467382 |
DP_EPOD_WEB_SERVICE.sql | 1.197 | EPOD Web Service | 00469939 |
DP_EPOD_WEB_SERVICE.sql | 1.198 | EPOD Web Service | 00504598 |
DP_EPOD_WEB_SERVICE.sql | 1.199 | EPOD Web Service | 00497703 |
DP_EPOD_WEB_SERVICE.sql | 1.201 | EPOD Web Service | 00508400 |
DP_EPOD_WEB_SERVICE.sql | 1.203 | EPOD Web Service | 00512122 |
DP_EPOD_WEB_SERVICE.sql | 1.204 | EPOD Web Service | 00517795 |
DP_EPOD_WEB_SERVICE.sql | 1.205 | EPOD Web Service | 00517913 |
DP_EPOD_WEB_SERVICE.sql | 1.206 | EPOD Web Service | 00517813 |
DP_EPOD_WEB_SERVICE.sql | 1.207 | EPOD Web Service | 00518292 |
DP_EPOD_WEB_SERVICE.sql | 1.208 | EPOD Web Service | 00519173 |
DP_EPOD_WEB_SERVICE.sql | 1.209 | EPOD Web Service | 00346696 |
DP_EPOD_WEB_SERVICE.sql | 1.210 | EPOD Web Service | 00520332 |
DP_EPOD_WEB_SERVICE.sql | 1.211 | EPOD Web Service | 00520335 |
DP_EPOD_WEB_SERVICE.sql | 1.212 | EPOD Web Service | 00522359 |
DP_EPOD_WEB_SERVICE.sql | 1.213 | EPOD Web Service | 00522955 |
DP_EPOD_WEB_SERVICE.sql | 1.215 | EPOD Web Service | 00524609 |
DP_EXPORT_EVENTS.sql | 5.24 | API Export Events Database Package | 00474454 |
DP_EXPORT_EVENTS.sql | 5.25 | API Export Events Database Package | 02595529 |
DP_EXPORT_EVENTS.sql | 5.27 | API Export Events Database Package | 00479895 |
DP_EXPORT_EVENTS.sql | 5.27 | API Export Events Database Package | 00491708 |
DP_EXPORT_EVENTS.sql | 5.28 | API Export Events Database Package | 02722382 |
DP_EXPORT_EVENTS.sql | 5.29 | API Export Events Database Package | 00517783 |
DP_EXPORT_EVENTS.sql | 5.30 | API Export Events Database Package | 00521914 |
DP_EXPORT_EVENTS.sql | 5.31 | API Export Events Database Package | 00522214 |
DP_EXPORT_EVENTS.sql | 5.32 | API Export Events Database Package | 00524609 |
DP_NOKIA_LOC_PLAT.sql | 1.39 | Nokia Location Platform Interface | 00512100 |
DP_NOKIA_LOC_PLAT.sql | 1.40 | Nokia Location Platform Interface | 00521338 |
DP_PAR_API.sql | 5.14 | Paragon API Database Package | 00481913 |
DP_PAR_API.sql | 5.15 | Paragon API Database Package | 00340478 |
DP_PAR_API.sql | 5.16 | Paragon API Database Package | 00481577 |
DP_PAR_API.sql | 5.17 | Paragon API Database Package | 00516019 |
DP_PAR_API.sql | 5.18 | Paragon API Database Package | 00501535 |
DP_PAR_API_STP.sql | 5.11 | STP Paragon API Database Package | 00487971 |
DP_PAR_API_STP.sql | 5.12 | STP Paragon API Database Package | 00495483 |
DP_PAR_API_STP.sql | 5.13 | STP Paragon API Database Package | 00505975 |
DP_PAR_API_STP.sql | 5.14 | STP Paragon API Database Package | 00340478 |
DP_PAR_API_STP.sql | 5.15 | STP Paragon API Database Package | 00481577 |
DP_PAR_API_STP.sql | 5.16 | STP Paragon API Database Package | 00510599 |
DP_PAR_API_STP.sql | 5.17 | STP Paragon API Database Package | 00516061 |
DP_PAR_API_STP.sql | 5.18 | STP Paragon API Database Package | 00515979 |
DP_PAR_API_STP.sql | 5.19 | STP Paragon API Database Package | 00517964 |
DP_PAR_API_STP.sql | 5.20 | STP Paragon API Database Package | 00501535 |
DP_REPORTS.sql | 5.75 | Reports package | 02719799 |
DP_TOMTOM.sql | 1.42 | TomTom Package | 00469910 |
DP_TOMTOM.sql | 1.43 | TomTom Package | 00505586 |
DP_TOMTOM.sql | 1.44 | TomTom Package | 02719799 |
DP_TOMTOM.sql | 1.45 | TomTom Package | 00375203 |
DP_TOMTOM_DEBUG.sql | 5.1 | TomTom Debug procedure | 00469910 |
DP_WEB_SERVICE_ENQUIRY.sql | 1.7 | Web service processing | 02466153 |
EPOD_WSA.fmx | 1.11 | EPOD Web Service Audit Form | 00501535 |
IMP.sql | 5.224 | CSV Imports Package | 00464118 |
IMP.sql | 5.229 | CSV Imports Package | 00481867 |
IMP.sql | 5.229 | CSV Imports Package | 00484500 |
IMP.sql | 5.230 | CSV Imports Package | 00479887 |
IMP.sql | 5.230 | CSV Imports Package | 00491708 |
IMP.sql | 5.231 | CSV Imports Package | 00479894 |
IMP.sql | 5.232 | CSV Imports Package | 00518660 |
IMP.sql | 5.233 | CSV Imports Package | 00520185 |
INT_XML_IN.sql | 5.240 | Order Import Package | 00510701 |
INT_XML_OUT2.sql | 5.331 | Outbound XML Package | 00484535 |
INT_XML_OUT2.sql | 5.332 | Outbound XML Package | 00479887 |
INT_XML_OUT2.sql | 5.332 | Outbound XML Package | 00491708 |
INT_XML_OUT2.sql | 5.333 | Outbound XML Package | 00479897 |
INT_XML_OUT2.sql | 5.334 | Outbound XML Package | 00522955 |
INVOICES.fmx | 2.65 | Invoices Screen | 00488390 |
LOCATION.fmx | 2.206 | Location Maintenance | 00479894 |
OF_INT.sql | 5.65 | Oracle Financials interface | 00495952 |
OF_INT.sql | 5.69 | Oracle Financials interface | 00495690 |
OF_INT.sql | 5.70 | Oracle Financials interface | 00492872 |
OF_INT.sql | 5.71 | Oracle Financials interface | 00521650 |
ORDERS.fmx | 2.454 | Order Screen | 00516565 |
ORDERS_WIDE.fmx | 1.50 | Orders Screen | 00516565 |
ORS.fmx | 1.38 | Oracle Reporting suite | 00507384 |
PLANNING.fmx | 1.141 | Planning Screen | 02588754 |
PLANNING.fmx | 1.143 | Planning Screen | 02665941 |
PLANNING.fmx | 1.144 | Planning Screen | 02694314 |
PLANNING.fmx | 1.145 | Planning Screen | 00516565 |
RATE.sql | 5.169 | Rates Tariff database package | 00488390 |
RATE.sql | 5.170 | Rates Tariff database package | 00495952 |
RESOURCE.fmx | 2.196 | Resource Maintenance form | 02592042 |
RESOURCE.fmx | 2.198 | Resource Maintenance form | 00517612 |
ROUTES_MAINT.fmx | 2.54 | Fixed Routes Maintenance | 00481867 |
ROUTES_MAINT.fmx | 2.55 | Fixed Routes Maintenance | 00519909 |
TI_SCH_ORD_STATUS.sql | 1.28 | Trigger on SCH_ORD for status change | 00521914 |
TRG_PAR_KEYS_BIU.sql | 1.2 | Trigger | 00481913 |
TRG_RES_TRACTOR_CUSTOMER_BIU.sql | 1.1 | Trigger | 00479887 |
TRG_RES_VEHICLE_CONF_AXLE_EPOD.sql | 1.2 | Trigger | 00467382 |
TRG_RES_VEHICLE_CONF_AXLE_EPOD.sql | 1.3 | Trigger | 00497703 |
TRG_RES_VEHICLE_CONF_AXLE_EPOD.sql | 1.4 | Trigger | 00508400 |
TRG_RES_VEHICLE_CONFIG_EPOD.sql | 1.2 | Trigger | 00497703 |
TRG_RES_VEHICLE_CONFIG_EPOD.sql | 1.3 | Trigger | 00508400 |
TRG_SCH_ORD_REFERENCE_RUN.sql | 5.2 | Trigger | 00495483 |
TRG_SCH_ORD_VEHICLE_UID.sql | 1.1 | Trigger | 00479895 |
TRG_SCH_ORDER_LINE_PAR.sql | 5.3 | Trigger | 00482360 |
TRG_SCH_TRIP_MTM_COST.sql | 1.2 | Trigger | 02660730 |
TRG_SCH_TRIP_STOP_ACPT.sql | 5.2 | Trigger | 00469910 |
TRG_SCH_TRIP_XML_GEN.sql | 5.25 | Trigger | 02665941 |
TRG_SHA_TRUNK_TRIP.sql | 5.3 | Trigger | 00481350 |
TRG_SOL_XML.sql | 5.49 | Trigger | 00517913 |
TRG_SOL_XML.sql | 5.50 | Trigger | 00524544 |
TRG_TT_EVENTS_STORE.sql | 1.8 | Trigger | 00469910 |
TRG_WMS_PRODUCT_XREF_BIU.sql | 1.2 | Trigger | 00469939 |
TRG_WMS_PRODUCT_XREF_BIU.sql | 1.3 | Trigger | 00497703 |
TRG_WMS_PRODUCT_XREF_BIU.sql | 1.3 | Trigger | 00508400 |
TRIP_OVERVIEW.fmx | 1.75 | Trip Waterfall | 00499449 |
TRIP_OVERVIEW.sql | 5.12 | Trip Waterfall | 00517796 |
TRIP_OVERVIEW.sql | 5.13 | Trip Waterfall | 00518000 |
TRIP_OVERVIEW.sql | 5.15 | Trip Waterfall | 02737619 |
TRIP_PLAN.fmx | 1.283 | Trip Planning Screen | 00496683 |
TRIPSUM.fmx | 2.450 | Trip Manipulation screen | 00496683 |
TRM.sql | 5.223 | Trip manipulation package | 00490822 |
TRM.sql | 5.224 | Trip manipulation package | 00479894 |
TRM.sql | 5.225 | Trip manipulation package | 00481577 |
TRM.sql | 5.226 | Trip manipulation package | 00499590 |
TRM.sql | 5.227 | Trip manipulation package | 00518002 |
TRM.sql | 5.228 | Trip manipulation package | 00519864 |
TRM.sql | 5.229 | Trip manipulation package | 00522300 |
V_CURRENT_DRIVER_LIST.sql | 1.1 | View | 00479895 |
V_CURRENT_DRIVER_LIST.sql | 1.2 | View | 00499175 |
V_CURRENT_DRIVER_LIST.sql | 1.3 | View | 00525198 |
V_DRIVER_ORDERS.sql | 1.1 | View | 00479895 |
V_DRIVER_ORDERS.sql | 1.2 | View | 00499175 |
V_DRIVER_ORDERS.sql | 1.3 | View | 00525198 |
V_ORD_ORDER_HEADER.sql | 1.17 | View | 00464750 |
V_ORD_ORDER_HEADER.sql | 1.18 | View | 00464795 |
V_ORD_ORDER_HEADER.sql | 1.19 | View | 00479896 |
V_ORD_ORDER_HEADER.sql | 1.20 | View | 00479887 |
V_ORD_ORDER_HEADER.sql | 1.21 | View | 00479894 |
V_ORD_ORDER_HEADER.sql | 1.22 | View | 00479897 |
V_PRODUCT_CTL.sql | 1.6 | View | 00479897 |
V_PRODUCT_CTL.sql | 1.7 | View | 00525976 |
V_RES_TRACTOR_CUSTOMER.sql | 1.1 | View | 00499175 |
V_RES_VEHICLE_CUST_LOC.sql | 1.3 | View | 00479887 |
V_VEHICLE_DETAILS.sql | 5.6 | View | 00479887 |
WAREHOUSE.fmx | 2.18 | Warehouse Screen | 00477098 |
WAREHOUSE.fmx | 2.19 | Warehouse Screen | 00489063 |
WAREHOUSE.fmx | 2.20 | Warehouse Screen | 00488390 |
ADDITIONAL CHANGES
CTL
A CTL change is required with this release
Manual
A manual change is required for the following packages:
DP_PAR_API_STP - A branch version (5.20.1.1) is required for STA
DP_PAR_API - A branch version (5.18.1.1) is required for MAR