How to Identify - Confirm What is the Framework Bundle - Framework Level - Applied in 12.1 and 12.2 Installations (Doc ID 2300940.1)

 

References

---

APPLIES TO:

Oracle Applications Framework - Version 12.1.3 and later
Information in this document applies to any platform.

GOAL

Framework has its own Code Stack (12.1.3, 12.2.4, 12.2.5, 12.2.6, 12.2.7, 12.2.8 etc..) and for each stack there are specific Framework Bundle patches released. 

For example, it is possible to have a 12.2.6 Framework Code Stack on a 12.2.4 E-Business Suite installation.

How can the Framework Bundle Code Level be identified?  How can the Framework point release be determined?

 

OA Framework Bundles

EBS Release	Framework Codelevel	Latest OA Framework Bundle Patch
12.1.3	B	22284589 FWK RELEASE B.DELTA.5 Support recommends also applying these key one-off Framework patches on top of FWK B.Delta.5     23200210 R12.FWK.B TRACKING BUG FOR 121RUP5+ ONE-OFF     26731171 R12.FWK.B TRACKING BUG FOR 121RUP5+ ONE-OFF
12.2.4	C.4	30309169: ORACLE APPLICATION FRAMEWORK (FWK) RELEASE 12.2.4 BUNDLE 22
12.2.5	C.5	31571414: ORACLE APPLICATION FRAMEWORK (FWK) RELEASE 12.2.5 BUNDLE 24
12.2.6	C.6	31831920: ORACLE APPLICATION FRAMEWORK (FWK) RELEASE 12.2.6 BUNDLE 26
12.2.7 / 12.2.8	C.7	32418566: ORACLE APPLICATION FRAMEWORK (FWK) RELEASE 12.2.7 BUNDLE13
12.2.9	C.8	32642088: ORACLE APPLICATION FRAMEWORK (FWK) RELEASE 12.2.9 BUNDLE9
12.2.10	C.9	32642176: ORACLE APPLICATION FRAMEWORK (FWK) RELEASE 12.2.10 BUNDLE3

 

SOLUTION

In order to find the Framework Bundle Code level, please use the SQL statement below, which applies to the 12.1 and 12.2.

 

-- Confirm the Instance:
SELECT
instance_name
FROM
v$instance;

-- Confirm current Framework Code Stack level:
SELECT codelevel,
decode((codelevel),
'C.9', '12.2.10 Framework Code Stack',
'C.8', '12.2.9 Framework Code Stack',
'C.7', '12.2.7/12.2.8 Framework Code Stack',
'C.6', '12.2.6 Framework Code Stack',
'C.5', '12.2.5 Framework Code Stack',
'C.4', '12.2.4 Framework Code Stack',
'B.5', '12.1.3 Framework Code Stack',
'B.4', '11.5.10 Framework Code Stack') stack
FROM AD_TRACKABLE_ENTITIES
WHERE abbreviation='fwk';

