{"id":946,"date":"2026-06-03T07:37:07","date_gmt":"2026-06-03T12:37:07","guid":{"rendered":"https:\/\/www.wisconsin.edu\/systemwide-it\/?p=946"},"modified":"2026-06-03T07:39:57","modified_gmt":"2026-06-03T12:39:57","slug":"refunding-outbound-1-11-central-release","status":"publish","type":"post","link":"https:\/\/www.wisconsin.edu\/systemwide-it\/2026\/06\/03\/refunding-outbound-1-11-central-release\/","title":{"rendered":"Refunding Outbound 1.11 Central Release"},"content":{"rendered":"\n<p>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.<\/p>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Issue<\/strong>:<\/h6>\n\n\n\n<p>In version 1.10, to remedy refunds not being picked up for campuses that use the delivered \u201cRefund With Extra Amount\u201d 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\u2019s 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.<\/p>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Fix<\/strong>:<\/h6>\n\n\n\n<p>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.<\/p>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Link to download<\/strong>:<\/h6>\n\n\n\n<p><a href=\"https:\/\/universityofwisconsin.sharepoint.com\/sites\/uw-oasis\/SIS%20Workday%20Integrations%20Download%20Library\/UW_SF_REFUNDS_OUTBOUND_V1.11.zip\" target=\"_blank\" rel=\"noreferrer noopener\">UW_SF_REFUNDS_OUTBOUND_V1.11.zip<\/a><\/p>\n\n\n\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<\/p>\n\n\n\n<p>To view items ready for an application&#8217;s next maintenance release:<br>Incidents:&nbsp;<a href=\"https:\/\/tableau.wisconsin.edu\/#\/site\/SYS\/views\/SISTeamDashboard\/SISTeamDashboard?:iid=1\" target=\"_blank\" rel=\"noreferrer noopener\">SIS Team\u2019s Reported Bugs Dashboard<\/a><br>Service Requests:&nbsp;<a href=\"https:\/\/tableau.wisconsin.edu\/#\/site\/SYS\/views\/SISTeamDashboard\/SISTeamServiceRequestsDB?:iid=1\" target=\"_blank\" rel=\"noreferrer noopener\">SIS Team\u2019s Enhancement Requests Dashboard<\/a><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":6584,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-946","post","type-post","status-publish","format-standard","hentry","category-siss"],"_links":{"self":[{"href":"https:\/\/www.wisconsin.edu\/systemwide-it\/wp-json\/wp\/v2\/posts\/946","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wisconsin.edu\/systemwide-it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wisconsin.edu\/systemwide-it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wisconsin.edu\/systemwide-it\/wp-json\/wp\/v2\/users\/6584"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wisconsin.edu\/systemwide-it\/wp-json\/wp\/v2\/comments?post=946"}],"version-history":[{"count":1,"href":"https:\/\/www.wisconsin.edu\/systemwide-it\/wp-json\/wp\/v2\/posts\/946\/revisions"}],"predecessor-version":[{"id":947,"href":"https:\/\/www.wisconsin.edu\/systemwide-it\/wp-json\/wp\/v2\/posts\/946\/revisions\/947"}],"wp:attachment":[{"href":"https:\/\/www.wisconsin.edu\/systemwide-it\/wp-json\/wp\/v2\/media?parent=946"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wisconsin.edu\/systemwide-it\/wp-json\/wp\/v2\/categories?post=946"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wisconsin.edu\/systemwide-it\/wp-json\/wp\/v2\/tags?post=946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}