• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
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)

May 15, 2019 by techgoeasy Leave a Comment

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

Filed Under: Oracle, Oracle Ebuisness Suite Tagged With: patch history tables

Reader Interactions

Leave a Reply Cancel reply

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

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • Password Version in oracle
  • How to login as user without changing the password in Oracle database(alter user identified by values)
  • How to check encrypted tablespace in the Database
  • How To Export -Import TDE Master Encryption Key
  • How to Configure Auto Login TDE Wallet

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us