-- Confirm the current status of available Framework Patches for your Framework Code level
set pagesize 50
set linesize 88
col INSTANCE for a16
col RELEASE for a10
col PATCH for a10
col BUG_NUMBER for a8 head "Framework Patches"
col APPLIED for a12
SELECT
(SELECT instance_name FROM v$instance) INSTANCE,
(SELECT release_name from fnd_product_groups) RELEASE,
Bugs.Bug_Number as PATCH,
Decode(Bugs.Bug_Number,
'31947046', 'FWK RELEASE 12.2.10 (C.9) BUNDLE 1',
'32130969', 'FWK RELEASE 12.2.10 (C.9) BUNDLE 2',
'32642176', 'FWK RELEASE 12.2.10 (C.9) BUNDLE 3',
'30098489', 'FWK RELEASE 12.2.9 (C.8) Consolidated Patch',
'30908501', 'FWK RELEASE 12.2.9 (C.8) BUNDLE 1',
'30980514', 'FWK RELEASE 12.2.9 (C.8) BUNDLE 2',
'31189388', 'FWK RELEASE 12.2.9 (C.8) BUNDLE 3',
'31466879', 'FWK RELEASE 12.2.9 (C.8) BUNDLE 4',
'31829822', 'FWK RELEASE 12.2.9 (C.8) BUNDLE 5',
'31943873', 'FWK RELEASE 12.2.9 (C.8) BUNDLE 6',
'32130874', 'FWK RELEASE 12.2.9 (C.8) BUNDLE 7',
'32308701', 'FWK RELEASE 12.2.9 (C.8) BUNDLE 8',
'32642088', 'FWK RELEASE 12.2.9 (C.8) BUNDLE 9',
'28830603', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 1',
'28963259', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 2',
'29232729', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 3',
'29679229', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 4',
'29880879', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 5',
'30139276', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 6',
'30369165', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 7',
'30720143', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 8',
'31154508', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 9',
'31445005', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 10',
'31667105', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 11',
'31883479', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 12',
'32418566', 'FWK RELEASE 12.2.7 (C.7) BUNDLE 13',
'24301236', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 1',
'25805360', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 2',
'25958203', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 3',
'26127158', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 4',
'26382210', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 5',
'26543378', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 6',
'26792877', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 7',
'26953578', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 8',
'27113797', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 9',
'27308923', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 10',
'27529582', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 11',
'27675364', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 12',
'27948803', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 13',
'28183913', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 14',
'28442391', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 15',
'28649181', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 16',
'28805689', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 17',
'28970079', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 18',
'29438310', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 19',
'29679234', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 20',
'30095623', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 21',
'30339377', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 22',
'30543303', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 23',
'30901459', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 24',
'31625670', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 25',
'31831920', 'FWK RELEASE 12.2.6 (C.6) BUNDLE 26',
'22745072', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 2',
'22892644', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 3',
'23179558', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 4',
'23597151', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 5',
'24329530', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 6',
'24561446', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 7',
'24813943', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 8',
'25124879', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 9',
'25264693', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 10',
'25633876', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 11',
'25805309', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 12',
'25964634', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 13',
'26244104', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 14',
'26440798', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 15',
'26648248', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 16',
'26823961', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 17',
'27014320', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 18',
'27256875', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 19',
'27476539', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 20',
'28183924', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 21',
'29582468', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 22',
'30552929', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 23',
'31571414', 'FWK RELEASE 12.2.5 (C.5) BUNDLE 24',
'21420257', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 1 --(Obsoleted)',
'21420272', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 2 --(Obsoleted)',
'21564727', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 3 --(Obsoleted)',
'21760224', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 4',
'21981732', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 5 --(Obsoleted)',
'22263785', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 6 --(Obsoleted)',
'22544086', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 7',
'22730127', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 8',
'22892369', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 9',
'23119976', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 10',
'23329010', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 11',
'24007747', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 12',
'24618945', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 13',
'24911652', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 14',
'25145239', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 15',
'25582065', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 16',
'26026963', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 17',
'26924548', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 18',
'27252629', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 19',
'28034418', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 20',
'28948407', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 21',
'30309169', 'FWK RELEASE 12.2.4 (C.4) BUNDLE 22',
'11894708', 'OA FRAMEWORK 12.1.3.1',
'15880118', 'OA FRAMEWORK 12.1.3.2',
'18936791', 'FWK RELEASE B.DELTA.4',
'22284589', 'FWK RELEASE B.DELTA.5',
'23200210', 'R12.FWK.B 121RUP5+ ONE-OFF',
'26731171', 'R12.FWK.B 121RUP5+ ONE-OFF') as "Framework Patches",
decode(Ad_Patch.Is_Patch_Applied('R12',-1,bugs.bug_Number),'EXPLICIT','APPLIED','NOT APPLIED') as APPLIED
From (select '32642176' as bug_number, 'C.9' as fwk_version from Dual
UNION ALL
select '31947046' as bug_number, 'C.9' as fwk_version from Dual
UNION ALL
select '32130969' as bug_number, 'C.9' as fwk_version from Dual
UNION ALL
select '30098489' as bug_number, 'C.8' as fwk_version from Dual
UNION ALL
select '30908501' as bug_number, 'C.8' as fwk_version from Dual
UNION ALL
select '30980514' as bug_number, 'C.8' as fwk_version from Dual
UNION ALL
select '31189388' as bug_number, 'C.8' as fwk_version from Dual
UNION ALL
select '31466879' as bug_number, 'C.8' as fwk_version from Dual
UNION ALL
select '31829822' as bug_number, 'C.8' as fwk_version from Dual
UNION ALL
select '31943873' as bug_number, 'C.8' as fwk_version from Dual
UNION ALL
select '32130874' as bug_number, 'C.8' as fwk_version from Dual
UNION ALL
select '32308701' as bug_number, 'C.8' as fwk_version from Dual
UNION ALL
select '32642088' as bug_number, 'C.8' as fwk_version from Dual
UNION ALL
select '28830603' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '28963259' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '29232729' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '29679229' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '29880879' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '30139276' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '30369165' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '30720143' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '31154508' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '31445005' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '31667105' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '31883479' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
select '32418566' as bug_number, 'C.7' as fwk_version from Dual
UNION ALL
--C6
select '24301236' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '25805360' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '25958203' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '26127158' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '26382210' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '26543378' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '26792877' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '26953578' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '27113797' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '27308923' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '27529582' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '27675364' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '27948803' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '28183913' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '28442391' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '28805689' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '28649181' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '28805689' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '28970079' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '29438310' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '29679234' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '30095623' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '30339377' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '30543303' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '30901459' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '31625670' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
select '31831920' as bug_number, 'C.6' as fwk_version from Dual
UNION ALL
--C5
select '22745072' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '22892644' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '23179558' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '23597151' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '24329530' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '24561446' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '27256875' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '24813943' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '25124879' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '25264693' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '25633876' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '25805309' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '25964634' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '26244104' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '26440798' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '26648248' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '26823961' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '27014320' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '27476539' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '28183924' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '29582468' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '30552929' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
select '31571414' as bug_number, 'C.5' as fwk_version from Dual
UNION ALL
--C4
select '21420257' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '21420272' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '21564727' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '21760224' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '21981732' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '22263785' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '22544086' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '22730127' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '22892369' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '23119976' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '23329010' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '24007747' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '24618945' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '24911652' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '25145239' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '25582065' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '26026963' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '26924548' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '27252629' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '28034418' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '28948407' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
select '30309169' as bug_number, 'C.4' as fwk_version from Dual
UNION ALL
--B5
select '22284589' as bug_number, 'B.5' as fwk_version from Dual
UNION ALL
select '18936791' as bug_number, 'B.5' as fwk_version from Dual
UNION ALL
select '15880118' as bug_number, 'B.5' as fwk_version from Dual
UNION ALL
select '11894708' as bug_number, 'B.5' as fwk_version from Dual
UNION ALL
select '23200210' as bug_number, 'B.5' as fwk_version from Dual
UNION ALL
select '26731171' as bug_number, 'B.5' as fwk_version from Dual) Bugs
where fwk_version= ( SELECT codelevel FROM AD_TRACKABLE_ENTITIES WHERE abbreviation='fwk')
order by 3;
     
    

Using the sql above - the bundle patch which applies to the Framework Code Level Stack can be determined.

 

Please Note:  An alternative method for confirming the Framework patches is to utilize the following analyzer: Note 2319360.1    E-Business Suite Applications Login Analyzer

NOTE: R12.FWK.B.delta.3 R12.1.3.3 patch 18190190 was never released