PATCH C-TMS 11.0 P018 081215: Difference between revisions

From Calidus HUB
No edit summary
No edit summary
Line 131: Line 131:
|-
|-
| 331927 || - || 3 || Allow orders where the delivered quantity is null or 0 to be unscheduled from COMPLETED trips, based on cost centre parameter ORD_UNSCHED_COMP || u/a || u/a || MICHELLE NAUMOVSKI || ER017-053 || N || N || N || N || N
| 331927 || - || 3 || Allow orders where the delivered quantity is null or 0 to be unscheduled from COMPLETED trips, based on cost centre parameter ORD_UNSCHED_COMP || u/a || u/a || MICHELLE NAUMOVSKI || ER017-053 || N || N || N || N || N
|-
| 330159 || Bath 054 || 3 || Fix for route code to be populated correctly within the ORS Failed Morning Report. || u/a || u/a || Tom Judge || ER017-054 || N || N || N || N || N
|-
|-
| 329360 || - || 3 || Product fix to prevent the errors tab for diappearing on Refresh Tree || u/a || u/a || Pete Crane || - || N || N || N || N || N
| 329360 || - || 3 || Product fix to prevent the errors tab for diappearing on Refresh Tree || u/a || u/a || Pete Crane || - || N || N || N || N || N
Line 202: Line 204:
{{PATCHModDeliveredTableRow | DATA_MCS_CONTROL_PARAM_322972.sql | 1.2 | Data Script | 322972 }}
{{PATCHModDeliveredTableRow | DATA_MCS_CONTROL_PARAM_322972.sql | 1.2 | Data Script | 322972 }}
{{PATCHModDeliveredTableRow | DATA_ORS_MASTER_DATA_331367.sql | 1.2 | Data Script | 331367 }}
{{PATCHModDeliveredTableRow | DATA_ORS_MASTER_DATA_331367.sql | 1.2 | Data Script | 331367 }}
{{PATCHModDeliveredTableRow | DATA_ORS_SQL_330159.sql | 1.1 | Data Script | 330159 }}
{{PATCHModDeliveredTableRow | DATA_REP_REPORT_330770.sql | 1.1 | Data Script | 330770 }}
{{PATCHModDeliveredTableRow | DATA_REP_REPORT_330770.sql | 1.1 | Data Script | 330770 }}
{{PATCHModDeliveredTableRow | DATA_REP_REPORT_331824.sql | 1.1 | Data Script | 331824 }}
{{PATCHModDeliveredTableRow | DATA_REP_REPORT_331824.sql | 1.1 | Data Script | 331824 }}

Revision as of 11:57, 8 December 2015





Aptean Logo.png







OBS Logistics Ltd

Software Release Notes


CALIDUS TMS

3rd Dec 2015 - 1.0
Reference: P018












































Development Defects

  Changes Required
