PATCH C-TMS P042: Difference between revisions

From Calidus HUB
VisualWikitext
No edit summary
Line 651: Line 651:
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}
 
{| class="wikitable" border="1" width="100%"
|- bgcolor="silver"
!colspan="4" | New Parameters
|-
!Parameter Name !! Config Level !! Setting Value !! Result
|-
|CNT_SERVICE_LEVEL_OFFSETS
|SYSTEM
|Y
|Enables collection and delivery offsets for service levels in the 'Business Data Maintenance' screen.
|-
|CNT_SERVICE_LEVEL_OFFSETS
|SYSTEM
|N
|Does not enable collection and delivery offsets for service levels in the 'Business Data Maintenance' screen.
|}
 
== Log Number: 02064763 ==
== Log Number: 02064763 ==
{| width="100%"
{| width="100%"

Revision as of 11:00, 15 July 2022




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

Log Number: 00239646

Summary of Call SCR-CTMS-440451-03 CTMS Database Changes
Detail of Fix Database scripts to modify the database for the new items.
Set-up and Configuration No set-up/configuration required


Log Number: 00249891

Summary of Call SCR-CTMS-440451-08 Screen changes - fleet inspection periods
Detail of Fix Added new tab page 'Fleet Inspection' to the LOCATION form.

Database script for enabling 'Fleet Inspection' tab page in Access Groups screen.

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


Log Number: 00260058

Summary of Call SCR-CTL-440451-32A Calidus Reporting Hub
Detail of Fix The ORS extract can be run from CTL
Set-up and Configuration No set-up/configuration required


Log Number: 00260047

Summary of Call SCR-CTL-440451-09 CTL Call Logging Screen
Detail of Fix CTL changes - New development: Call logging screen
Set-up and Configuration No set-up/configuration required


Log Number: 00244856

Summary of Call SCR-CTMS-440451-13 CTMS Generation of service jobs by job (delivery)
Detail of Fix Updated the description of the 'POD_ITEM_LEVEL' and 'EPOD_WS_MESSAGE_FORMAT' system parameters.

The 'EPOD_ITEM_LEVEL' parameter will include 'IC', 'IP', 'LC' and 'LP' values to include item and product information to be included for item or line level for the 'EPOD_CONTAINERS'.

Added 'Epod Mode' as a dropdown list to the delivery types in the 'Business Data Maintenance' screen.

The 'Epod Mode' will include 'MODE1', 'MODE2', 'CALLOUT' and 'INSPECT'.

The outbound EPOD message will assess the 'Epod Mode' for the delivery type of the order.

The 'CALLOUT' mode will include 'EPOD_SERVICES' for the delivery jobs for the orders.

Set-up and Configuration
New Parameters
Parameter Name Config Level Setting Value Result
EPOD_ITEM_LEVEL SYSTEM IC Send Containers for items
EPOD_ITEM_LEVEL SYSTEM IP Send Containers for item products
EPOD_ITEM_LEVEL SYSTEM LC Send Containers for lines
EPOD_ITEM_LEVEL SYSTEM LP Send Containers for line products
EPOD_WS_MESSAGE_FORMAT SYSTEM PARCEL EPOD message format
EPOD_WS_MESSAGE_FORMAT SYSTEM BULK EPOD message format
EPOD_WS_MESSAGE_FORMAT SYSTEM RETAIL EPOD message format
EPOD_WS_MESSAGE_FORMAT SYSTEM MODE1 EPOD message format
EPOD_WS_MESSAGE_FORMAT SYSTEM MODE2 EPOD message format
EPOD_WS_MESSAGE_FORMAT SYSTEM DELTYPE EPOD message format - can be MODE1, MODE2 (default), CALLOUT or INSPECT mode for the delivery type to define where fields are sent in the web service message.


Log Number: 00252522

Summary of Call SCR-CTMS-440451-20 CTMS Customer Vehicle Search webservice
Detail of Fix New inbound CUSTOMER_VEHICLE_SEARCH
Set-up and Configuration No set-up/configuration required


Log Number: 00274077

Summary of Call Https calls for lat/long calcs
Detail of Fix The wallet file and its password can be specified in system parameters 'HTTPS_WALLET_FILE' and 'HTTPS_PASSWORD' for the database when using 'https' url commands.
Set-up and Configuration
New Parameters
Parameter Name Config Level Setting Value Result
HTTPS_WALLET_FILE SYSTEM Populated The wallet file will be used for the 'https' url commands in the database.
HTTPS_WALLET_FILE SYSTEM Null The wallet file will not be used for the 'https' url commands in the database.
HTTPS_PASSWORD SYSTEM Populated The password will be used with the wallet file for the 'https' url commands in the database.
HTTPS_PASSWORD SYSTEM Null The password will not be used with the wallet file for the 'https' url commands in the database.


Log Number: 01899265

Summary of Call New API for external carrier
Detail of Fix Changes to use a new Carrier API to send manifests and retrieve labels in json format.
Set-up and Configuration No set-up/configuration required


Log Number: 01909696

Summary of Call Mixmove development
Detail of Fix A new interface for MIXMOVE to send manifests and receive scans
Set-up and Configuration No set-up/configuration required


Log Number: 00260441

Summary of Call SCR-CTL-440451-34 CTL Customer Reports
Detail of Fix Added scripts to insert new ORS_TYPE named "TYRE_ORDS" to replicate STD_ORDS

Added new ORS type 'TYRE_INSP' with levels 'ORDER AND TRIP', 'VEHICLE_TYRES', 'INSPECTIONS'.

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


Log Number: 01967222

Summary of Call Carrier API Testing Incident
Detail of Fix Amendment to Carrier API to allow continued tracking and audit for non API packs
Set-up and Configuration No set-up/configuration required


Log Number: 01970111

Summary of Call Changes to the Carrier API
Detail of Fix Prevent the un pack message being displayed for LFE trips where the carrier only sends a single tracking record and the tracking records do not match the number of packed items
Set-up and Configuration No set-up/configuration required


Log Number: 01969607

Summary of Call Received Order Status tag and generate a reference record
Detail of Fix Create audit records for ORDER_STATUS as received in AX. Include the VEHCILE_CODE in the outbound event back to AX.
Set-up and Configuration No set-up/configuration required


Log Number: 00256955

Summary of Call SCR29 - Oracle Development
Detail of Fix Modified 'IMP' package to include the new import types 'TYRES' and 'CUST_FLEET'
Set-up and Configuration No set-up/configuration required


Log Number: 01969399

Summary of Call Status change on IF054 to include Tendered
Detail of Fix Changes to inbound files to set to status ACCEPTED if currently at status PLANNED or TENDERED
Set-up and Configuration No set-up/configuration required


Log Number: 00250543

Summary of Call SCR-CTL-440451-32B CTL Fleet Inspection Analysis Report
Detail of Fix Corrected system parameters which had hardcoded value
Set-up and Configuration No set-up/configuration required


Log Number: 00284500

Summary of Call Carrier API changes to the label
Detail of Fix Carrier API changes to the label details
Set-up and Configuration No set-up/configuration required


Log Number: 00261979

Summary of Call CTMS Development with EPOD for 261925 440451-26.
Detail of Fix Updates from EPOD:

A new system parameter called 'EPOD_COMPLETE_ON_LOAD_UPDATE' can be configured by cost centre to enable the trips to be set to status 'COMPLETED' for a load update. The system parameter 'EPOD_COMPLETE_ON_RTD' should be set to 'N' when 'EPOD_COMPLETE_ON_LOAD_UPDATE' is set to 'Y'. The trip status will not be updated to 'COMPLETED' except when updating loads when 'EPOD_COMPLETE_ON_LOAD_UPDATE' is set to 'Y'.

Trip planning from CTL:

The orders will be added to the trips for delivery. The driver, carrier and vehicle will be validated that they are active and for their combination. Any advised trips for the order must have the same driver, carrier and vehicle for the order to be added to that trip. The trips will have a shift for the driver if the order is being delivered within that shift and the driver does not have a planned diary exception for that time (e.g. for annual leave or sickness). These trips will have start and end times for the times for the shift. The trips will have a diary exception for the driver outside of the shift for the driver (e.g. overtime). These trips will have start and end times for the times for the diary exception. If an order is being planned outside of a shift for the driver and without a diary exception (e.g. overtime), the trip will have start and end times based on the standard distance and time calculations based on the time windows for the order.

Set-up and Configuration
New Parameters
Parameter Name Config Level Setting Value Result
EPOD_COMPLETE_ON_LOAD_UPDATE COST_CENTRE Y The trips will be set to status 'COMPLETED' for a load update.
EPOD_COMPLETE_ON_LOAD_UPDATE COST_CENTRE N The trips will not be set to status 'COMPLETED' for a load update.


Log Number: 00287229

Summary of Call 3pl carrier configuration
Detail of Fix Changes to the 3PL carrier rating to take into account the number of trips a carrier can be assigned per day. Additional changes to the rating card to include a new condition type TRAILER_GRP
Set-up and Configuration No set-up/configuration required


Log Number: 00265284

Summary of Call SCR-CTMS-440451-14 CTMS Update of service jobs by job (delivery) type
Detail of Fix The driver assignment for shifts will allow a vehicle to be optional
Set-up and Configuration No set-up/configuration required


Log Number: 00287039

Summary of Call SCR-CTL-440451-34 CTL Customer Reports - Amendments to TYRE_ORDS extract
Detail of Fix TYRE_ORDS is amended to contain two new fields called Rejection Reason Code and Rejection Reason from the late reason codes for the order.
Set-up and Configuration No set-up/configuration required


Log Number: 00287384

Summary of Call Trip ID Development
Detail of Fix Changes to the trip id format to use the owning depot to set trip id prefix. Controlled by new system Parameter SCH_TRIP_ID_DEPOT.
Set-up and Configuration No set-up/configuration required


Log Number: 00287950

Summary of Call SCR-CTL-440451-29 Additional Requirements for the CUST_FLEET import.
Detail of Fix The 'CUST_FLEET' import type has been modified to include a new field and to create new vehicles.

The field 'REG_FLEET_NUMBER' will be mandatory but a valid tractor code for the vehicle need not be provided. The vehicle will be created when a new registration number is provided.

A new optional field called 'CUSTOMER_ID' is available. If a customer is provided it must contain a valid customer code. The customer will be used to make the vehicle available in the advised 'BRANCH' location.

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


Log Number: 00287894

Summary of Call SCR-CTL-440451-32D Additional Requirements to the ORS screen
Detail of Fix Req filed is made editable and Added buttons called 'Req All' and 'Req None' , which can be saved and extract can be created
Set-up and Configuration No set-up/configuration required


Log Number: 00287638

Summary of Call SCR-CTL-440451 Additional Requirements
Detail of Fix System parameter 'EPOD_SEND_EPL_LAT_LONG' will be available to configure by cost centre to send the 'EPL_LAT' and 'EPL_LONG' elements for jobs to EPOD.

System parameter 'EPOD_SEND_ITEM_AKA_CODE' will be available to configure by cost centre to send the item AKA code instead of the item identifier in the 'EPL_PRODUCT_CODE' element for jobs to EPOD.

Sends element 'EPL_UNIT_TYPE' for the service with the vehicle configuration ID.

Sends the ordered quantity instead of 0 when the quantity to deliver is not set for the order item as the 'EPL_QUANTITY'.

Amendments to inbound jobs from EPOD with service updates to use the product code from the service activities as well as the service products.

Set-up and Configuration
New Parameters
Parameter Name Config Level Setting Value Result
EPOD_SEND_EPL_LAT_LONG COST_CENTRE Y Sends EPL_LAT or EPL_LONG for EPOD_JOB_ADDRESS
EPOD_SEND_EPL_LAT_LONG COST_CENTRE N Does not send EPL_LAT or EPL_LONG for EPOD_JOB_ADDRESS
EPOD_SEND_ITEM_AKA_CODE COST_CENTRE Y Sends item AKA code for EPL_PRODUCT_CODE instead of item identifier but not instead of DU type for container products
EPOD_SEND_ITEM_AKA_CODE COST_CENTRE N Does send item AKA code for EPL_PRODUCT_CODE instead of item identifier but not instead of DU type for container products


Log Number: 00293881

Summary of Call SCR-CTMS-Issue 31 Send reason codes to EPOD for the RVC
Detail of Fix Created trigger on RES_VEHICLE_CONFIG which sends EPOD_REASON_CODE for insert, update (with action 'A') or delete (with action 'X') as configured for the carriers or the cost centres.
Set-up and Configuration No set-up/configuration required


Log Number: 00266101

Summary of Call API release
Detail of Fix New API method for receiving Orders and sending Trip events from and to source systems
Set-up and Configuration No set-up/configuration required


Log Number: 00294849

Summary of Call SCR-CTL-440451-29 Additional Requirements for the CUST_FLEET import
Detail of Fix The 'CUST_FLEET' import type has been modified to include a new field and to create new vehicles.

The field 'REG_FLEET_NUMBER' will be mandatory but a valid tractor code for the vehicle need not be provided. The vehicle will be created when a new registration number is provided.

A new optional field called 'CUSTOMER_ID' is available. If a customer is provided it must contain a valid customer code. The customer will be used to make the vehicle available in the advised 'BRANCH' location.

This case is linked to 287950 for 440451-29.

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


Log Number: 00294874

Summary of Call SCR-CTMS-Issue 37 Send Removal items to EPOD after creation in CTL
Detail of Fix EPOD_SERVICE_PRODUCT is modified to include EPL_DIRECTION to 'R', and EPL_QUANTITY = 1 when service_type is 'REMOVAL', other values are as generated for the original tyre.

Altered SCH_ORD_ITEMS to include new column SERVICE_TYPE (eg: REMOVAL).

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


Log Number: 00295843

Summary of Call CTY Issue 38 - 440451-20 Vehicle Searches
Detail of Fix Modified DP_EPOD_WEB_SERVICE.EPOD_VEHICLE_SEARCH_IN So that the vehicle searches for the web service will not refer to the location usage directly to obtain the customer, they will use the customer locations for the vehicle themselves.
Set-up and Configuration No set-up/configuration required


Log Number: 00279282

Summary of Call TTM Interface changes
Detail of Fix New sections for LOTS for tyres and order vehicles.

See LOTS_EXPORT_TYRE for the sections for the tyres for the order and its items.

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


Log Number: 02030242

Summary of Call Manually send orders via API
Detail of Fix New menu items available in Orders screens to push orders out
Set-up and Configuration No set-up/configuration required


Log Number: 00301397

Summary of Call Release of V_VEHICLE_DETAILS on CTMS
Detail of Fix New view for CTL.
Set-up and Configuration No set-up/configuration required


Log Number: 00301831

Summary of Call CTY - 440451-20 Amend format of the results for the Vehicle Searches
Detail of Fix The Vehicle Searches will contain the results with the customer and location within the vehicle section.
Set-up and Configuration No set-up/configuration required


Log Number: 00308136

Summary of Call Enable Collection and delivery offsets
Detail of Fix A new system parameter called 'CNT_SERVICE_LEVEL_OFFSETS' can be used to enable collection and delivery offsets for service levels 'Business Data Maintenance' screen.

When its value is 'Y', the 6 new offset fields will be displayed for each service level. Coll/Del Offset field will contain a number of days between 0 and 999. Early/Late Col/Del offset fields will contain a number of minutes between 0 and 999999. Collection offsets cannot be greater than delivery offsets. The set of Coll/Del Offset and Early/Late Col/Del fields must be present to save the data.

Set-up and Configuration No set-up/configuration required
New Parameters
Parameter Name Config Level Setting Value Result
CNT_SERVICE_LEVEL_OFFSETS SYSTEM Y Enables collection and delivery offsets for service levels in the 'Business Data Maintenance' screen.
CNT_SERVICE_LEVEL_OFFSETS SYSTEM N Does not enable collection and delivery offsets for service levels in the 'Business Data Maintenance' screen.

Log Number: 02064763

Summary of Call MixMove development request
Detail of Fix Outbound 'MIXMOVE' will contain EDI parameters to send DU types and reusable assets.

'SEND_DU_TYPE' will include the 'DU_TYPE' tag for the order items when it is set to 'Y'.

'SEND_REUSABLE_ASSET' will remove the suffix for any reusable assets in the 'ITEM_IDENTIFIER' tag when it is set to 'Y'.

Inbound 'MIXMOVE_SCNS' will contain an EDI parameter to receive reusable assets.

'SEND_REUSABLE_ASSET' will reattach the suffix for any reusable assets on the order from the 'ITEM_IDENTIFIER' tag when it is set to 'Y'.

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


Log Number: 00310665

Summary of Call CTY Issue 52 - Service jobs should not have Linked ID set against them when sent from CTMS to EPOD
Detail of Fix When EPL_JOB_TYPE is set to 'S' then service jobs should not have Linked ID set against them when sent from CTMS to EPOD
Set-up and Configuration No set-up/configuration required


Log Number: 02023242

Summary of Call LFE POD Format Update
Detail of Fix The creation of a tracking reference is audited when a label is printed for the order, and the deletion of a tracking reference is audited for the order.

The 'CARRIER_POD' type of import will include new columns of data to extract from the file for the format that is being used:

- POD_NAME

- TRIP_ID

- REASON_TEXT


The 'DELIVERED' field should be 'FIXED' to 'Y' to enable only the 'Delivered' events to be processed in the message.

The 'LFE POD' message contains validation of the size and type of the data.

The delivered tracking reference must exist for the advised order reference.

The order lines will be updated as delivered as they have been packed and despatched.

The orders will be updated with information about the signatory and the reason code for the delivery.

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

Log Number: 02069048

Summary of Call Services case 02069048
Detail of Fix The ‘On Time Items (Assets)’ extract does not include the ‘Child Asset’ column of data.

The ‘On Time Items’ extract continues to include the ‘Child Asset’ column of data.

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


Log Number: 02064838

Summary of Call BOBS Extract
Detail of Fix A new database view called V_SCH_TRIP_STATUS has been created to select records from the auditing of the trips.

The following columns will be available to query:

STA_SCHED_NAME STA_TRIP_ID STA_TRIP_STATUS STA_ACTION_DATE STA_ACTIONED_BY

The data will be selected in the following sequence:

STA_SCHED_NAME STA_TRIP_ID

And then by an audit number which will correspond to the STA_ACTION_DATE.

Access has been granted to MTS_USER and BOBS_ROLE.

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


Log Number: 02011793

Summary of Call Amend and Cancel Carrier API calls
Detail of Fix Carrier API changes to call the amendment process when an order is re-packed and the cancel process when an order is UNSCHEDULED.
Set-up and Configuration No set-up/configuration required


Log Number: 00274074

Summary of Call Change https calls to include a system param for a wallet and password
Detail of Fix Changed https calls to include system parameters called HTTPS_WALLET_FILE and HTTPS_PASSWORD for secure call.
Set-up and Configuration No set-up/configuration required


Log Number: 00273451

Summary of Call SCR-CTMS-440451-06 CTMS Internal Integration
Detail of Fix System parameter 'API_WS_ELUCID_ADDRESS' can be used to specify the address for the Elucid interface.

System parameters 'API_WS_ELUCID_USER' and 'API_WS_ELUCID_PASSWD' can be used to specify access for the Elucid interface. This address will be used in preference to the generic 'API_WS_ADDRESS' when the EDI parameter 'API_USE_WS_ELUCID' is 'Y'. The EDI parameter 'API_INC_CANCELLED' can be set to 'Y' to include orders that are 'CANCELLED' as well as 'FAILED'. Customer imports can be run by calling the 'DP_CTMS_IMPORT.IMPORT_CUSTOMER' function."

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


Log Number: 00310663

Summary of Call CTY Issue 42 - Sending activity records across to EPOD from CTMS
Detail of Fix Sending activity records across to EPOD from CTMS.

RVT table is altered to add two new columns RVT_NEW_REMOULD and RVT_REGROOVED. EPOD_JOB_IN is modified to update RVT with OTI/SOI EPOD_OUT is changed to use RVT in EPOD_SERVICE_ACTIVITY PRESSURE and SIZE are populated as per requirement in a cascade of levels

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


Log Number: 02108659

Summary of Call Provide Planners with AX status
Detail of Fix A new system parameter called 'TRM_SOURCE_SYSTEM' will be used to display a new field called 'Source System Status' in the 'Trip Details' tab page in the 'Planning' screen.

When this parameter is set to 'Y' and the source system status for the trip is either 'IN PROGRESS' or 'CLOSED', then the fields on the 'Trip Details' and 'Stops' tab pages will be displayed in white text on a red background to advise the user that that trip is active in the WMS source system and that it should not be amended manually.

The order will store a reference called 'ORDER_WMS_STATUS' from the 'ORDER_STATUS' tag in the 'ORDER_HEADER' section of the order message from the API.

This WMS order status will update the source system status of the relevant trip for the order.

A 'STAGED' WMS order status will update any trunk trips for the order, otherwise the delivery trip will be updated for the order.

Note that the source system status of the trip will not revert to a previous status should one of its orders be advised with a new WMS order status out of sequence; the sequence 'OPEN' to 'IN PROGRESS' to 'CLOSED' will be followed.

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


Log Number: 02112078

Summary of Call Add additional text to the supplier manifest
Detail of Fix Carrier 3PL Emails - Generate Tender, Tender amendment and cancel emails to Carriers
Set-up and Configuration No set-up/configuration required


Log Number: 00296022

Summary of Call Auditing API
Detail of Fix DP_EXPORT_EVENTS is modified to use two edi_process_triggers AUDIT_STATUS for the status from EVENTS_OUT.And AUDIT_METHOD for the storage option.

Then audit the NAK/ACK responses and store them in audit records or text FILE accordingly.

DP_CTMS_IMPORT- (import_order and import_customer functions) are modified to use two edi_process_triggers AUDIT_STATUS for the status and AUDIT_METHOD for the storage option.

To choose the audit responses as NAK/ACK/NAK,WAK/ALL and store them in audit records or text FILE accordingly.

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

Log Number: 02108654

Summary of Call Create a new NAK email event
Detail of Fix New email messages for NAK events.

Setup:

The new system parameter called 'MSG_NAKS' can be set to 'Y' to trigger email messages for 'NAK' events.

The new system parameter called 'MSG_NAKS_EMAIL' can be used to store email addresses for 'NAK' events (delimited by semi-colons).

The new system parameter called 'MSG_NAKS_TYPE' to list the types of processes for 'NAK' events (delimited by commas).

A new message type called 'NAK_MSG' is present to enable the email messages to be processed for 'NAK' events’.

A new import decode type called 'MSG_NAK_EVENTS' is available to configure the text for the emails for the type of messages being generated, for example:

'INBOUND' as 'Inbound from EPOD' 'IN_API_ORD' as 'Inbound order from AX' 'IN_API_CUST' as 'Inbound customer from Elucid' 'OUT_API' as 'Outbound to AX' 'OUTBOUND' as 'Outbound to EPOD'

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


Log Number: 00530144

Summary of Call Webfleet Change
Detail of Fix Changes to the outbound Webfleet interface to send different OrderNo data and drip feed stops. Changes to the inbound interface to store in 3 new tables
Set-up and Configuration No set-up/configuration required


Log Number: 00530148

Summary of Call Customer Enquiry API and Text Messages
Detail of Fix New Customer Enquiry API to receive an external reference and respond with the ETA. New TEXT API to send information to external system for generating text messages
Set-up and Configuration No set-up/configuration required


Log Number: 00278514

Summary of Call SCR-CTMS-440451-32D Operational Reports
Detail of Fix New ORS types 'STD_TIMES', 'TYREKEYCUS' and 'TYREKEYGRP' have been created.

A new system parameter called 'ORS_TYPE_DEF_GROUP_BY' with description 'List of the ORS types to default group by fields' will be used to identify ORS types that will default the 'Grp By' column from the master data to use in the report when the column itself may not be selected for display.

The initial values will be 'TYREKEYCUS,TYREKEYGRP' to default the 'Period', and the 'Customer' and 'Customer Group' fields respectively.

The 'TYRE_KEY' reports will have separate types to report by 'Customer' or by 'Customer Group', they will be known as 'TYREKEYCUS' and 'TYREKEYGRP' respectively.

The 'Period' should be specified as a range of values in format 'YYYY-MM'.

The 'Customer' and the 'Customer Group' should be specified to optimise the production of the respective reports.

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


Log Number: 02124442

Summary of Call Paragon Interface
Detail of Fix New API to link Paragon and CTMS
Set-up and Configuration No set-up/configuration required


Log Number: 02133144

Summary of Call BTO and TOT suppression in MIXMOVE
Detail of Fix Suppress BTO and TOT media types to MIXMOVE
Set-up and Configuration No set-up/configuration required


Log Number: 00311975

Summary of Call Carrier API to take account of Bank Holidays
Detail of Fix Ready date must not include bank holidays
Set-up and Configuration No set-up/configuration required


Log Number: 00321455

Summary of Call Audit API Amendments
Detail of Fix Included all the changes that are mentioned in the below comments.

DP_EXPORT_EVENTS is modified to change the Audit messages so that, ACK includes Only RESPONSE.

NAK includes REQUEST/RESPONSE.

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


Log Number: 02116783

Summary of Call WebFleet amendment to receive text requests and respond
Detail of Fix WEBFLEET changes to receive text messages from Drivers and respond with itinerary or re-sending orders
Set-up and Configuration No set-up/configuration required


Log Number: 00323040

Summary of Call CTMS exports to epod
Detail of Fix The message to EPOD will contain a new field called EPL_AXLE_TYPE in the EPOD_SERVICE_ACTIVITIES section.
Set-up and Configuration No set-up/configuration required


Log Number: 02131420

Summary of Call Changes to WebFleet, Epod truncation, and trip id format
Detail of Fix Requested amendments to the customer interface
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
New Parameters
Parameter Name Config Level Setting Value Result
OMS_INVALID_SAME_LOCS SYSTEM Y Orders will have a status of 'INVALID' when they have the same 'from' and 'to' locations.

This validation will apply to 'master' and 'child' locations.

OMS_INVALID_SAME_LOCS SYSTEM N Orders will not be invalid when they have the same 'from' and 'to' locations.


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=10142’