PATCH C-TMS 11.0 P025

From Calidus HUB
Revision as of 15:56, 6 July 2017 by StylesC (talk | contribs)





Aptean Logo.png







OBS Logistics Ltd

Release Notes

CALIDUS WMS

8th May 2016 - 1.0
Reference: PPatch without the P e.g. 091











































SUMMARY INTRODUCTION

INTRODUCTION

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


GLOSSARY OF TERMS

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


TESTING PROCESS

TIDs AND RESOLUTION

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


FINAL 'END TO END' TESTING

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


AUTHORISATION

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


CHANGE REQUESTS

Customer Ref: NO REF

OBS Log Number: 341505
Reporter: Leon Winchester
Summary of Call Invoice amendments
Detail of Change/Fix Invoice Amendments
Set-up and Configuration No set-up/configuration required

Customer Ref: SCR-001

OBS Log Number: 342263
Reporter: Colin Lowe
Summary of Call Stairwalker required on orders
Detail of Change/Fix Functionality to allow Stairwalkers to be requested and applied to trips
Set-up and Configuration No set-up/configuration required

Customer Ref: SCR-003

OBS Log Number: 342265
Reporter: Colin Lowe
Summary of Call Special instructions - concatenation
Detail of Change/Fix Added EPOD_CONCATENATE_JOB_INSTR system param to enable collection/delivery comments to be appended to job instructions when sent to EPOD
Set-up and Configuration No set-up/configuration required

Customer Ref: SCR-004

OBS Log Number: 342266
Reporter: Colin Lowe
Summary of Call Customer standard instructions
Detail of Change/Fix Default special instructions from a new customer level standard instructions on new orders.
Set-up and Configuration No set-up/configuration required

Customer Ref: SCR-007

OBS Log Number: 342269
Reporter: Colin Lowe
Summary of Call Schedule rules - Date/time validation
Detail of Change/Fix Allows weekends to be included or exclude from schedule rules
Set-up and Configuration No set-up/configuration required

Customer Ref: EP-AKHDTL

OBS Log Number: 341870
Reporter: Emlyn Phipps
Summary of Call RIO: Messages from CTMS to PRL
Detail of Change/Fix Allow PRL to receive and send XML messages to C-TMS
Set-up and Configuration No set-up/configuration required

Customer Ref: DS-ALKG5L

OBS Log Number: 342564
Reporter: Denis Starodubov
Summary of Call RIO: Suppress C-TMS resource on LOAD msg
Detail of Change/Fix Do not include resource details in XML outbound message based on the value of system parameter
Set-up and Configuration No set-up/configuration required

Customer Ref: JB-AMQEYY

OBS Log Number: 342918
Reporter: Jez Brookes
Summary of Call SCR-01 Import Upload of CSV from OTM
Detail of Change/Fix Changes to generic CSV order import (ORD_LINE_ITM) to accommodate the new OTM requirements.
Set-up and Configuration No set-up/configuration required

Customer Ref: JB-AMQKTC

OBS Log Number: 342919
Reporter: Jez Brookes
Summary of Call SCR-02 - Suppress Messages to LOTS /OTM
Detail of Change/Fix Suppression of LOTS messages and reverse decodes for OTM.
Set-up and Configuration No set-up/configuration required

Customer Ref: JB-AMQKWQ

OBS Log Number: 342920
Reporter: Jez Brookes
Summary of Call SCR-03 Create CSV format output for OTM
Detail of Change/Fix New OTM export.
Set-up and Configuration No set-up/configuration required

Customer Ref: HP-AM7K8G

OBS Log Number: 342923
Reporter: Hiren Patel
Summary of Call RIO: Require POD Information
Detail of Change/Fix A new EDI process will need to be setup to process the POD_INFO files to be transferred to DHL Link. The FTP Server will need to be setup unless the existing flow for TRIPXML files can be used: this directory structure is used for LOAD, CITD and Electronic Manifest files.

A new system parameter OMS_CREATE_POD will need to be configured for the appropriate customers of the orders to generate the POD_INFO files. The POD_INFO files will be triggered when the delivered quantity of an order line is changed and the order line has not been zero packed. The delivered quantity will be compared to the despatched, packed or ordered quantity of the order line to assess the status of the order as SUCCESS, FAILED, PART DELIVERED or PART UNDELIVERED.

