PATCH C-TMS P035: Difference between revisions

From Calidus HUB
VisualWikitext
No edit summary
No edit summary
Line 1,050: Line 1,050:
!Module Name !! Version No !! Description !! Log Number
!Module Name !! Version No !! Description !! Log Number
|-
|-
| || || ||  
| ACC.sql || 5.77 || Accounts package || 360756
|-
| ACC.sql || 5.79 || Accounts package || 362440
|-
| AT_GEO_LOCATION_359667.sql || 1.1 || AT Script || 359667
|-
| AT_ORG_CUSTOMER_359664.sql || 1.1 || AT Script || 359660
|-
| AT_RES_CARRIER_359664.sql || 1.1 || AT Script || 359664
|-
| AT_RTE_ROUTE_359664.sql || 1.1 || AT Script || 359660
|-
| AT_SCH_ORD_359252.sql || 1.1 || AT Script || 359252
|-
| AT_SCH_ORD_359664.sql || 1.2 || AT Script || 359664
|-
| AT_SCH_SHIP_PALL_359661.sql || 1.1 || AT Script || 359661
|-
| CARRIER_MANIFEST_DHLEXP.rep || 1.17 || Carrier Manifest || 352903
|-
| CARRIER_MANIFEST_UKMAIL.rep || 1.5 || Carrier Manifest || 352903
|-
| CARRIER_MANIFEST_YODEL.rep || 1.12 || Carrier Manifest Report || 352903
|-
| CNT.sql || 5.52 || Contracts package || 362723
|-
| CNT.sql || 5.53 || Contracts package || 363082
|-
| CSV.sql || 5.113 || CSV extract package || 359252
|-
| CSV.sql || 5.114 || CSV extract package || 359664
|-
| CSV.sql || 5.115 || CSV extract package || 362508
|-
| CSV.sql || 5.116 || CSV extract package || 364523
|-
| CSV.sql || 5.117 || CSV extract package || 364556
|-
| CT_T_PALLET_LIST_359671.sql || 1.1 || CT Script || 359671
|-
| CUST_COST.fmx || 2.133 || Customer Maintenance form || 359664
|-
| DATA_1_REP_PARAM_TYPE_358425.sql || 1.1 || Data Script || 358425
|-
| DATA_2_REP_REPORT_358425.sql || 1.1 || Data Script || 358425
|-
| DATA_3_REP_REPORT_PARAM_358425.sql || 1.1 || Data Script || 358425
|-
| DATA_4_REP_PARAM_VALUE_358425.sql || 1.1 || Data Script || 358425
|-
| DATA_ADM_FORM_TAB_359667.sql || 1.1 || Data Script || 359667
|-
| DATA_ADM_SYSTEM_PARAM_358506.sql || 1.1 || Data Script || 358506
|-
| DATA_ADM_SYSTEM_PARAM_359252.sql || 1.1 || Data Script || 359252
|-
| DATA_ADM_SYSTEM_PARAM_359656.sql || 1.1 || Data Script || 359656
|-
| DATA_ADM_SYSTEM_PARAM_359664.sql || 1.1 || Data Script || 359664
|-
| DATA_ADM_SYSTEM_PARAM_359667.sql || 1.4 || Data Script || 359667
|-
| DATA_ADM_SYSTEM_PARAM_362508.sql || 1.3 || Data Script || 362508
|-
| DATA_ADM_SYSTEM_PARAM_363082.sql || 1.2 || Data Script || 363082
|-
| DATA_ADM_SYSTEM_PARAM_363499.sql || 1.1 || Data Script || 363499
|-
| DATA_ADM_SYSTEM_PARAM_363855.sql || 1.1 || Data Script || 363855
|-
| DATA_ADM_SYSTEM_PARAM_CONFIG_358506.sql || 1.1 || Data Script || 358506
|-
| DATA_ADM_SYSTEM_PARAM_CONFIG_359252.sql || 1.1 || Data Script || 359252
|-
| DATA_ADM_SYSTEM_PARAM_CONFIG_359656.sql || 1.2 || Data Script || 359656
|-
| DATA_ADM_SYSTEM_PARAM_CONFIG_359664.sql || 1.1 || Data Script || 359664
|-
| DATA_ADM_SYSTEM_PARAM_CONFIG_362508.sql || 1.3 || Data Script || 362508
|-
| DATA_ADM_SYSTEM_PARAM_CONFIG_363082.sql || 1.1 || Data Script || 363082
|-
| DATA_AUTO_SCHEDULING_ENGINE_359664.sql || 1.1 || Data Script || 359664
|-
| DATA_IMP_DECODE_359667.sql || 1.1 || Data Script || 359667
|-
| DATA_IMP_DECODE_ENTRY_359667.sql || 1.1 || Data Script || 359667
|-
| DATA_ORS_MASTER_DATA_359779.sql || 1.1 || Data Script || 359779
|-
| DATA_ORS_MASTER_DATA_361243.sql || 1.1 || Data Script || 361243
|-
| DATA_ORS_SQL_359779.sql || 1.1 || Data Script || 359779
|-
| DATA_ORS_SQL_361243.sql || 1.1 || Data Script || 361243
|-
| DATA_REP_REPORT_PARAM_362667.sql || 1.1 || Data Script || 362667
|-
| DATA_RES_CARRIER_FORMATS_359661.sql || 1.1 || Data Script || 359661
|-
| DATA_RES_CARRIER_FORMATS_MAP_359661.sql || 1.1 || Data Script || 359661
|-
| DATA_RES_LABEL_FORMATS_359661.sql || 1.1 || Data Script || 359661
|-
| DATA_RES_LABEL_FORMATS_362811.sql || 1.1 || Data Script || 362811
|-
| DP_CARRIER.sql || 1.84 || Carrier Management || 359661
|-
| DP_CARRIER.sql || 1.86 || Carrier Management || 362625
|-
| DP_CARRIER.sql || 1.87 || Carrier Management || 359663
|-
| DP_CARRIER.sql || 1.88 || Carrier Management || 363681
|-
| DP_CARRIER.sql || 1.89 || Carrier Management || 362811
|-
| DP_CSV_DUN.sql || 5.48 || Client specific CSV extracts || 358425
|-
| DP_CSV_DUN.sql || 5.49 || Client specific CSV extracts || 364431
|-
| DP_CSV_DUN.sql || 5.50 || Client specific CSV extracts || 364473
|-
| DP_EPOD_WEB_SERVICE.sql || 1.122 || EPOD Web Service || 359518
|-
| DP_EPOD_WEB_SERVICE.sql || 1.124 || EPOD Web Service || 361188
|-
| DP_IMP.sql || 5.38 || Imports Package || 363681
|-
| DP_MCS_SCANNING.sql || 5.42 || MCS Scanning Package || 359670
|-
| DP_MCS_SCANNING.sql || 5.43 || MCS Scanning Package || 359661
|-
| DP_MCS_SCANNING.sql || 5.44 || MCS Scanning Package || 359674
|-
| DP_MCS_SCANNING.sql || 5.45 || MCS Scanning Package || 359663
|-
| DP_MCS_SCANNING.sql || 5.48 || MCS Scanning Package || 359671
|-
| DP_RDT_FAST_UNLOAD.sql || 5.44 || RF Unload Package || 362828
|-
| DP_SCHEDULING_ENGINE.sql || 5.150 || Scheduling Package || 359457
|-
| DP_SCHEDULING_ENGINE.sql || 5.153 || Scheduling Package || 359664
|-
| DP_SCHEDULING_ENGINE.sql || 5.155 || Scheduling Package || 363499
|-
| DP_SCHEDULING_ENGINE.sql || 5.156 || Scheduling Package || 363801
|-
| DP_SHIPMENT.sql || 5.19 || Shipment Code package || 360403
|-
| DP_SHIPMENT.sql || 5.21 || Shipment Code package || 362440
|-
| DP_SHIPMENT.sql || 5.22 || Shipment Code package || 363082
|-
| DP_WEB_SERVICE_ORD.sql || 1.22 || Web Service Package || 359252
|-
| DP_WEB_SERVICE_ORD.sql || 1.23 || Web Service Package || 358506
|-
| DP_WEB_SERVICE_ORD.sql || 1.25 || Web Service Package || 359601
|-
| DUNELM_VEHICLE_DESPATCH.rep || 1.6 || Vehicle Despatch report || 362667
|-
| EXPORTS.fmx || 2.36 || Exports screen || 358425
|-
| HC_SHUNT_SHEET.rep || 1.5 || HC Shunt Sheet Report || 359668
|-
| HC_TRIP_SHEET.rep || 1.13 || HC Trip Sheet Report || 359668
|-
| HCR_LOADING_SHEET.rep || 1.4 || Customer Loading Sheet || 359668
|-
| IMP.sql || 5.194 || CSV Imports Package || 360150
|-
| INT_XML_MIC.sql || 5.145 || MIC interface || 359656
|-
| INT_XML_MIC.sql || 5.146 || MIC interface || 363855
|-
| INT_XML_OUT2.sql || 5.292 || Outbound XML Package || 360459
|-
| INT_XML_OUT2.sql || 5.293 || Outbound XML Package || 359518
|-
| INT_XML_OUT2.sql || 5.294 || Outbound XML Package || 359660
|-
| INT_XML_OUT2.sql || 5.295 || Outbound XML Package || 358670
|-
| INT_XML_OUT2.sql || 5.296 || Outbound XML Package || 362508
|-
| INT_XML_OUT2.sql || 5.297 || Outbound XML Package || 362482
|-
| INT_XML_OUT2.sql || 5.298 || Outbound XML Package || 363421
|-
| INT_XML_OUT2.sql || 5.299 || Outbound XML Package || 363855
|-
| INV.sql || 5.44 || Invoice Package || 360403
|-
| INV.sql || 5.45 || Invoice Package || 363974
|-
| INV.sql || 5.46 || Invoice Package || 363185
|-
| INVOICES.fmx || 2.61 || Invoices Screen || 363185
|-
| LOCATION.fmx || 2.191 || Location Maintenance || 359667
|-
| OF_INT.sql || 5.52 || Oracle Financials interface || 360756
|-
| OF_INT.sql || 5.54 || Oracle Financials interface || 362440
|-
| OF_INT.sql || 5.55 || Oracle Financials interface || 363373
|-
| OF_INT.sql || 5.56 || Oracle Financials interface || 364191
|-
| OF_INT.sql || 5.57 || Oracle Financials interface || 364696
|-
| OF_INT.sql || 5.58 || Oracle Financials interface || 365003
|-
| OMS.sql || 5.223 || Order package || 359664
|-
| OMS.sql || 5.224 || Order package || 359663
|-
| OMS.sql || 5.225 || Order package || 363801
|-
| OMS.sql || 5.226 || Order package || 363082
|-
| OMS.sql || 5.227 || Order package || 365051
|-
| ORDERS.fmx || 2.422 || Order Screen || 361329
|-
| ORDERS.fmx || 2.423 || Order Screen || 359664
|-
| ORDERS.fmx || 2.426 || Order Screen || 359663
|-
| ORDERS_WIDE.fmx || 1.24 || Orders Screen || 359664
|-
| ORDERS_WIDE.fmx || 1.25 || Orders Screen || 359663
|-
| PAR.sql || 5.105 || Paragon Interface || 359664
|-
| PAR.sql || 5.106 || Paragon Interface || 364910
|-
| PAR_INT.fmx || 10.40 || Paragon Interface form || 364523
|-
| PL_VERSION.sql || 4.1 || Version, Date and Author Package || 361652
|-
| PLANNING.fmx || 1.108 || Planning Screen || 359621
|-
| RATE.sql || 5.154 || Rates Tariff database package || 360756
|-
| RATE.sql || 5.155 || Rates Tariff database package || 361291
|-
| RATE.sql || 5.156 || Rates Tariff database package || 364191
|-
| REPORTS.fmx || 2.35 || Reports Screen || 358425
|-
| RESOURCE.fmx || 2.193 || Resource Maintenance form || 359664
|-
| ROUTES_MAINT.fmx || 2.49 || Fixed Routes Maintenance || 359664
|-
| SHIPMENT_INVOICE.rep || 1.3 || Shipment Invoice Report || 361291
|-
| SHIPMENT_PALLETS.fmx || 5.3 || Shipment Pallets Form || 359661
|-
| SHIPMENT_PALLETS.fmx || 5.4 || Shipment Pallets Form || 359663
|-
| SHIPMENT_PALLETS.fmx || 5.5 || Shipment Pallets Form || 359671
|-
| T_SCH_ORD_PNL.sql || 5.15 || Trigger || 360756
|-
| TIU_TRIP_STATUS.sql || 5.54 || Trigger on SCH_TRIP for status change || 359660
|-
| TRG_MCS_REQUEST_BU.sql || 1.3 || Trigger || 359670
|-
| TRG_SCH_ORD_XML_INT.sql || 5.18 || Trigger || 358670
|-
| TRG_SHA_XML_OUT.sql || 1.15 || Haulage Activity Trigger || 359660
|-
| TRIPDTL.fmx || 2.225 || Trip Debrief || 359621
|-
| TRM.sql || 5.191 || Trip manipulation package || 360756
|-
| TRM.sql || 5.193 || Trip manipulation package || 362440
|-
| TRM.sql || 5.194 || Trip manipulation package || 359663
|-
| TRM.sql || 5.195 || Trip manipulation package || 363082
|-
| USER_CONTEXT_PKG.sql || 5.3 || User Context Database Package || 359601
|-
| USER_CONTEXT_PKG.sql || 5.4 || User Context Database Package || 365051
|-
| V_MCS_MENU_ITEM.sql || 1.1 || View || 359670
|-
| V_MCS_MENU_ITEM.sql || 1.2 || View || 359671
|-
| V_MCS_PALLET.sql || 1.1 || View || 359671
|-
| V_MCS_SITE.sql || 1.2 || View || 359670
|-
| V_MCS_SITE.sql || 1.3 || View || 362654
|-
| V_MCS_SYSTEM_STATUS.sql || 1.1 || View || 359670
|-
| V_MCS_TRIP_ITEM.sql || 1.14 || Trip Items View || 359674
|}
|}


