January 20, 2021

How to check AD and TXK code levels in EBS

We can use following query to get AD and TXK code level in EBS environment


SQL>col ABBREVIATION for a20

SQL>set lines 300

SQL>col NAME for a40

SQL>col CODELEVEL for a20 

SQL> SELECT ABBREVIATION,NAME,codelevel FROM AD_TRACKABLE_ENTITIES WHERE abbreviation in ('txk','ad');

 

ABBREVIATION         NAME                                     CODELEVEL

-------------------- ---------------------------------------- --------------------

ad                   Applications DBA                                     C.10

txk                  Oracle Applications Technology Stack     C.10


3 comments:

How to Patch Oracle 19c to Release 19.30 on Windows – A Complete Step-by-Step Blog

  As soon as   Oracle released quarterly patch for Jan 2026 , I had to patch one of my Oracle 19c databases from 19.25 to 19.30. Since this ...