Note that a status of PRE DELIVERY will be used should a control record be generated and then the delivered quantity be removed. A POD_INFO file will be generated for each order and it will contain its current trip and debrief information with a vertical bar as a fixed delimiter. Note that if multiple signatories have been recorded, e.g. the order has been delivered at different times, these signatories will be listed together.

The EDI process will use the following report values:

1.

Title: Process Name

Name: P_PROCESS_NAME

Value: POD_INFO

2.

Title: Package Name

Name: PROCESS

Value: DP_CSV_POD.P_PROCESS_CSV_POD

See FS-342923 for further information.

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


Customer Ref: SH-AM9BZL

OBS Log Number: 342954
Reporter: Sarah Howells
Summary of Call RIO: LRS Order Cancellation Update
Detail of Change/Fix Send CAN message when booking ref not populated
Set-up and Configuration No set-up/configuration required

Customer Ref: SCR-335287-18 & 14

OBS Log Number: 343000
Reporter: Mike Heslop
Summary of Call CSV Upload Changes
Detail of Change/Fix Amendment to CSV import to allow home deliveries
Set-up and Configuration No set-up/configuration required


SUPPORT INCIDENTS

Customer Ref: Direct email CAK

OBS Log Number: 343143
Reporter: Nev Robinson
Summary of Call Inactive Vehicles
Detail of Change/Fix So not make vehilces inactive for Van Swap
Set-up and Configuration No set-up/configuration required

Customer Ref: INC17881661

OBS Log Number: 342684
Reporter: Piotr Plusa
Summary of Call Slow application
Detail of Change/Fix Improve speed of invoice print.
Set-up and Configuration No set-up/configuration required

Customer Ref: INC18083902

OBS Log Number: 342988
Reporter: Kelly Hembling
Summary of Call Unable to copy order
Detail of Change/Fix Amendment to copy order process when adding the suffix to the customer reference on the new orders.
Set-up and Configuration No set-up/configuration required

Customer Ref: 15/05/17 - Release

OBS Log Number: 343046
Reporter: Michelle Naumovski
Summary of Call Testing issues following release
Detail of Change/Fix The labels can be produced with the appropriate on-forwarding carrier and routing codes. The labels can be produced via the packing process as Zebra labels (for Standard and non-Standard delivery type orders), via the reports menu as an Oracle report (LFS_LABEL), or via import files from Portal as an Oracle report (LFS_LABEL_MULTI). The on-forwarding carrier will be either the predicted or the actual carrier for the delivery leg of the order. The routing codes will be displayed for the destination zone and or a via zone depending on the predicted routing or the actual routing. If the order is predicted to be delivered out of another depot the via zone will be displayed as long as it differs to the destination and origin zones for the order. Once the order has been transported to another depot the via zone will be displayed as long as it differs to the destination and origin zones for the order.
Set-up and Configuration No set-up/configuration required

Customer Ref: NO REF

OBS Log Number: 343134
Reporter: Darren Owens
Summary of Call Issue with date range on ORS
Detail of Change/Fix ORS reports fix for selecting by datetime columns
Set-up and Configuration No set-up/configuration required

Customer Ref: INC18156062

OBS Log Number: 343151
Reporter: Perry
Summary of Call Delivery report not showing all items
Detail of Change/Fix Amend customer format delivery note to work with multiple pages.
Set-up and Configuration No set-up/configuration required

Customer Ref: NO REF

OBS Log Number: 343197
Reporter: Hayley Keegan
Summary of Call Issues with testing 339950
Detail of Change/Fix Add transport mode to fuel and security
Set-up and Configuration No set-up/configuration required

Customer Ref: n/k

OBS Log Number: 343304
Reporter: Michelle
Summary of Call XML incorrect address query
Detail of Change/Fix Amendment to XML order import to include EDI process parameter 'MATCH_FULL_LOC', so supplied location details will identify an existing C-TMS location matching on all address fields and not just searching based on the location name and postcode.
Set-up and Configuration No set-up/configuration required

Customer Ref: INC18256805

OBS Log Number: 343376
Reporter: Michaela Vanousova
Summary of Call New rate uploading failure
Detail of Change/Fix Amendment to contract data import process so new fields for the import type (transport mode, accumulator) etc are only validated if they are supplied as part of the import file.
Set-up and Configuration No set-up/configuration required

Customer Ref: N/A

OBS Log Number: 343415
Reporter: Michelle Naumovski
Summary of Call <Auto-scheduling incorrect
Detail of Change/Fix Amendment to scheduling engine to correctly handle the offset days for non-working state holiday that affect scehdule routes.
Set-up and Configuration No set-up/configuration required

