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.

1 comment:

  1. 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