Share the content if you found it is useful (You can share using 300 community websites) click "share" at the end of the post.

You are encouraged to leave a comment.








Tuesday, January 27, 2009

To Install OLAP and Demand Planning In Oracle Applications

Check The following before proceed to Installation of OLAP

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


ODP CUMULATIVE PATCH 2

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:

Related Posts Plugin for WordPress, Blogger...

Let us be Friends...

Share |

Popular Posts

Recent Comments