PATCH C-TMS P043: Difference between revisions

From Calidus HUB
VisualWikitext
No edit summary
No edit summary
Line 159: Line 159:
   
   
ORD_START_TIME = 08:00
ORD_START_TIME = 08:00
ORD_END_TIME = 18:00
ORD_END_TIME = 18:00
   
   
Line 164: Line 165:
   
   
CREATE_UNKNOWN_LOCS = Y
CREATE_UNKNOWN_LOCS = Y
CREATE_UNKNOWN_ORDER = N
CREATE_UNKNOWN_ORDER = N
MATCH_FULL_LOC = Y
MATCH_FULL_LOC = Y
   
   
Line 170: Line 173:
   
   
DEFAULT_COLLECTION = Y
DEFAULT_COLLECTION = Y
LOCATION_EXT_REF = Y
LOCATION_EXT_REF = Y
ORD_INVOICED = Y
ORD_INVOICED = Y
ROUTE_DELIVERY = Y
ROUTE_DELIVERY = Y
RUN_NUMBER_VALID = Y
RUN_NUMBER_VALID = Y
   
   
Line 178: Line 185:
   
   
CUST_UPDATE_ORDER_LINES = N
CUST_UPDATE_ORDER_LINES = N
INTERFACE_FORMAT = NONE
INTERFACE_FORMAT = NONE
ORD_LINK_CONTENTS = N
ORD_LINK_CONTENTS = N
   
   

Revision as of 11:55, 31 January 2023




Aptean Logo.png










Release Notes

CALIDUS TMS

12th December 2023 - 1.0
Reference: P043











































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: 00320472

Summary of Call Create location ID
Detail of Fix Location ID is modified to create from Recipient address reference instead of postcode which was in use until now,

based on the maximum length location is appended with the subsequent suffix to keep it unique or truncated to add suffix so that it doesn't violate the maximum length.

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


Log Number: 00327516

Summary of Call Emails not received when trip deleted
Detail of Fix There aren't any recipients for CANCEL_3PL messages for carrier RBT for trip TQK-00046583.

The carrier was N113780 until it was changed at 2022/07/20 12:52:44.

The message was generated at this time so RBT was used.

RBT was used for the carrier on the trip when its schedule was switched from 220719 to 220721.

The carrier is reset for the owning depot ready for the carrier to be confirmed and updated for the new schedule.

A new system parameter called 'TRM_RETAIN_CARRIER_NEW_SCHED' can be used to retain the carrier on the trip when the schedule is changed in the 'Planning' screen.

Set-up and Configuration


New Parameters
Parameter Name Config Level Setting Value Result
TRM_RETAIN_CARRIER_NEW_SCHED COST_CENTRE Y/N It is to retain a carrier when the schedule of the trip is updated. Otherwise, the carrier is reset to the carrier for the owning depot.


Log Number: 00326413

Summary of Call Trunking Specification
Detail of Fix New Fixed routes trunking engine.
Set-up and Configuration No set-up/configuration required


Log Number: 00315981

Summary of Call Calidus CTL Build
Detail of Fix Various changes for CTL call logging.
Set-up and Configuration No set-up/configuration required


Log Number: 00322438

Summary of Call Orders Interface
Detail of Fix New system parameters are available to store the start and end times for the orders, for example:

ORD_START_TIME = 08:00

ORD_END_TIME = 18:00

Other system parameters should be set:

CREATE_UNKNOWN_LOCS = Y

CREATE_UNKNOWN_ORDER = N

MATCH_FULL_LOC = Y

The EDI process called 'API' will have new parameters to set for the new functionality:

DEFAULT_COLLECTION = Y

LOCATION_EXT_REF = Y

ORD_INVOICED = Y

ROUTE_DELIVERY = Y

RUN_NUMBER_VALID = Y

Other EDI parameters should be set:

CUST_UPDATE_ORDER_LINES = N

INTERFACE_FORMAT = NONE

ORD_LINK_CONTENTS = N

The 'End' time for the fixed route can be maintained in the 'Route Detail' screen.

Set-up and Configuration


New Parameters
Parameter Name Config Level Setting Value Result
ORD_START_TIME SYSTEM NULL Not used for the default early delivery time.
ORD_START_TIME SYSTEM TIME The default early delivery time when a route is not provided for an API order (HH:MM).
ORD_END_TIME SYSTEM NULL Not used for the default late delivery time.
ORD_END_TIME SYSTEM TIME The default late delivery time when a route is not provided for an API order (HH:MM).


Log Number: 00335523

Summary of Call ParentCustomer Relationships
Detail of Fix Amendments to parent and child customers and groups for creation and updating.

Address lines will be limited to 50 characters.

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


Log Number: 00336332

Summary of Call Tyre removal order line is showing on device for collection
Detail of Fix Order items for REMOVAL service types will not be included for Loading stops when the job is sent to EPOD.
Set-up and Configuration No set-up/configuration required


Log Number: 00339287

Summary of Call API Export Events not auditing all messages
Detail of Fix The temporary variables which are accessing EDI_PROCESS_TRIGGER for AUDIT_METHOD and AUDIT_STATUS are made to be populated at the start of the 2 procedures (process_xml_outbound_api, process_xml_outbound_api_ord) so that they can be assessed for each type of message.
Set-up and Configuration No set-up/configuration required


Log Number: 00340343

Summary of Call Service update issue between EPOD & CTMS
Detail of Fix The EPL_UDF item will be accepted with a null value.
Set-up and Configuration No set-up/configuration required


Log Number: 00340339

Summary of Call Export Work Type
Detail of Fix EPL_DIRECTION is based on the work type for the order item.

It will be R for Removal or I for Installation.

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


Log Number: 00341214

Summary of Call Order Item Reason Codes
Detail of Fix Trip stops will be updated with actual times for a service job as well as a collection job or a delivery job.

Order lines and items will be maintained for the deliveries and services.

The format 'OMS-SEQ' will be used for new items with the next sequence number being obtained for that format.

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


Log Number: 00342094

Summary of Call CTL Order Items
Detail of Fix Fixed the generation of sch_order_line records when creating an order in CTL.
Set-up and Configuration No set-up/configuration required


Log Number: 00325239

Summary of Call Cleanse data in outbound API
Detail of Fix Modified the packages DP_EXPORT_EVENTS and DP_XML_EPOD to remove the special characters that are getting generated in the output file.
Set-up and Configuration No set-up/configuration required


Log Number: 00344579

Summary of Call Add On Products and Services
Detail of Fix New Interface to upload items onto pre-existing orders.
Set-up and Configuration No set-up/configuration required


Log Number: 00340340

Summary of Call Update fails into Elucid from CTMS
Detail of Fix A new EDI parameter called 'SEND_DEL_TYPE_CODE' can be set to 'Y' to send the code for the delivery type as 'TMS_DELIVERY_TYPE'.

The EDI parameter 'DEL_ALL_ACT_QTY' can be used to assess the delivered quantities for the order items.

The system parameter 'LOTS_DEL_CUST_SIGNATORY' can be used to assess the signatory for the orders.

An amendment has been made to the 'DEL' messages for a trip to assess the quantities separately to the signatory.

An appropriate message will be generated for when a 'DEL' message cannot be sent with respect to those parameters.

Auditing has been reinstated for trip and order events.

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


Log Number: 00345032

Summary of Call The CAN messages are being re-sent.
Detail of Fix 'CAN' messages will be sent once.
Set-up and Configuration No set-up/configuration required


Log Number: 00344924

