PATCH C-TMS P044: Difference between revisions

From Calidus HUB
VisualWikitext
No edit summary
No edit summary
Line 1,409: Line 1,409:
* Log 02590010  
* Log 02590010  
MAR: v5.13.1.1 of DP_PAR_API.sql
MAR: v5.13.1.1 of DP_PAR_API.sql
STS: v5.9.1.1 of DP_PAR_API_STP.sql
STS: v5.9.1.1 of DP_PAR_API_STP.sql


Revision as of 17:57, 22 June 2023




Aptean Logo.png










Release Notes

CALIDUS TMS

22nd May 2023 - 1.0
Reference: P044











































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

Summary of Call Driver Trip Sheet
Detail of Fix 'Driver Signature' has been added.

'Workroom/M2M Order Numbers:' is printed in full.

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


Log Number: 00354055

Summary of Call CTY Issue 93 - Can't see ETAs of drivers
Detail of Fix A new web service for EPOD will exist to perform vehicle position requests to store the latitude-longitude in CTMS with the last known date and time.

A new location type of 'TRACTOR' will be used for these vehicle locations. A new interface type of 'VEHICLE_POS_REQ' will be available in the 'EPOD Web Service Audit' screen.

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


Log Number: 00377266

Summary of Call CTY Issue 343 - Uppercase vehicle ID
Detail of Fix The vehicle search in CTMS will upshift the reg/fleet number that the user can enter on the EPOD device.

The inbound jobs from EPOD will upshift the vehicle for the service in EPL_CODE_2.

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


Log Number: 00377386

Summary of Call CTY Issue 338 - TMS Epod vehicle creation
Detail of Fix Customer locations may be INV as well as BRANCH locations for the serviced vehicles.
Set-up and Configuration No set-up/configuration required


Log Number: 00377345

Summary of Call CTY Issue 353 - Mismatch between TMS and Epod setup for tractors
Detail of Fix EPOD will be informed when a tractor is added to a carrier, deleted from a carrier, activated for a carrier or inactivated for a carrier.
Set-up and Configuration No set-up/configuration required


Log Number: 00377394

Summary of Call CTY Issue 329 - Product code incorrect on removal record generated
Detail of Fix Fixed DP_CUST_SERV to no longer set the product code and aka code for removed items records.
Set-up and Configuration No set-up/configuration required


Log Number: 02462955

Summary of Call Development for change to validation on upload to ePOD
Detail of Fix New Parameter NO_VALID_ORDS_ACPT set to Y will prevent orders from being validated when a trip is set to ACCEPTED
Set-up and Configuration No set-up/configuration required


Log Number: 00380741

Summary of Call Load Sheet in Landscape format
Detail of Fix Update Load Sheet to Landscape format
Set-up and Configuration No set-up/configuration required


Log Number: 00381222

Summary of Call Ctl Issue 359 - Vehicle Updates
Detail of Fix Various changes to ctl for the creation and updates of vehicles etc.
Set-up and Configuration No set-up/configuration required


Log Number: 02240275

Summary of Call Rate Table Management
Detail of Fix Rate Table Management for parties of customers to generate order payments.
Set-up and Configuration *********************


Log Number: 00378735

Summary of Call CTY Issue 337 - Invoice to is not populated in the Service Report
Detail of Fix Sends the customer code to EPOD for service jobs instead of the delivery address although the delivery address will remain as the address for the customer for the service job.
Set-up and Configuration No set-up/configuration required


Log Number: 00381747

Summary of Call CTY Issue 367 - Callout services are no longer being created
Detail of Fix New decodes will be created for services for the orders and the accounts when they are provided by EPOD:

SERVICE_CODES (CAR) - Decodes the delivery type to a service code for a car. SERVICE_CODES (VAN) - Decodes the delivery type to a service code for a van. SERVICE_CODES (TRUCK) - Decodes the delivery type to a service code for a tractor, trailer, rigid or vehicle. SERVICE_CODES (AGRI) - Decodes the delivery type to a service code for an agricultural vehicle.

ACC_SERVICE_CODES - Decodes the name of the new service code.

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


Log Number: 00432970

Summary of Call Create Order details
Detail of Fix Changes to the Order Import interface to allow Collection orders with no dates , Invoiced orders to be created and Items to be retained on INVALID orders.
Set-up and Configuration No set-up/configuration required


Log Number: 02254537

Summary of Call MCS - Streamline Process
Detail of Fix A system parameter is created when it is active then FN_VALIDATE_PIECE , FN_VALIDATE_ITEM_FOR_PALL, FN_ADD_TO_PALLET functions will call FN_FAST version of themselves, which will have lesser validation so that performance is improved during pallet building.
Set-up and Configuration ****************************