Log Number Client Ref Log Priority Issue Raised and Test Objective Project/Site Functional Area Reported ER Number WCS EPOD TTM EDI MCS
330487 Script Correction 3 Update script for parameter INTERFACE_FORMAT u/a u/a Suzanne Woodcock ER017-001 N N N N N
330510 - 3 This log includes a version of a database package that will be released with log 329857 u/a Interface - Mail messaging Internal ER017-002 N N N N N
330423 326855 3 Changes to the header extract Australia Accounts - Invoices Suzanne Woodcock ER017-003 N N N N N
329682 PROD MANAGEMENT 020 3 New menu design initialy just for demo's. u/a u/a Dave Meir ER017-004 N N N N N
330046 DH-A2EFE4 1 New decode WMS_LOCATION_MAPPING for translating warehouse tag on outbound XML. u/a u/a Darryl Horton ER017-005 N N N N N
330158 PG-A2RH6G 4 Adjust the dates provided for orders to avoid weekends and bank holidays. u/a u/a Peter Greer ER017-006 N N N N N
330682 - 3 SMS messaging database jobs u/a u/a Suzanne Woodcock ER017-008 N N N N N
330702 - 3 Del msg being sent at collection. Check added to ensure only sent at final delivery location Australia Orders Hayley Keegan ER017-010 N N N N N
330672 - 1 Sets the file extension for an LOTS FTP transfer which is then set after transfer back to the original file extension type. New system parameter called LOTS_XFER_EXTENSION has been created at Cost Centre level which will require setting to .TMP Australia EPOD - Export Michelle Naumovski ER017-011 N N N N N
330617 330091 - Rework 3 Do not remove files if ftp process not in operation u/a u/a Rob Merrill ER017-011 N N N N N
330810 - 3 Change to code to look for pending records Australia u/a Suzanne Woodcock ER017-012 N N N N N
330774 Bath 055 3 Fix applied to correctly store volume against order items lines for the EDI XML item import u/a EDI - Inbound Tom Judge ER017-013 N N N N N
330613 - 3 Fix to pallet label to fix issue with the label counts and resetting the counts correctly based on the location, DU Type, DU Quantity & OMS Ref Poland Reports Arkadiusz Garbacik ER017-015 N N N N N
330947 - 3 Changes to the out bound file to LOTS for COL and DEL messages to nvl to planned depart and arrive times when the actuals are not populated , when deriving Transaction Date Australia u/a Suzanne Woodcock ER017-016 N N N N N
330656 INC11247922 3 Change extract to always include lifts Lutterworth EDI - Outbound Grant Wilson ER017-017 N N N N N
330751 INC11277761 5 Data fixes to the following three reports for search criteria issues: Outbound Shortage, Receipt Scanning, Driver Scanning u/a Reports Suzie Maskery ER017-018 N N N N N
330956 - 3 Code change to prevent orphaned payments when orders are deleted through the portal upload because they are invalid Australia u/a Suzanne Woodcock ER017-019 N N N N N
331038 - 3 Create order manifest for new orders created through the XML import process u/a u/a Phil Harding ER017-020 N N N N N
331071 Invalid Order sel 3 Multiple INVALID orders can be present for updating and the earliest order by OMS reference will be selected if its supplier manifest has not been closed. u/a EDI - Inbound Phil Harding ER017-021 N N N N N
330623 CR 3 When an order is cancelled in C-TMS or EPOD, this will be reflected on the PORTAL with a specific message. 3 new parameters, cost centre level, should be set to Y ORD_NO_DEL_FAILS, ORD_UNSCHEDULED_FAILS, ORD_REMOVE_CANC. Australia u/a Hayley Keegan ER017-023 N N Y N N
330557 ec3 3 Fix issue with check for duplicate files on Paragon imports. u/a Interface - Paragon Internal ER017-024 N N N N N
330651 CR 3 New import file import for loading All DU Types to a Carrier, adjustment for existing import process to assign specific DU Types to a Carrier. Both the new import and existing import will need setting up for the import type DU_TYPE, this will need the import columns configured as per functional spec (CSV import file). Once the import has been create, access will need to be granted within the group maintenance form under the import tab. Australia u/a Michelle Naumovski ER017-025 N N N N N
330624 - 3 New REN message for change of customer ref u/a u/a Hayley Keegan ER017-026 N N N N N
331146 - 3 Do not send REN message for INVALID orders u/a u/a Tina Kinsella ER017-027 N N N N N
322972 - 3 Added control parameters for mcs. Site Id, Sync Indicator and Device Setting Indicator. Australia u/a Hayley Keegan ER017-028 N N N N N
330544 DF017 3 Changes to the clob display to prevent Oracle errors u/a u/a Internal ER017-029 N N N N N
331244 DF017 3 Correct search criteria on EPOD_WSA u/a u/a Tina Kinsella ER017-030 N N N N N
331258 - 2 Changes to the selection of receipt trips to exclude locals from email pre-alerts Australia u/a Michelle Naumovski ER017-031 N N N N N
331318 - 3 Issue with DEL message selection - missing join to SCH_ORD table, join added in to prevent multiple selection Australia EDI - Outbound Hayley Keegan ER017-033 N N N N N
330324 DF-TMS-008 3 Changes for reprocessing of epod interface records u/a Interfaces Julie Scott ER017-034 N N N N N
331392 3 Changes for oms ref population under PARCEL mode. u/a u/a Javier Gomez ER017-035 N N N N N
331410 3 Remove debug message and NVL parameter u/a u/a Suzanne Woodcock ER017-036 N N N N N
330826 INC11311033 4 RPE not set on stops if trip has no carrier System parameter TRM_ENFORCE_CARRIER_RULES needs to be switched on for the relevant cost centres. Long Eaton Trips - Trip Manipulation Michael Nycz ER017-037 N N N N N
329369 - 3 Resolved oracle error displayed when accessing Orders screen from Trip Planning screens. u/a u/a Peter Crane ER017-038 N N N N N
331248 - 2 Ensure customer ref always populated u/a u/a Matthew Tipping ER017-039 N N N N N
331367 - 2 Changes to the ORS to ensure created date is converted to the local timezone of the user running the report when parameters are passed in at runtime in the screen. Australia u/a Michelle Naumovski ER017-040 N N N N N
331261 - 3 Add calendar date picker u/a u/a Pete Crane ER017-041 N N N N N
331269 - 3 Add new location usage tab page u/a u/a Pete Crane ER017-042 N N N N N
331455 - 3 Code changes to prevent _, @, % ,$ ,& from being enteredas part of the location id.Orders screen amended to prevent the wrogn location from being displayed in the LOC_DETAIL tab Australia Orders MICHELLE NAUMOVSKI ER017-043 N N Y N N
331739 Additional Change 3 from being used in Location_id Australia Orders Michelle Nauovski ER017-044 N N N N N
330718 SM-A2SP6R 4 Report amendments to include both the Schedule Name and Load Depot on the following reports ON_TIME_DROP, ON_TIME_ITEMS, ON_TIME_RETURNS, OUTBOUND_SHORTAGE, CROSS_DOCK, VOLUMN_ACTIVITY. This call also includes the changes for 330297 (SM-A2P7AP) u/a u/a Suzie Maskery ER017-045 N N N N N
331121 - 3 Fixes to Driver Scanning Report to remove duplicate records and to correctly work out scan percentage Automotive Reports Susy Maskery ER017-045 N N N N N
331763 - 1 Issue when saving new locations with the length of the location usage field Australia u/a Michelle Naumovski ER017-046 N N N N N
331824 SM-A2P7AP 3 Additional report Amendments relating to both logs 330297 & 330718, fixes issue with duplicate report parameters being displayed and allowing access to the new report On Time Arrivals. Access will need to be given to the new report On Time Arrivals via the User Access Maintenance screen using Group Maintenance and applying the export to the relevant groups u/a u/a Dave Meir ER017-047 N N N N N
331853 SM-A2SP6R 3 Additional report Amendments relating to both logs 330297 & 330718 u/a u/a Dave Meir ER017-048 N N N N N
331585 INC11701526 3 Only update quantity for single line orders within Amend value. Cherwell Trips - Trip Manipulation CALUM MCGREGOR ER017-049 N N N N N
331492 - 3 The icon that is displayed in the trip tree will refer to the system parameter called 'INCOMPLETE_ORDERS_WARNING' for the cost centre of the trip: when it is 'Y' the error of the trip will check for incomplete orders on the trip with regards to missing order items. If an error is detected for a trip then the icon will be red. The trip icon will be displayed and updated with reference to the current trip error message in the 'Trip Manipulation' and 'Trip Planning' screens. Cherwell Trips - Trip Manipulation CALUM MCGREGOR ER017-049 N N N N N
331952 - 3 Amendments to the Support Documents to include an order by based on date Australia u/a Hayley Keegan ER017-050 N N N N N
331998 SM-A2P7AP (rework) 3 Fix to On Time Arrivals Report to calculate the correct cut off time for the report. u/a u/a Dave Meir ER017-051 N N N N N
331715 - 3 Set currency in validate trip u/a u/a Matt Tipping ER017-052 N N N N N
331927 - 3 Allow orders where the delivered quantity is null or 0 to be unscheduled from COMPLETED trips, based on cost centre parameter ORD_UNSCHED_COMP u/a u/a MICHELLE NAUMOVSKI ER017-053 N N N N N
330159 Bath 054 3 Fix for route code to be populated correctly within the ORS Failed Morning Report. u/a u/a Tom Judge ER017-054 N N N N N
329360 - 3 Product fix to prevent the errors tab for diappearing on Refresh Tree u/a u/a Pete Crane - N N N N N
330528 - 3 Fix the trailer on the PCL trips so it does not keep getting reset by validation causing lots of audit records. u/a Trips Dave Meir - N N N N N
330401 - 3 Stop TRIP_ACTPD message when no recipient exists u/a Trips Dave Meir - N N N N N
331070 - 3 Alternative country code to be used for Nokia calls for Channel Islands etc. based on postal region level. u/a Setup / Maintenance Peter Crane - N N N N N
330946 - 3 Trip screen not retaining focus on selected order after edit u/a u/a Tina Kinsella - N N N N N
330794 INC11297049 1 When import process removes details for an existing order include the late reason table in the associated records to be removed. Bolton Interface - Pluto Jason Bailey - N N N N N
330915 ec5 3 Reset all NEW orders and trips for Paragon after re-spin complete. u/a Interface - Paragon Emily Collins - N N N N N
330897 - 3 Set currency when cost centre re-added to the default if only 1 currency exists for the database. u/a Orders Geoff Holliday - N N N N N
331276 - 3 Add customer to order filter in Trip Manipulation and Trip Planning u/a u/a Pete Crane - N N N N N
331176 DF020 3 Stop interface records being created with blank events and ensure all outstanding messages are only processed once. u/a u/a Emily Collins - N N N N N
330556 ec2 3 Product fix to add additional error handling and reporting into the Microlise interface package, additionally include a fix to increase the variable size of the location id within the package to prevent errors occurring. u/a Interfaces Julie Taylor - N N N N N
330770 - 4 New CMR report created u/a u/a Dave Meir - N N N N N
331438 DF022 3 Add additonal ADM messages to PAR package u/a u/a Emily Collins - N N N N N
331609 - 3 Fix to prevent Asset Management Maintenance screen from querying all data on entry. u/a u/a Dave Meir - N N N N N
329142 NA-9Z5BG9 1 Allow booking ref and book dates to be provided in paragon import and used to update the order accordingly. u/a Interface - Paragon Naved Akhtar - N N N N N
331758 - 3 Allow COMPLETED trips to be unload scanned by WCS. u/a Interface - WCS Dave Meir - N N N N N
331270 - 3 Add audit records when orders are added/removed u/a u/a Pete Crane - N N N N N