Line 1,091: Line 1,391:


An EDI change is required for the following logs:  
An EDI change is required for the following logs:  
* Log
OR


There are no EDI changes required.
* 358670 - A new version 2.43 of TripOrder.xsd will need to be installed for the EDI files for messages for the new ConnectedView interface.




</div>
</div>
[[Category:{{#var:Client}} PATCH]]
[[Category:{{#var:Client}} PATCH]]

Revision as of 16:44, 14 November 2019





Aptean Logo.png







OBS Logistics Ltd

Release Notes

CALIDUS TMS

12th Nov 2019 - 1.0
Reference: P035











































SUMMARY INTRODUCTION

INTRODUCTION

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


GLOSSARY OF TERMS

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


TESTING PROCESS

TIDs AND RESOLUTION

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


FINAL 'END TO END' TESTING

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


AUTHORISATION

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


CHANGE REQUESTS

Customer Ref: Actuals

OBS Log Number: 359621
Summary of Call Ensure all actuals are debriefed
Detail of Fix Ensure all actual weights and volumes are populated before a trip can be set to COMPLETED
Set-up and Configuration No set-up/configuration required


Customer Ref: Despatch

OBS Log Number: 362667
Summary of Call Vehicle Despatch Report
Detail of Fix Add depot to parameters
Set-up and Configuration No set-up/configuration required


Customer Ref: WREQ0030580

OBS Log Number: 358425
Summary of Call GSN: Create a new report
Detail of Fix The new export Inventory Transactions will need authorisation for the appropriate user groups.
Set-up and Configuration No set-up/configuration required


Customer Ref: WREQ0030824

OBS Log Number: 358506
Summary of Call GSN: Modify ASN interface
Detail of Fix Override collection location on ASN1 dependant on new WS_COLLECT_LOCATION parameter and partnership setting for store.
Set-up and Configuration
Registry/Rules Settings
Path & Name Setting Value Result
WS_COLLECT_LOCATION 9576 Collection location to override the supplier partnership at customer level


Customer Ref: WREQ0031943

OBS Log Number: 358670
Summary of Call HAM - Connected View Interfaces
Detail of Fix


New version 2.43 of TripOrder.xsd will need to be installed by for the EDI files for interfacing with ConnectedView.


The EDI processes for ConnectedView should exist with triggers, parameters and report processes without a location or a customer but for a cost centre.

ORD:

Flow Type: ORD_XML_OUT

Trigger STATUS: UNSCHEDULED

Parameters:

ALLOW_MULTI_CUSTOMER = Y

INCLUDE_ORDER_STATUS = Y

SEND_HEADER_UPDATES = Y

SEND_LINE_ITEMS = Y


The order message will be sent for the despatching source depot for the creation and amendment of the orders at the depot.

PACK:

Flow Type: ORD_XML_OUT

Parameters:

PACK_EVENT = Y

SEND_LINE_ITEMS = Y


The pack message will be sent for the despatching source depot for the packing of the orders at the depot.

POCPOD:

Flow Type: TRIP_XML

Parameters:

ALLOW_MULTI_CUSTOMER = Y

INCLUDE_ITEM_DELIVER = Y

INCLUDE_NONCON_CODES = Y

INCLUDE_REASON_CODES = Y

INCLUDE_REASON_TYPE = Y

INCLUDE_SIGNATURE = Y

PODS_POCS = Y

SEND_LINE_ITEMS = Y


The POC messages will be sent for the loading at the source location for the collection orders.

The POD messages will be sent for the unloading at the delivery location for the delivery orders.

This trip may be for a depot that may be an outbase for the van fleet.

The EDI processes also should exist for the LOAD, CITD and electronic manifest messages.

The load message will be sent for the despatching source depot.

The CITD message will be sent for the despatching source depot.

An electronic manifest message will be sent for the despatching delivery depot for the parcel carrier.

This depot may be an outbase for the van fleet.

These EDI parameters can be configured to match the mapping of the files by any external processing for transfer to the source systems for the orders and carriers.

New version 2.43 of TripOrder.xsd will be required for the messages for ConnectedView to be mapped.

This version contains the ORDER_STATUS element at the end of the ORDER_HEADER segment.


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


Customer Ref: WREQ0031664

OBS Log Number: 359252
Summary of Call GSN: Retain FORECAST Value from ASN2
Detail of Fix Set new forecast figures on ASN1 only and send to paragon in preference to planned.
Set-up and Configuration
Registry/Rules Settings
Path & Name Setting Value Result
PAR_EXPORT_FORECAST Y Send forecast rather than actual values to paragon


Customer Ref: WREQ0031943

OBS Log Number: 359656
Summary of Call HAM - Microlise Interface
Detail of Fix Changes to the Microlise interface
Set-up and Configuration No set-up/configuration required


Customer Ref: WREQ0031943

OBS Log Number: 359660
Summary of Call HAM - Changes to WMS Despatch (CITD)
Detail of Fix The EDI processes for LOAD and CITD messages will need to have a new EDI parameter called OUTBASE_INDICATOR set to Y to enable the new functionality.

When the parameter is Y, the LOAD and CITD messages will be split by outbase for the same TMS trip to create separate WMS loads based on the outbase indicator.

Note that any orders that are not going to an outbase for a customer that is using the van fleet will not be included in a file for the outbase and these orders will be included in a file for the TMS trip itself without an outbase indicator.

The customers and fixed routes will need to have the new 'Van Fleet' flag set to Y to enable the new functionality.

The outbases will be identified as RDC locations that exist with an 'OUTBASE_INDICATOR' decoded value for 'REFERENCE'.

This outbase indicator will be a single character to be included in the TMS trip to replace the first digit of the trip number (e.g. MAN-A0123456 instead of MAN-00123456).

This decoded value must exist to enable the new functionality.

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


Customer Ref: WREQ0031943

OBS Log Number: 359661
Summary of Call HAM - Item & Master Pallet Labels
Detail of Fix The new package label format will be available for configuration

The new pallet label format will be available for configuration.

The pallet label printing will be to a laser printer for a PDF document or to a label printer for a Zebra label format.

The new MCS_PALLET_LABEL_FORMAT system parameter will be used to store the Zebra pallet label format.

If this system parameter is not specified, the existing PDF pallet label format will be used.

The supporting information of the new package label will need to be implemented for the carrier tracking and routing.

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


Customer Ref: WREQ0031943

OBS Log Number: 359663
Summary of Call HAM - Create Items when order packed
Detail of Fix Order items will be created for the tracking references when the carrier labels are printed for the van fleet routes.

These order items will be made available as trip items for scanning using MCS in the active depots.

The deletion of tracking references will delete the corresponding order items when the order is unpacked, repacked or unscheduled without retaining pack data.

The corresponding trip items will also be deleted when the order items are deleted.

Any trip items that have been palletised or added to AWB/Consignments in the depots will be removed from the pallets and AWB/Consignments.

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


Customer Ref: WREQ0031943

OBS Log Number: 359664
Summary of Call HAM - Scheduling Engine
Detail of Fix Changes to the Scheduling Engine and Paragon
Set-up and Configuration No set-up/configuration required

Customer Ref: WREQ0031943

OBS Log Number: 359667
Summary of Call HAM - MCS Control Parameters
Detail of Fix Changed the location screen to display the mcs parameters in a new tab.
Set-up and Configuration No set-up/configuration required


Customer Ref: WREQ0031943

OBS Log Number: 359668
Summary of Call HAM - Trip Barcode on Reports
Detail of Fix The HC Shunt Sheet, HC Trip Sheet and HCR Loading Sheet reports will include a barcode for the TRIP ID in format 39 for scanning using MCS.
Set-up and Configuration No set-up/configuration required


Customer Ref: WREQ0031943

OBS Log Number: 359670
Summary of Call HAM - MCS General Changes
Detail of Fix Read system params into MCS and hide AWB number.
Set-up and Configuration No set-up/configuration required


Customer Ref: WREQ0031943

OBS Log Number: 359671
Summary of Call HAM - MCS Project specific changes
Detail of Fix Pallet Building and Pallet Closure changes.
Set-up and Configuration No set-up/configuration required


Customer Ref: WREQ0031943

OBS Log Number: 359674
Summary of Call HAM - MCS Trans-Ship
Detail of Fix Added Trans Ship functionality for MCS.
Set-up and Configuration No set-up/configuration required


Customer Ref: WREQ0031943

OBS Log Number: 362625
Summary of Call HAM - Item & Master Pallet Label 2
Detail of Fix Amended the reprinting of the label format.

The Service Type will display the carrier service level or the order service level to ensure that a service is displayed depending on the type of routing that has been performed to schedule the order.

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


Customer Ref: Inventory Transactions

OBS Log Number: 364431
Summary of Call Inventory Transactions Store Scan Change
Detail of Fix The StoreScan section included extra columns as per the other scan sections. The depot and user columns have been removed from the extract.
Set-up and Configuration No set-up/configuration required


Customer Ref: PO 44010884813

OBS Log Number: 362811
Summary of Call Webservice Label Change
Detail of Fix Changes to Labels
Set-up and Configuration No set-up/configuration required



SUPPORT INCIDENTS

Customer Ref: 360403

OBS Log Number: 360403
Summary of Call VDA4933 and VDA4933 additional matches
Detail of Fix When a 4987 matches to more than one 4933 on the same delivery stop, replace the orders on the trip
Set-up and Configuration No set-up/configuration required


Customer Ref: LOTS

OBS Log Number: 360459
Summary of Call Send address to LOTS in ORD event
Detail of Fix Change to allow address details and contacts to be sent to LOTS
Set-up and Configuration No set-up/configuration required


Customer Ref: Reason Code

OBS Log Number: 361188
Summary of Call Cancelled Item - Reason Code
Detail of Fix Only create SD reason codes for all items on an order when no items sent and none returned.
Set-up and Configuration No set-up/configuration required


Customer Ref: Encrypted sources

OBS Log Number: 361652
Summary of Call Release PL_VERSION
Detail of Fix Release package to assist with version control checks.
Set-up and Configuration No set-up/configuration required


Customer Ref: 362482

OBS Log Number: 362482
Summary of Call Email Information - populated fields
Detail of Fix Amendment to XML outbound generation so contact details not based on comments being null but on email address being populated.
Set-up and Configuration No set-up/configuration required


Customer Ref: Performance Improvements

OBS Log Number: 362723
Summary of Call Performance Improvements
Detail of Fix Reduced the number of times that the standard journeys are assessed for the 'from' location of the orders when calculating payments.
Set-up and Configuration No set-up/configuration required


Customer Ref: Invoice Format

OBS Log Number: 363373
Summary of Call Incorrect Invoice format
Detail of Fix Changes to the BL numbers and the frequency reported- no longer at order level but at gate level within the shipment and invoice
Set-up and Configuration No set-up/configuration required


Customer Ref: INC30189216

OBS Log Number: 363421
Summary of Call File has order header but no details
Detail of Fix When determining if an order is to be included in Zetes file extend test for 'SL' reason code items to exclude the 'X' items that have been split off
Set-up and Configuration No set-up/configuration required


Customer Ref: INC30418115

OBS Log Number: 364473
Summary of Call Report showing wrong data
Detail of Fix Amendment to ITEM_MOVEMENTS_EXTRACT_2 to correct to population of POD confirmed date (column T) on so uses scan date
Set-up and Configuration No set-up/configuration required


Customer Ref: Decode Amendment

OBS Log Number: 364696
Summary of Call Change decode names
Detail of Fix Amendment to shipment extract to use Parts decode where appropriate
Set-up and Configuration No set-up/configuration required


Customer Ref: Scheduling Engine

OBS Log Number: 359457
Summary of Call Scheduling Engine Single Network
Detail of Fix Ensure when roll back performed inside of loop that it is not then also performed outside of the loop.
Set-up and Configuration No set-up/configuration required


Customer Ref: Portal

OBS Log Number: 359518
Summary of Call Portal not reporting shortages
Detail of Fix Changed EPOD interface to ensure quantity set before reason added and also ensure order details sent to LOTS on delivery message.
Set-up and Configuration No set-up/configuration required


Customer Ref: Empties Changes

OBS Log Number: 362440
Summary of Call Rqmts change for Credit acc on empties
Detail of Fix Changes to the finance functionality based on the Empties not providing the references we expected
Set-up and Configuration No set-up/configuration required


Customer Ref: Split Order scanning

OBS Log Number: 362828
Summary of Call Split order scanning delivery trips
Detail of Fix Change to split scanning, to prevent orders being planned on empty stops
Set-up and Configuration No set-up/configuration required


Customer Ref: Support

OBS Log Number: 364191
Summary of Call Debrief issue
Detail of Fix Changes to the shipment extract and removal of validate order when rating a completed trip
Set-up and Configuration No set-up/configuration required


Customer Ref: Trunk Scripts Main

OBS Log Number: 364910
Summary of Call Trunk Scripts added into main stream
Detail of Fix Trunk scripts for Paragon added into main code stream
Set-up and Configuration No set-up/configuration required


Customer Ref: Collection dates/times

OBS Log Number: 365051
Summary of Call Validate order collection dates/times
Detail of Fix The just in time orders will only have their collection date/time windows assessed when the order status is INVALID, VALID or UNSCHEDULED.

A user context will be set when validating the just in time orders for the cost centre of the order unless the calling process has already done so (e.g. Paragon planning).

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


Customer Ref: Packaging and Service

OBS Log Number: 359779
Summary of Call Current packaging and Service charge ext
Detail of Fix Report type OWN_CHRGS already in Oracle reporting suite for the packaging charges. Options added to ORS for

1) Service Capture (SRVCS_CAPT)

2) Services including sliding charges (ACC_SRVCS)

3) Accounts (ACC_ACCOUNT).

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


Customer Ref: 361243

OBS Log Number: 361243
Summary of Call Export the cost per route
Detail of Fix Add the fields for business data 'Fixed costs by route' to extract suite under type RTE_COSTS.
Set-up and Configuration No set-up/configuration required



TID CHANGES

OBS Log Number: 361291

Customer Ref: Invoice Formats
Summary of Call Amend Invoice report and extract
Detail of Fix Changes to the invoice report to include invoice number and Rating to update the order revenue total
Set-up and Configuration No set-up/configuration required


OBS Log Number: 362508

Customer Ref: INC29954448 - Main
Summary of Call Interface from CTMS to ZETES are failing
Detail of Fix Fixes for OUT2 and CSV. You will need to switch on 'SEND_PALLET_ID_XML' paramater if required in XML.
Set-up and Configuration
Registry/Rules Settings
Path & Name Setting Value Result
SEND_PALLET_ID_XML 'N' Send the pallet ID tag in the XML flows


OBS Log Number: 365003

Customer Ref: Remove sum from sql
Summary of Call Remove sum
Detail of Fix Amend the shipment cursor to remove Sum from invoice amount
Set-up and Configuration No set-up/configuration required


OBS Log Number: 360756

Customer Ref: Invoicing
Summary of Call Testing - Invoicing
Detail of Fix Changes to the outbound Interface file format.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 352903

Customer Ref: No Ref
Summary of Call Carrier manifest reports
Detail of Fix Added new parameter into Function call on reports to allow reports to run
Set-up and Configuration No set-up/configuration required


OBS Log Number: 360150

Customer Ref: No Ref
Summary of Call Paragon Import fails
Detail of Fix Fix issue with trunk flag on directs from paragon.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 361329

Customer Ref: P34 - 1.3 & 5.5
Summary of Call Patch Test - P34 - Manual Orders
Detail of Fix Ensure line data block cleared based on correct product type.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 363499

Customer Ref: Validate order sched
Summary of Call Validate order before scheduling van
Detail of Fix Include a validate order at the start of the scheduling engine for van fleet
Set-up and Configuration No set-up/configuration required


OBS Log Number: 363681

Customer Ref: No Ref
Summary of Call Orders not being packed via CIPD in CTMS
Detail of Fix The trip for the delivery of the order will be found for the printing of the carrier labels via CIPD files.

Any shunt and trunk trips will not be used to assess the label format for the carrier.

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


OBS Log Number: 363801

Customer Ref: Just In Time Orders
Summary of Call Just In Time orders set available date
Detail of Fix Changes to prevent available date from being set until the order has been validated
Set-up and Configuration No set-up/configuration required


OBS Log Number: 363855

Customer Ref: EDI Amendments
Summary of Call HAM - Amendments to EDI files for CV
Detail of Fix 1. The EVENT_TYPE for trip files will be TRP unless the file is for POC or POD for Connected View interfaces. Then the event type will be POC or POD as required.

2. Microlise - New system Parameter MIC_SHIPMENT_SO_REF to control if the external_ref is included in the shipment details tag

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


OBS Log Number: 363974

Customer Ref: Invoicing
Summary of Call Main release of branch 362111
Detail of Fix Changes to Invoicing to select customers who have outstanding payments
Set-up and Configuration No set-up/configuration required


OBS Log Number: 364523

Customer Ref: Paragon
Summary of Call HAM - Filters on Paragon Export
Detail of Fix Changes to the Paragon expotrt to segregate Van fleet from other fleets
Set-up and Configuration No set-up/configuration required


OBS Log Number: 364556

Customer Ref: Paragon
Summary of Call HAM - Fix to NEW trips from Paragon expt
Detail of Fix Changes to the export code to update NEW trips
Set-up and Configuration No set-up/configuration required



OBSL PRODUCT DEVELOPMENT

OBS Log Number: 363082

Summary of Call Performance improvements to finance
Detail of Fix Improvements to performance times based on 2 new parameters ACC_SUPPRESS_RATING and ACC_KNOWN_ZONE
Set-up and Configuration
Registry/Rules Settings
Path & Name Setting Value Result
ACC_SUPRESS_RATING Y Stops orders from rating
ACC_KNOWN_ZONE Y Pass in a zone format COUNTRY CODE and POSTAL REGION


OBS Log Number: 363185

Summary of Call Incompatibility with invoice and Reports
Detail of Fix Amended parameter to display shipment file
Set-up and Configuration No set-up/configuration required


OBS Log Number: 359601

Summary of Call Context for PARINT / webservices 359072
Detail of Fix New clear context to be called at start of web service just in case a previous call has set a context in the session that is not applicable to the new order.

Session remains after web service call end and is re-connected too by later web service calls.

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


OBS Log Number: 362654

Summary of Call Fix MCS Site view
Detail of Fix Fix to mcs sites scipt.
Set-up and Configuration No set-up/configuration required



MODULES DELIVERED

Module Name Version No Description Log Number
ACC.sql 5.77 Accounts package 360756
ACC.sql 5.79 Accounts package 362440
AT_GEO_LOCATION_359667.sql 1.1 AT Script 359667
AT_ORG_CUSTOMER_359664.sql 1.1 AT Script 359660
AT_RES_CARRIER_359664.sql 1.1 AT Script 359664
AT_RTE_ROUTE_359664.sql 1.1 AT Script 359660
AT_SCH_ORD_359252.sql 1.1 AT Script 359252
AT_SCH_ORD_359664.sql 1.2 AT Script 359664
AT_SCH_SHIP_PALL_359661.sql 1.1 AT Script 359661
CARRIER_MANIFEST_DHLEXP.rep 1.17 Carrier Manifest 352903
CARRIER_MANIFEST_UKMAIL.rep 1.5 Carrier Manifest 352903
CARRIER_MANIFEST_YODEL.rep 1.12 Carrier Manifest Report 352903
CNT.sql 5.52 Contracts package 362723
CNT.sql 5.53 Contracts package 363082
CSV.sql 5.113 CSV extract package 359252
CSV.sql 5.114 CSV extract package 359664
CSV.sql 5.115 CSV extract package 362508
CSV.sql 5.116 CSV extract package 364523
CSV.sql 5.117 CSV extract package 364556
CT_T_PALLET_LIST_359671.sql 1.1 CT Script 359671
CUST_COST.fmx 2.133 Customer Maintenance form 359664
DATA_1_REP_PARAM_TYPE_358425.sql 1.1 Data Script 358425
DATA_2_REP_REPORT_358425.sql 1.1 Data Script 358425
DATA_3_REP_REPORT_PARAM_358425.sql 1.1 Data Script 358425
DATA_4_REP_PARAM_VALUE_358425.sql 1.1 Data Script 358425
DATA_ADM_FORM_TAB_359667.sql 1.1 Data Script 359667
DATA_ADM_SYSTEM_PARAM_358506.sql 1.1 Data Script 358506
DATA_ADM_SYSTEM_PARAM_359252.sql 1.1 Data Script 359252
DATA_ADM_SYSTEM_PARAM_359656.sql 1.1 Data Script 359656
DATA_ADM_SYSTEM_PARAM_359664.sql 1.1 Data Script 359664
DATA_ADM_SYSTEM_PARAM_359667.sql 1.4 Data Script 359667
DATA_ADM_SYSTEM_PARAM_362508.sql 1.3 Data Script 362508
DATA_ADM_SYSTEM_PARAM_363082.sql 1.2 Data Script 363082
DATA_ADM_SYSTEM_PARAM_363499.sql 1.1 Data Script 363499
DATA_ADM_SYSTEM_PARAM_363855.sql 1.1 Data Script 363855
DATA_ADM_SYSTEM_PARAM_CONFIG_358506.sql 1.1 Data Script 358506
DATA_ADM_SYSTEM_PARAM_CONFIG_359252.sql 1.1 Data Script 359252
DATA_ADM_SYSTEM_PARAM_CONFIG_359656.sql 1.2 Data Script 359656
DATA_ADM_SYSTEM_PARAM_CONFIG_359664.sql 1.1 Data Script 359664
DATA_ADM_SYSTEM_PARAM_CONFIG_362508.sql 1.3 Data Script 362508
DATA_ADM_SYSTEM_PARAM_CONFIG_363082.sql 1.1 Data Script 363082
DATA_AUTO_SCHEDULING_ENGINE_359664.sql 1.1 Data Script 359664
DATA_IMP_DECODE_359667.sql 1.1 Data Script 359667
DATA_IMP_DECODE_ENTRY_359667.sql 1.1 Data Script 359667
DATA_ORS_MASTER_DATA_359779.sql 1.1 Data Script 359779
DATA_ORS_MASTER_DATA_361243.sql 1.1 Data Script 361243
DATA_ORS_SQL_359779.sql 1.1 Data Script 359779
DATA_ORS_SQL_361243.sql 1.1 Data Script 361243
DATA_REP_REPORT_PARAM_362667.sql 1.1 Data Script 362667
DATA_RES_CARRIER_FORMATS_359661.sql 1.1 Data Script 359661
DATA_RES_CARRIER_FORMATS_MAP_359661.sql 1.1 Data Script 359661
DATA_RES_LABEL_FORMATS_359661.sql 1.1 Data Script 359661
DATA_RES_LABEL_FORMATS_362811.sql 1.1 Data Script 362811
DP_CARRIER.sql 1.84 Carrier Management 359661
DP_CARRIER.sql 1.86 Carrier Management 362625
DP_CARRIER.sql 1.87 Carrier Management 359663
DP_CARRIER.sql 1.88 Carrier Management 363681
DP_CARRIER.sql 1.89 Carrier Management 362811
DP_CSV_DUN.sql 5.48 Client specific CSV extracts 358425
DP_CSV_DUN.sql 5.49 Client specific CSV extracts 364431
DP_CSV_DUN.sql 5.50 Client specific CSV extracts 364473
DP_EPOD_WEB_SERVICE.sql 1.122 EPOD Web Service 359518
DP_EPOD_WEB_SERVICE.sql 1.124 EPOD Web Service 361188
DP_IMP.sql 5.38 Imports Package 363681
DP_MCS_SCANNING.sql 5.42 MCS Scanning Package 359670
DP_MCS_SCANNING.sql 5.43 MCS Scanning Package 359661
DP_MCS_SCANNING.sql 5.44 MCS Scanning Package 359674
DP_MCS_SCANNING.sql 5.45 MCS Scanning Package 359663
DP_MCS_SCANNING.sql 5.48 MCS Scanning Package 359671
DP_RDT_FAST_UNLOAD.sql 5.44 RF Unload Package 362828
DP_SCHEDULING_ENGINE.sql 5.150 Scheduling Package 359457
DP_SCHEDULING_ENGINE.sql 5.153 Scheduling Package 359664
DP_SCHEDULING_ENGINE.sql 5.155 Scheduling Package 363499
DP_SCHEDULING_ENGINE.sql 5.156 Scheduling Package 363801
DP_SHIPMENT.sql 5.19 Shipment Code package 360403
DP_SHIPMENT.sql 5.21 Shipment Code package 362440
DP_SHIPMENT.sql 5.22 Shipment Code package 363082
DP_WEB_SERVICE_ORD.sql 1.22 Web Service Package 359252
DP_WEB_SERVICE_ORD.sql 1.23 Web Service Package 358506
DP_WEB_SERVICE_ORD.sql 1.25 Web Service Package 359601
DUNELM_VEHICLE_DESPATCH.rep 1.6 Vehicle Despatch report 362667
EXPORTS.fmx 2.36 Exports screen 358425
HC_SHUNT_SHEET.rep 1.5 HC Shunt Sheet Report 359668
HC_TRIP_SHEET.rep 1.13 HC Trip Sheet Report 359668
HCR_LOADING_SHEET.rep 1.4 Customer Loading Sheet 359668
IMP.sql 5.194 CSV Imports Package 360150
INT_XML_MIC.sql 5.145 MIC interface 359656
INT_XML_MIC.sql 5.146 MIC interface 363855
INT_XML_OUT2.sql 5.292 Outbound XML Package 360459
INT_XML_OUT2.sql 5.293 Outbound XML Package 359518
INT_XML_OUT2.sql 5.294 Outbound XML Package 359660
INT_XML_OUT2.sql 5.295 Outbound XML Package 358670
INT_XML_OUT2.sql 5.296 Outbound XML Package 362508
INT_XML_OUT2.sql 5.297 Outbound XML Package 362482
INT_XML_OUT2.sql 5.298 Outbound XML Package 363421
INT_XML_OUT2.sql 5.299 Outbound XML Package 363855
INV.sql 5.44 Invoice Package 360403
INV.sql 5.45 Invoice Package 363974
INV.sql 5.46 Invoice Package 363185
INVOICES.fmx 2.61 Invoices Screen 363185
LOCATION.fmx 2.191 Location Maintenance 359667
OF_INT.sql 5.52 Oracle Financials interface 360756
OF_INT.sql 5.54 Oracle Financials interface 362440
OF_INT.sql 5.55 Oracle Financials interface 363373
OF_INT.sql 5.56 Oracle Financials interface 364191
OF_INT.sql 5.57 Oracle Financials interface 364696
OF_INT.sql 5.58 Oracle Financials interface 365003
OMS.sql 5.223 Order package 359664
OMS.sql 5.224 Order package 359663
OMS.sql 5.225 Order package 363801
OMS.sql 5.226 Order package 363082
OMS.sql 5.227 Order package 365051
ORDERS.fmx 2.422 Order Screen 361329
ORDERS.fmx 2.423 Order Screen 359664
ORDERS.fmx 2.426 Order Screen 359663
ORDERS_WIDE.fmx 1.24 Orders Screen 359664
ORDERS_WIDE.fmx 1.25 Orders Screen 359663
PAR.sql 5.105 Paragon Interface 359664
PAR.sql 5.106 Paragon Interface 364910
PAR_INT.fmx 10.40 Paragon Interface form 364523
PL_VERSION.sql 4.1 Version, Date and Author Package 361652
PLANNING.fmx 1.108 Planning Screen 359621
RATE.sql 5.154 Rates Tariff database package 360756
RATE.sql 5.155 Rates Tariff database package 361291
RATE.sql 5.156 Rates Tariff database package 364191
REPORTS.fmx 2.35 Reports Screen 358425
RESOURCE.fmx 2.193 Resource Maintenance form 359664
ROUTES_MAINT.fmx 2.49 Fixed Routes Maintenance 359664
SHIPMENT_INVOICE.rep 1.3 Shipment Invoice Report 361291
SHIPMENT_PALLETS.fmx 5.3 Shipment Pallets Form 359661
SHIPMENT_PALLETS.fmx 5.4 Shipment Pallets Form 359663
SHIPMENT_PALLETS.fmx 5.5 Shipment Pallets Form 359671
T_SCH_ORD_PNL.sql 5.15 Trigger 360756
TIU_TRIP_STATUS.sql 5.54 Trigger on SCH_TRIP for status change 359660
TRG_MCS_REQUEST_BU.sql 1.3 Trigger 359670
TRG_SCH_ORD_XML_INT.sql 5.18 Trigger 358670
TRG_SHA_XML_OUT.sql 1.15 Haulage Activity Trigger 359660
TRIPDTL.fmx 2.225 Trip Debrief 359621
TRM.sql 5.191 Trip manipulation package 360756
TRM.sql 5.193 Trip manipulation package 362440
TRM.sql 5.194 Trip manipulation package 359663
TRM.sql 5.195 Trip manipulation package 363082
USER_CONTEXT_PKG.sql 5.3 User Context Database Package 359601
USER_CONTEXT_PKG.sql 5.4 User Context Database Package 365051
V_MCS_MENU_ITEM.sql 1.1 View 359670
V_MCS_MENU_ITEM.sql 1.2 View 359671
V_MCS_PALLET.sql 1.1 View 359671
V_MCS_SITE.sql 1.2 View 359670
V_MCS_SITE.sql 1.3 View 362654
V_MCS_SYSTEM_STATUS.sql 1.1 View 359670
V_MCS_TRIP_ITEM.sql 1.14 Trip Items View 359674


ADDITIONAL CHANGES

WCS

A WCS change is required for the following logs:

  • Log

OR

There are no WCS changes required.

EPOD/T2A

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

  • Log

OR

There are no ePOD/T2A changes required.

MCS

An MCS change is required for the following logs:

  • Log

OR

There are no MCS changes required.

PORTAL/TTM

A Portal change is required for the following logs:

  • Log

OR

There are no Portal changes required.

EDI

An EDI change is required for the following logs:

  • 358670 - A new version 2.43 of TripOrder.xsd will need to be installed for the EDI files for messages for the new ConnectedView interface.


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