Log Number: 00433739

Summary of Call Ctl default the last vehicle the driver used.
Detail of Fix Changed get_driver_list to find the last vehicle the driver used.
Set-up and Configuration No set-up/configuration required


Log Number: 00432097

Summary of Call CTY Issue 371 - Vehicle Search
Detail of Fix The vehicle search will use the tyre information but the inspection information for the action and comments.
Set-up and Configuration No set-up/configuration required


Log Number: 00433476

Summary of Call CTY Issue 362 - Customer Vehicle on SOI
Detail of Fix The customer vehicle will be stored for the items as well as the order when the item is created via the customer service by CTL and via the services by EPOD.
Set-up and Configuration No set-up/configuration required


Log Number: 02280656

Summary of Call Additional reports
Detail of Fix Additional Report types added to the ORS and trip level information added to the existing Trip Level ORS types.

New SCHEDULE_DETAILS export and changes to the Planning screen to send orders to Paragon from the Order well

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


Log Number: 02280682

Summary of Call Tendered Emails
Detail of Fix The email messages for the tendered trips will refer to the new system parameter called ‘MSG_SUB_DEPOT’ to assess the actual stops for the current locations of the ordered items.

The first loading location will match the specified depot to include any current locations of the order items that are being loaded at the sub-depot for the trip stop at the depot.

For example, a trip stop at HFX will include the current locations of the order items at WLA, BFT and HFX itself.

Note that any order items that do not have a current location will be included at the depot for the trip stop itself as usual.

Set-up and Configuration **********************************


Log Number: 00437518

Summary of Call CTY Issue 367 - Account Service Code
Detail of Fix Only creates services for the order if the delivery type of the order is explicitly decoded using SERVICE_CODES for the group for the vehicle.
Set-up and Configuration No set-up/configuration required


Log Number: 00440383

Summary of Call CTY Issue 378 - Vehicles not showing on device
Detail of Fix See case 378735 for the change to send the customer not the location - this amendment has been reversed.

Excludes the EPOD modes, CALLOUT and INSPECT, for van swaps and asset tagging to send the information to EPOD.

Any items that are created from the service will set the pallet ID to the item ID as per the order creation by CTL via the customer service.

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


Log Number: 00380366

Summary of Call CTY Issue 360 - Cannot see service reports in Portal
Detail of Fix DP_CUST_SERV.FN_UPDATE_ORDER_CTL is modified to trigger the creation of INT_XML_CONTROL records for LOTS.

Created new EDI parameter called CUST_LOTS_SEND_ORD to create/update customers with the SEND_ORD_MSG flag set to Y when the customer has LOTS installed in DP_CTMS_IMPORT.

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


Log Number: 00440788

Summary of Call CTY Issue 365 - Import of inspection date incorrect
Detail of Fix The customers can be imported via the API with defaulted values for the vehicle inspection periods.

The EDI parameters for the 'API' process should be set as follows to create an inspection period of 3 months to begin on the first day of the month:

INSPECT_DATE_FROM = 01/01/2023 INSPECT_PERIOD_TYPE = M INSPECT_PERIOD_VALUE = 3

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


Log Number: 02539052

Summary of Call Driver Sheet Changes
Detail of Fix Additional changes to driver sheet as requested: 
- To include the text 'Store Planned Delivery Window:' and the planned arrival and departure dates and times for delivery locations.
- Include postcode for the locations.
Set-up and Configuration No set-up/configuration required


Log Number: 00445742

Summary of Call CTY issues 391 and 392
Detail of Fix Don't create RES_CARRIER_TRACTOR and set location name correctly for new locations.
Set-up and Configuration No set-up/configuration required


Log Number: 00452346

Summary of Call Cty Issue 389 - allow for map locations to change
Detail of Fix Change to allow Here maps locations to change. Update the location record and the order to reflect this.
Set-up and Configuration No set-up/configuration required


Log Number: 00453913

Summary of Call Paragon ID and Waterfall changes
Detail of Fix Changes to the Waterfall screen and Import Customer API to show more trip information and populate the Paragon Id
Set-up and Configuration No set-up/configuration required


Log Number: 00459135

Summary of Call Temporary Location Fix
Detail of Fix Temporary Location Fix (UNKNOWN) setting the new location id incorrectly.
Set-up and Configuration No set-up/configuration required


Log Number: 00461571

Summary of Call Code Tweaks and fixes
Detail of Fix Changes for OAuth and reducing traffic to Paragon
Set-up and Configuration No set-up/configuration required


Log Number: 00459921

Summary of Call Additional columns to be added to customers ORS reports
Detail of Fix Added new columns to ORS_TYPE - HAULIER, CARR_ALLOC, CONTRACTS.

