a) In ODP as Demand Planning System Administrator (DPSA), Demand Plan Manager (DPM) or Demand Planner (DP), locate the 'About Demand Planning' button. As DPM or DP it is in the left frame, in the Help icon (?).
Note the setting for 'Build'
Alternatively, you can check the ODPCODE.VERSION in Express Monitor or in
SQL*PLUS as the APPS user:
set serveroutput on
exec dbms_aw.execute('aw attach APPS.odpcode ro');
exec dbms_aw.execute('decimals=5');
exec dbms_aw.execute('show odpcode.version');
exec dbms_aw.execute('aw detach APPS.odpcode')
With the info in 'Build' or in ODPCODE.VERSION, you can compare with this table:
Patch Name Patch Number ODPCODE.VERSION
---- ----- ----
Patchset J, 11.5.10 3930903 1.245
Patchset J CU1 4042499 1.245
Patchset J, 11.5.10.CU2 4398235 1.250
Note that as the table is not complete for all ODP 11.5.10 patches, it is instead recommended that method b), to discover the exact ODP patch level.
These patches already contains the internal version properly set:
Patch Name Patch Number ODPCODE.VERSION
---- ----- ----
DP RUP#6 5934903 1.256
DP RUP#7 5869450 1.257
DP RUP#8 6036268 1.258
DP RUP#9 6036268 1.259
DP RUP#10 6353791 1.26600
DP RUP#11 6625130 1.26700
DP RUP#12 6751750 1.26800
DP RUP#13 7115768 1.26900
------------------------
b) Run the following query as APPS account from SQL*PLUS:
select a.bug PatchNo,
decode (a.bug,
'3930903','DPE CONSOLIDATED 11.5.10 PATCH',
'4104832', 'CUMULATIVE 1 PATCH',
'4398235','CUMULATIVE 2 PATCH ',
'5120460','DPE RUP#1',
'5367230','DP RUP#2 PATCH Obsolete',
'5578973','DP RUP#2 PATCH',
'5395666','DP RUP#3 PATCH',
'5578993','DP RUP#4 PATCH',
'5659805','DP RUP#5 PATCH',
'5934903','DP RUP#6 PATCH',
'5869450','DP RUP#7 PATCH',
'6036268','DP RUP#8 PATCH Obsolete',
'6321532','DP RUP#8 PATCH',
'6200268','DP RUP#9 PATCH',
'6416414','Patch on Top RUP#9',
'6353791','DP RUP#10 PATCH',
'6625130','DP RUP#11 PATCH',
'6751750','DP RUP#12 PATCH',
'7115768','DP RUP#13 PATCH')
Description,
nvl(to_char(b.creation_date),'Not Installed') Installed
from applsys.ad_bugs b,
(select 3930903 bug from dual union
select 4104832 bug from dual union
select 4398235 bug from dual union
select 5120460 bug from dual union
select 5367230 bug from dual union
select 5578973 bug from dual union
select 5395666 bug from dual union
select 5578993 bug from dual union
select 5659805 bug from dual union
select 5934903 bug from dual union
select 5869450 bug from dual union
select 6036268 bug from dual union
select 6321532 bug from dual union
select 6200268 bug from dual union
select 6416414 bug from dual union
select 6353791 bug from dual union
select 6625130 bug from dual union
select 6751750 bug from dual union
select 7115768 bug from dual
) a
where to_char(substr(a.bug,1,7)) = to_char(b.bug_number(+))
order by a.bug desc
------------------------
c) An alternative way to check the ODP patch level is to run these commands from SQL*PLUS:
ODP 11.5.10 base without any patch:
select * from applsys.ad_bugs where bug_number='3930903';
result:
Patch 3930903
Description DPE CONSOLIDATED 11.5.10 PATCH
Product Demand Planning Engine
Release 11i
Last Updated 05-JAN-2005
ODP 11.5.10 CUMULATIVE PATCH 1:
select * from applsys.ad_bugs where bug_number='4104832';
result:
Patch 4104832
Description HOLDER FOR DPE 11.5.10.1CU (V5) - CUMULATIVE 1 PATCH FOR 11.5.10+
Product Demand Planning Engine
Release 11i
Last Updated 17-MAR-2005
select * from applsys.ad_bugs where bug_number='4398235';
result:
Patch 4398235
Description HOLDER FOR DPE 11.5.10.2CU (V7) - CUMULATIVE 2 PATCH FOR 11.5.10+
Product Demand Planning Engine
Release 11i
Last Updated 08-JUL-2005
ODP RUP#1 (CU3)
select * from applsys.ad_bugs where bug_number='5120460';
result:
Patch 5120460
Description DPE RUP#1 ON TOP OF 11.5.10 CU2
Product Demand Planning Engine
Release 11i
Last Updated 03-JUL-2006
ODP RUP#2
select * from applsys.ad_bugs where bug_number='5367230';
result:
Patch 5367230
Description DP 11510 RUP#2 PATCH
Product Demand Planning Engine
Release 11i
Last Updated 05-OCT-2006
ODP RUP#2 (like previous one but with a .sql corrected)
select * from applsys.ad_bugs where bug_number='5578973';
result:
Patch 5578973
Description DP 11510 RUP#2 PATCH
Product Demand Planning
Release 11i
Last Updated 05-OCT-2006
ODP DP RUP#3
select * from applsys.ad_bugs where bug_number='5395666';
result:
Patch 5395666
Description DP RUP#3 PATCH FOR 11.5.10 BRANCH
Product Demand Planning Engine
Release 11i
Last Updated 06-NOV-2006
ODP DP RUP#4
select * from applsys.ad_bugs where bug_number='5578993';
result:
Patch 5578993
Description DP RUP#4 PATCH FOR 11.5.10 BRANCH
Product Demand Planning Engine
Release 11i
Last Updated 04-DEC-2006
ODP DP RUP#5
select * from applsys.ad_bugs where bug_number='5659805';
result:
Patch 5659805
Description DP RUP#5 PATCH FOR 11.5.10 BRANCH
Product Demand Planning Engine
Release 11i
Last Updated 11-JAN-2007
ODP DP RUP#6
select * from applsys.ad_bugs where bug_number='5934903';
result:
Patch 5934903
Description DP RUP#6 PATCH FOR (MSD+MSE) 11.5.10 BRANCH
Product Demand Planning Engine
Release 11i
Last Updated 15-MAR-2007
NOTE: Please, apply the Patch 5934903 instead of Patch 5715560.
The below Patch 5715560 should NOT be applied on RDBMS 10.x (there is
no problem if you apply it on RDBMS 9.x).
select * from applsys.ad_bugs where bug_number='5715560';
result:
Patch 5715560
Description DP RUP#6 PATCH FOR (MSD+MSE) 11.5.10 BRANCH
Product Demand Planning Engine
Release 11i
Last Updated 09-MAR-2007
ODP DP RUP#7
select * from applsys.ad_bugs where bug_number='5869450';
result:
Patch 5869450
Description DP RUP#7 PATCH FOR (MSD+MSE) 11.5.10 BRANCH
Product Demand Planning Engine
Release 11i
Last Updated 23-MAY-2007
ODP DP RUP#8
select * from applsys.ad_bugs where bug_number='6321532';
Patch 6321532
Description DP RUP#8 PATCH FOR (MSD+MSE) 11.5.10 BRANCH
Product Demand Planning Engine
Release 11i
Last Updated 03-AUG-2007
NOTE: Please, apply the Patch 6321532 instead of Patch 6036268.
The below Patch 6036268 should NOT be applied on RDBMS 10.x (there is
no problem if you apply it on RDBMS 9.x).
select * from applsys.ad_bugs where bug_number='6036268';
result:
Patch 6036268
Description DP RUP#8 PATCH FOR (MSD+MSE) 11.5.10 BRANCH
Product Demand Planning Engine
Release 11i
Last Updated 31-JUL-2007
ODP DP RUP#9
select * from applsys.ad_bugs where bug_number='6200268';
Patch 6200268
Description DP RUP#9 PATCH FOR 11.5.10 BRANCH
Product Demand Planning Engine
Release 11i
Last Updated 28-SEP-2007
NOTE:
If you have already applied the Patch 6200268 (RUP#9), then you should apply also the patch:
Patch 6416414
Description ERROR "(MXUPDATE03) AW MSD.MSD3581A1 IS READ-ONLY" WHILE LOGGING IN
Product Demand Planning
Release 11i
Last Updated 20-SEP-2007
This is because code for Patch 6370304 got into RUP#9 requiring the subsequent patch to be needed.
Query:
select * from applsys.ad_bugs where bug_number='6416414';
ODP DP RUP#10
select * from applsys.ad_bugs where bug_number='6353791';
Patch 6353791
Description DP RUP#10 PATCH FOR 11.5.10 BRANCH
Product Demand Planning Engine
Release 11i
Last Updated 12-DEC-2007
ODP DP RUP#11
select * from applsys.ad_bugs where bug_number='6625130';
Patch 6625130
Description DP RUP#11 PATCH FOR 11.5.10 BRANCH
Product Demand Planning Engine
Release 11i
Last Updated 24-MAR-2008
ODP DP RUP#12
select * from applsys.ad_bugs where bug_number='6751750';
Patch 6751750
Description APS DP RUP#12 PATCH FOR 11.5.10 BRANCH
Product Demand Planning Engine
Release 11i
Last Updated 10-AUG-2008
ODP DP RUP#13
select * from applsys.ad_bugs where bug_number='7115768';
Description APS DP RUP#13 PATCH FOR 11.5.10 BRANCH
Product Demand Planning Engine
Release 11i
Last Updated 28-OCT-2008
d) To check the Web Agent version, you can use, the following:
d.1) Using Express Monitor in ODP:
aw attach apps.xwdevkit first
rpr w 30 _xwd_devkitver
Example:
_XWD_DEVKITVER
------------------------------
9.48.0.0
d.2) Using SQL*PLUS:
set serveroutput on
exec dbms_aw.execute('aw attach apps.xwdevkit ro');
exec dbms_aw.execute('rpr w 30 _xwd_devkitver');
exec dbms_aw.execute('aw detach apps.xwdevkit');
Example:
_XWD_DEVKITVER
------------------------------
9.48.0.0
If you do not see the following directory on your system: cwmlite\admin
You need to install the oracle olap 9.2.0.1.0 from the product cd following
these steps:1. Insert the 9.2.0.1 Disk 1 into the cd drive
2. Choose install/deinstall
3. Click Next
4. Choose your oracle home --
this will be where you already installed the 9i database without the olap option
5. Select Oracle 9i Database 9.2.0.1.0 Enterprise Edition
6. Click Next
7. Select Custom
9. Click Next
10. Under Enterprise Edition Options.Check Oracle OLAP 9.2.0.1.0
Once the scripts are installed, perform the following steps to install the cwmlitemetadata:
In sql*plus, connected to the database as a dba and issue the following:
(Replacing the ORACLE_HOME with your Oracle Home and mysid with your database sid
ORACLE_BASE is the root directory of all your oracle product installs,
if you areusing Oracle Flexible Architecture (OFA))
If the cwmlite/admin directory is NOT present issue the following SQL/PLUS commands:
sql> connect SYS/sys_password as SYSDBA
sql> CREATE TABLESPACE "CWMLITE" LOGGING DATAFILE '/ORACLE_BASE/oradata/mysid/cwmlite01.dbf'
SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
sql> @?/ORACLE_HOME/olap/admin/olap.sql mysid
sql> connect SYS/sys_password as SYSDBA
sql> @?/cwmlite/admin/oneinstl.sql CWMLITE TEMP;
If the cwmlite/admin directory is present and the CWMLITE tablespace already exist,
simply issue the following commands:In sql*plus:
sql> connect SYS/sys_password as SYSDBA
sql> @?/olap/admin/olap.sql mysid
sql> @?/cwmlite/admin/oneinstl.sql CWMLITE TEMP;
oneinstl.sql takes two arguments, the destination tablespace (in this case CWMLITE)
and the temporary tablespace (TEMP)
For 10G:
--------
There is no need to create the cwmlite tablespace as the catalog is now stored in the SYSAUX tablespace.
All one needs to do in 10g is run this script on Enterprise instances that require the OLAP option.
sql>?\olap\admin\olap.sql SYSAUX TEMP
Apply 3553738 (OPatch) (Mandatory)
Applications Part:
Download and Apply : Patch no. 3930903
Then Apply: 4398235 Patch .
Now check with Demand Planning Administrator Responsibility to get the relevant menus.
No comments:
Post a Comment