E-Business Oracle EBS 12.2 Check AD and TXK patches versions applied

Standard question for EBS 12 - what AD and TXK versions have been applied ?

You can check via query on a  metatable



sqlplus connect as apps and run

column codelevel format a30
column name format a40
 select  ABBREVIATION, NAME, codelevel FROM AD_TRACKABLE_ENTITIES where abbreviation in ('txk','ad');


ABBREVIA NAME                                     CODELEVEL
-------- ---------------------------------------- ------------------------------
ad       Applications DBA                         C.6
txk      Oracle Applications Technology Stack     C.6

SQL>

Column Codelevel is what you want  So C.6