View source for FS 291253 PW-8KRCWE Prioritise WMS-WCS Messages

<div class="noprint">
{{#vardefine:Client|DHL}}
{{#vardefine:ClientName|DHL Atherstone}}
{{#vardefine:System|''CALIDUS'' WMS}}
{{#vardefine:Doc_Title|Prioritise WMS-WCS Messages}}
{{#vardefine:Version|1.0}}
{{#vardefine:Date|10th October 2011}}
{{#vardefine:Reference|291253 PW-8KRCWE}}
</div>
{{Doc_Title
|Client={{#var:ClientName}}
|System={{#var:System}}
|Title={{#var:Doc_Title}}
|Reference=FS {{#var:Reference}}
|Version={{#var:Version}}
|Date={{#var:Date}}
}} 

<!-- TOC --> 
<div class="noprint">
= Functional Overview  =

== Client Requirement  ==
Prioritise certain messages from WMS to WCS so that they take priority over standard messages and arrive before them into the WCS. The messages to be modified initially are the UPC responses to Receipt Precheck, Putaway and Pick Replacements from Pick Shortages.

== Solution Overview  ==
The standard messaging function within ''CALIDUS'' WMS will be modified to ensure that all messages are sent at a standard message priority (i.e. 5), rather than accepting the default from the Oracle queues.

The UPC responses to Receipt Precheck, Putaway and Pick Replacements from Pick Shortages messages will be modified to be set at a high priority (i.e. 1-4). The messages affected by the high priority setting will not be modifiable by the user, so only these specific messages will be affected.

The Standard and High Priority values will be specified as system parameters. 

This modification will ensure that the high-priority messages specified will be sent to the WCS before lower-priority messages.

== Scope  ==
{{Note}} This modification affects the ''CALIDUS'' mobile system connecting to the Oracle ''CALIDUS'' WMS system only.

{{Note}} The message priority does not affect the content of the message, just the sequence in which they are sent to ''CALIDUS'' Mobile.

{{Warning}} This modification affects the core ''CALIDUS'' Mobile interface in ''CALIDUS'' WMS. This will require several programs to be recompiled and released, as well as a fundamental change to the Oracle Advance Queues within the database. As such, the installation of this will require scheduled downtime. No ''CALIDUS'' Mobile programs need to be released to implement this functionality, however.

<!-- NEW PAGE --> 

= Set-up  =

== Pre-requisites  ==
A valid ''CALIDUS'' Mobile system must be connected to your ''CALIDUS'' WMS.

== Menu Structure  ==
None

== Data  ==
Warehouse rule 'RPCA' ("RF Picking - Create Amendments") must be created and set to value 'Y'.

<!-- NEW PAGE -->

= Functional Description  =

==DP_WMS_IF==
This Oracle package will be changed to allow the WMS RF sending packages to specify a priority on the messages sent to ''CALIDUS'' Mobile. 
All overloaded versions of procedure 'send_to_wcs' and 'send_edi_to_wcs' will be modified to receive a priority parameter. If no priority is specified (for the majority of messages), the priority will default to 5.

The priority of the record built to send (p_rec_dets) will be set to this parameter.

{{Note}} The contents of this procedure contain amendments for stock take developments and changes to the way that the common record are retrieved that must be reflected in the latest version - the version differences must be checked for this. The procedures to be checked are:
*get_session_qschema_agent
*get_edi_session_qschema_agent
*recvd_rec

==DP_RDT_STKENQ==
Procedure 'check_upc_code' will be modified so that, when messages are returned to ''CALIDUS'' Mobile with the UPC information, they are sent with priority value '2'. This is done when the procedure 'send_edi_to_wcs' is called at the end of the procedure.

==DP_RDT_PICK_CONF==
This package will be modified to set the priority of any pick replacement message returned to ''CALIDUS'' Mobile to '2'.

Pick Modification messages are only returned to ''CALIDUS'' Mobile if the warehouse rule 'RPCA' is set to 'Y', through procedure 'search_for_alternative', when there has been a shortage against a particular pick line.

If an alternative pick is found, the pick task on ''CALIDUS'' WMS is created and a pick task is sent using procedure 'send_to_pick'. This procedure is called only for this reason. This procedure will be modified to set the priority of the messages to '2' when the procedure 'send_edi_to_wcs' is called from here.

If no alternative pick is found, a message is returned to ''CALIDUS'' Mobile to inform the users that no alternative pick is available. This is sent from procedure 'send_blank_pick'. This procedure is called only for this reason. This procedure will be modified to set the priority of the messages to '2' when the procedure 'send_edi_to_wcs' is called from here.
 

<!-- MEDIA LANDSCAPE YES -->

= Appendix A: TEST PLAN  =

{{TestPlan_Header
|Title={{#var:Doc_Title}}
|Log={{#var:Reference}}
|Description=Test prioritisation of messages from WMS to WCS.
|MenuAccess=None
|Prerequisites=See Setup section
|Objective=To test that: all standard messages are defaulted to a default priority; high-priority messages are sent with the high priority and; messages at different priority levels are received in the sequence expected.
}} 
{{ #vardefine: Cycle | 0 }}{{ #vardefine: SubCycle | 0 }}
{{TestPlan_CycleHeader
|Cycle={{ #vardefineecho: Cycle | {{ #expr: {{ #var: Cycle }} + 1 }} }}{{ #vardefine: SubCycle | {{ #var: Cycle }} }}
|Title=Standard Message Sending
|Notes=
}} <!--INSERT TESTS HERE --> {{TestPlan_Test
|Test={{ #vardefineecho: SubCycle | {{ #expr: {{ #var: SubCycle }} + 0.1 }} }}
|Action=Send all types of messages (for the client, this is standing data, picks). Check the sent messages on the WMS Queue and the WCS Incoming Log.
|Result=All messages enqueue with priority 5 and are received in the sequence they are sent.
|Remarks=
|PassFail=
}} {{TestPlan_CycleFooter}} 

{{TestPlan_CycleHeader
|Cycle={{ #vardefineecho: Cycle | {{ #expr: {{ #var: Cycle }} + 1 }} }}{{ #vardefine: SubCycle | {{ #var: Cycle }} }}
|Title=Priority Message Sending
|Notes=
}} <!--INSERT TESTS HERE --> {{TestPlan_Test
|Test={{ #vardefineecho: SubCycle | {{ #expr: {{ #var: SubCycle }} + 0.1 }} }}
|Action=Perform a UPC enquiry (from Blind Receipt or Putaway). Check the sent messages on the WMS Queue and the WCS Incoming Log.
|Result=Responses are received and were put on the queue at priority 2.
|Remarks=
|PassFail=
}} {{TestPlan_Test
|Test={{ #vardefineecho: SubCycle | {{ #expr: {{ #var: SubCycle }} + 0.1 }} }}
|Action=Perform a short pick of stock where there is replacement stock in the warehouse. Check the sent messages on the WMS Queue and the WCS Incoming Log.
|Result=Responses are received and were put on the queue at priority 2.
|Remarks=
|PassFail=
}} {{TestPlan_Test
|Test={{ #vardefineecho: SubCycle | {{ #expr: {{ #var: SubCycle }} + 0.1 }} }}
|Action=Perform a short pick of stock where there is no replacement stock in the warehouse. Check the sent messages on the WMS Queue and the WCS Incoming Log.
|Result=Responses are received and were put on the queue at priority 2.
|Remarks=
|PassFail=
}} {{TestPlan_CycleFooter}} 

{{TestPlan_CycleHeader
|Cycle={{ #vardefineecho: Cycle | {{ #expr: {{ #var: Cycle }} + 1 }} }}{{ #vardefine: SubCycle | {{ #var: Cycle }} }}
|Title=Message Queue Sequencing
|Notes=Send through some standing data messages that will take time to perform (>1000 messages). All tests below should be completed before these messages have all been received.
}} <!--INSERT TESTS HERE --> {{TestPlan_Test
|Test={{ #vardefineecho: SubCycle | {{ #expr: {{ #var: SubCycle }} + 0.1 }} }}
|Action=Perform a UPC enquiry (from Blind Receipt or Putaway).
|Result=A response is received in a timely fashion.
|Remarks=
|PassFail=
}} {{TestPlan_Test
|Test={{ #vardefineecho: SubCycle | {{ #expr: {{ #var: SubCycle }} + 0.1 }} }}
|Action=Perform a short pick of stock where there is replacement stock in the warehouse. 
|Result=A response is received in a timely fashion.
|Remarks=
|PassFail=
}} {{TestPlan_Test
|Test={{ #vardefineecho: SubCycle | {{ #expr: {{ #var: SubCycle }} + 0.1 }} }}
|Action=Perform a short pick of stock where there is no replacement stock in the warehouse. 
|Result=A response is received in a timely fashion.
|Remarks=
|PassFail=
}} {{TestPlan_CycleFooter}}

<!-- MEDIA LANDSCAPE NO --> 
{{Doc_Appendix
|Appendix=B
|Estimate=Y
|Glossary=WCS
|Ref1=EST 291253 PW-8KRCWE Prioritise WMS-WCS Messages
|RefV1=1.0
|RefDate1=19/08/2011
|REQ=0
|EST=1.25
|FS=0.75
|TS=0
|DEV=1.5
|ST=1.5
|IMP=0
|Client={{#var:Client}}
|Year=2011
|FSEST=Y
|Rev1=Phil Harding
|Rev1Title=OBS Project Manager
|Rev2=Phil Isle
|Rev2Title=DHL Representative
}}</div> 
[[Category:{{#var:Client}} FS]]