How to check if a patch is applied in Oracle Applications without logging into the server / database / application?

If we want to check the patches applied and their date without logging into the server, not even connect to database nor login into application, the process is very simple and straight forward.

Just open the Oracle Applications login page for the instance which you desire to check.

On the login page, at Extreme left bottom, we will notice a link "About this page".

Click on "About this page" as shown in above picture.

We will not be required to enter any username/password. It will simply take us to the below page.

select the "Patches" tab as shown in above picture.

Finally query the patch you wanted to search for.

How to Rollback / Revert the autoconfig changes in EBS

When ever we run autoconfig, the autoconfig log files are stored under the following locations.

On Database Tier:
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/<MMDDhhmm>

On Middle Tier:
$APPL_TOP/admin/$CONTEXT_NAME/log/<MMDDhhmm>


At the same time, all the backup configuration files from each autoconfig session are saved under following directories:

On Database Tier:
$ORACLE_HOME/appsutil/out/$CONTEXT_NAME/<MMDDhhmm>

On Middle Tier:
$APPL_TOP/admin/$CONTEXT_NAME/out/<MMDDhhmm>

There is also a script called restore.sh / restore.cmd under these locations along with backup configuration files.

We can run restore.sh (unix) or restore.cmd (windows) to revert back the autoconfig changes.