HAULIER - First Stop Loc ID, First Stop Loc Name, Last Stop Loc ID, Last Stop Loc Name, Registration. CARR_ALLOC - Carrier Name. CONTRACTS - Counter Party Name.

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


Log Number: 00451971

Summary of Call Invalid Orders
Detail of Fix Modified the package, so that the provided customer group is being updated against the customer_id when the edi parameter ‘UPDATE_CUST_GROUP’ is set to ‘Y’.

Updating of customer group depends on the edi parameter 'UPDATE_CUST_GROUP'.

The default customer group depends on the edi parameter 'DEFAULT_ADD_CUST_GRP'.

Set-up and Configuration ***************************


Log Number: 00464296

Summary of Call CTY Issue 390
Detail of Fix Fixed CTMS to reset Inspection if related callout is cancelled either on ctl or epod.
Set-up and Configuration No set-up/configuration required


Log Number: 00465517

Summary of Call CTY Issue 387 - XML Updates
Detail of Fix Fix for epod > ctms services updates. Fixed XML updates in ctms package.
Set-up and Configuration No set-up/configuration required


Log Number: 02554907

Summary of Call Waterfall Screen
Detail of Fix Waterfall screen is modified to accommodate new fields in all tab pages and blocks as per the requirement.

Trip locations, Req Veh Type, Actual Col Arrive, Actual Col Depart, Plan Col Loc, Actual Del Arrive, Actual Del Depart, Plan Del Loc are the new columns added to all the blocks and tab pages.

New tickbox called 'Inc All Stops' is added.

The following decoded values can be setup to translate the stop type to a description to display for the trip stops and locations:

Decode Name = 'STOP_TYPE' Decode Type = 'REFERENCE'

Source Value Target Value SU Start Up PK Pick Up DL Delivery CL Close Down

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


Log Number: 00468785

Summary of Call COPY CONTRACT/TARIFF
Detail of Fix Contracts is amended so that user can copy contract/tariff/du tariff/delivery tariff from customer to party and vice versa. Basically Contract type is made available to be chosen by user while copying so that it avoids the restriction of copying to same kind.
Set-up and Configuration No set-up/configuration required



SUPPORT INCIDENTS

Log Number: 00375172

Summary of Call Send 432 messages to WCS to unload trunk trips
Detail of Fix Creates 432 messages for WCS when the trunk trip is updated for unloading status when it is EN-ROUTE.

This development relates to additional messages that are required for the new EDI process for case 02254409.

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


Log Number: 00375171

Summary of Call Various changes for Ctl and ctms
Detail of Fix Issue 299 - Removed Date validation for Releasing.

Issue 312 - Default Trip Vehicle from the drivers current trip.

Issue 323 - Set Date To to be the next day if the time is lower.

Issue 292 - Reset Hidden Fields properly when pressing Clear.

Issue 296 - Display Vehicle Description correctly.

Issue 314 - Removed wildcard from the location search on vehicles.

Issue 275 - FIA report issues.

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


Log Number: 00376075

Summary of Call Send 431 messages to WCS to unload trunk trip from the order interface
Detail of Fix The new order items will be created in a despatch bay and then sent in 431 messages to the depot for unloading with the 432 message for the trip.
Set-up and Configuration No set-up/configuration required


Log Number: 00415572

Summary of Call Control Waterfall screen
Detail of Fix A new parameter will be inactive in the Trip Waterfall screen to enable the current configuration to be retained for the users.

Correction for parameter release in 00351271 - Control Waterfall Updates Parameter will be released as N instead of Y.

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


Log Number: 00376072

Summary of Call Extend the carrier name in the Planning screen
Detail of Fix The carrier name can now be displayed with 50 characters.
Set-up and Configuration No set-up/configuration required


Log Number: 00462809

Summary of Call 3PL Fixed Drop Scheduling
Detail of Fix The orders were being reprocessed for the 3PL fixed drop scheduling when the delivery date is in the past and they cannot be scheduled.
Set-up and Configuration No set-up/configuration required


Log Number: 00463330

Summary of Call Exclude inactive depots from 3PL Schedules
Detail of Fix The new system parameter called 'AUTO_SCHED_INACTIVE_DEPOTS' is available to list the depots that will not be included in the fixed drop scheduling.
Set-up and Configuration *******************************


Log Number: 00456483

Summary of Call TI order import error
Detail of Fix The package is modified. So, when an incorrect customer code is imported, it’s been reported with a valid error message.
Set-up and Configuration No set-up/configuration required


Log Number: 00464609

Summary of Call Version release control for 02274554
Detail of Fix Created TRM_ORD_SCHED_SEARCH_PLANNING, TRM_ORD_SCHED_FROM_PLANNING and TRM_ORD_SCHED_TO_PLANNING parameters at system level, and added code in PLANNING.fmb (Originally this has been done in 02274554).
Set-up and Configuration ****************************



