Tuesday, November 17, 2015

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


Column Codelevel is what you want  So C.6