Friday, July 24, 2009

Patch release history in oracle apps.

SELECT (bug_number),
decode((bug_number),
'4440000','Release 12.0.0 - provides R12 baseline code for PRC_PF',
'5082400','Release 12.0.1',
'5484000','Release 12.0.2 - provides R12.PRC_PF.A.delta.2',
'6141000','Release 12.0.3 - provides R12.PRC_PF.A.delta.3',
'6435000','Release 12.0.4 - provides R12.PRC_PF.A.delta.4',
'6728000','Release 12.0.6 - provides R12.PRC_PF.A.delta.6',
'7015582','Procurement Release 12.0 Rollup Patch 5',
'7218243','Procurement R12.0 Update July 2008',
'7291462','Procurement R12.0 Update August 2008',
'7355145','Procurement R12.0 Update Sept 2008',
'7433336','Procurement R12.0 Update Oct 2008',
'7505241','Procurement R12.0 Update Nov 2008',
'7600636','Procurement R12.0 Update Dec 2008',
'7691702','Procurement R12.0 Update Jan 2009',
'8298073','Procurement R12.0 Update Mar 2009',
'Other') "Description"
FROM ad_bugs
WHERE bug_number IN
('4440000','5082400','5484000','6141000','6435000',
'6728000','7015582','7218243','7291462','7355145',
'7433336','7505241','7600636','7691702','8298073')
order by 2

No comments:

Post a Comment

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...