BUGS

Log Number: 02277663

Summary of Call MIS Report not running
Detail of Fix The format of the dates for MIS extracts will be converted to 'DD/MM/YYYY' for the selection criteria based on the EDI parameters to offset the 'SYSDATE' (e.g. 'SYSDATE-1' to 'SYSDATE+1').
Set-up and Configuration No set-up/configuration required


Log Number: 02433470

Summary of Call Issue when setting a C-TMS Location to In-active
Detail of Fix The radio buttons for the active/inactive locations can be changed, saved and stored.
Set-up and Configuration No set-up/configuration required


Log Number: 02274554

Summary of Call Planning screens
Detail of Fix For version 1.133 - Added logic in F_POP_LISTS to populate 'TO' schedule even when cost_centre is set to ALL.

For version 1.134 - created TRM_ORD_SCHED_SEARCH, TRM_ORD_SCHED_FROM and TRM_ORD_SCHED_TO parameters at system level, and added code in PLANNING.fmb to access those when COST_CENTRE is set to ALL for a user

For version 1.135 - Amended system parameters to restrict them to only Planning screen to avoid discrepancies.

For version 1.136 - Considered the scenario where two cost centres are set for a user and system parameter exist for one of them then system should consider that cost centre rather than the one it was using as per alphanumerical order and if both cost centres are active then system should use the maximum range active for the cost centre parameters.

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


Log Number: 02531360

Summary of Call Tripsum
Detail of Fix Changes to the drop down list of schedules in the Order well search to prevent blank values
Set-up and Configuration No set-up/configuration required


Log Number: 02281070

Summary of Call Better auditing in CTMS EPOD import package
Detail of Fix More information is included in the audit message along with the user name. So, that the lock can be identified along with the user details.
Set-up and Configuration No set-up/configuration required


Log Number: 02539791

Summary of Call EDI Modifications
Detail of Fix Modified the EDI_MAINT form. So that, If the user not decided to enter any details he/she close the screen without getting the stuck.
Set-up and Configuration No set-up/configuration required


Log Number: 02542209

Summary of Call Trip Waterfall screen
Detail of Fix The 'Print' dialogue box will be displayed in the Trip Waterfall screen from the 'Print' action prompt.
Set-up and Configuration No set-up/configuration required


Log Number: 02537338

Summary of Call XML EDI files not generating items
Detail of Fix Included NVL of N to SEND_LINE_ITEMS parameter so the hardcoded value of 'I' can be removed for ZETES and to reintroduce the previous functionality for all the other processes.
Set-up and Configuration No set-up/configuration required


Log Number: 02543350

Summary of Call Error planning orders
Detail of Fix A new system parameter called 'UPDATE_ORDER_TIMES_TO_TRIP' can be configured at the cost-centre level to enable the current orders to have their time windows updated to match the stop time windows when the 'Confirm Update/Add' process is started to add new matching orders to the stops.

This system parameter can be set to 'Y' to ensure that the order time windows are set ready for the new orders to be assigned.

Set-up and Configuration ************************************


Log Number: 02442010

Summary of Call Order import via web service
Detail of Fix Modified the package to include the correct error in the audit trail.
Set-up and Configuration No set-up/configuration required


Log Number: 00436894

Summary of Call Reports
Detail of Fix Fix for issues created in log 02280656.

Mainly, corrections required in data types and rounding of the result to run Haulier report and correction ORS_MASTER_DATA to pass correct number of parameters to COST_PER_TONNE and some corrections to ORS_TITLE which had been misspelled.

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


Log Number: 02566122

Summary of Call Scheduling engine
Detail of Fix Auditing will be present for when the order is rolled back from its partial scheduling.
Set-up and Configuration No set-up/configuration required


Log Number: 02528443

Summary of Call Message not triggering
Detail of Fix A message will be sent when the seal number is changed and the status of the trip is 'COMPLETED'.
Set-up and Configuration No set-up/configuration required


Log Number: 02558002

Summary of Call Cancelling R21 at 0:06AM
Detail of Fix The 4PL carriers, as well as the 3PL carriers, will be excluded from this process to change the schedule for the trips when the database job runs at midnight.
Set-up and Configuration No set-up/configuration required


Log Number: 02440377

Summary of Call Duplicate Customer References
Detail of Fix The function OMS.set_unique_ext_ref has been altered for certain queries that were previously available to choose a max value now will only select a single record that has the highest value for the external_ref suffix.
Set-up and Configuration No set-up/configuration required


Log Number: 02576783

