Due to an edge case recently identified at UW-Platteville, we have an updated version released on the Oasis of Refunding Outbound. While Version 1.10, released on May 4th, successfully resolved the original issue it was intended to address, it also introduced an unintended edge-case issue under specific conditions. To address this, Version 1.11 has been developed and will replace Version 1.10 as the recommended release.
Issue:
In version 1.10, to remedy refunds not being picked up for campuses that use the delivered “Refund With Extra Amount” refunding option, we altered the LdStage SQL in the refunding outbound program. The method we used was a UNION, and while this does work for most cases, unfortunately there’s one specific case that should work that no longer does. Students can receive multiple refunds for different terms that have identical information for this specific SQL step, and due to built-in functionality in the UNION method, the step incorrectly identifies these refunds as duplicates and only sends one of the two.
Fix:
We were able to simply switch the UNION method to UNION ALL, as this does not have the same deduplication functionality that UNION does. With this change, we were able to see the correct refunds once again. This change is included in version 1.11 of the refunding outbound project on OASIS.
Link to download:
UW_SF_REFUNDS_OUTBOUND_V1.11.zip
————————————————————————————————————————
To view items ready for an application’s next maintenance release:
Incidents: SIS Team’s Reported Bugs Dashboard
Service Requests: SIS Team’s Enhancement Requests Dashboard