Summary of Call Interface to Portal
Detail of Fix The 'LAST_INSPECTION_DATE' will not be sent to 'LOTS' when a date has not been recorded.
Set-up and Configuration No set-up/configuration required


Log Number: 00344993

Summary of Call Convert CTL items to format OMS-SEQ to match EPOD item
Detail of Fix A new system parameter called 'OMS_SEQ_CTL_ITEM_FORMAT' will be used to identify the format of the order items when they are created in CTL.

The format 'OMS-SEQ' will be used when the system parameter is 'Y'.

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


Log Number: 00345010

Summary of Call EPOD Services and Prices
Detail of Fix Removed default start and end times of '00' to send to EPOD.

Sends price to EPOD with a default value of 0.00.

Sends services to EPOD for INSPECT delivery type orders as well as CALLOUT orders.

Includes decimal places from EPOD for:

EPL_MILEAGE EPL_PRESSURE EPL_TREAD_DEPTH EPL_PRICE

Updates stop times from EPOD for service jobs.

Stores classification and category for WMS products.

Updates order items, actual despatched and delivered quantities once when EPOD sends multiple updates.

Uses default DU type and product type for new order lines for products from EPOD.

Creates services based on the delivery type and the vehicle type for CALLOUT orders.

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


Log Number: 02111893

Summary of Call Secure FTP
Detail of Fix Code has been added to the package DP_INT_XML_MIC2 to enable SFTP in TMSDEV, able to do SFTP now.

A record will need to be added as a known host in the database to enable SFTP.

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


Log Number: 02227349

Summary of Call Changes to EDI to accomodate Microlise interface
Detail of Fix Set despatched quantity to send messages to Microlise
Set-up and Configuration No set-up/configuration required


Log Number: 01935522

Summary of Call Inbound Scanning Loose Items
Detail of Fix The order items can be reused on later orders once they have been scanned through cross-docking.

Checks whether the scanned item exists on the same order on which it was planned before checking to see if the item has been seen in the network before - these items can be scanned on their current planned orders.

If the item has been scanned on a different order, checks if the item is found to have been through the network on other orders. These items cannot be scanned.

If the item is only planned onto one other order, the item will be moved from that order to the order indicated by the scan as normal.

This validation will apply to the 831 and 835 messages from WCS, the standard and the faster scanning processes will include this validation.

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


Log Number: 00342485

Summary of Call CTL Trip Order Assignment
Detail of Fix Retains the stop times when the driver of the trip does not have any times to set from a shift for planning in CTL.
Set-up and Configuration No set-up/configuration required


Log Number: 02231368

Summary of Call Additional Changes Required
Detail of Fix New fields added to the Configurable layout in Waterfall screen, changes to the Order Well in the planning screen
Set-up and Configuration No set-up/configuration required


Log Number: 02165959

Summary of Call LFE Carrier Change
Detail of Fix Service levels will be decoded using 'CARRIER_API_SERVICE_LEVEL' for the carrier of the trip and they will be added to the Carrier API message.

A new system parameter called 'CARRIER_API_MANIFEST_READY_TIME' for the system will be used to set the cut-off time in format 'HH24:MI' to assess the ready times.

A default value of '18:00' will be used should the system parameter not be set or if it is set with an invalid format for the time.

The Ready Time will be adjusted to account for the cut-off time when the order is packed in advance of the delivery date of the order.

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


Log Number: 00350325

Summary of Call Waterfall screen amendments
Detail of Fix Amendments following UAT, TAB BLOCKS configured, EN-ROUTE status set based on DL and PK stops and not SU. Prevent Carrier trips from moving schedules in the overnight process.
Set-up and Configuration No set-up/configuration required


Log Number: 00323035

Summary of Call Scheduling Engine
Detail of Fix New scheduling process for customer, covering delivery routes, replen orders and collection desk orders
Set-up and Configuration No set-up/configuration required


Log Number: 00322441

Summary of Call Customer Onboarding Interface
Detail of Fix New API standard customer import.
Set-up and Configuration No set-up/configuration required


Log Number: 00349335

Summary of Call CTL menu items for ORS
Detail of Fix Modified the form and package so that any unauthorized user group cannot access that menu. This depends on the 'ADM_NO_DISPLAY_MENU' system parameter i.e, set to 'CTL'
Set-up and Configuration No set-up/configuration required


Log Number: 00351008

Summary of Call Load Index to be changed to 20 character field from numeric field
Detail of Fix Alters the database table to store a larger load index up to 20 digits for the WMS products references.
Set-up and Configuration No set-up/configuration required


Log Number: 00353959

Summary of Call LFE Carrier Amendment
Detail of Fix Amendment to switch the serviceCode to use the customer of the order not the carrier of the trip.
Set-up and Configuration No set-up/configuration required


Log Number: 00349336

Summary of Call On inspection update
Detail of Fix Added EPL_WORK_COMPLETE for the service status.

The service status is C when there is no action or the work is complete, otherwise it is P.

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


Log Number: 00350925

Summary of Call No delivered item in Elucid
Detail of Fix Update items as delivered for EPOD level IP based on the AKA, direction and position.
Set-up and Configuration No set-up/configuration required


Log Number: 00349283

Summary of Call Amend driver shift patterns screen
Detail of Fix Adding new shift manually instead of via display shifts.

Default database parameters such as depot in the detail screen.

Update message 'all drivers' should read 'all selected drivers'.

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


Log Number: 00355355

Summary of Call Failure Notifications for Customer Imports
Detail of Fix Reports separately these items for the API customer import from Elucid:

RecipientAddress

RecipientCompany

InvoiceCompany

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


Log Number: 00355573

Summary of Call Inbound Job
Detail of Fix Alters the database table to store a larger load index up to 20 digits for the WMS products references.
Set-up and Configuration No set-up/configuration required


Log Number: 00350912

Summary of Call PSI pressure set to 2 characters in epod and TMS
Detail of Fix The pressure and the tread depth have been increased in length to store 4 numbers plus a decimal place.
Set-up and Configuration No set-up/configuration required


Log Number: 00355519

Summary of Call LOTS Installation for Customer Imports
Detail of Fix The customers will be stored with a LOTS customer based on the buyer from Elucid when LOTS is active when the EDI parameter CUST_LOTS_ID is Y.

The customers will be stored with a LOTS customer based on the customer in the standard import process when LOTS is active when the EDI parameter CUST_LOTS_ID is Y.

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


Log Number: 00355562

Summary of Call Order Auditing
Detail of Fix The auditing is not being triggered by CTL orders.

The booking process has been changed to perform the auditing instead to create the vehicle record for the order.

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


Log Number: 00356803

Summary of Call Service Report
Detail of Fix The EPL_OFFICE_INSTRUCTIONS item in the EPOD_JOB section is included when the order on the trip has an order to action.
Set-up and Configuration No set-up/configuration required


Log Number: 00364252

Summary of Call No vehicle search found
Detail of Fix The vehicle search will be case sensitive for the reg/fleet number.
Set-up and Configuration No set-up/configuration required


Log Number: 00356212

Summary of Call Number of tyres
Detail of Fix The order line quantity will be incremented or decremented when the quantities for the order items is added or adjusted.

These quantities will be for the ordered quantity or the despatched quantity as appropriate.

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


Log Number: 00365467

Summary of Call Service Report
Detail of Fix Uses EPL_OFFICE_INSTRUCTION.
Set-up and Configuration No set-up/configuration required


Log Number: 00365797

Summary of Call Sending loading jobs to EPOD
Detail of Fix Includes the item description instead of the DU type description in EPL_DESCRIPTION for level IP.
Set-up and Configuration No set-up/configuration required