Customer Ref: NO REF

OBS Log Number: 343424
Reporter: Hayley Keegan
Summary of Call Fix for Minimum security Charge
Detail of Change/Fix Change to use the newer Security Table to apply Minimum charges
Set-up and Configuration No set-up/configuration required

Customer Ref: NO REF

OBS Log Number: 344031
Reporter: Peter Blackburn
Summary of Call Schedule Engine Net route Public Holiday
Detail of Change/Fix Amendment to scheduling engine to correctly handle the offset days for non-working state holiday that affect scehdule routes.
Set-up and Configuration No set-up/configuration required

Customer Ref: 804 Message

OBS Log Number: 343731
Reporter: Dave Meir
Summary of Call 804 message from WCS - trip update
Detail of Change/Fix Set trip on asset history for combined load.
Set-up and Configuration No set-up/configuration required

Customer Ref: INC18509944

OBS Log Number: 343882
Reporter: Emily Collins
Summary of Call Report tuning for INC18509944
Detail of Change/Fix Tune customer return to base report
Set-up and Configuration No set-up/configuration required

Customer Ref: Cfile Issues

OBS Log Number: 343393
Reporter: Tina Kinsella
Summary of Call Process B File before C File
Detail of Change/Fix Change to process B and C files as one EDI flow
Set-up and Configuration No set-up/configuration required


TID CHANGES

OBS Log Number:

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


OBSL PRODUCT DEVELOPMENT

OBS Log Number:

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


MODULES DELIVERED

