Wednesday, February 12, 2020

How to find EBS CPU Patch Level in R12.2 ?

How to find EBS CPU Patch Level in R12.2 
For 12.2 use the below script. 

  
set linesize 141
set pagesize 100;
col "Patch" format A10;
col "Description" format A70;
select distinct bug_number Patch, decode(bug_number,
    '28421544','ORACLE APPLICATIONS RELEASE 12.2: CPU PATCH FOR OCT 2018',
    '28018169','ORACLE APPLICATIONS RELEASE 12.2: CPU PATCH FOR JUL 2018',
    '27468058','ORACLE APPLICATIONS RELEASE 12.2: CPU PATCH FOR APR 2018',
    '27040860','ORACLE APPLICATIONS RELEASE 12.2: CPU PATCH FOR JAN 2018',
    '26574498','ORACLE APPLICATIONS RELEASE 12.2: CPU PATCH FOR OCT 2017',
    '25982922','ORACLE APPLICATIONS RELEASE 12.2: CPU PATCH FOR JUL 2017',
    '25449173','ORACLE APPLICATIONS RELEASE 12.2: CPU PATCH FOR APR 2017',
    '25032335','ORACLE APPLICATIONS RELEASE 12.2: CPU PATCH FOR JAN 2017',
    '24390794','ORACLE APPLICATIONS RELEASE 12.2: CPU PATCH FOR OCT 2016',
    '23144508','ORACLE APPLICATIONS RELEASE 12.2: CPU PATCH FOR JUL 2016',
    '22614473','ORACLE APPLICATIONS RELEASE 12.2: CPU PATCH FOR APR 2016',
    '22133451','ORACLE APPLICATIONS RELEASE 12.2: CPU PATCH FOR JAN 2016',
    '21507429','ORACLE APPLICATIONS RELEASE 12.2: CPU PATCH FOR OCT 2015',
    '20953338','ORACLE APPLICATIONS RELEASE 12.2: CPU PATCH FOR JUL 2015',
    '20406630','ORACLE APPLICATIONS RELEASE 12.2: CPU PATCH FOR APR 2015',
    '19873050','ORACLE APPLICATIONS RELEASE 12.2: CPU PATCH FOR JAN 2015') Description,
     CREATION_DATE Applied
from ad_bugs
where bug_number in
('28421544','28018169','27468058','27040860','26574498','25982922','25449173','25032335','24390794','23144508','22614473','22133451','21507429','20953338','20406630','19873050') order by Description desc;

output
--------



1 comment:

Unknown said...

Did you know there's a 12 word phrase you can speak to your partner... that will induce deep feelings of love and impulsive attractiveness to you deep within his heart?

Because deep inside these 12 words is a "secret signal" that triggers a man's impulse to love, cherish and protect you with his entire heart...

12 Words Who Trigger A Man's Desire Instinct

This impulse is so hardwired into a man's mind that it will drive him to work harder than ever before to make your relationship the best part of both of your lives.

In fact, fueling this all-powerful impulse is so binding to achieving the best ever relationship with your man that the second you send your man one of these "Secret Signals"...

...You will soon notice him open his mind and heart for you in a way he never expressed before and he'll see you as the one and only woman in the universe who has ever truly understood him.