Home » Oracle » Oracle Ebuisness Suite » Patch history tables in Oracle Apps (11i/R12.1/R12.2)

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

See also  How Oracle RAC handles instance failure and recovery

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top