Modules Delivered

Module Name Version No Description Log Number
ASSET_MANAGEMENT.fmx 1.15 Asset Screen 331609
AT_GEO_PLAN_REGION_331070.sql 1.1 Alter Table Script 331070
AT_MCS_CONTROL_PARAM_322972.sql 1.1 Alter Table Script 322972
AT_PAR_TRIP_DTL_329142.sql 1.1 Alter Table Script 329142
CALENDAR.fmx 1.3 Calendar Pop-Up 331261
CMR.rep 1.2 CMR Report 330770
DATA_ADM_FORM_TAB_330324.sql 1.1 Data Script 330324
DATA_ADM_FORM_TAB_331763.sql 1.1 Data Script 331763
DATA_ADM_LOG_PROG_NAME_330556.sql 1.1 Data Script 330556
DATA_ADM_SYSTEM_PARAM_330324.sql 1.1 Data Script 330324
DATA_ADM_SYSTEM_PARAM_330487.sql 1.1 Data Script 330487
DATA_ADM_SYSTEM_PARAM_330623.sql 1.1 Data Script 330623
DATA_ADM_SYSTEM_PARAM_330672.sql 1.1 Data Script 330672
DATA_ADM_SYSTEM_PARAM_331927.sql 1.1 Data Script 331927
DATA_ADM_SYSTEM_PARAM_CONFIG_330623.sql 1.1 Data Script 330623
DATA_ADM_SYSTEM_PARAM_CONFIG_330672.sql 1.1 Data Script 330672
DATA_ADM_SYSTEM_PARAM_CONFIG_331927.sql 1.1 Data Script 331927
DATA_DBA_JOBS_1_330682.sql 1.2 Data Script 330682
DATA_DBA_JOBS_2_330682.sql 1.2 Data Script 330682
DATA_IMP_FIELD_329142.sql 1.1 Data Script 329142
DATA_IMP_FIELD_330651.sql 1.1 Data Script 330651
DATA_MCS_CONTROL_PARAM_322972.sql 1.2 Data Script 322972
DATA_ORS_MASTER_DATA_331367.sql 1.2 Data Script 331367
DATA_ORS_SQL_330159.sql 1.1 Data Script 330159
DATA_REP_REPORT_330770.sql 1.1 Data Script 330770
DATA_REP_REPORT_331824.sql 1.1 Data Script 331824
DATA_REP_REPORT_PARAM_330718.sql 1.1 Data Script 330718
DATA_REP_REPORT_PARAM_330770.sql 1.1 Data Script 330770
DATA_REP_REPORT_PARAM_331824.sql 1.1 Data Script 331824
DP_CSV6.sql 1.13 CSV Extract package 330656
DP_CSV6.sql 1.14 CSV Extract package 330751
DP_CSV6.sql 1.15 CSV Extract package 331121
DP_CSV6.sql 1.16 CSV Extract package 330718
DP_CSV6.sql 1.17 CSV Extract package 331824
DP_CSV6.sql 1.18 CSV Extract package 331853
DP_CSV6.sql 1.20 CSV Extract package 331998
DP_EPOD_WEB_SERVICE.sql 1.79 EPOD Web Service 330324
DP_EPOD_WEB_SERVICE.sql 1.80 EPOD Web Service 331392
DP_EPOD_WEB_SERVICE_STUB.sql 1.21 Database package 330324
DP_EPOD_WEB_SERVICE_STUB.sql 1.21 Database package 331392
DP_IMP_2.sql 1.50 Import Package 330956
DP_INT_XML_TRIP_ORD.sql 5.24 Inbound Trip XML 330794
DP_RDT_FAST_UNLOAD.sql 5.29 RF Unload Package 331758
DP_REPORTS.sql 5.34 Reports package 331258
DP_SCHEDULING_ENGINE.sql 5.88 Scheduling Package 330528
EPOD_WSA.fmx 1.3 EPOD Web Service Audit Form 330544
EPOD_WSA.fmx 1.5 EPOD Web Service Audit Form 331244
IMP.sql 5.115 CSV Imports Package 330557
IMP.sql 5.116 CSV Imports Package 330651
IMP.sql 5.117 CSV Imports Package 329142
INT_ERR.fmx 1.85 Interface Errors 330324
INT_XML_IN.sql 5.131 Order Import Package 330774
INT_XML_IN.sql 5.132 Order Import Package 331038
INT_XML_IN.sql 5.133 Order Import Package 331071
INT_XML_MIC.sql 5.121 MIC interface 330046
INT_XML_MIC.sql 5.123 MIC interface 330556
INT_XML_OUT2.sql 5.205 Outbound XML Package 330046
INT_XML_OUT2.sql 5.209 Outbound XML Package 330672
INT_XML_OUT2.sql 5.210 Outbound XML Package 330617
INT_XML_OUT2.sql 5.211 Outbound XML Package 330810
INT_XML_OUT2.sql 5.212 Outbound XML Package 330947
INT_XML_OUT2.sql 5.213 Outbound XML Package 330623
INT_XML_OUT2.sql 5.214 Outbound XML Package 330624
INT_XML_OUT2.sql 5.215 Outbound XML Package 331318
INT_XML_OUT2.sql 5.216 Outbound XML Package 331176
LOCATION.fmx 2.131 Location Maintenance 331410
LOCATION.fmx 2.132 Location Maintenance 331269
LOCATION.fmx 2.134 Location Maintenance 331455
LOCATION.fmx 2.135 Location Maintenance 331739
LOCATION.fmx 2.136 Location Maintenance 331763
MSG_PROCESSING.sql 5.53 Message Processing package 330510
OF_INT.sql 5.18 Oracle Financials interface 330423
OF_INT.sql 5.19 Oracle Financials interface 331367
OF_INT.sql 5.20 Oracle Financials interface 331952
OMS.sql 5.140 Order package 330897
OMS_INT.sql 5.6 Original Order Interface 330158
ORDERS.fmx 2.316 Order Screen 329369
ORDERS.fmx 2.317 Order Screen 331248
ORDERS.fmx 2.319 Order Screen 331261
ORDERS.fmx 2.320 Order Screen 331455
ORION.mmx 1.36 Orion Menu 329682
PAR.sql 5.65 Paragon Interface 330915
PAR.sql 5.66 Paragon Interface 331438
PAR.sql 5.67 Paragon Interface 329142
POLAND_PALLET_LABEL.rep 1.7 Label Report 330613
STATIC_DATA_MAINT.fmx 1.21 Static Data Maintenance Screen 331070
T_GEO_LOCATION_LATLONG.sql 5.7 Geo Location trigger for Lat/Long 331070
T_SCH_HAULAGE_ACTIVITY_BIU.sql 1.6 Trigger 331270
TI_SCH_ORD_STATUS.sql 1.14 Trigger on SCH_ORD for status change 330623
TIU_TRIP_STATUS.sql 5.38 Trigger on SCH_TRIP for status change 330401
TRG_SCH_ORD_INFORMATION_IU.sql 1.4 Trigger 330702
TRG_SCH_ORD_INFORMATION_IU.sql 1.5 Trigger 330623
TRG_SCH_ORD_ITEMS_REASONS.sql 5.12 Trigger 330702
TRG_SCH_ORD_LOTS.sql 5.6 Trigger 330623
TRG_SCH_ORD_LOTS.sql 5.7 Trigger 330624
TRG_SCH_ORD_LOTS.sql 5.8 Trigger 331146
TRG_SCH_ORD_NON_CONF_XML_INT.sql 5.9 Trigger 330623
TRG_SCH_ORD_TO_LOTS.sql 5.4 Trigger 331176
TRG_SOL_XML.sql 5.36 Trigger 330623
TRG_SOL_XML.sql 5.37 Trigger 331455
TRIP_PLAN.fmx 1.261 Trip Planning Screen 329360
TRIP_PLAN.fmx 1.263 Trip Planning Screen 330946
TRIP_PLAN.fmx 1.264 Trip Planning Screen 331276
TRIP_PLAN.fmx 1.265 Trip Planning Screen 331492
TRIPSUM.fmx 2.407 Trip Manipulation screen 330946
TRIPSUM.fmx 2.408 Trip Manipulation screen 331276
TRIPSUM.fmx 2.409 Trip Manipulation screen 331492
TRIPSUM.fmx 2.410 Trip Manipulation screen 331585
TRM.sql 5.136 Trip manipulation package 330826
TRM.sql 5.137 Trip manipulation package 331715
TRM.sql 5.138 Trip manipulation package 331927


New Parameters

Log Number Path & Name Config Level Setting Value Result
330672 LOTS_XFER_EXTENSION COST CENTRE .TMP Set the FTP file transfer extension before renaming back to original extension name after transfer.
330623 ORD_NO_DEL_FOR_FAILS COST_CENTRE Y Controls is DELS are suppressed for FAILED orders
330623 ORD_UNSCHEDULE_FAILS COST_CENTRE Y Controls if Orders Cancelled in EPOD generate a CANC message to LOTS
330623 ORD_REMOVE_CANC COST_CENTRE Y Controls if REM messages are sent to the PORTAL
330324 EPOD_WS_TIMEOUT SYSTEM 60 Controls the time period a failed epod message will be re-processed for.


New Access

Log Number Access Tab Name Description
330324 INT_ERR EPOD_WS_AUDIT Epod Audit Records