PATCH C-TMS 11.0 P025: Difference between revisions

From Calidus HUB
VisualWikitext
No edit summary
No edit summary
Line 92: Line 92:
|'''Summary of Call'''|| Invoice amendments
|'''Summary of Call'''|| Invoice amendments
|-
|-
|'''Detail of Change/Fix''' || BWSC Invoice Amendments
|'''Detail of Change/Fix''' || Invoice Amendments
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 106: Line 106:
|'''Summary of Call'''|| Stairwalker required on orders
|'''Summary of Call'''|| Stairwalker required on orders
|-
|-
|'''Detail of Change/Fix''' || functionality to allow stairwalkers to be requested and applied to trips
|'''Detail of Change/Fix''' || Functionality to allow Stairwalkers to be requested and applied to trips
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 132: Line 132:
|'''Reporter: ''' || Colin Lowe
|'''Reporter: ''' || Colin Lowe
|-
|-
|'''Summary of Call'''|| Customer standard Instructions
|'''Summary of Call'''|| Customer standard instructions
|-
|-
|'''Detail of Change/Fix''' || Default special instructions from a new customer level standard insructions on new orders.
|'''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
|'''Set-up and Configuration''' || No set-up/configuration required
Line 160: Line 160:
|'''Reporter: ''' || Emlyn Phipps
|'''Reporter: ''' || Emlyn Phipps
|-
|-
|'''Summary of Call'''|| RIO:Messages from CTMS to PRL
|'''Summary of Call'''|| RIO: Messages from CTMS to PRL
|-
|-
|'''Detail of Change/Fix''' || Allow PRL to recieve and send xml messages to C-TMS
|'''Detail of Change/Fix''' || Allow PRL to receive and send XML messages to C-TMS
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 174: Line 174:
|'''Reporter: ''' || Denis Starodubov
|'''Reporter: ''' || Denis Starodubov
|-
|-
|'''Summary of Call'''|| RIO:Suppress CTMS resource on LOAD msg
|'''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
|'''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
|'''Set-up and Configuration''' || No set-up/configuration required
Line 190: Line 190:
|'''Summary of Call'''|| SCR-01 Import Upload of CSV from OTM
|'''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 accomodate the new OTM requirements.
|'''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
|'''Set-up and Configuration''' || No set-up/configuration required
Line 230: Line 230:
|'''Reporter: ''' || Hiren Patel
|'''Reporter: ''' || Hiren Patel
|-
|-
|'''Summary of Call'''|| RIO:Celesio Require POD Information
|'''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.
|'''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 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.  
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:   
The EDI process will use the following report values:   


1.                                                     
1.                                                     
Title: Process Name
Title: Process Name
Name: P_PROCESS_NAME
Name: P_PROCESS_NAME
Value: POD_INFO
Value: POD_INFO


2.
2.
Title: Package Name
Title: Package Name
Name: PROCESS
Name: PROCESS
Value: DP_CSV_POD.P_PROCESS_CSV_POD
Value: DP_CSV_POD.P_PROCESS_CSV_POD


Line 261: Line 269:
|'''Reporter: ''' || Sarah Howells
|'''Reporter: ''' || Sarah Howells
|-
|-
|'''Summary of Call'''|| RIO:LRS Order Cancellation Update
|'''Summary of Call'''|| RIO: LRS Order Cancellation Update
|-
|-
|'''Detail of Change/Fix''' || Send CAN message when booking ref not populated
|'''Detail of Change/Fix''' || Send CAN message when booking ref not populated

Revision as of 15:50, 6 July 2017





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:

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


TID CHANGES

OBS Log Number:

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


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