• 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

Primary Sidebar

Top Posts & Pages

  • Oracle Indexes and types of indexes in oracle with example
  • Top 30 Most Useful Concurrent Manager Queries
  • Top 46 Oracle ASM Interview Questions
  • Oracle dba interview questions and answers
  • 40 question you must know about R12.2



Subscribe to our mailing list

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

Recent Posts

  • Multi Language Support in 11i/R12
  • EBS PDB service name disappear from listener in 19c
  • how to download oracle e-business suite 12.2 software
  • Step by step upgrade process to R12.2 Upgrade part -2(Main Upgrade Driver for R12.2.0)
  • Step by step upgrade process for R12.2 Upgrade Part -1

Copyright © 2021 : TechGoEasy

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