Log Number: 00366524

Summary of Call Actions not completing
Detail of Fix The Pending tyre inspections will be updated for a position on a vehicle based on the EPL_CODE_2.
Set-up and Configuration No set-up/configuration required


Log Number: 00366230

Summary of Call Some completed jobs are showing as part delivered
Detail of Fix Sends an ORDER_VEHICLES section per order to LOTS.
Set-up and Configuration No set-up/configuration required


Log Number: 02254409

Summary of Call Cross Dock Scanning
Detail of Fix Added new EDI_PROCESS for customer, which calls the new function - fn_load_trunks to avoid ford scanning.

Setup: Create a new EDI Process for that particular customer along with its cost center.

Add the function (TRM.fn_load_trunks) in the report values and run the EDI process every 5 minutes.

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


Log Number: 00367465

Summary of Call RVA_PRESSURE needs increasing in size
Detail of Fix RES_VEHICLE_CONFIG_AXLE.RVA_PRESSURE is NUMBER(5,1) to match RES_VEHICLE_AXLE.RVA_PRESSURE.
Set-up and Configuration No set-up/configuration required


Log Number: 00366787

Summary of Call Vehicle Fleet Maintenance
Detail of Fix An inspection is not required in CTL for a location that does not have a period setup.
Set-up and Configuration No set-up/configuration required


Log Number: 00366861

Summary of Call Epod MODE 2
Detail of Fix Standard orders will update the order items when a position and a direction/work type are not known.
Set-up and Configuration No set-up/configuration required


Log Number: 00368176

Summary of Call COL-VUI messages
Detail of Fix The COL-VUI messages will include the ORDER_VEHICLE section once per vehicle.
Set-up and Configuration No set-up/configuration required


Log Number: 00368493

Summary of Call Customer Load Sheets
Detail of Fix Runs a new Loading Sheet based on new parameters
Set-up and Configuration No set-up/configuration required


Log Number: 00368621

Summary of Call STS Auditing for the Customer Import API
Detail of Fix Amendments to auditing for the RESPONSE and for UAT.
Set-up and Configuration No set-up/configuration required


Log Number: 00371961

Summary of Call Change for fleet inspections for EPOD
Detail of Fix Services are only sent to EPOD for a CALLOUT.

Customer vehicles are only stored as order vehicles for a CALLOUT.

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


Log Number: 00368184

Summary of Call Order with tyre value of 0
Detail of Fix Does not update DELIVERED or FAILED orders to be ON-HOLD, when an order is validated when the customer account is on hold.

Does not update ON-HOLD, DELIVERED or FAILED orders to be SCHEDULED or UNSCHEDULED when a service is added to the order.

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


Log Number: 00364162

Summary of Call Copy and split order functions
Detail of Fix Copy_order ,split_order and duplicate_order functions in OMS are updated to insert the newly added columns for SCH_ORD and SCH_ORD_ITEMS tables.
Set-up and Configuration No set-up/configuration required


Log Number: 00371509

Summary of Call Change to addresses
Detail of Fix Includes an EPOD_CUSTOMER_INVOICE section within the EPOD_CUSTOMER section in the EPOD_JOB SECTION for the service jobs when the new system parameter called EPOD_CUSTOMER_INVOICE is set to Y.

For release with issue 301 for EPOD.

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


Log Number: 02166754

Summary of Call Driver Sheet
Detail of Fix The customer Trip Sheet for the drivers has been converted to a portrait format.
Set-up and Configuration No set-up/configuration required


Log Number: 00372699

Summary of Call Trips showing as Part Delivered
Detail of Fix The new order items will be created with a planned quantity and a despatched quantity to match the advised delivered quantity.

These items will be for vehicles that have been inspected and that have had parts supplied

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


Log Number: 00372373

Summary of Call ODO not stored
Detail of Fix Update statement for RES_TRACTOR has been added to the the package, which will update ODO value by assessing EPL_MILEAGE.
Set-up and Configuration No set-up/configuration required


Log Number: 00373035

Summary of Call Remove EPL_SITE_ID
Detail of Fix Removed EPL_SITE_ID from previous version as it was causing error while uploading the data.
Set-up and Configuration No set-up/configuration required



INCIDENTS

Log Number: 00325803

Summary of Call Always send locations to Paragon via API
Detail of Fix Send Locations to Paragon when manual orders are sent to Paragon
Set-up and Configuration No set-up/configuration required


Log Number: 00326046

Summary of Call API export
Detail of Fix Return NAK from API export when not success.
Set-up and Configuration No set-up/configuration required


Log Number: 00328694

Summary of Call Driver not being sent to ePOD
Detail of Fix System parameter EPOD_SEND_DRIVER can be set to N to send the EPL_USER_ID as a null value instead of the driver's username.

A default value of Y will apply to continue to send the driver's username.

Set-up and Configuration


New Parameters
Parameter Name Config Level Setting Value Result
EPOD_SEND_DRIVER SYSTEM Y The driver's username is included.
EPOD_SEND_DRIVER SYSTEM N The driver's username is not included.


Log Number: 00328687

Summary of Call Callout orders not getting sent to ePOD
Detail of Fix Applied NVL to the fields EPL_PRODUCT_QTY_CASE and EPL_MILEAGE so that if the values are blank it'll update to 0.

EPL_SIZE will be assessed as a character not a number.

Added the trip ID to the audit log for exceptional error handling.

Set-up and Configuration


New Parameters
Parameter Name Config Level Setting Value Result
EPOD_WS_MESSAGE_FORMAT SYSTEM NONE EPOD message format - can either be PARCEL, BULK, RETAIL, MODE1, MODE2 or DELTYPE to define where fields are sent in the web service message.


Log Number: 00330994

Summary of Call TOMTOM Amendment
Detail of Fix Amendment to TOMTOM to only look at next days depot for trips.
Set-up and Configuration No set-up/configuration required


Log Number: 00332107

Summary of Call ORDER_STATUS in API
Detail of Fix The 'ORDER_STATUS' will be included in the 'ORDER_HEADER' section for the API messages when the EDI parameter 'INCLUDE_ORDER_STATUS' is 'Y'.
Set-up and Configuration No set-up/configuration required


Log Number: 00332122

Summary of Call API Customer Import Amendments for Elucid
Detail of Fix Amendments to the customer import for Elucid including:

1. Using the Buyer for the location for the MAIN address

2. Creating an account for a new customer.

3. Inserting or updating customers, locations and contacts.

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


Log Number: 00332893

Summary of Call API Customer Import - Exceptional Error Handling for Elucid
Detail of Fix The customer group name will be truncated to 35 characters but the customer name will remain at 50 characters.

Locations for customers and customer groups will available to use.

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


Log Number: 00338487

Summary of Call Various Ctl changes.
Detail of Fix CTL Call Logging Changes. Update Vehicle change. Fix for Contact generation. Generate Axle and Tyres info.
Set-up and Configuration No set-up/configuration required


Log Number: 00327382

Summary of Call ORS failing in CTL
Detail of Fix Changed the datatype of the field t_det_sel to CLOB to mitigate the error in the package. Added storage limit exception to the form and package. So, the user is advised to use limited records to produce the report. Added a new parameter to the CTL procedure DP_REPORT.P_GEN_ORS_SQL_CTL to display the err_msg in CTL. It needs to be tested in CTL as it involves the procedure DP_REPORT.P_GEN_ORS_SQL_CTL.

Also, modified the code to mitigate the string concatenation too long error.

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


Log Number: 00340142

