While preparing patch analysis on EBS environments, some times we find in README file that AD/ TXK level should be at a certain code level to apply the patch.We can use the below query to check AD and TXK Code level.
select ABBREVIATION, NAME, codelevel FROM AD_TRACKABLE_ENTITIES where abbreviation in ('txk','ad');
Sample Output
$sqlplus apps
SQL> select ABBREVIATION, NAME, codelevel FROM AD_TRACKABLE_ENTITIES where abbreviation in ('txk','ad');
ABBREVIATION NAME CODELEVEL
------------------------------ ---------------------------------------- ----------
ad Applications DBA C.11
txk Oracle Applications Technology Stack C.11
No comments:
Post a Comment
Was this Post Helpful?
Feel free to suggest your opinions in the comments section!