Friday, August 1, 2014

SQL query to find out Oracle patch has applied or not on Oracle applications enviornment


By running below query you can check that patch has been applied or not.


SELECT
BUG_NUMBER, --THIS IS PATCH NUMBER
ARU_RELEASE_NAME,
CREATION_DATE,
LAST_UPDATE_DATE
FROM APPS.AD_BUGS;


Also you can find more information by running Diagnostics: Apps Check program from application.
Posted by at
Labels:

2 comments:

  1. UnknownSeptember 24, 2016 at 10:46 AM

    Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete
  2. UnknownMarch 10, 2019 at 11:03 AM

    Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com

    ReplyDelete

Subscribe to: Post Comments (Atom)