Patch history tables in Oracle Apps (11i/R12.1/R12.2)

Patch history tables in Oracle Apps 11i and R12.1

AD_APPL_TOPS

Stores information about all APPL_TOPS utilizing this instance.
AD_APPLIED_PATCHES

Stores information about all distinct updates applied.
AD_BUGS

Stores information about all distinct bug fixes applied.
AD_DRIVERS

Stores information about the drivers that comprise an update.
AD_FILE_VERSIONS

Stores version information for files.
AD_FILES

Stores information about files in the system.
AD_PATCH_COMMON_ACTIONS

Stores information about actions in update driver files.
AD_PATCH_DRIVER_LANGS

Stores information about the languages included in an update driver file.
AD_PATCH_DRIVER_MINIPKS

Stores information about minipacks.
AD_PATCH_RUN_BUG_ACTIONS

Stores detailed information about actions applied by an update.
AD_PATCH_RUN_BUGS

Stores information about all bug fixes included in an update , applied or not.
AD_PATCH_RUNS

Stores information about all invocations of AutoPatch for all of the various updates applied.
AD_RELEASES

Stores release information about the Oracle Applications system.

Tables which are extra in R12.2

ad_adop_sessions

This table show the status for each adop phase along with its corresponding session id. This is effectively a history of online patching in an environment.

ad_adop_session_patches

To show which patches were applied in each ADOP_SESSION_ID (patching cycle)

Related Articles

How to check Patch application in Oracle E-Business Suite instance R12.1/R12.2

Top queries to find Patch applied in Oracle apps

31 Useful adop (AD online patching ) command line for R12.2

How to use Patch wizard in Oracle EBS environment

How to rollback the patch after failed cutover phase in R12.2