How To Get Versions on EBS

One of the daunting tasks of being new to EBS is how to get the versions of its components. For me as a DBA I just say Oracle 12c, 12c R2, 10g, 9i  etc.   However, in EBS there are several others.

On this post lets get you started with some basic ones.

AD and TXK

SQL> set linesize 132
col ABBREVIATION format A20
col CODELEVEL format A20

select ABBREVIATION, CODELEVEL
from AD_TRACKABLE_ENTITIES
where ABBREVIATION in ('ad', 'txk');SQL> SQL> SQL> SQL>   2    3

ABBREVIATION         CODELEVEL
-------------------- --------------------
ad                   C.6
txk                  C.6

So for this one it is a delta 6 

Also a better way to do this is by looking at the Oracle Application Manager in EBS. The navigation is Sytem Administrator>Oracle Application Manager > Dashboard > software updates > other links > code level summary