PATCH WMS P044

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	FTP 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	Amendment to 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	Amendment to 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
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	Change to 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 change
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.
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 01894246 (UP230530)

EPOD/T2A

There are no ePOD/T2A changes required.

MCS

There are no MCS changes required.

PORTAL/TTM

There are no Portal changes required.

EDI

There are no EDI changes required.

MANUAL

A manual change is required for the following logs:

• 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 be needed after the release, before the functionality is usable. sftp_known_hosts and Oracle Directories need to be setup