Summary of Call Ctl Call Logging Issues 87/92
Detail of Fix Changes to update the Time Windows whenever the order changes if it isn't booked or cancelled
Set-up and Configuration No set-up/configuration required


Log Number: 02139434

Summary of Call Invalid order lines preventing trips moving to ACCEPTED status
Detail of Fix A new system parameter called 'WCS_RETAIN_EMPTY_LINES' can be set to 'Y' to retain any empty order lines that have been created after their items have been deleted during the order confirmation process.

These order lines will not have a despatched quantity.

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


Log Number: 00340479

Summary of Call Include created and updated auditing for contracts and imports
Detail of Fix The contracts and import maintenance tables are altered to use CREATED_DATE/BY and UPDATED_DATE/BY to assist analysis.
Set-up and Configuration No set-up/configuration required


Log Number: 00345853

Summary of Call Version release control for 02221309
Detail of Fix The audit message in the import package are updated to avoid filling up the disk space.
Set-up and Configuration No set-up/configuration required


Log Number: 00345814

Summary of Call A validation error is occurring for some DSPD messages
Detail of Fix The DSPD message will enable EN-ROUTE trips to be updated with package information.
Set-up and Configuration No set-up/configuration required


Log Number: 00345445

Summary of Call Changes containing trunk version of DP_EPOD_WEB_SERVICE
Detail of Fix Phase 2 of webfleet integration including free text message requires, working hours request, drive card message, incorrect address, incorrect contact, next delivery.

Delete orders not finished in overnight job, move future trips to the correct schedule.

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


Log Number: 02234525

Summary of Call Cost not pulling through
Detail of Fix Generates an outbound API event when the trip cost is set for the first time or is changed.
Set-up and Configuration No set-up/configuration required


Log Number: 00357019

Summary of Call Additional Changes to Planning and Waterfall screen
Detail of Fix Changes to Planning and Waterfall screen and allocate resources

2 new parameters SHOW_CARRIER_NAME and ALLOC_RESOURCE to be set to Y

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


Log Number: 00365766

Summary of Call Additional Changes Part 2
Detail of Fix Part 2 of additional changes. Parameter CANCEL_STATUS_CHK must be set to Y
Set-up and Configuration No set-up/configuration required


Log Number: 00366538

Summary of Call Waterfall Menu
Detail of Fix Control waterfall menu access
Set-up and Configuration No set-up/configuration required


Log Number: 00374968

Summary of Call Release of V_TRIP_OVERVIEW
Detail of Fix Database view V_TRIP_OVERVIEW will be made available to recompile.
Set-up and Configuration No set-up/configuration required


Log Number: 00374083

Summary of Call Indexes for new tables
Detail of Fix Indexes added for performance optimization
Set-up and Configuration No set-up/configuration required


Log Number: 00349874

Summary of Call Display automatically on screen a newly created contract
Detail of Fix Added new functionality to the contracts form to populate new contract in Contracts screen automatically.
Set-up and Configuration No set-up/configuration required



BUGS

Log Number: 02129675

Summary of Call Trip audit missing items
Detail of Fix The update of the following information for the trip will be audited separately:

Owning Depot Route Code Carrier ID Tractor ID Driver ID Shift Code Seal Number

Note that the 'Tractor ID' may be set to 'SUB-CONTRACT' when the 'Sub Contractor' box is ticked for the trip.

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


Log Number: 00298173

Summary of Call LFE Carrier Integration
Detail of Fix TRG to populate Created_date and Created_by in sch_ord_tracking before inserting a tracking reference record.
Set-up and Configuration No set-up/configuration required


Log Number: 00325648

Summary of Call EPL_JOB_ID sent twice
Detail of Fix Remove duplicate EPL_JOB_ID
Set-up and Configuration No set-up/configuration required


Log Number: 02140871

Summary of Call API Processing
Detail of Fix A TRP message will be sent via the API when an order is deassigned from a trip or assigned to a trip when its status is not PLANNED.
Set-up and Configuration No set-up/configuration required


Log Number: 02135828

Summary of Call CTMS Export processing
Detail of Fix Corrected code so update requests are on the currently open cursor
Set-up and Configuration No set-up/configuration required


Log Number: 02132813

Summary of Call Payments - Currency Code not set
Detail of Fix A new function is available in CTMS:

The currency code will be returned to set for the Portal order that is being entered.

This currency code will be present to calculate the payments when the order is scheduled.

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


Log Number: 02137857

Summary of Call Portal Order Entry
Detail of Fix New function to allow portal to write audit records
Set-up and Configuration No set-up/configuration required


Log Number: 00320489

Summary of Call Location Maintenance for SWAP locations
Detail of Fix A new system parameter called GEO_HIDE_SWAP_LOCATIONS can be used to remove SWAP locations from the location list when set to Y.
Set-up and Configuration


New Parameters
Parameter Name Config Level Setting Value Result
GEO_HIDE_SWAP_LOCATIONS SYSTEM Y/N It is to exclude SWAP locations from list of Location_ID's in location maintenance screen


Log Number: 02128190

Summary of Call Orders not consolidating on stops
Detail of Fix Customers that do not allow consolidated orders on delivery trips will assess overlapping available order time windows for their trip stops.

A new system parameter called 'TRM_CONSOL_ORDER_AFTER_XDOCK' can be set to 'Y' if the customers do not want to assess these available order time windows against the other orders on the loading trip stop when the order has been collected previously.

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


Log Number: 00333266

Summary of Call Customer Upload bug
Detail of Fix Call Logging changes for booking releases, Issue 6 changes etc.
Set-up and Configuration No set-up/configuration required


Log Number: 02128610

Summary of Call Access Control - CNT functions
Detail of Fix Resolved all the issues, Modified the CONTRACT form to use the CNT functions based on the respected access_control functions for the user group. Introduced a new CNT function 'CNT_Delete_Tier_Name' for the Ability to delete tier names.
Set-up and Configuration No set-up/configuration required


Log Number: 02222075

Summary of Call Batch Order creation, Order reference does not enable Alpha entry on numeric
Detail of Fix Modified the package OMS.create_order_from_template to mitigate the numeric conversion error which is restricting the user from creating orders in the ORDER TEMPLATE screen.

This change also contains the solution for case 02160908.

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


Log Number: 00346821

Summary of Call Ctl changes for issues 168 and 171
Detail of Fix Ctl Issues 168 and 171 resolved. Plus a fix for Here maps.
Set-up and Configuration No set-up/configuration required


Log Number: 02224778

Summary of Call Incorrect data on actual arrive date POD
Detail of Fix Amended the CARPOD process for LFE to ensure that the POD_DATE includes the full year in its format to assign to the actual date for the trip stops.
Set-up and Configuration No set-up/configuration required


Log Number: 02147681

Summary of Call Warehouse screen
Detail of Fix The ad-hoc services will be stored as a payment and then it can be updated.

The payments, bulk packaging and services will be audited as they are created and updated.

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


Log Number: 00351271

Summary of Call Control updates in the Waterfall screen
Detail of Fix Control when updates can be performed in WATERFALL screen
Set-up and Configuration No set-up/configuration required


Log Number: 00349334

Summary of Call Ctl System Params
Detail of Fix Changes for CTL inspections. Added default Del Types and Services.
Set-up and Configuration No set-up/configuration required


Log Number: 02243017

Summary of Call Microlise Outbound Interface
Detail of Fix The maximum length of the direct messages to Microlise has been extended.
Set-up and Configuration No set-up/configuration required


Log Number: 02232219

Summary of Call CFX inbound interface incorrect
Detail of Fix The PLANNED and TENDERED trips will be updated to ACCEPTED.