Summary of Call Planning screen error
Detail of Fix Removed the spurious audit messages which were writing in to SCH_TRIP_DETAIL_AUDIT table in DP_PAR_API and DP_PAR_API_STP packages.
Set-up and Configuration No set-up/configuration required


Log Number: 00459742

Summary of Call Duplicate Rows
Detail of Fix The Schedule Details report will not include duplicate rows per trip.
Set-up and Configuration No set-up/configuration required


Log Number: 00462694

Summary of Call Waterfall screen
Detail of Fix New version of V_TRIP_OVERVIEW to resolve waterfall screen issue
Set-up and Configuration No set-up/configuration required


Log Number: 00463873

Summary of Call Trip Status returned from CTMS to Portal is incorrect
Detail of Fix Issue has been fixed and Portal now displays the correct status.
Set-up and Configuration No set-up/configuration required


Log Number: 02587737

Summary of Call Rate upload testing
Detail of Fix Counter party Name in Copy Contract, Copy Tariff, Copy Del Tariff have been modified to include Counter Party name for 'Party' contract.

The charges can be found for a customer without a rating party when rating by party is active.

The import process for the contracts will set a default value of N for the order movement rate. The contract can then be updated.

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


Log Number: 02574489

Summary of Call Delivery Window on Tender Emails
Detail of Fix The body of the message will include the full dates and times for the tendered invitations.

Trips will generate emails for carriers for tendered invitations. These trips can include multiple orders on multiple stops with a single item or multiple items. The time windows will include the date and the time for each order.

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


Log Number: 02590010

Summary of Call Imported trips - missing mileage
Detail of Fix The distance to the next stop will be applied to the last stop when it is provided by Paragon.
Set-up and Configuration No set-up/configuration required


Log Number: 00466359

Summary of Call Fixed Routes in TMS - depot is not recognised
Detail of Fix A new system parameter called 'RTE_MAINT_RDC_ALL_USAGE' can be set to 'Y' to allow the lists of values for the fixed route's details to include an 'RDC' location when that depot has not been assigned to a customer or a customer group depending on the type of usage that is operational for the locations.
Set-up and Configuration *****************************


Log Number: 00465515

Summary of Call Cancellation message not processing in TMS - Ref: 19591
Detail of Fix The current location of an order will be updated to the latest location that has been planned on a trip.
Set-up and Configuration No set-up/configuration required


Log Number: 02575003

Summary of Call INC49978883: POD information not present on the relevant order
Detail of Fix If system param MIC_CREATE_CD (Microlise interface to create CD reason for successful deliveries when not provided) is set to 'Y', amendment has been made to MIC file processing to ensure the CD clean deliver is written.
Set-up and Configuration No set-up/configuration required


Log Number: 00470954

Summary of Call Trip Waterfall screen for Tyres on the Drive orders Ref: 19669
Detail of Fix TRIP_OVERVIEW.get_tmps is altered to exclude the Unscheduled Return orders from displaying in Tmps column of Waterfall screen.
Set-up and Configuration No set-up/configuration required


Log Number: 02593759

Summary of Call Multiple Email Sends
Detail of Fix A message event to generate an email to a carrier to tender a trip will be triggered once.
Set-up and Configuration No set-up/configuration required


Log Number: 02230751

Summary of Call Failed Import
Detail of Fix The import process of files will use a system parameter called 'UTL_IMPORT_IGNORE_INVALID_OPERATION' to suppress the auditing of messages when a file does not exist on the server to overwrite.

This system parameter can be set to 'Y' for that purpose.

Set-up and Configuration *************************************



PRODUCT DEVELOPMENT

MODULES DELIVERED