Module Name Version No Description Log Number
ACC.sql 5.63 Accounts package 343197
ACC.sql 5.66 Accounts package 341505
ADM.sql 5.10 Administrator package containing various DB utils 339733
AGR.sql 1.16 Agreements Package 341505
AT_EDI_PROCESS_HEADER_339733.sql 1.1 Alter Table Script 339733
AT_LOGIX_TRIP_DTL_342195.sql 1.2 Alter Table Script 342195
AT_ORG_CUST_ZONES_SURCHARGES_343197.sql 1.1 Alter Table Script 343197
AT_ORG_CUSTOMER_342266.sql 1.1 Alter Table Script 342266
AT_ORG_CUSTOMER_342269.sql 1.1 Alter Table Script 342269
AT_ORS_MASTER_DATA_339733.sql 1.1 Alter Table Script 339733
AT_ORS_USER_DETAILS_339733.sql 1.1 Alter Table Script 339733
AT_RES_CARRIER_342920.sql 1.1 Alter Table Script 342920
AT_SCH_ORD_342263.sql 1.1 Alter Table Script 342263
AT_SCH_ORD_342918.sql 1.1 Alter Table Script 342918
AT_SCH_ORD_343000.sql 1.1 Alter Table Script 343000
AT_SCH_ORD_INFORMATION_343000.sql 1.1 Alter Table Script 343000
AT_SCH_ORD_RES_EQUIP_342263.sql 1.1 Alter Table Script 342263
AT_SCH_TRIP_342263.sql 1.1 Alter Table Script 342263
AT_SCHEDULE_RULES_343000.sql 1.1 Alter Table Script 343000
BATHSTORE_RET_TO_BASE.rep 1.13 Return to Base Report 343882
BNL_DELIVERY.rep 1.8 Delivery Report 343151
CARRIER_RULES.fmx 1.13 Carrier Rules Maintenance Screen 343350
CONTRACT.fmx 2.65 Contracts Form 341505
CSV.sql 5.100 CSV extract package 343233
CT_CNT_CONTRACT_INDEX_341505.sql 1.2 Create Table Script 341505
CT_OTM_ORDER_EXPORTS_342920.sql 1.1 Create Table Script 342920
CT_RES_EQUIPMENT.sql 1.1 Create Table Script 342263
CT_RES_EQUIPMENT_LOADING.sql 1.1 Create Table Script 342263
CUST_COST.fmx 2.115 Customer Maintenance form 342269
CUST_COST.fmx 2.116 Customer Maintenance form 343197
CUST_COST.fmx 2.117 Customer Maintenance form 342266
DATA_1_REP_REPORT_342920.sql 1.1 Data Script 342920
DATA_2_REP_REPORT_PARAM_342920.sql 1.1 Data Script 342920
DATA_ADM_FORM_TAB_342266.sql 1.1 Data Script 342266
DATA_ADM_SYSTEM_PARAM_341505.sql 1.1 Data Script 341505
DATA_ADM_SYSTEM_PARAM_341870.sql 1.1 Data Script 341870
DATA_ADM_SYSTEM_PARAM_342195.sql 1.1 Data Script 342195
DATA_ADM_SYSTEM_PARAM_342263.sql 1.1 Data Script 342263
DATA_ADM_SYSTEM_PARAM_342265.sql 1.1 Data Script 342265
DATA_ADM_SYSTEM_PARAM_342269.sql 1.1 Data Script 342269
DATA_ADM_SYSTEM_PARAM_342315.sql 1.1 Data Script 342315
DATA_ADM_SYSTEM_PARAM_342918.sql 1.1 Data Script 342918
DATA_ADM_SYSTEM_PARAM_342919.sql 1.1 Data Script 342919
DATA_ADM_SYSTEM_PARAM_342923.sql 1.1 Data Script 342923
DATA_ADM_SYSTEM_PARAM_342954.sql 1.1 Data Script 342954
DATA_ADM_SYSTEM_PARAM_343000.sql 1.1 Data Script 343000
DATA_ADM_SYSTEM_PARAM_343678.sql 1.2 Data Script 343678
DATA_ADM_SYSTEM_PARAM_CONFIG_341505.sql 1.1 Data Script 341505
DATA_ADM_SYSTEM_PARAM_CONFIG_342265.sql 1.1 Data Script 342265
DATA_ADM_SYSTEM_PARAM_CONFIG_342315.sql 1.1 Data Script 342315
DATA_ADM_SYSTEM_PARAM_CONFIG_342923.sql 1.1 Data Script 342923
DATA_ADM_SYSTEM_PARAM_CONFIG_343000.sql 1.1 Data Script 343000
DATA_DP_CSV_POD_342923.sql 1.1 Data Script 342923
DATA_IMP_DECODE_TYPE_342269.sql 1.1 Data Script 342269
DATA_IMP_FIELD_342918.sql 1.1 Data Script 342918
DATA_IMP_FIELD_343000.sql 1.1 Data Script 343000
DATA_ORS_MASTER_DATA_339733.sql 1.1 Data Script 339733
DATA_REP_REPORT_343508.sql 1.1 Data Script 343508
DATA_REP_REPORT_PARAM_343508.sql 1.1 Data Script 343508
DATA_RES_LABEL_FORMATS_343046.sql 1.1 Data Script 343046
DP_CARRIER.sql 1.55 Carrier Management 343046
DP_CSV_DHL.sql 1.16 Export Package 342920
DP_CSV_DHL.sql 1.17 Export Package 343752
DP_CSV_DHL.sql 1.18 Export Package 343945
DP_CSV_POD.sql 1.2 Database Package 342923
DP_CSV_POD.sql 1.3 Database Package 344097
DP_EPOD_WEB_SERVICE.sql 1.91 EPOD Web Service 342315
DP_EPOD_WEB_SERVICE.sql 1.93 EPOD Web Service 342263
DP_EPOD_WEB_SERVICE.sql 1.94 EPOD Web Service 343143
DP_EPOD_WEB_SERVICE.sql 1.96 EPOD Web Service 342265
DP_EPOD_WEB_SERVICE.sql 1.97 EPOD Web Service 343870
DP_IMP_2.sql 1.60 Import Package 342918
DP_IMP_2.sql 1.62 Import Package 342920
DP_IMP_2.sql 1.63 Import Package 343753
DP_IMP_2.sql 1.64 Import Package 343752
DP_LOGIX_DOM.sql 1.1 Logix Procedures 342195
DP_PULSE.sql 1.46 Pulse Interface Package 343393
DP_RDT_AUTO.sql 5.43 Client specific RDT funtions 343731
DP_REPORTS.sql 5.43 Reports package 339733
DP_SCHEDULING_ENGINE.sql 5.105 Scheduling Package 343121
DP_SCHEDULING_ENGINE.sql 5.106 Scheduling Package 343176
DP_SCHEDULING_ENGINE.sql 5.107 Scheduling Package 343233
DP_SCHEDULING_ENGINE.sql 5.108 Scheduling Package 343267
DP_SCHEDULING_ENGINE.sql 5.109 Scheduling Package 343046
DP_SCHEDULING_ENGINE.sql 5.110 Scheduling Package 343415
DP_SCHEDULING_ENGINE.sql 5.111 Scheduling Package 343000
DP_SCHEDULING_ENGINE.sql 5.112 Scheduling Package 344031
DP_SCHEDULING_ENGINE.sql 5.113 Scheduling Package 344016
EDI.sql 5.6 EDI package 339733
EDI_MAINT.fmx 10.13 EDI Maintenance Screen 339733
HAULIER_INVOICE.rep 2.15 Haulier Invoice Report 341505
IMP.sql 5.148 CSV Imports Package 343000
IMP.sql 5.149 CSV Imports Package 343376
IMP.sql 5.151 CSV Imports Package 343678
INT_XML_IN.sql 5.164 Order Import Package 343304
INT_XML_IN.sql 5.165 Order Import Package 342919
INT_XML_IN.sql 5.166 Order Import Package 341870
INT_XML_OUT2.sql 5.250 Outbound XML Package 342919
INT_XML_OUT2.sql 5.251 Outbound XML Package 342564
INT_XML_OUT2.sql 5.252 Outbound XML Package 343685
INT_XML_OUT2.sql 5.253 Outbound XML Package 341870
INV.sql 5.25 Invoice Package 343424
INVOICE_CUST_DUN.rep 1.19 Customer Invoice Report 342684
INVOICES.fmx 2.45 Invoices Screen 341505
LFS_LABEL.rep 1.19 Label Report 343046
LFS_LABEL_MULTI.rep 1.7 Label Report 343046
OMS.sql 5.185 Order package 342315
OMS.sql 5.186 Order package 342269
OMS.sql 5.187 Order package 342988
OMS.sql 5.188 Order package 343543
OMS.sql 5.189 Order package 343000
OMS.sql 5.190 Order package 343678
ORDERS.fmx 2.387 Order Screen 343595
ORDERS.fmx 2.388 Order Screen 342266
ORDERS_WIDE.fmx 1.1 Orders Screen 340076
ORDERS_WIDE.fmx 1.3 Orders Screen 342315
ORDERS_WIDE.fmx 1.5 Orders Screen 342263
ORDERS_WIDE.fmx 1.6 Orders Screen 343595
ORION.mmx 1.42 Orion Menu 340076
ORS.fmx 1.27 Oracle Reporting suite 343134
ORS.fmx 1.28 Oracle Reporting suite 339733
PAR.sql 5.80 Paragon Interface 343294
PAR.sql 5.81 Paragon Interface 343832
PLANNING.fmx 1.57 Planning Screen 342195
PLANNING.fmx 1.59 Planning Screen 342263
PORTAL_LABEL.rep 1.1 Generic Portal Label 343453
PORTAL_LABEL.rep 1.2 Generic Portal Label 343884
RESOURCE.fmx 2.179 Resource Maintenance form 342263
RESOURCE.fmx 2.180 Resource Maintenance form 342920
SCHED_RULES.fmx 1.32 Scheduling Screen 343000
SCHED_RULES.fmx 1.33 Scheduling Screen 343678
SUPPLIER_INVOICE.rep 2.19 Supplier Invoice Report 341505
TRG_SCH_ORD_ITEMS_DIMEN.sql 5.4 Order Items Table Trigger 342315
TRG_SCH_ORD_ITEMS_REASONS.sql 5.13 Trigger 342919
TRG_SCH_ORD_LATE_REASON.sql 5.8 Trigger 342919
TRG_SCH_ORD_LOTS.sql 5.11 Trigger 342919
TRG_SCH_ORD_LOTS.sql 5.12 Trigger 342954
TRG_SCH_ORD_NON_CONF_XML_INT.sql 5.11 Trigger 342919
TRG_SCH_ORD_TO_LOTS.sql 5.5 Trigger 342919
TRG_SCH_TRIP_XML_INT.sql 5.30 Trigger 342919
TRG_SHA_LOTS.sql 5.5 Trigger 342919
TRG_SOL_XML.sql 5.40 Trigger 342919
TRG_SOL_XML.sql 5.42 Trigger 342923
TRG_STS_XML.sql 5.21 Trigger 342919
TRG_STS_XML_OUT.sql 5.35 Trip Stop Trigger 342919
TRM.sql 5.158 Trip manipulation package 342263
TRM.sql 5.159 Trip manipulation package 343567


ADDITIONAL CHANGES

WCS

There are no WCS changes required.


EPOD/T2A

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

  • 342265


MCS

There are no MCS changes required.


PORTAL/TTM

There are no Portal changes required.


EDI

An EDI change is required for the following logs:

  • 342923


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