An audit message will be created should the trip status fail to update.

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


Log Number: 00355544

Summary of Call CTL Changes
Detail of Fix Various changes for CTL
Set-up and Configuration No set-up/configuration required


Log Number: 00360149

Summary of Call Release for Issue 214
Detail of Fix Set action_id for linked inspections.
Set-up and Configuration No set-up/configuration required


Log Number: 00365146

Summary of Call Order Lines
Detail of Fix Added deletion of order lines.
Set-up and Configuration No set-up/configuration required


Log Number: 00364940

Summary of Call Issue 250
Detail of Fix Only select drivers that are active for the carrier in question.
Set-up and Configuration No set-up/configuration required


Log Number: 02263060

Summary of Call Copy Order function
Detail of Fix Copy order functions in OMS is modified to create the IXC record when EDI trigger INC_COPIED_ORDERS is set to 'Y' to trigger the messages to ConnectedView.
Set-up and Configuration No set-up/configuration required


Log Number: 00366764

Summary of Call Tyre size
Detail of Fix Issue 245 Added tyre size to vehicle view. Issue 247 added check for To Location.
Set-up and Configuration No set-up/configuration required


Log Number: 00367653

Summary of Call Cty Vehicle view
Detail of Fix Added location name and axle config description.

CTL release required alongside CTMS release

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



PRODUCT DEVELOPMENT

Log Number: 00318182

Summary of Call Review inactive flags that are not being referenced - delivery type-service level
Detail of Fix Inactive flag has been reviewed to make it consistent throughout the database for DEL_TYPE and SERVICE_LEVEL
Set-up and Configuration No set-up/configuration required


Log Number: 00279440

Summary of Call Issues In CTMS Locations screen
Detail of Fix The 'Close' button is modified to mitigate the error. 'Save changes' message will not be displayed without any change in the Form.
Set-up and Configuration No set-up/configuration required


Log Number: 00314793

Summary of Call Wait for API response
Detail of Fix A new EDI parameter should be set up to enable to wait for a response or 'send and forget'.

EDI parameter called SEND_AND_FORGET should be set up for process name API, which when set to Y, it will stop waiting for response and vice versa.

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


Log Number: 00323078

Summary of Call Temperature violation during trip validation
Detail of Fix The error message regarding temperature violation during trip validation was noted for the case 322452.

There is a query (actually more than one) that will not find a record and issue this error message but it can never select a record without the trailer being known.

In that sense change is made to display this error message only when trailer type is known and if not then it should be suppressed.

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


Log Number: 00374777

Summary of Call Wallet File
Detail of Fix https has to be used in 19c databases – change is to use the wallet file.

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



MODULES DELIVERED

