Saturday, March 28, 2020

EBS-Check AD and TXK patches versions applied.

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

ABBREVIA NAME
-------- --------------------------------------------------
CODELEVEL
--------------------------------------------------------------------------------
ad Applications DBA
B.1

txk Techstack
B.1

-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Oracle Database Password Management: Resetting Password Policies and User Account Expiry Issues

  Checking Password Lifetime Policy Oracle password expiration rules are controlled through profiles. The following query helps identify the...

  • TKPROF Overview
      TKPROF Overview.   TKPROF is used for diagnosing performance issues.  It formats a trace file into readable format for performance ana...
  • ORACLE CLOUD EBS INSTALLTION
      CLOUD EBS INSTALLTION   login as: opc Authenticating with public key "rsa-key-20201105" from agent Last login: Thu Nov 19 08...
  • Query to find the Concurrent Request Trace File Path
      Query to find the Concurrent Request Trace File Path In Oracle Applications, we all submit concurrent requests. As a developer when we nee...