Step by step---Oracle Application Patching R12.1

1.Pre-requisite checks:

       a.Check whether the given patch number is applied before using below query.It will show the bug number if applied before.

                select bug_number from ad_bugs where bug_number='9488727';

       

       b.check count of objects INVALID. The count of invalids should go down after applying patches.

                select count(*) from dba_objects where status='INVALID';