PATCH WMS P044: Difference between revisions

From Calidus HUB
VisualWikitext
No edit summary
No edit summary
Line 452: Line 452:
|width="30%"|'''Summary of Call'''|| Re-work of 02234568 - kitting issue
|width="30%"|'''Summary of Call'''|| Re-work of 02234568 - kitting issue
|-
|-
|'''Detail of Fix''' || "Improve lock handling.
|'''Detail of Fix''' || Improve lock handling. If ORDER HEADER record locked, handle lock records events correctly.
 
If ORDER HEADER record locked, handle lock records events correctly"
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 509: Line 507:
|width="30%"|'''Summary of Call'''|| Portal Order Processing
|width="30%"|'''Summary of Call'''|| Portal Order Processing
|-
|-
|'''Detail of Fix''' || "Add new rule 'DSIC' (Despatch Status Ignore Customer Setup)
|'''Detail of Fix''' || Add new rule 'DSIC' (Despatch Status Ignore Customer Setup)
   
   
If rule set to Y or 9, customer setup is ignore for despatch status, and orders are processed, order moved to status 9 (despatched) rather than F (owner POD) or G (customer POD) or I (awaiting invoicing)."
If rule set to Y or 9, customer setup is ignored for despatch status, and orders are processed, order moved to status 9 (despatched) rather than F (owner POD) or G (customer POD) or I (awaiting invoicing).
|-
|-
|'''Set-up and Configuration''' ||
|'''Set-up and Configuration''' ||
Line 545: Line 543:
|width="30%"|'''Summary of Call'''|| Pick Confirmation error
|width="30%"|'''Summary of Call'''|| Pick Confirmation error
|-
|-
|'''Detail of Fix''' || "Add new PICKCONF_LOCKED table to stop 2 users manually pick confirming the same order simultaneously.
|'''Detail of Fix''' || Add new PICKCONF_LOCKED table to stop 2 users manually pick confirming the same order simultaneously. The change only affects manually picked orders. RF and Portal processes unaffected.
 
 
The change only affects manually picked orders. RF and Portal processes unaffected."
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}
<!-- NEW PAGE -->
Line 559: Line 556:
|width="30%"|'''Summary of Call'''|| Hold / Release EDI
|width="30%"|'''Summary of Call'''|| Hold / Release EDI
|-
|-
|'''Detail of Fix''' || "Amend EDI hold/release package, so if a pallet is held with a system hold and a manual hold, allow user to change manual hold.
|'''Detail of Fix''' || Amend EDI hold/release package, so if a pallet is held with a system hold and a manual hold, allow user to change manual hold.


Note: if pallet is allocated, involved in move etc, then user will continue not to be able to change hold reason code.
Note: If pallet is allocated, involved in move etc, then user will continue not to be able to change hold reason code. Ensure if pallet is short despatched, the held quantity is correctly downdated.
 
Ensure if pallet is short despatched, the held quantity is correctly downdated."
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 574: Line 569:
|width="30%"|'''Summary of Call'''|| Orders being pick confirmed incorrectly
|width="30%"|'''Summary of Call'''|| Orders being pick confirmed incorrectly
|-
|-
|'''Detail of Fix''' || "If user enters in a range of orders, do not allow users to enter in a pick date less than pick list date of any order.
|'''Detail of Fix''' || If user enters in a range of orders, do not allow users to enter in a pick date less than pick list date of any order.


