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