Checking Patches and Releases

Sometimes it is necessary to check whether patches or emergency releases have been made to a system.

Identify the patch or ER

You can identify the patch number from the system e.g. in CTMS:

• Check your MAIN form - the patch version is shown on the form.

Using this OBS Assist, you can find ERs and patches easily.

• Go to Category Emergency Releases or Patches and look for your system, patch number or ERs as a category or as a page.
• Search for your DevOps number using the search bar at the top - this will show the patch and ER number on which the DevOps log was released.
• Search for the package and version if known using the search bar.

Check the Patch Level

Using PL/SQL deveoper (or other database query tool) check table RELEASE_HISTORY.

select * from release_history
where patch_no like '%47%'
order by version desc, patch_no desc

If the ER number or patch is there, the release has been done and the functionality is available.