Also, add additional validation to screening (development done against log 02268738)"
Also, add additional validation to screening (development done against log 02268738)
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 585: Line 580:
{| width="100%"
{| width="100%"
|-
|-
|width="30%"|'''Summary of Call'''|| MSCI interface rework
|width="30%"|'''Summary of Call'''|| MSCI interface
|-
|-
|'''Detail of Fix''' || "Amend Shipper/Trader/Event and Pack message in regard to user feedback.
|'''Detail of Fix''' || Amend Shipper/Trader/Event and Pack message in regard to user feedback.


Rework file naming conventions to bring them into line with 414 functionality.
Rework file naming conventions to bring them into line with 414 functionality.


Ensure files are created as expected."
Ensure files are created as expected.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 611: Line 606:
{| width="100%"
{| width="100%"
|-
|-
|width="30%"|'''Summary of Call'''|| Fix issue with MSCI stock snapshot
|width="30%"|'''Summary of Call'''|| MSCI stock snapshot
|-
|-
|'''Detail of Fix''' || Amend MSCI format EDI stock snapshot in line with EDI layout issues raised by customer.
|'''Detail of Fix''' || Amend MSCI format EDI stock snapshot in line with EDI layout issues raised by customer.
Line 624: Line 619:
|width="30%"|'''Summary of Call'''|| EDI for 19c
|width="30%"|'''Summary of Call'''|| EDI for 19c
|-
|-
|'''Detail of Fix''' || "Add new 19C directory creation process.
|'''Detail of Fix''' || Add new 19C directory creation process.


Change controlled by 4 new COMPANY level fields which are not user maintainable, but if set, will control the EDI directory paths the user can enter.
Change controlled by 4 new COMPANY level fields which are not user maintainable, but if set, will control the EDI directory paths the user can enter.
Line 633: Line 628:


grant create any directory to public;
grant create any directory to public;
grant drop any directory to public;"
 
grant drop any directory to public;
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 653: Line 649:
{| width="100%"
{| width="100%"
|-
|-
|width="30%"|'''Summary of Call'''|| MSCI rework - Order Detail trigger not generating records
|width="30%"|'''Summary of Call'''|| MSCI &#45; Order Detail trigger not generating records
|-
|-
|'''Detail of Fix''' || "Amend order trigger to ensure that MSCI_ORD record is written.
|'''Detail of Fix''' || Amend order trigger to ensure that MSCI_ORD record is written.


Amend XML tags in trader message to fix issues."
Amend XML tags in trader message to fix issues.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 666: Line 662:
{| width="100%"
{| width="100%"
|-
|-
|width="30%"|'''Summary of Call'''|| MSCI Inventory file re-work
|width="30%"|'''Summary of Call'''|| MSCI Inventory file
|-
|-
|'''Detail of Fix''' || "Inventory message – amend <InventoryProductQuantities> segment reporting, so it written once per file, not once per stock code.
|'''Detail of Fix''' || Inventory message &#45; amend <InventoryProductQuantities> segment reporting, so it written once per file, not once per stock code.


Event message – change data reported in the <TrackingIdentifier>.  The field now displays order number rather than the order reference.
Event message &#45; change data reported in the <TrackingIdentifier>.  The field now displays order number rather than the order reference.


Update: as per user request, the Event message changes have been removed from the release."
Update: as per user request, the Event message changes have been removed from the release.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}
<!-- NEW PAGE -->
== Aptean Log Number: 02270721 ==
== Aptean Log Number: 02270721 ==
Line 683: Line 680:
|width="30%"|'''Summary of Call'''|| RF Pick Confirmation
|width="30%"|'''Summary of Call'''|| RF Pick Confirmation
|-
|-
|'''Detail of Fix''' || "Amend log message to ensure that the date passed is 'g_date' rather than 'sysdate'.
|'''Detail of Fix''' || Amend log message to ensure that the date passed is 'g_date' rather than 'sysdate'.


Ensure g_route_code/g_load_number reset correctly every message.
Ensure g_route_code/g_load_number reset correctly every message.


WDD created from pallet exchange are created with the sell by date of the new pallet."
WDD created from pallet exchange are created with the sell by date of the new pallet.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 731: Line 728:
|width="30%"|'''Summary of Call'''|| Unable to retrieve picks on RF
|width="30%"|'''Summary of Call'''|| Unable to retrieve picks on RF
|-
|-
|'''Detail of Fix''' || Ensure when user swapping OOS line with valid pallet, a 341 message is sent with corresponding 121 records
|'''Detail of Fix''' || Ensure when user swapping OOS line with valid pallet, a 341 message is sent with corresponding 121 records.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 773: Line 770:
|width="30%"|'''Summary of Call'''|| EDI Data Maps incorrect
|width="30%"|'''Summary of Call'''|| EDI Data Maps incorrect
|-
|-
|'''Detail of Fix''' || "EDI Maps script re-worked to handle layout.  
|'''Detail of Fix''' || EDI Maps script re-worked to handle layout.  
Change tested in both WMSdev and WMStst, using customer file as test file."
Change tested in both WMSdev and WMStst, using customer file as test file.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 796: Line 793:
|width="30%"|'''Summary of Call'''|| GRN confirmation WHS0150 - seals references are missing
|width="30%"|'''Summary of Call'''|| GRN confirmation WHS0150 - seals references are missing
|-
|-
|'''Detail of Fix''' || "WHS0150 - Stop users from running 'next_btn' when unsaved container details exist
|'''Detail of Fix''' || WHS0150 - Stop users from running 'next_btn' when unsaved container details exist


WHS0110 - Stop users from running 'send rf' button when unsaved container details exist
WHS0110 - Stop users from running 'send rf' button when unsaved container details exist.
"
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 810: Line 806:
|width="30%"|'''Summary of Call'''|| Inbound SFTP functionality
|width="30%"|'''Summary of Call'''|| Inbound SFTP functionality
|-
|-
|'''Detail of Fix''' || "The DP_PROCESS_CONTROL_XFM package is being modified now to send and pull the files from the client-server.
|'''Detail of Fix''' || The DP_PROCESS_CONTROL_XFM package is being modified now to send and pull the files from the client-server.
Changed the GET_FILE call directory parameter (amended file_name) to the directory path."
Changed the GET_FILE call directory parameter (amended file_name) to the directory path.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 827: Line 823:
|}
|}
<!-- NEW PAGE -->
== Aptean Log Number: 02574548 ==
== Aptean Log Number: 02574548 ==
Line 886: Line 883:
{| width="100%"
{| width="100%"
|-
|-
|width="30%"|'''Summary of Call'''|| Re-work putaway algo G
|width="30%"|'''Summary of Call'''|| Putaway algo G
|-
|-
|'''Detail of Fix''' || "Amend functionality of put-away algo G
|'''Detail of Fix''' || Amend functionality of put-away algo G


Functionality will look initially for an empty anchor-point put-away location.
Functionality will look initially for an empty anchor-point put-away location.


If not setup or not empty, pallets will ONLY be put in empty bulk locations, even if an empty pick location is available and or nearer."
If not setup or not empty, pallets will ONLY be put in empty bulk locations, even if an empty pick location is available and or nearer.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 903: Line 900:
|width="30%"|'''Summary of Call'''|| Goods receipt by RF &#45; auto hold not working
|width="30%"|'''Summary of Call'''|| Goods receipt by RF &#45; auto hold not working
|-
|-
|'''Detail of Fix''' || "Amend RFT GRN pallet creation process, so stock codes with a blank auto quarantine flag are handled the same way as stock codes with an N (No) auto quarantine flag.
|'''Detail of Fix''' || Amend RFT GRN pallet creation process, so stock codes with a blank auto quarantine flag are handled the same way as stock codes with an N (No) auto quarantine flag.
"
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 915: Line 911:
|width="30%"|'''Summary of Call'''|| Issue with Free Generation
|width="30%"|'''Summary of Call'''|| Issue with Free Generation
|-
|-
|'''Detail of Fix''' || "DP_WARE_LOC package has been modified to set the location_status to '6' at the time of free locations generation.
|'''Detail of Fix''' || DP_WARE_LOC package has been modified to set the location_status to '6' at the time of free locations generation.
This log is being released under 02263025."
This log is being released under 02263025.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 938: Line 934:
|width="30%"|'''Summary of Call'''|| Release log for 00481793
|width="30%"|'''Summary of Call'''|| Release log for 00481793
|-
|-
|'''Detail of Fix''' || "Replicate changes made in branch log 00481793 into main version.
|'''Detail of Fix''' || Replicate changes made in branch log 00481793 into main version.


For MSCI message, ensure the apostrophes are replaced with '&apos;' rather than '&aps;'."
For MSCI message, ensure the apostrophes are replaced with '&apos;' rather than '&aps;'.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}


= PRODUCT DEVELOPMENT =
<!--
== OBS Log Number:  ==
{| width="100%"
|-
|width="30%"| '''Reporter:''' ||
|-
|'''Summary of Call'''||
|-
|'''Detail of Fix''' ||
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
-->
== OBS Log Number:  ==
{| width="100%"
|-
|width="30%"| '''Reporter:''' ||
|-
|'''Summary of Call'''||
|-
|'''Detail of Fix''' ||
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}




Revision as of 13:10, 13 October 2023





Aptean Logo.png







CALIDUS WMS

Release Notes

CALIDUS WMS

8th Sep 2023 - 1.0
Reference: P044











































SUMMARY INTRODUCTION

INTRODUCTION

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


GLOSSARY OF TERMS

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


TESTING PROCESS

TIDs AND RESOLUTION

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


FINAL 'END TO END' TESTING

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


AUTHORISATION

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


CHANGE REQUESTS

Aptean Log Number: 02141290

Summary of Call OK to Ship
Detail of Fix Add new 'Okay to Ship' process

New EDI inbound process to upload data

New screen WHS1810 (Okay to Ship Enquiry) to allow users to view and 'override' the 'okay to ship' flag

New 'Ok to Ship' ORS report.

New screen WHS1810 added to OF_WHS000070 (Despatch) menu

Set-up and Configuration


New Access
Access Tab Name Description
Warehouse/Despatch WHS1810.fmx Okay To Ship Enquiry


New Parameters
Parameter Name Config Level Setting Value Result
OK2S Owner Y Orders must be marked as 'Okay to Ship' before orders can be despatched.
Okay to Ship Owner Any other value No change in functionality


Aptean Log Number: 02144277

Summary of Call ORS Change
Detail of Fix The Container Details ORS report (CY_CON_DTL) is changed to add 'Seal' values.

The 'Inbound Method' and 'Owner' fields are changes to allow the user to enter these values as ranges

The Container Movement ORS report (CY_MOV_DTL) is changed to allow users to enter 'Movement Type', 'Service' and 'Carrier' values as ranges

Note: new ORS reports will need to be created to pick up the changes

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


Aptean Log Number: 02261048

Summary of Call Packing List
Detail of Fix Created new GS2 format despatch note/picking list
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 02228562

Summary of Call MySupplyChain - Development
Detail of Fix Create new MSCI (My Supply Chain) interface functionality

Generate 5 new messages

Order Creation/Amendment - Shipper/Trader Message

Order Allocation-Pick-Cancellation - Event Message

Order Despatch - Pack Message

Stock Snapshot - Inventory Message

Changes will be controlled by MSCI rule (My Supply Chain Interface) - can be set at either owner or warehouse.

Set-up and Configuration


New Parameters
Parameter Name Config Level Setting Value Result
MSCI (My Supply Chain Interface) WHSE/OWNR Y If OWNR record not found, process will check for WHSE record.

If rule flag set to Yes AND EDI process record for owner found, then outbound MSCI_ORD, MSCI_ORD_EVENT or MSCI_ORD_PACK records will be written

- - Not set or any other value No new records will be set.


Aptean Log Number: 02525154

Summary of Call FTT to SFTP changes
Detail of Fix Add new SFTP functionality to WMS

Allow files to be sent

NOTE: Setup will need to be done after release before the functionality is usable. Sftp_known_hosts and Oracle Directories need to be setup

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


Aptean Log Number: 02575028

Summary of Call WREQ0087817: Pack List changes
Detail of Fix The GS2 format despatch note now displays the 'Customer Ref' rather than 'Order Reference' as 'Request ID'

New AKAV (AKA Validation) owner rule to control the AKA Stock Code value.

Set-up and Configuration


New Parameters
Parameter Name Config Level Setting Value Result
AKAV Owner Y If inventory exist, do not let a populated AKA stock code value be changed
AKA Validation Owner N or any other value No change in functionality


Aptean Log Number: 02590029

Summary of Call Despatch Note Format
Detail of Fix Create new JAK format despatch note
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 02569544

Summary of Call Required addition of alcohol content and lot numbers to purchase receipts, putaway.
Detail of Fix Add new GRAS (Goods Receipt Alcohol Strength) owner rule to control population of new ALCOHOL STRENGTH field.
Set-up and Configuration


New Parameters
Parameter Name Config Level Setting Value Result
GRAS Owner Y Enable setting of new Alcohol Strength field
Goods Receipt Alcohol Strength Owner Any other setting No change in functionality.


Aptean Log Number: 02680036

Summary of Call Add cust pallet no to Desp conf screen
Detail of Fix Add new owner level DDCP (Dispatch Display Customer Pallet id) rule.

If set to Yes, the screen now shows the Customer Pallet id (Cust Pallet Id) plus a new 'change display' button, rather than Location Check Digit field (C/D) and System Pallet Id (Pallet).

If not set, there will be no change in functionality.

Set-up and Configuration


New Parameters
Parameter Name Config Level Setting Value Result
DDCP Owner Y The screen now shows the Customer Pallet id (Cust Pallet Id) plus a new 'change display' button, rather than Location Check Digit field (C/D) and System Pallet Id (Pallet).
DDCP Owner Not set or any other value No change in functionality.


Aptean Log Number: 02704846

Summary of Call CR - Amending the DCX7 segment in the pack an despatch messages
Detail of Fix Add new owner level DPR1 (Display Pack Ref1) rule, which if set, will add the Pack Ref1 (Pack Ref1 of Pack Level) to the end of DC17/87 and D016/86 message segments.

If not set, segments unchanged.

Set-up and Configuration


New Parameters
Parameter Name Config Level Setting Value Result
DPR1 Owner Y Pack and Despatch DC17/87 and D016/86 message amended to contain Pack Ref1 value.
DPR1 Owner Not set/any other value No change in functionality



SUPPORT INCIDENTS

Aptean Log Number: 02584124

Summary of Call Receipt message with no location
Detail of Fix Ensure if rotation no populated by customer rotation no, value is only written if valid.

Also ensure it checks both WARE_PARAMS and OWNER_WARE_PARAMS tables when checking for rotation length.

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


Aptean Log Number: 02683284

Summary of Call Pallets lost hold reason code
Detail of Fix When AHSO rule set to C, don't allow allocated pallets to have hold removed.
Set-up and Configuration No set-up/configuration required



TID CHANGES

Aptean Log Number: 00375145

Summary of Call Issue with WHR1900_GSK with order M2500000000000000025 / warehouse IS2
Detail of Fix Address change fix. Fix issue where town displayed twice in delivery address. Post code not displayed.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 02234568

Summary of Call Kitting issue
Detail of Fix Added reset to t_excess variables (case/unit/qty) so if any value not set, will not inherit value from previous line.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 00416716

Summary of Call Re-work of 02234568 - kitting issue
Detail of Fix Adding locking check to stop 2 users from confirming the same kitting order simultaneously.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 00427137

Summary of Call Re-work of 02234568 - kitting issue
Detail of Fix Improve lock handling. If ORDER HEADER record locked, handle lock records events correctly.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 00431089

Summary of Call Stock Kit rework
Detail of Fix Fix oracle error when user enters screen and exits without entering any details
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 00431645

Summary of Call Fix issue with SOS1428
Detail of Fix Change made to canvas to ensure screen works in 12c environment the same it does in 11g.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 00443937

Summary of Call Serial Number rework
Detail of Fix Fixed issue so that 'create range' button now returns a value.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 02557468

Summary of Call Handling of returns charges
Detail of Fix Change to correct handling of returns charges
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 02110977

Summary of Call Portal Order Processing
Detail of Fix Add new rule 'DSIC' (Despatch Status Ignore Customer Setup)

If rule set to Y or 9, customer setup is ignored for despatch status, and orders are processed, order moved to status 9 (despatched) rather than F (owner POD) or G (customer POD) or I (awaiting invoicing).

Set-up and Configuration


New Parameters
Parameter Name Config Level Setting Value Result
'DSIC' Owner / Warehouse Y If no error occurs, order marked as status 9 (despatched) rather than F, G or I (depending on customer setup).
Despatch Status Ignore Customer Setup Note: owner rule setup supersedes warehouse 9 If no error occurs, order marked as status 9 (despatched) rather than F, G or I (depending on customer setup).
- - Not set or any other value No change in value


Aptean Log Number: 02268738

Summary of Call Pick Confirmation error
Detail of Fix Add new PICKCONF_LOCKED table to stop 2 users manually pick confirming the same order simultaneously. The change only affects manually picked orders. RF and Portal processes unaffected.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 02280115

Summary of Call Hold / Release EDI
Detail of Fix Amend EDI hold/release package, so if a pallet is held with a system hold and a manual hold, allow user to change manual hold.

Note: If pallet is allocated, involved in move etc, then user will continue not to be able to change hold reason code. Ensure if pallet is short despatched, the held quantity is correctly downdated.

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


Aptean Log Number: 02441057

Summary of Call Orders being pick confirmed incorrectly
Detail of Fix If user enters in a range of orders, do not allow users to enter in a pick date less than pick list date of any order.

Also, add additional validation to screening (development done against log 02268738)

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


Aptean Log Number: 00455345

Summary of Call MSCI interface
Detail of Fix Amend Shipper/Trader/Event and Pack message in regard to user feedback.

Rework file naming conventions to bring them into line with 414 functionality.

Ensure files are created as expected.

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


Aptean Log Number: 02563358

Summary of Call Invalid password error
Detail of Fix Modified the form to mitigate the password incorrect error.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 00470931

Summary of Call MSCI stock snapshot
Detail of Fix Amend MSCI format EDI stock snapshot in line with EDI layout issues raised by customer.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 02127197

Summary of Call EDI for 19c
Detail of Fix Add new 19C directory creation process.

Change controlled by 4 new COMPANY level fields which are not user maintainable, but if set, will control the EDI directory paths the user can enter.

When user enters/updates/deletes EDI directory data, the new process will create and or delete unix and oracle folders as appropriate.

The following 2 grants must be applied as part of release:

grant create any directory to public;

grant drop any directory to public;

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


Aptean Log Number: 02530103

Summary of Call Order quantity changed before GENORD message
Detail of Fix Add new functionality for line type 3, 4, 5 and 6 order lines, so a check will be made to see if duplicate order lines exist. If duplicate lines exist, check to see if the total values exceed available values.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 00476115

Summary of Call MSCI - Order Detail trigger not generating records
Detail of Fix Amend order trigger to ensure that MSCI_ORD record is written.

Amend XML tags in trader message to fix issues.

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


Aptean Log Number: 00478176

Summary of Call MSCI Inventory file
Detail of Fix Inventory message - amend <InventoryProductQuantities> segment reporting, so it written once per file, not once per stock code.

Event message - change data reported in the <TrackingIdentifier>. The field now displays order number rather than the order reference.

Update: as per user request, the Event message changes have been removed from the release.

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


Aptean Log Number: 02270721

Summary of Call RF Pick Confirmation
Detail of Fix Amend log message to ensure that the date passed is 'g_date' rather than 'sysdate'.

Ensure g_route_code/g_load_number reset correctly every message.

WDD created from pallet exchange are created with the sell by date of the new pallet.

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


Aptean Log Number: 02277297

Summary of Call WL-695: Date on Pick Records
Detail of Fix Sell by date set correctly on pick records when the pallet has been exchanged
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 02549600

Summary of Call Pallet Exchange leaving reason 79 on some pallets
Detail of Fix The RDT pick confirmation of an exchanged pallet will lock and delete the held stock records for reason code '79'.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 00481210

Summary of Call MSCI SFTP timing issue
Detail of Fix Amend SFTP process, so files created the same minute the poller is run, can be sent.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 02532605

Summary of Call Unable to retrieve picks on RF
Detail of Fix Ensure when user swapping OOS line with valid pallet, a 341 message is sent with corresponding 121 records.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 00479522

Summary of Call Picker to trigger pick face replen when required
Detail of Fix Create new SAPP (Soft Allocate Part Pick Tasks) to allow for new RF part pick functionality by creating new unallocated 'dummy' pick tasks. When the RF pick tasks are completed, delete 'dummy' picks.

Release log for change 01894246 (Dynamic Replens to Defined Pick Location)

Set-up and Configuration


New Parameters
Parameter Name Config Level Setting Value Result
SAPP Owner Y For part picks in pick locations, create 'dummy' allocation records, to be passed to RF.
Soft Allocate Part Pick Tasks - Any other value/not set No change in functionality


Aptean Log Number: 00485583

Summary of Call EDI Data Maps incorrect
Detail of Fix EDI Maps script re-worked to handle layout.

Change tested in both WMSdev and WMStst, using customer file as test file.

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


Aptean Log Number: 02673931

Summary of Call Missing message
Detail of Fix Missing error message for OK to Ship development - Add dynamic message missed from Dev 02141290.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 02659763

Summary of Call GRN confirmation WHS0150 - seals references are missing
Detail of Fix WHS0150 - Stop users from running 'next_btn' when unsaved container details exist

WHS0110 - Stop users from running 'send rf' button when unsaved container details exist.

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


Aptean Log Number: 00485427

Summary of Call Inbound SFTP functionality
Detail of Fix The DP_PROCESS_CONTROL_XFM package is being modified now to send and pull the files from the client-server.

Changed the GET_FILE call directory parameter (amended file_name) to the directory path.

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


Aptean Log Number: 02664000

Summary of Call Pick tasks not going to gun
Detail of Fix Ensure move completion message is sent to WCS when a move is confirmed in WMS
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 02574548

Summary of Call Allocation by order range
Detail of Fix Amend Order Number LOV to improve performance.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 02654727

Summary of Call Returns report
Detail of Fix Amend discount calculation so report and pdf report the same data.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 02601949

Summary of Call Calidus removed an order line
Detail of Fix Add extra validation to line type 5 order line functionality, so if a record lock occurs, the functionality handles the issue, and rejects the whole order.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 02693043

Summary of Call Manufacture date not set on pallets
Detail of Fix Ensure that the field manufacturing date on the table Ware Location Entries is always set, when required by stock setup.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 02683713

Summary of Call Pick Confirmation - pick lock
Detail of Fix Amended pick confirmation screen, so when users finds any records, any 'old' lock records linked to those orders, which were created by that user are deleted.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 00508533

Summary of Call Putaway algo G
Detail of Fix Amend functionality of put-away algo G

Functionality will look initially for an empty anchor-point put-away location.

If not setup or not empty, pallets will ONLY be put in empty bulk locations, even if an empty pick location is available and or nearer.

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


Aptean Log Number: 02602347

Summary of Call Goods receipt by RF - auto hold not working
Detail of Fix Amend RFT GRN pallet creation process, so stock codes with a blank auto quarantine flag are handled the same way as stock codes with an N (No) auto quarantine flag.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 00364604

Summary of Call Issue with Free Generation
Detail of Fix DP_WARE_LOC package has been modified to set the location_status to '6' at the time of free locations generation.

This log is being released under 02263025.

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


Aptean Log Number: 02263025

Summary of Call Automatic Location Generation
Detail of Fix Modified the package to mitigate the extra space error for location_type and also added changes to set the location_status to '6' at the time of free_locations generation
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 00514977

Summary of Call Release log for 00481793
Detail of Fix Replicate changes made in branch log 00481793 into main version.

For MSCI message, ensure the apostrophes are replaced with ''' rather than '&aps;'.

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



MODULES DELIVERED

Module Name Version No Description Log Number
AT_COMPANY_02127197.sql 4.1 AT Script 02127197
AT_EDI_GRN_CONF_DETAIL_OUT_02569544.sql 4.1 AT Script 02569544
AT_EDI_PRE_ADVICE_DETAIL_IN_02569544.sql 4.2 AT Script 02569544
AT_EDI_PRODUCT_MASTER_02569544.sql 4.1 AT Script 02569544
AT_ORDER_HEADER_02141290.sql 4.1 AT Script 02141290
AT_STOCK_02569544.sql 4.1 AT Script 02569544
AT_STOCK_AUDIT_02569544.sql 4.1 AT Script 02569544
AT_WARE_GOODS_ENTRY_DETAILS_02569544.sql 4.1 AT Script 02569544
CT_EDI_OK_TO_SHIP_DETS_02141290.sql 4.3 CT Script 02141290
CT_MSCI_ORD_02228562.sql 4.1 CT Script 02228562
CT_MSCI_ORD_EVENT_02228562.sql 4.1 CT Script 02228562
CT_MSCI_ORD_INV_SEQ_02228562.sql 4.1 CT Script 02228562
CT_MSCI_ORD_NSE_SEQ_02228562.sql 4.1 CT Script 02228562
CT_MSCI_ORD_NSP_SEQ_02228562.sql 4.1 CT Script 02228562
CT_MSCI_ORD_PACK_02228562.sql 4.1 CT Script 02228562
CT_MSCI_ORD_SHP_SEQ_02228562.sql 4.1 CT Script 02228562
CT_MSCI_ORD_TRD_SEQ_02228562.sql 4.1 CT Script 02228562
CT_OK_TO_SHIP_DETS_02141290.sql 4.2 CT Script 02141290
CT_PICKCONF_LOCKED_02268738.sql 4.1 CT Script 02268738
CT_PICKCONF_LOCKED_02268738.sql 4.1 CT Script 02280115
CT_SFTP_KNOWN_HOSTS_02525154.sql 4.1 CT Script 02525154
DATA_DYNAMIC_MESSAGES_00416716.sql 4.1 Data Script 00416716
DATA_DYNAMIC_MESSAGES_00427137.sql 4.1 Data Script 00427137
DATA_DYNAMIC_MESSAGES_02127197.sql 4.1 Data Script 02127197
DATA_DYNAMIC_MESSAGES_02441057.sql 4.2 Data Script 02441057
DATA_DYNAMIC_MESSAGES_02530103.sql 4.1 Data Script 02530103
DATA_DYNAMIC_MESSAGES_02575028.sql 4.1 Data Script 02575028
DATA_DYNAMIC_MESSAGES_02673931.sql 4.1 Data Script 02673931
DATA_EDI_MAPS_02141290.sql 4.1 Data Script 02141290
DATA_EDI_MAPS_02569544.sql 4.2 Data Script 02569544
DATA_EDI_MAPS_02667631.sql 4.3 Data Script 00485583
DATA_FXM_OPTIONS_02141290.sql 4.1 Data Script 02141290
DATA_FXM_SCREENS_02141290.sql 4.1 Data Script 02141290
DATA_ML_CAPTIONS_02261048.sql 4.1 Data Script 02261048
DATA_ML_CAPTIONS_02525154.sql 4.1 Data Script 02525154
DATA_ML_CAPTIONS_02590029.sql 4.1 Data Script 02590029
DATA_ORS_MASTER_DATA_02141290.sql 4.2 Data Script 02141290
DATA_ORS_MASTER_DATA_02144277.sql 4.1 Data Script 02144277
DATA_ORS_SQL_02141290.sql 4.1 Data Script 02141290
DATA_WAREHOUSE_RULES_02110977.sql 4.2 Data Script 02110977
DATA_WAREHOUSE_RULES_02141290.sql 4.2 Data Script 02141290
DATA_WAREHOUSE_RULES_02569544.sql 4.1 Data Script 02569544
DATA_WAREHOUSE_RULES_02575028.sql 4.1 Data Script 02575028
DATA_WAREHOUSE_RULES_02680036.sql 4.1 Data Script 02680036
DATA_WAREHOUSE_RULES_02704846.sql 4.1 Data Script 02704846
DATA_WAREHOUSE_RULES_CONTROL_00455345.sql 4.1 Data Script 00455345
DATA_WAREHOUSE_RULES_CONTROL_00479522.sql 4.1 Data Script 00479522
DATA_WAREHOUSE_RULES_CONTROL_02110977.sql 4.1 Data Script 02110977
DATA_WAREHOUSE_RULES_CONTROL_02141290.sql 4.1 Data Script 02141290
DATA_WAREHOUSE_RULES_CONTROL_02569544.sql 4.1 Data Script 02569544
DATA_WAREHOUSE_RULES_CONTROL_02575028.sql 4.1 Data Script 02575028
DATA_WAREHOUSE_RULES_CONTROL_02680036.sql 4.1 Data Script 02680036
DATA_WAREHOUSE_RULES_CONTROL_02704846.sql 4.1 Data Script 02704846
DATA_XF_COMMAND_02141290.sql 4.1 Data Script 02141290
DATA_XF_SUBMIT_DETAIL_02141290.sql 4.1 Data Script 02141290
DATA_XF_SUBMIT_HEADER_02141290.sql 4.1 Data Script 02141290
DP_COPY_OWNER_EDI.sql 4.7 Owner EDI Copy Package 02127197
DP_DESPATCH.sql 4.118 Despatch Confirmation Package 1 02110977
DP_DESPATCH.sql 4.119 Despatch Confirmation Package 1 02280115
DP_EDI_OUTBOUND.sql 4.110 EDI Outbound Receipt Confirmation 02569544
DP_EDIGEN_HOLD_VAL.sql 4.31 EDI Inbound Holds Validation Package 02280115
DP_EDIGEN_HOLD_VAL.sql 4.32 EDI Inbound Holds Validation Package 02683284
DP_EDIGEN_OK_TO_SHIP_LOAD.sql 4.1 New inbound Edi okay to ship load package 02141290
DP_EDIGEN_OK_TO_SHIP_VAL.sql 4.1 New inbound Edi okay to ship validation package 02141290
DP_EDIGEN_OUT_PDP_CONF.sql 4.163 Outbound EDI Generation 02228562
DP_EDIGEN_OUT_PDP_CONF.sql 4.164 Outbound EDI Generation 00455345
DP_EDIGEN_OUT_PDP_CONF.sql 4.165 Outbound EDI Generation 00476115
DP_EDIGEN_OUT_PDP_CONF.sql 4.168 Outbound EDI Generation 02704846
DP_EDIGEN_OUT_PDP_CONF.sql 4.169 Outbound EDI Generation 00514977
DP_EDIGEN_OUT_RECEIPT_CONFIRM.sql 4.71 Receipt conf outbound file creation 02569544
DP_EDIGEN_OUT_ST_BAL.sql 4.100 STK balance flat file package 02228562
DP_EDIGEN_OUT_ST_BAL.sql 4.101 STK balance flat file package 00455345
DP_EDIGEN_OUT_ST_BAL.sql 4.102 STK balance flat file package 00470931
DP_EDIGEN_OUT_ST_BAL.sql 4.103 STK balance flat file package 00478176
DP_EDIGEN_OUTBOUND.sql 4.16 Outbound EDI 02569544
DP_EDIGEN_PRE_ADVICE_LOAD.sql 4.72 WMS Pre Advice EDI load 02569544
DP_EDIGEN_PRE_ADVICE_VAL.sql 4.94 EDI Pre-Advice Validation 02569544
DP_EDIGEN_PROD_VAL.sql 4.53 Inbound EDI Stock Upload Validation 02575028
DP_EDIGEN_PROD_VAL.sql 4.54 Inbound EDI Stock Upload Validation 02569544
DP_EDIGEN_PRODUCT_MASTER_LOAD.sql 4.41 EDI Stock Table Upload 02569544
DP_EDIGEN_SALES_ORDER_VAL.sql 4.234 Order_Header update package 02530103
DP_EDIGEN_SALES_ORDER_VAL.sql 4.235 Order_Header update package 02601949
DP_PICK_CONF_1.sql 4.84 Pick Confirmation Database Package 1 02268738
DP_PICK_CONF_1.sql 4.86 Pick Confirmation Database Package 1 02280115
DP_PICK_CONF_1.sql 4.87 Pick Confirmation Database Package 1 02441057
DP_PICK_CONF_1.sql 4.88 Pick Confirmation Database Package 1 00479522
DP_PICK_CONF_1.sql 4.89 Pick Confirmation Database Package 1 02683713
DP_PICK_CONF_2.sql 4.38 Pick Confirmation Database Package 2 02280115
DP_PORTAL.sql 4.30 Portal Package 02141290
DP_PROCESS_CONTROL_XFM.sql 4.39 Outbound process control 02525154
DP_PROCESS_CONTROL_XFM.sql 4.40 Outbound process control 00481210
DP_PROCESS_CONTROL_XFM.sql 4.42 Outbound process control 00485427
DP_RDT.sql 4.56 RDT Messages 00479522
DP_RDT_GRNCONF.sql 4.78 RDT Goods Receipt Confirmation 02584124
DP_RDT_GRNCONF.sql 4.79 RDT Goods Receipt Confirmation 02602347
DP_RDT_PICK_CONF.sql 4.138 RDT Pick Confirmation 02270721
DP_RDT_PICK_CONF.sql 4.139 RDT Pick Confirmation 02277297
DP_RDT_PICK_CONF.sql 4.140 RDT Pick Confirmation 02549600
DP_RDT_PICK_CONF.sql 4.141 RDT Pick Confirmation 00479522
DP_RDT_PICK_REQUEST.sql 4.65 Pick Request Database Package 00479522
DP_RDT_STKENQ.sql 4.40 RDT Stock Enquiry processing 00479522
DP_SERIALS_2.sql 4.18 Medical/Serial Number entry/validation package 00443937
DP_SFTP.sql 4.1 SFTP package 02525154
DP_SOR7055.sql 4.19 Amendment History Report (CSV format) 02654727
DP_SOS1428.sql 4.4 Generic WMS kit assembly 02234568
DP_SOS1428.sql 4.5 Generic WMS kit assembly 00416716
DP_SOS1428.sql 4.6 Generic WMS kit assembly 00427137
DP_SOS1428.sql 4.7 Generic WMS kit assembly 00431089
DP_UNIX_FILES.sql 4.26 Database Package 02127197
DP_UPM_RENT.sql 4.34 Package to generate rent charges 02557468
DP_UTL_FILE.sql 4.1 WMS/UTL File 02127197
DP_WARE_LOC.sql 4.35 Free Location Generation – database package 00364604
DP_WARE_LOC.sql 4.36 Free Location Generation – database package 02263025
DP_WHS2185.sql 4.33 Suggested Location database package 00508533
DP_WMS_ALLOC.sql 4.205 Allocation Procedure 00479522
filelist_sftp.ksh 4.1 Ksh file 00481210
PFS1510_GEN.fmx 4.29 Generic Inbound EDI pre-advice 02569544
PFS1520.fmx 4.19 Product Master Validation 02569544
SOR7055.rdf 4.26 Amendment Report 02654727
SOS1428.fmx 4.21 Stock Kits Assembly Request 00416716
SOS1428.fmx 4.22 Stock Kits Assembly Request 00427137
SOS1428.fmx 4.23 Stock Kits Assembly Request 00431645
SOS7100.fmx 4.9 Deals Maintenance Form 02563358
STKSTOC01B.fmx 4.105 Stock Maintenance 02575028
STKSTOC01B.fmx 4.106 Stock Maintenance 02569544
TRG_FREE_TYPE_ADDRESS_AIUDR.sql 4.3 Order Free Type Address Trigger 02228562
TRG_ORDER_DETAIL_AIR.sql 4.6 Order Detail Trigger 02228562
TRG_ORDER_DETAIL_AIR.sql 4.8 Order Detail Trigger 00455345
TRG_ORDER_DETAIL_AIR.sql 4.9 Order Detail Trigger 00476115
TRG_ORDER_HEADER_AIR.sql 4.7 Order Header Trigger 02228562
TRG_ORDER_HEADER_AIR.sql 4.9 Order Header Trigger 00455345
TRG_WARE_LOCATION_ENTRIES_BIR.sql 4.13 Trigger to create master sequence 02693043
WHR1900_GS2.rdf 4.3 GS2 format despatch note 02261048
WHR1900_GS2.rdf 4.4 GS2 format despatch note 02575028
WHR1900_GSK.rdf 4.16 GSK format despatch note 00375145
WHR1900_JAK.rdf 4.1 JAK format despatch note 02590029
WHS0110.fmx 4.96 Goods Receipt Pre-Advice 02569544
WHS0110.fmx 4.97 Goods Receipt Pre-Advice 02659763
WHS0150.fmx 4.158 Goods Receipt Confirmation 02659763
WHS0200.fmx 4.22 Pick by Line Ticket Print Kick Off 00443937
WHS0700.fmx 4.74 Warehouse Movements 02664000
WHS1710A.fmx 4.104 Pick List Confirmation 02268738
WHS1710A.fmx 4.105 Pick List Confirmation 02280115
WHS1710A.fmx 4.107 Pick List Confirmation 02441057
WHS1710A.fmx 4.108 Pick List Confirmation 02532605
WHS1710A.fmx 4.109 Pick List Confirmation 00479522
WHS1714.fmx 4.139 Pick Confirmation 02268738
WHS1714.fmx 4.142 Pick Confirmation 02441057
WHS1714.fmx 4.143 Pick Confirmation 02683713
WHS1810.fmx 4.3 Stock to Production Confirmation 02141290
WHS1910.fmx 4.95 Despatch Confirmation 02141290
WHS1910A.fmx 4.13 Despatch Confirmation 02680036
WHSORA010.fmx 4.92 Allocation Kick-off 02574548
XFM0020.fmx 4.67 XF Monitor 02127197
XFM0020.fmx 4.68 XF Monitor 02525154


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:

  • Log

OR

There are no EDI changes required.

MANUAL

  • Log 02127197

The following 2 grants must be applied as part of release:

  • grant create any directory to public;
  • grant drop any directory to public;
  • LOG 02525154

Setup will need to be done after release before the functionality is usable. sftp_known_hosts and Oracle Directories need to be setup


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