PART A - Impact Analysis Instructions:
1. Update the case header and ensure the Priority, Category, Group, Weight, and other details are correct
2. Update the case header with a clear and concise description of the problem. 3. Itemize and number each section so it can be clearly referenced.
4. Update the case Subject to clearly describe the issue 5. If there is a significant change to the effort, assign the case to Sanjay for approval.
6. Cleanup the case header and ensure blank lines and formatting is neat. The case should contain relevant statements only. PART B - Analysis
1. Verify the request. If System Issue, verify the issue exists. If New/Improvement, verify justification.
2. The following changes will be required:
a. Change the procedure that extracts delivery batches to use GROUP BY batch number instead of DISTINCT.
2. Affected Areas:
a. POS -> Delivery Search
3. The issue was caused by: Use of DISTINCT in a combination with the modified date has caused the issue.
Is there a significant change in the effort to complete this case: No Next Step: proceed with the development
---------------------- PART C - Development Reference (Place descriptor for objects changed): 1. Other areas in the system that could have a similar issue (and provide next steps): The two issues identified in this case has been noted and will be applied to any future changes to procedures, they are:
a. Input parameter cleaning to be implemented using functions. b. When distinct is used in a select, having a modified date may cause duplicate entries.
|