My Oracle Support Banner

12.2 E-Business Suite Applications DBA Patch Application SQL to Check Current Levels Related To The Technology Stack (AD / TXK / ATG_PF) Products (Doc ID 2414925.1)

Last updated on NOVEMBER 27, 2023

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.2.4 and later
Oracle Applications DBA - Version 12.2.4 and later
Information in this document applies to any platform.


E-Business Suite 12.2 Applications DBA, Patch Application related issues





There are many situation in which we need to confirm the patch level for AD/TXK/ATG_PF before applying other patches.

This note provides a SQL script to find out which patch level for each of these AD/TXK/ATG_PF that have applied in an E-Business Suite environment.

Note: Please source the RUN environmental file and in order to correctly reflect the patch level, please execute below SQL after the adop patch cycle is finished.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.