Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

R12 :Why 2 records in ad_applied_patches

edited Sep 5, 2014 4:55AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered ✓

hello,


The above are the patches applied since August, here most patches has 2 records and few has only one record in ad_applied_patches and why is that.

SQL> set line 100;
SQL> col patch_name form a10;
ALTER SESSION SET nls_date_format='MM/DD/YYYY HH24:MI:SS';
SQL>
Session altered.

SQL> select applied_patch_id,patch_name,creation_date from apps.ad_applied_patches
where to_date(creation_date,'MM/DD/YYYY HH24:MI:SS') BETWEEN
2    3  TO_date ('08/11/2014 23:59:59', 'MM/DD/YYYY HH24:MI:SS')
4  AND TO_date ('09/05/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS')
order by creation_date desc;  5

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center