https://calidusassist.adcservices.apteancloud.com/calidus-assist/OBS/index.php?action=history&feed=atom&title=Checking_Patches_and_ReleasesChecking Patches and Releases - Revision history2026-07-01T14:09:03ZRevision history for this page on the wikiMediaWiki 1.39.8https://calidusassist.adcservices.apteancloud.com/calidus-assist/OBS/index.php?title=Checking_Patches_and_Releases&diff=11996&oldid=prevAnw: Minor correction2025-06-02T12:45:54Z<p>Minor correction</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en-GB">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 14:45, 2 June 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l8">Line 8:</td>
<td colspan="2" class="diff-lineno">Line 8:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Using this OBS Assist, you can find ERs and patches easily.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Using this OBS Assist, you can find ERs and patches easily.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* Go to Category <del style="font-weight: bold; text-decoration: none;">ER </del>or Patches and <del style="font-weight: bold; text-decoration: none;">search </del>for your patch number or ERs.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* Go to Category <ins style="font-weight: bold; text-decoration: none;">Emergency Releases </ins>or Patches and <ins style="font-weight: bold; text-decoration: none;">look </ins>for your <ins style="font-weight: bold; text-decoration: none;">system, </ins>patch number or ERs <ins style="font-weight: bold; text-decoration: none;">as a category or as a page</ins>.</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* Search for your DevOps number using the search bar at the top - this will show <del style="font-weight: bold; text-decoration: none;">you </del>the patch and ER number on which the <del style="font-weight: bold; text-decoration: none;">devops </del>log was released.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* Search for your DevOps number using the search bar at the top - this will show the patch and ER number on which the <ins style="font-weight: bold; text-decoration: none;">DevOps </ins>log was released.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Search for the package and version if known using the search bar.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Search for the package and version if known using the search bar.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
</table>Anwhttps://calidusassist.adcservices.apteancloud.com/calidus-assist/OBS/index.php?title=Checking_Patches_and_Releases&diff=11995&oldid=prevAnw: Initial Creation2025-06-02T12:43:48Z<p>Initial Creation</p>
<p><b>New page</b></p><div>Sometimes it is necessary to check whether patches or emergency releases have been made to a system.<br />
<br />
<br />
== Identify the patch or ER ==<br />
You can identify the patch number from the system e.g. in CTMS:<br />
* Check your MAIN form - the patch version is shown on the form.<br />
<br />
Using this OBS Assist, you can find ERs and patches easily.<br />
<br />
* Go to Category ER or Patches and search for your patch number or ERs.<br />
* Search for your DevOps number using the search bar at the top - this will show you the patch and ER number on which the devops log was released.<br />
* Search for the package and version if known using the search bar.<br />
<br />
<br />
== Check the Patch Level ==<br />
Using PL/SQL deveoper (or other database query tool) check table RELEASE_HISTORY.<br />
<pre><br />
select * from release_history<br />
where patch_no like '%47%'<br />
order by version desc, patch_no desc<br />
<br />
If the ER number or patch is there, the release has been done and the functionality is available.<br />
</pre><br />
<noinclude><br />
[[Category:CTMS]][[Category:WMS]]<br />
</noinclude></div>Anw