Module Name Version No Description Log Number
ACC_CTRL.fmx 2.56 Access control maintenance 00349335
ADM.sql 5.12 Administrator package containing various DB utils 00349335
AT_CNT_CHARGE_CONDITIONS_TRACTOR_340479.sql 1.1 AT Script 00340479
AT_CNT_CHARGE_CONDITIONS_TRLRTYPE_340479.sql 1.1 AT Script 00340479
AT_CNT_CHARGE_MIN_MAX_340479.sql 1.1 AT Script 00340479
AT_CNT_CHARGE_PARAM_340479.sql 1.1 AT Script 00340479
AT_CNT_CHARGE_TYPE_340479.sql 1.1 AT Script 00340479
AT_CNT_CONDITION_340479.sql 1.1 AT Script 00340479
AT_CNT_CONDITION_VALUE_340479..sql 1.1 AT Script 00340479
AT_CNT_CONTRACT_INDEX_340479.sql 1.1 AT Script 00340479
AT_CNT_CUST_LOC_GROUP_340479.sql 1.1 AT Script 00340479
AT_CNT_DEL_TYPE_340479.sql 1.1 AT Script 00340479
AT_CNT_DEL_TYPE_CONV_340479.sql 1.1 AT Script 00340479
AT_CNT_DEL_TYPE_CUST_EXCL_340479.sql 1.1 AT Script 00340479
AT_CNT_DEL_TYPE_USE_340479.sql 1.1 AT Script 00340479
AT_CNT_RHA_CONFIG_340479.sql 1.1 AT Script 00340479
AT_CNT_RHA_INDEX_340479.sql 1.1 AT Script 00340479
AT_CNT_SERVICE_CHARGES_340479.sql 1.1 AT Script 00340479
AT_CNT_SERVICE_CONTRACTS_340479.sql 1.1 AT Script 00340479
AT_CNT_SERVICE_LEVEL_340479.sql 1.1 AT Script 00340479
AT_CNT_STD_JOURNEY_340479.sql 1.1 AT Script 00340479
AT_CNT_TIER_NAME_340479.sql 1.1 AT Script 00340479
AT_GEO_LOCATION_00322441.sql 1.1 AT Script 00322441
AT_IMP_FIELD_340479.sql 1.1 AT Script 00340479
AT_IMP_FIELD_SOURCE_340479.sql 1.1 AT Script 00340479
AT_IMP_FORMULA_340479.sql 1.1 AT Script 00340479
AT_IMP_HIST_DETAIL_340479.sql 1.1 AT Script 00340479
AT_IMP_HIST_HEADER_340479.sql 1.1 AT Script 00340479
AT_IMP_IMPORT_TYPE_340479.sql 1.1 AT Script 00340479
AT_IMP_IMPORT_TYPE_REC_TYPE_340479.sql 1.1 AT Script 00340479
AT_IMP_LOAD_AUDIT_340479.sql 1.1 AT Script 00340479
AT_IMP_ORDERS_340479.sql 1.1 AT Script 00340479
AT_IMP_RECORD_FORMAT_340479.sql 1.1 AT Script 00340479
AT_INT_XML_ORD_HEADER_00368493.sql 1.1 AT Script 00368493
AT_ORD_TYRE_INSPECTIONS_00350912.sql 1.1 AT Script 00350912
AT_ORG_CUSTOMER_00322441.sql 1.1 AT Script 00322441
AT_ORG_CUSTOMER_00368493.sql 1.1 AT Script 00368493
AT_RES_VEHICLE_AXLE_00350912.sql 1.1 AT Script 00350912
AT_RES_VEHICLE_CONFIG_AXLE_00367465.sql 1.1 AT Script 00367465
AT_RES_VEHICLE_TYRE_00350912.sql 1.1 AT Script 00350912
AT_RTE_ROUTE_00322438.sql 1.1 AT Script 00322438
AT_RTE_ROUTE_00323035.sql 1.1 AT Script 00323035
AT_SCH_ORD_ITEMS_00350912.sql 1.1 AT Script 00350912
AT_TOMTOM_ETA_EVENTS_374083.sql 1.1 AT Script 00374083
AT_TRM_CARRIER_COST_374083.sql 1.1 AT Script 00374083
AT_WMS_PRODUCT_XREF_00351008.sql 1.1 AT Script 00351008
BDM.fmx 2.106 Business Data Form 00326413
BDM.fmx 2.108 Business Data Form 00349283
CARRIER_RULES.fmx 1.16 Carrier Rules Maintenance Screen 00318182
CONTRACT.fmx 2.75 Contracts Form 02128610
CONTRACT.fmx 2.76 Contracts Form 00340479
CONTRACT.fmx 2.77 Contracts Form 00349874
CT_GEO_DELIVERY_ROUTE_PRIORITY.sql 1.3 CT Script 00326413
CT_GEO_LOCATION_WINDOW_00322441.sql 1.1 CT Script 00322441
CT_GEO_ROUTE_DTLS.sql 1.3 CT Script 00326413
CT_PAR_API_STAGING_ROUTE.sql 1.2 CT Script 00326413
CT_PAR_JSON_IN_ROUTE.sql 1.3 CT Script 00326413
CT_PAR_KEYS_ROUTE.sql 1.3 CT Script 00326413
CT_SEQ_GEO_LOCATION_WINDOW_00322441.sql 1.1 CT Script 00322441
CT_SEQ_GEO_ROUTE_DTLS.sql 1.2 CT Script 00326413
CT_SEQ_TT_DRIVE_02156578.sql 1.1 CT Script 00345445
CT_SEQ_TT_WORK_02156578.sql 1.1 CT Script 00345445
CT_TOM_DRIVE_02156578.sql 1.1 CT Script 00345445
CT_TOM_WORK_02156578.sql 1.1 CT Script 00345445
CUST_COST.fmx 2.140 Customer Maintenance form 00318182
CUST_COST.fmx 2.141 Customer Maintenance form 00322441
DATA_ADM_FUNCTION_322353.sql 1.1 Data Script 02128610
DATA_ADM_LOG_PROG_NAME_02111893.sql 1.2 Data Script 02111893
DATA_ADM_LOG_PROG_NAME_349283.sql 1.1 Data Script 00349283
DATA_ADM_SYSTEM_PARAM_00322438.sql 1.1 Data Script 00322438
DATA_ADM_SYSTEM_PARAM_00323035.sql 1.2 Data Script 00323035
DATA_ADM_SYSTEM_PARAM_00330994.sql 1.1 Data Script 00330994
DATA_ADM_SYSTEM_PARAM_00351271.sql 1.1 Data Script 00351271
DATA_ADM_SYSTEM_PARAM_00357019.sql 1.1 Data Script 00357019
DATA_ADM_SYSTEM_PARAM_00365766.sql 1.1 Data Script 00365766
DATA_ADM_SYSTEM_PARAM_00368493.sql 1.1 Data Script 00368493
DATA_ADM_SYSTEM_PARAM_00371509.sql 1.1 Data Script 00371509
DATA_ADM_SYSTEM_PARAM_02111893.sql 1.3 Data Script 02111893
DATA_ADM_SYSTEM_PARAM_02124442.sql 1.1 Data Script 00328694
DATA_ADM_SYSTEM_PARAM_02128190.sql 1.1 Data Script 02128190
DATA_ADM_SYSTEM_PARAM_02139434.sql 1.1 Data Script 02139434
DATA_ADM_SYSTEM_PARAM_02156578.sql 1.1 Data Script 00345445
DATA_ADM_SYSTEM_PARAM_02165959.sql 1.1 Data Script 02165959
DATA_ADM_SYSTEM_PARAM_02231368.sql 1.1 Data Script 02231368
DATA_ADM_SYSTEM_PARAM_315981.sql 1.1 Data Script 00315981
DATA_ADM_SYSTEM_PARAM_318182.sql 1.1 Data Script 00318182
DATA_ADM_SYSTEM_PARAM_320489.sql 1.2 Data Script 00320489
DATA_ADM_SYSTEM_PARAM_327516.sql 1.1 Data Script 00327516
DATA_ADM_SYSTEM_PARAM_328687.sql 1.1 Data Script 00328687
DATA_ADM_SYSTEM_PARAM_344993.sql 1.1 Data Script 00344993
DATA_ADM_SYSTEM_PARAM_349335.sql 1.1 Data Script 00349335
DATA_ADM_SYSTEM_PARAM_CONFIG_327516.sql 1.1 Data Script 00327516
DATA_ADM_USER_PARAM_002118515.sql 5.1 Data Script 00333266
DATA_ADM_USER_PARAM_TYPE_002118515.sql 5.1 Data Script 00333266
DATA_ADM_USER_PARAM_TYPE_00349334.sql 1.1 Data Script 00349334
DATA_EDI_FLOW_TYPES_00344579.sql 1.1 Data Script 00344579
DATA_GEO_LOC_TYPE_346821.sql 1.1 Data Script 00346821
DATA_MSG_EVENT_TYPE_00323035.sql 1.1 Data Script 00323035
DATA_REP_REPORT_00368493.sql 1.1 Data Script 00368493
DATA_REP_REPORT_PARAM_00368493.sql 1.1 Data Script 00368493
DP_ASKGEO.sql 1.3 AskGEO Interface 00374777
DP_CARRIER_API.sql 5.10 Database Package 02165959
DP_CARRIER_API.sql 5.11 Carrier API Database Package 00353959
DP_CTMS_IMPORT.sql 5.11 API Import Database Package 00332893
DP_CTMS_IMPORT.sql 5.12 API Import Database Package 00335523
DP_CTMS_IMPORT.sql 5.15 API Import Database Package 00322441
DP_CTMS_IMPORT.sql 5.16 API Import Database Package 00355355
DP_CTMS_IMPORT.sql 5.17 API Import Database Package 00355519
DP_CTMS_IMPORT.sql 5.18 API Import Database Package 00365766
DP_CTMS_IMPORT.sql 5.20 API Import Database Package 00368621
DP_CTMS_IMPORT.sql 5.7 Database Package 00320472
DP_CTMS_IMPORT.sql 5.8 API Import Database Package 00322438
DP_CTMS_IMPORT.sql 5.9 API Import Database Package 00332122
DP_CUST_SERV.sql 1.39 Customer Service Package 00315981
DP_CUST_SERV.sql 1.41 Customer Service Package 00333266
DP_CUST_SERV.sql 1.42 Customer Service Package 00338487
DP_CUST_SERV.sql 1.45 Customer Service Package 00340142
DP_CUST_SERV.sql 1.46 Customer Service Package 00342094
DP_CUST_SERV.sql 1.47 Customer Service Package 00344993
DP_CUST_SERV.sql 1.48 Customer Service Package 00346821
DP_CUST_SERV.sql 1.49 Customer Service Package 00349334
DP_CUST_SERV.sql 1.50 Customer Service Package 00355544
DP_CUST_SERV.sql 1.51 Customer Service Package 00355562
DP_CUST_SERV.sql 1.52 Customer Service Package 00360149
DP_CUST_SERV.sql 1.53 Customer Service Package 00356212
DP_CUST_SERV.sql 1.54 Customer Service Package 00365146
DP_CUST_SERV.sql 1.55 Customer Service Package 00366764
DP_EPOD_WEB_SERVICE.sql 1.151 EPOD Web Service 00325648
DP_EPOD_WEB_SERVICE.sql 1.152 EPOD Web Service 00325803
DP_EPOD_WEB_SERVICE.sql 1.153 EPOD Web Service 00328694
DP_EPOD_WEB_SERVICE.sql 1.156 EPOD Web Service 00328687
DP_EPOD_WEB_SERVICE.sql 1.157 EPOD Web Service 00336332
DP_EPOD_WEB_SERVICE.sql 1.158 EPOD Web Service 00340343
DP_EPOD_WEB_SERVICE.sql 1.159 EPOD Web Service 00340339
DP_EPOD_WEB_SERVICE.sql 1.160 EPOD Web Service 00341214
DP_EPOD_WEB_SERVICE.sql 1.161 EPOD Web Service 00345010
DP_EPOD_WEB_SERVICE.sql 1.162 EPOD Web Service 00345445
DP_EPOD_WEB_SERVICE.sql 1.163 EPOD Web Service 00349336
DP_EPOD_WEB_SERVICE.sql 1.164 EPOD Web Service 00350925
DP_EPOD_WEB_SERVICE.sql 1.165 EPOD Web Service 00355573
DP_EPOD_WEB_SERVICE.sql 1.166 EPOD Web Service 00356803
DP_EPOD_WEB_SERVICE.sql 1.167 EPOD Web Service 00364252
DP_EPOD_WEB_SERVICE.sql 1.168 EPOD Web Service 00365467
DP_EPOD_WEB_SERVICE.sql 1.169 EPOD Web Service 00365797
DP_EPOD_WEB_SERVICE.sql 1.170 EPOD Web Service 00366524
DP_EPOD_WEB_SERVICE.sql 1.171 EPOD Web Service 00366787
DP_EPOD_WEB_SERVICE.sql 1.172 EPOD Web Service 00366861
DP_EPOD_WEB_SERVICE.sql 1.173 EPOD Web Service 00371961
DP_EPOD_WEB_SERVICE.sql 1.174 EPOD Web Service 00371509
DP_EPOD_WEB_SERVICE.sql 1.175 EPOD Web Service 00373035
DP_EPOD_WEB_SERVICE.sql 1.176 EPOD Web Service 00372373
DP_EPOD_WEB_SERVICE.sql 1.177 EPOD Web Service 00372699
DP_EXPORT_EVENTS.sql 5.11 API Export Events Database Package 02135828
DP_EXPORT_EVENTS.sql 5.12 API Export Events Database Package 00326046
DP_EXPORT_EVENTS.sql 5.13 API Export Events Database Package 00332107
DP_EXPORT_EVENTS.sql 5.15 API Export Events Database Package 00339287
DP_EXPORT_EVENTS.sql 5.17 API Export Events Database Package 00314793
DP_EXPORT_EVENTS.sql 5.18 API Export Events Database Package 00325239
DP_EXPORT_EVENTS.sql 5.20 API Export Events Database Package 00340340
DP_EXPORT_EVENTS.sql 5.21 API Export Events Database Package 00345032
DP_EXPORT_EVENTS.sql 5.22 API Export Events Database Package 02231368
DP_FORD_EDI_IN.sql 5.1 Database Package 00344579
DP_FORD_EDI_IN.sql 5.2 Database Package 02227349
DP_IMP_2.sql 1.81 Import Package 00318182
DP_INT_TMS_WMS_IN_STUB.sql 1.23 Inbound WMS/TMS Interface Package 00318182
DP_INT_XML_CFX.sql 1.7 CFX Interface Database Package 02232219
DP_INT_XML_MIC2.sql 1.35 CTMS to MIC Interface 02111893
DP_INT_XML_MIC2.sql 1.36 CTMS to MIC Interface 02243017
DP_LFE_POD.sql 5.6 LFE POD Database Package 02224778
DP_NOKIA_LOC_PLAT.sql 1.37 Nokia Location Platform Interface 00345445
DP_PAR_API.sql 5.8 Database Package 00345445
DP_PAR_API.sql 5.9 Database Package 02231368
DP_PAR_API_STP.sql 5.1 Database Package 00323035
DP_PULSE.sql 1.51 Pulse Interface Package 00318182
DP_RDT_AUTO.sql 5.47 Client specific RDT funtions 02139434
DP_RDT_FAST_UNLOAD.sql 5.48 RF Unload Package 01935522
DP_REPORTS.sql 5.72 Reports package 00327382
DP_REPORTS.sql 5.73 Reports package 00368493
DP_SCHEDULING_ENGINE.sql 5.179 Scheduling Package 00326413
DP_SCHEDULING_ENGINE.sql 5.180 Scheduling Package 00323035
DP_SCHEDULING_ENGINE.sql 5.181 Scheduling Package 00357019
DP_TOMTOM.sql 1.38 TomTom Package 00330994
DP_TOMTOM.sql 1.39 TomTom Package 00345445
DP_TOMTOM.sql 1.40 TomTom Package 02231368
DP_TRM_CHANGE_SCHEDULE.sql 5.1 Database Package 00345445
DP_TRM_CHANGE_SCHEDULE.sql 5.2 Database Package 00350325
DP_WEB_SERVICE_ORD.sql 1.30 Web Service Package 00318182
DP_XML_EPOD.sql 1.4 XML Database Package 00335523
DP_XML_EPOD.sql 1.5 XML Database Package 00325239
EDI_MAINT.fmx 10.17 EDI Maintenance Screen 00357019
EXECUTION.fmx 1.108 Execution screen 00318182
IMP.sql 5.215 CSV Imports Package 00318182
IMP.sql 5.216 CSV Imports Package 00345853
IMP.sql 5.217 CSV Imports Package 00350912
IMPORTS_MAINT.fmx 1.25 Import Maintenance Form 00318182
INT_ERR.fmx 1.111 Interface Errors 00344579
INT_ERR_ORD.fmx 2.10 Interface error correction 00318182
INT_XML_IN.sql 5.238 Order Import Package 00345814
INT_XML_OUT2.sql 5.326 Outbound XML Package 00344924
INT_XML_OUT2.sql 5.327 Outbound XML Package 00366230
INT_XML_OUT2.sql 5.328 Outbound XML Package 00368176
LOCATION.fmx 2.202 Location Maintenance 00279440
LOCATION.fmx 2.203 Location Maintenance 00326413
LOCATION.fmx 2.204 Location Maintenance 00320489
MSG_MAINT.fmx 2.33 Message Maintenance screen 00318182
MSG_PROCESSING.sql 5.75 Message Processing package 00330994
NETWORK.fmx 1.18 Network Maintenance 00318182
OMS.sql 5.252 Order package 00318182
OMS.sql 5.253 Order package 02132813
OMS.sql 5.254 Order package 02137857
OMS.sql 5.255 Order package 02222075
OMS.sql 5.257 Order package 02263060
OMS.sql 5.329 Order package 00368184
OMS.sql 5.330 Order package 00364162
ORD_ENTRY_TARGET.fmx 2.30 Order Entry Target 00318182
ORDERS.fmx 2.453 Order Screen 00320489
ORDERS_WIDE.fmx 1.49 Orders Screen 00320489
ORDTEMPL.fmx 2.51 Order template 00318182
ORS.fmx 1.37 Oracle Reporting suite 00327382
PLANNING.fmx 1.128 Planning Screen 00327516
PLANNING.fmx 1.129 Planning Screen 02231368
PLANNING.fmx 1.130 Planning Screen 00323035
PLANNING.fmx 1.131 Planning Screen 00357019
PLANNING.fmx 1.132 Planning Screen 00368493
RES_PERSON_UID.sql 5.8 Trigger 00357019
RES_TRACTOR_UID.sql 5.9 Trigger 00357019
ROUTES_MAINT.fmx 2.51 Fixed Routes Maintenance 00322438
ROUTES_MAINT.fmx 2.52 Fixed Routes Maintenance 00323035
SCHED_RULES.fmx 1.35 Scheduling Screen 00318182
STAP_LOAD_SHEET.rep 1.1 Report 00368493
T_SCH_ORD_AUDIT.sql 5.20 Trigger for SCH_ORD_AUDIT 00371961
TI_SCH_ORD_STATUS.sql 1.25 Trigger on SCH_ORD for status change 00350325
TI_SCH_TRIP_AUDIT.sql 5.7 Trigger 02129675
TRG_ACC_ADHOC_SERVICES_BIU.sql 1.1 Trigger 02147681
TRG_ACC_BULK_PACK_CHGS_BIU.sql 1.1 Trigger 02147681
TRG_ACC_BULK_PACKAGING_BIU.sql 1.1 Trigger 02147681
TRG_CNT_CHARGE_CONDITIONS_TRACTOR_BIU.sql 1.1 Trigger 00340479
TRG_CNT_CHARGE_CONDITIONS_TRLRTYPE_BIU.sql 1.1 Trigger 00340479
TRG_CNT_CHARGE_MIN_MAX_IUD.sql 1.2 Trigger 00340479
TRG_CNT_CHARGE_PARAM_BIU.sql 1.1 Trigger 00340479
TRG_CNT_CHARGE_TYPE_BIU.sql 1.1 Trigger 00340479
TRG_CNT_CONDITION_BIU.sql 1.1 Trigger 00340479
TRG_CNT_CONDITION_VALUE_BIU.sql 1.1 Trigger 00340479
TRG_CNT_CONTRACT_INDEX_BIU.sql 1.1 Trigger 00340479
TRG_CNT_CUST_LOC_GROUP_BIU.sql 1.1 Trigger 00340479
TRG_CNT_DEL_TYPE_BIU.sql 1.1 Trigger 00340479
TRG_CNT_DEL_TYPE_CONV_BIU.sql 1.1 Trigger 00340479
TRG_CNT_DEL_TYPE_CUST_EXCL_BIU.sql 1.1 Trigger 00340479
TRG_CNT_DEL_TYPE_USE_BIU.sql 1.1 Trigger 00340479
TRG_CNT_RHA_CONFIG_BIU.sql 1.1 Trigger 00340479
TRG_CNT_RHA_INDEX_BIU.sql 1.1 Trigger 00340479
TRG_CNT_SERVICE_CHARGES_BIU.sql 1.1 Trigger 00340479
TRG_CNT_SERVICE_CONTRACTS_BIU.sql 1.1 Trigger 00340479
TRG_CNT_SERVICE_LEVEL_BIU.sql 1.1 Trigger 00340479
TRG_CNT_STD_JOURNEY_BIU.sql 1.1 Trigger 00340479
TRG_CNT_TIER_NAME_BIU.sql 1.1 Trigger 00340479
TRG_GEO_LOC_WIN_BIU.sql 1.1 Trigger 00322441
TRG_GEO_LOCATION_UID.sql 5.3 Trigger 00323035
TRG_GEO_ROUTE_DTLS.sql 1.2 Trigger 00326413
TRG_IMP_FIELD_BIU.sql 1.1 Trigger 00340479
TRG_IMP_FIELD_SOURCE_BIU.sql 1.1 Trigger 00340479
TRG_IMP_FORMULA_BIU.sql 1.1 Trigger 00340479
TRG_IMP_HIST_DETAIL_BIU.sql 1.1 Trigger 00340479
TRG_IMP_HIST_HEADER_BIU.sql 1.1 Trigger 00340479
TRG_IMP_IMPORT_TYPE_BIU.sql 1.1 Trigger 00340479
TRG_IMP_IMPORT_TYPE_REC_TYPE_BIU.sql 1.1 Trigger 00340479
TRG_IMP_LOAD_AUDIT_BIU.sql 1.1 Trigger 00340479
TRG_IMP_ORDERS_BIU.sql 1.1 Trigger 00340479
TRG_IMP_RECORD_FORMAT_BIU.sql 1.1 Trigger 00340479
TRG_SCH_ORD_AUDIT_LOCS.sql 1.2 Trigger 00325803
TRG_SCH_ORD_CURRENT_DEPOT.sql 5.4 Trigger 00323035
TRG_SCH_ORD_REFERENCE_RUN.sql 5.1 Trigger 00323035
TRG_SCH_ORD_SERVICES_BIUDR.sql 5.4 Trigger for SCH_ORD_SERVICES 00368184
TRG_SCH_ORD_TRACKING_BI.sql 1.2 Trigger 00298173
TRG_SHA_LOTS.sql 5.9 Trigger 02140871
TRG_STS_STATUS_CHANGES.sql 1.1 Trigger 02231368
TRG_STS_STATUS_CHANGES.sql 1.2 Trigger 00350325
TRG_TRIP_COST.sql 1.4 Trigger 02234525
TRG_TT_EVENTS_STORE.sql 1.4 Trigger 00325803
TRG_TT_EVENTS_STORE.sql 1.5 Trigger 00345445
TRG_TT_EVENTS_STORE.sql 1.6 Trigger 02231368
TRIP_OVERVIEW.fmx 1.66 Trip Waterfall 02231368
TRIP_OVERVIEW.fmx 1.67 Trip Waterfall 00350325
TRIP_OVERVIEW.fmx 1.68 Trip Waterfall 00351271
TRIP_OVERVIEW.fmx 1.69 Trip Waterfall 00357019
TRIP_OVERVIEW.fmx 1.70 Trip Waterfall 00365766
TRIP_OVERVIEW.fmx 1.71 Trip Waterfall 00366538
TRIP_OVERVIEW.sql 5.8 Trip Waterfall 00350325
TRIP_SHEET_DUN_DETAIL.rep 5.28 Driver Trip Sheet 02166754
TRM.sql 5.211 Trip manipulation package 02128190
TRM.sql 5.212 Trip manipulation package 00323078
TRM.sql 5.213 Trip manipulation package 00345445
TRM.sql 5.214 Trip manipulation package 00342485
TRM.sql 5.215 Trip manipulation package 02231368
TRM.sql 5.216 Trip manipulation package 00350325
TRM.sql 5.217 Trip manipulation package 00365766
TRM.sql 5.219 Trip manipulation package 02254409
UTL_FILE.sql 5.4 UTL_FILE package 02243017
V_CTL_CUSTGROUP.sql 5.1 View 00315981
V_CTL_CUSTGROUP.sql 5.2 View 00346821
V_CTL_CUSTLOC.sql 5.4 View 00333266
V_CTL_CUSTLOC.sql 5.6 View 00355544
V_DRIVER_LIST.sql 5.2 View 00315981
V_DRIVER_LIST.sql 5.4 View 00364940
V_GEO_CONTACT.sql 1.1 View 00338487
V_ORD_ORDER_HEADER.sql 1.13 View 00315981
V_ORD_ORDER_HEADER.sql 1.14 View 00333266
V_ORD_ORDER_HEADER.sql 1.15 View 00355544
V_ORD_ORDER_STATUS.sql 1.4 View 00355544
V_PRODUCT_CTL.sql 1.2 View 00315981
V_PRODUCT_CTL.sql 1.3 View 00333266
V_PRODUCT_CTL.sql 1.5 View 00355544
V_RES_VEHICLE_CUST_LOC.sql 1.2 View 00349334
V_TRIP_OVERVIEW.sql 1.17 Trip View 02231368
V_TRIP_OVERVIEW.sql 1.19 Trip View 00374968
V_VEHICLE_DETAILS.sql 5.2 View 00315981
V_VEHICLE_DETAILS.sql 5.3 View 00366764
V_VEHICLE_DETAILS.sql 5.4 View 00367653
WAREHOUSE.fmx 2.11 Warehouse Screen 02147681



ADDITIONAL CHANGES

WCS

There is no WCS change required.


EPOD/T2A

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

  • Log 00340339
  • Log 00349334
  • Log 00351008
  • Log 00350912
  • Log 00371509
  • Log 00373035


CTL

A CTL change is required for the following logs:

  • 00340142
  • 00355544
  • 00365146
  • 00366764
  • 00367653
  • 00327382
  • 00373035


MCS

There is no MCS change required.


PORTAL/TTM

A Portal change is required for the following logs:

  • Log 02132813
  • Log 02137857


EDI

There is no EDI change required.


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