1) For the Apps Version run the following sql:


SQL > select release_name from fnd_product_groups;

2) For the Maintenance Family Pack Level run the following sql:

SQL > select patch_level from fnd_product_installations where application_id = 275;

3) For the RUPs(11i) run the following sql:

select distinct patch_name PatchNum,
decode(patch_name,
‘5644834’, ‘(11i.PJ_PF.M) Project Foundation Rollup 4’,
‘5644831’, ‘(11i.PJ_PF.M) Project Costing Rollup 4’,
‘5644832’, ‘(11i.PJ_PF.M) Project Billing Rollup 4’,
‘5644835’, ‘(11i.PJ_PF.M) Project Management Rollup 4’,
‘5673787’, ‘(11i.PJ_PF.M) Project Resource Management Rollup 4’,
‘5644833’, ‘(11i.PJ_PF.M) Grants Accounting Rollup 4’,
‘6007691’, ‘(11i.PJ_PF.M) Project Portfolio Analysis Rollup 4’,
‘5367017’, ‘(11i.PJ_PF.M) Projects ADI Functionality Rollup 4’,
‘5337976’, ‘(11i.PJ_PF.M) Project Foundation Rollup 3’,
‘5121547’, ‘(11i.PJ_PF.M) Project Costing Rollup 3’,
‘5121506’, ‘(11i.PJ_PF.M) Project Billing Rollup 3’,
‘5121499’, ‘(11i.PJ_PF.M) Project Management Rollup 3’,
‘5121501’, ‘(11i.PJ_PF.M) Project Resource Management Rollup 3’,
‘5121551’, ‘(11i.PJ_PF.M) Grants Accounting Rollup 3’,
‘5121559’, ‘(11i.PJ_PF.M) Project Portfolio Analysis Rollup 3’,
‘5087961’, ‘(11i.PJ_PF.M) Projects ADI Functionality Rollup 3’,
‘5039504’, ‘(11i.PJ_PF.M) Project Foundation Rollup 2’,
‘4997596’, ‘(11i.PJ_PF.M) Project Costing Rollup 2’,
‘4997595’, ‘(11i.PJ_PF.M) Project Billing Rollup 2’,
‘4997590’, ‘(11i.PJ_PF.M) Project Management Rollup 2’,
‘4997593’, ‘(11i.PJ_PF.M) Project Resource Management Rollup 2’,
‘4997597’, ‘(11i.PJ_PF.M) Grants Accounting Rollup 2’,
‘4884310’, ‘(11i.PJ_PF.M) Projects ADI Functionality Rollup 2’,
‘4463552’, ‘(11i.PJ_PF.M) Projects ADI Functionality Rollup 1’,
‘3337098’, ‘(11i.PJ_PF.M) Projects ADI Functionality For PA.M’,
‘5644830’, ‘(11i.PJ_PF.M) Rollup 4’,
‘5105878’, ‘(11i.PJ_PF.M) Rollup 3’,
‘4997599’, ‘(11i.PJ_PF.M) Rollup 2’,
‘4461989’, ‘(11i.PJ_PF.M) Rollup’,
‘4285356’, ‘(11.5.10) Projects Consolidated Patch for CU2’,
‘4027334’, ‘(11.5.10) Projects Consolidated Patch for CU1’,
‘4667955’, ‘(11i.PJ_PF.L10) Project Costing Rollup 1’,
‘4667957’, ‘(11i.PJ_PF.L10) Project Billing Rollup 1’,
‘4667965’, ‘(11i.PJ_PF.L10) Grants Accounting Rollup 1’,
‘4667949’, ‘(11i.PJ_PF.L10) Rollup 1’,
‘3397153’, ‘(11i.PJ_PF.L10) Projects Family Pack L10’,
‘2920766’, ‘(11i.PJ_PF.K) Rollup’,
‘3009044’, ‘(11i.PJ_PF.J) Rollup’) PatchName
from (select patch_name from ad_applied_patches union
select bug_number from ad_bugs)
where patch_name in (
‘5644830’, ‘5644834’, ‘5644831’, ‘5644832’, ‘5644835’, ‘5673787’, ‘5644833’,
‘6007691’, ‘5367017’, ‘5337976’, ‘5121547’, ‘5121506’, ‘5121499’, ‘5121501’,
‘5121551’, ‘5121559’, ‘5087961’, ‘5039504’, ‘4997596’, ‘4997595’, ‘4997590’,
‘4997593’, ‘4997597’, ‘4884310’, ‘4463552’, ‘3337098’, ‘5105878’, ‘4997599’,
‘4461989’, ‘4285356’, ‘4027334’, ‘4667955’, ‘4667957’, ‘4667965’, ‘4667949’,
‘3397153’, ‘2920766’, ‘3009044’)
order by patchnum desc

4) For the RUPs(R12) run the following sql:

SQL > select bug_number, creation_date
from ad_bugs
where bug_number in (‘6022657’, ‘6266113’, ‘6512963’, ‘5484000’, ‘6141000’, ‘6435000’,’7292354′,’6728000′)
ORDER BY 2;

Following RUP patches are released for Rel. 12:

6022657 – Oracle Projects Release Update Pack 2 for 12.0 (R12.PJ_PF.A.DELTA.2)
6266113 – Oracle Projects Release Update Pack 3 for 12.0 (R12.PJ_PF.A.DELTA.3)
6512963 – Oracle Projects Release Update Pack 4 for 12.0 (R12.PJ_PF.A.DELTA.4)
7292354 – Oracle Projects Release Update Pack 6 for 12.0 (R12.PJ_PF.A.DELTA.6)
5484000 – Oracle E-Business Suite 12.0.2 Release Update Pack (RUP2)
6141000 – Oracle E-Business Suite 12.0.3 Release Update Pack (RUP3)
6435000 – Oracle E-Business Suite 12.0.4 Release Update Pack (RUP4)
728000 – Oracle E-Business Suite 12.0.6 Release Update Pack (RUP6)

Leave a Reply