Module Name Version No Description Log Number
ACC_MAINT.fmx 2.98 Accounts Maintenance 02240275
AT_CNT_TARIFF_02240275.sql 1.3 AT Script 02240275
AT_GEO_LOCATION_00432970.sql 1.2 AT Script 00432970
AT_ORG_CUSTOMER_02240275.sql 1.1 AT Script 02240275
AT_PAR_API_STAGING_00432970.sql 1.1 AT Script 00432970
AT_PAR_JSON_IN_00432970.sql 1.1 AT Script 00432970
AT_RES_TRACTOR_00354055.sql 1.2 AT Script 00354055
CNT.sql 5.55 Contracts package 02240275
CNT.sql 5.57 Contracts package 00468785
CONTRACT.fmx 2.79 Contracts Form 02240275
CONTRACT.fmx 2.81 Contracts Form 02587737
CONTRACT.fmx 2.82 Contracts Form 00468785
CT_ACC_RATING_PARTY_02240275.sql 1.2 CT Script 02240275
CT_ACC_RATING_PARTY_459921.sql 1.1 CT Script 00459921
CT_PAR_FIX_API_00432970.sql 1.1 CT Script 00432970
CT_SCH_ORD_STATS.sql 1.1 CT Script 02280656
CT_T_DRIVER_LIST_375171.sql 1.1 CT Script 00375171
CT_TMP_TOKEN.sql 1.2 CT Script 00461571
CUST_COST.fmx 2.143 Customer Maintenance form 02240275
DATA_1_ORS_MASTER_DATA_459921.sql 1.1 Data Script 00459921
DATA_2_ORS_MASTER_DATA_459921.sql 1.1 Data Script 00459921
DATA_3_ORS_MASTER_DATA_459921.sql 1.1 Data Script 00459921
DATA_ADM_FORM_TAB_02240275.sql 1.1 Data Script 02240275
DATA_ADM_MSEL_FORM_PARAM_02554907.sql 1.1 Data Script 02554907
DATA_ADM_SYSTEM_PARAM_00415572.sql 1.2 Data Script 00415572
DATA_ADM_SYSTEM_PARAM_00432970.sql 1.1 Data Script 00432970
DATA_ADM_SYSTEM_PARAM_00463330.sql 1.1 Data Script 00463330
DATA_ADM_SYSTEM_PARAM_00466359.sql 1.1 Data Script 00466359
DATA_ADM_SYSTEM_PARAM_02230751 1.1 Data Script 02230751
DATA_ADM_SYSTEM_PARAM_02240275.sql 1.3 Data Script 02240275
DATA_ADM_SYSTEM_PARAM_02254537.sql 1.2 Data Script 02254537
DATA_ADM_SYSTEM_PARAM_02274554.sql 1.2 Data Script 00464609
DATA_ADM_SYSTEM_PARAM_02280682.sql 1.1 Data Script 02280682
DATA_ADM_SYSTEM_PARAM_02462955.sql 1.1 Data Script 02462955
DATA_ADM_SYSTEM_PARAM_02543350.sql 1.2 Data Script 02543350
DATA_ADM_SYSTEM_PARAM_CONFIG_02543350.sql 1.1 Data Script 02543350
DATA_CNT_CHARGE_PARAM_02240275.sql 1.6 Data Script 02240275
DATA_CNT_CONDITION_02240275.sql 1.2 Data Script 02240275
DATA_CNT_CONDITION_VALUE_02240275.sql 1.2 Data Script 02240275
DATA_EDI_PROCESS_TRIGGER_380366.sql 1.1 Data Script 00380366
DATA_EDI_PROCESS_TRIGGER_451971.sql 1.1 Data Script 00451971
DATA_GEO_LOC_TYPE_00354055.sql 1.1 Data Script 00354055
DATA_IMP_DECODE_00381747.sql 1.2 Data Script 00381747
DATA_IMP_DECODE_02240275.sql 1.1 Data Script 02240275
DATA_IMP_DECODE_ENTRY_00381747.sql 1.2 Data Script 00381747
DATA_IMP_DECODE_ENTRY_02240275.sql 1.3 Data Script 02240275
DATA_IMP_FIELD_02240275.sql 1.1 Data Script 02240275
DATA_ORS_MASTER_DATA_02280656.sql 1.1 Data Script 02280656
DATA_ORS_MASTER_DATA_1_02240275.sql 1.2 Data Script 02240275
DATA_ORS_MASTER_DATA_2_02240275.sql 1.2 Data Script 02240275
DATA_ORS_MASTER_DATA_3_02240275.sql 1.2 Data Script 02240275
DATA_ORS_MASTER_DATA_436894.sql 1.1 Data Script 00436894
DATA_ORS_SQL_02280656.sql 1.2 Data Script 02280656
DATA_ORS_SQL_1_02240275.sql 1.2 Data Script 02240275
DATA_ORS_SQL_459921.sql 1.1 Data Script 00459921
DATA_REP_REPORT_02280656.sql 1.1 Data Script 02280656
DATA_REP_REPORT_PARAM_02280656.sql 1.1 Data Script 02280656
DP_3PL_SCHED.sql 5.1 3PL Scheduling Engine Database Package 00432970
DP_3PL_SCHED.sql 5.2 3PL Scheduling Engine Database Package 00461571
DP_3PL_SCHED.sql 5.3 3PL Scheduling Engine Database Package 00462809
DP_3PL_SCHED.sql 5.4 3PL Scheduling Engine Database Package 00463330
DP_CSV_GEN.sql 1.7 Generic CVS package 02280656
DP_CSV_GEN.sql 1.8 Generic CVS package 00459742
DP_CTMS_IMPORT.sql 5.21 API Import Database Package 00432970
DP_CTMS_IMPORT.sql 5.22 API Import Database Package 02442010
DP_CTMS_IMPORT.sql 5.23 API Import Database Package 00380366
DP_CTMS_IMPORT.sql 5.24 API Import Database Package 00440788
DP_CTMS_IMPORT.sql 5.25 API Import Database Package 00453913
DP_CTMS_IMPORT.sql 5.26 API Import Database Package 00459135
DP_CTMS_IMPORT.sql 5.27 API Import Database Package 00451971
DP_CUST_SERV.sql 1.56 Customer Service Package 00375171
DP_CUST_SERV.sql 1.57 Customer Service Package 00377394
DP_CUST_SERV.sql 1.60 Customer Service Package 00381222
DP_CUST_SERV.sql 1.61 Customer Service Package 00433739
DP_CUST_SERV.sql 1.62 Customer Service Package 00433476
DP_CUST_SERV.sql 1.63 Customer Service Package 00380366
DP_CUST_SERV.sql 1.64 Customer Service Package 00445742
DP_CUST_SERV.sql 1.65 Customer Service Package 00452346
DP_CUST_SERV.sql 1.66 Customer Service Package 00464296
DP_EPOD_WEB_SERVICE.sql 1.178 EPOD Web Service 00354055
DP_EPOD_WEB_SERVICE.sql 1.179 EPOD Web Service 00377266
DP_EPOD_WEB_SERVICE.sql 1.180 EPOD Web Service 00377386
DP_EPOD_WEB_SERVICE.sql 1.181 EPOD Web Service 00378735
DP_EPOD_WEB_SERVICE.sql 1.182 EPOD Web Service 00381747
DP_EPOD_WEB_SERVICE.sql 1.183 EPOD Web Service 00432097
DP_EPOD_WEB_SERVICE.sql 1.184 EPOD Web Service 00433476
DP_EPOD_WEB_SERVICE.sql 1.185 EPOD Web Service 02281070
DP_EPOD_WEB_SERVICE.sql 1.186 EPOD Web Service 00437518
DP_EPOD_WEB_SERVICE.sql 1.187 EPOD Web Service 00440383
DP_EPOD_WEB_SERVICE.sql 1.188 EPOD Web Service 00464296
DP_EPOD_WEB_SERVICE.sql 1.189 EPOD Web Service 00465517
DP_EXPORT_EVENTS.sql 5.23 API Export Events Database Package 00461571
DP_MCS_SCANNING.sql 5.71 MCS Scanning Package 02254537
DP_MIS.sql 5.8 MIS Interface Package 02277663
DP_ORS_FUNCS.sql 5.29 Change to DOOD status function 00459921
DP_PAR_API.sql 5.12 Paragon API Database Package 02576783
DP_PAR_API.sql 5.13 Paragon API Database Package 02590010
DP_PAR_API_STP.sql 5.3 STP Paragon API Database Package 00432970
DP_PAR_API_STP.sql 5.5 STP Paragon API Database Package 00453913
DP_PAR_API_STP.sql 5.8 STP Paragon API Database Package 02576783
DP_PAR_API_STP.sql 5.9 STP Paragon API Database Package 02590010
DP_PORTAL.sql 5.20 Portal Package 00463873
DP_REPORTS.sql 5.74 Reports package 02240275
DP_SCHEDULING_ENGINE.sql 5.182 Scheduling Package 00432970
DP_SCHEDULING_ENGINE.sql 5.183 Scheduling Package 02566122
DP_TRM_CHANGE_SCHEDULE.sql 5.3 Change Schedule Database Package 02558002
EDI_MAINT.fmx 10.18 EDI Maintenance Screen 02539791
EPOD_WSA.fmx 1.10 EPOD Web Service Audit Form 00354055
IMP.sql 5.220 CSV Imports Package 02240275
IMP.sql 5.221 CSV Imports Package 00456483
IMP.sql 5.222 CSV Imports Package 02587737
INT_XML_IN.sql 5.239 Order Import Package 00451971
INT_XML_MIC.sql 5.156 MIC interface 02575003
INT_XML_OUT2.sql 5.329 Outbound XML Package 02537338
LOCATION.fmx 2.205 Location Maintenance 02433470
MSG_CONSTRUCTOR.sql 5.22 E-mail construction 02280682
MSG_CONSTRUCTOR.sql 5.23 E-mail construction 02574489
OMS.sql 5.331 Order package 02240275
OMS.sql 5.332 Order package 02440377
OMS.sql 5.333 Order package 00465515
ORS.sql 5.12 Oracle Reporting suite 02280656
ORS.sql 5.13 Oracle Reporting suite 00436894
PLANNING.fmx 1.136 Planning Screen 02274554
PLANNING.fmx 1.137 Planning Screen 02280656
PLANNING.fmx 1.138 Planning Screen 02543350
PLANNING.fmx 1.139 Planning Screen 00376072
RATE.sql 5.168 Rates Tariff database package 02240275
RES_TRACTOR_CARRIER_UID.sql 5.14 Trigger 00377345
ROUTES_MAINT.fmx 2.53 Fixed Routes Maintenance 00466359
STAP_LOAD_SHEET.rep 1.2 Loading Sheet 00380741
T_CNT_CONTRACT_CHECK_PARTYS.sql 1.2 Trigger 00468785
TI_SCH_ORD_STATUS.sql 1.26 Trigger on SCH_ORD for status change 00432970
TI_SCH_ORD_STATUS.sql 1.27 Trigger on SCH_ORD for status change 00461571
TIU_TRIP_STATUS.sql 5.56 Trigger on SCH_TRIP for status change 00375172
TIU_TRIP_STATUS.sql 5.57 Trigger on SCH_TRIP for status change 02593759
TRG_ACC_RATING_PARTY_BIU.sql 1.1 Trigger 02240275
TRG_DRY_ICE.sql 1.21 Trigger 02240275
TRG_GEL_PACKS.sql 1.16 Trigger 02240275
TRG_GEO_COUNTRY_CODE.sql 1.1 Trigger 00432970
TRG_GEO_DELIVERY_ROUTE_PRIORITY.sql 1.1 Trigger 00461571
TRG_GEO_LOCATION_UID.sql 5.5 Trigger 00432970
TRG_GEO_LOCATION_UID.sql 5.6 Trigger 00461571
TRG_SCH_ORD_CURRENT_DEPOT.sql 5.5 Trigger 00461571
TRG_SCH_ORD_EQUIP_SERVICES.sql 5.7 Database Trigger Script 02240275
TRG_SCH_ORD_LABOUR_SERVICES.sql 5.6 Database Trigger Script 02240275
TRG_SCH_ORD_LINES_SERVICES.sql 5.8 Database Trigger Script 02240275
TRG_SCH_ORD_LINES_SERVICES.sql 5.9 Database Trigger Script 00456483
TRG_SCH_ORD_SERVICES.sql 5.9 Database Trigger Script 02240275
TRG_SCH_ORD_SERVICES_BIUDR.sql 5.5 Trigger for SCH_ORD_SERVICES 02240275
TRG_SCH_ORDER_LINE_PAR.sql 5.2 Trigger 00461571
TRG_SCH_TRIP_XML_INT.sql 5.40 Trigger 02528443
TRIP_OVERVIEW.fmx 1.72 Trip Waterfall 02542209
TRIP_OVERVIEW.fmx 1.73 Trip Waterfall 00453913
TRIP_OVERVIEW.fmx 1.74 Trip Waterfall 02554907
TRIP_OVERVIEW.sql 5.10 Trip Waterfall 02554907
TRIP_OVERVIEW.sql 5.11 Trip Waterfall 00470954
TRIP_OVERVIEW.sql 5.9 Trip Waterfall 00453913
TRIP_PLAN.fmx 1.282 Trip Planning Screen 02543350
TRIP_SHEET_DUNELM_DETAIL.rep 5.29 Driver Trip Sheet 02437325
TRIP_SHEET_DUNELM_DETAIL.rep 5.31 Driver Trip Sheet 02539052
TRIPSUM.fmx 2.448 Trip Manipulation screen 02531360
TRIPSUM.fmx 2.449 Trip Manipulation screen 02543350
TRM.sql 5.220 Trip manipulation package 00375172
TRM.sql 5.221 Trip manipulation package 00376075
TRM.sql 5.222 Trip manipulation package 02462955
UTL.sql 5.4 Utility Database Package 02230751
V_ORD_ORDER_HEADER.sql 1.16 View 00381222
V_TRIP_OVERVIEW.sql 1.21 Trip View 00453913
V_TRIP_OVERVIEW.sql 1.22 Trip View 00462694
V_TRIP_OVERVIEW.sql 1.23 Trip View 02554907
V_TRIP_OVERVIEW_ORD.sql 5.14 Trip/Order View 02554907
V_VEHICLE_DETAILS.sql 5.5 View 00375171
WAREHOUSE.fmx 2.16 Warehouse Screen 02240275
WAREHOUSE.fmx 2.17 Warehouse Screen 02587737


ADDITIONAL CHANGES

EPOD/T2A

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

  • Log 00440383 (CTY Only)


CTL

A CTL change is required for the following logs:

  • Log 00375171
  • Log 00377394
  • Log 00381222
  • Log 00452346


Manual Release

A Manual release is required for the following logs:

  • Log 02590010

MAR: v5.13.1.1 of DP_PAR_API.sql

STS: v5.9.1.1 of DP_PAR_API_STP.sql


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