Oracle Apps R12 (EBS) - Demantra Integration

Oracle Demantra Overview
Oracle Apps R12 (EBS) - Demantra Integration

1.Install Oracle 10g database or Install Oracle 10g Client
2.Install Oracle iAS 10.1.3 Middle Tier
3.Install Oracle Demantra 7.2
4.Upgrade Oracle R12 to Oracle R12.0.4 (SCP is at the 12.0.3)
5.Install Oracle EBS-Demantra Integration Patch
6.Create and Deploy demantra.war file to Oracle AS 10.1.3 Middle Tier
7.Startup Oracle Demantra Steps

Oracle Apps R12 (EBS) - Demantra Integration Installing Steps

1.Install Oracle 10g Database

Pls see the Post Install Oracle 10g Database installing Step

After Database installed Create Required Tablespaces.

For Default DATA tablespace
create tablespace TS_DP datafile '.../ts_dp01.dbf' size 300M autoextend on maxsize 2000M;

For Default SALES tablespace
create tablespace TS_SALES_DATA datafile '.../ts_sales_data01.dbf' size 300M autoextend on maxsize 2000M;

For Default SALES INDEX tablespace
create tablespace TS_SALES_DATA_X datafile '.../ts_sales_data_x01.dbf' size 300M autoextend on maxsize 2000M;

For Default SIMULATION DATA tablespace
create tablespace TS_SIM datafile '.../ts_sim01.dbf' size 300M autoextend on maxsize 2000M;

For Default SIMULATION INDEX tablespace
create tablespace TS_SIM_X datafile '.../ts_sim_x01.dbf' size 300M autoextend on maxsize 2000M;

For Default SALES DATA ENGINE tablespace
create tablespace TS_SALES_DATA_ENGINE datafile '.../ts_sales_data_engine01.dbf' size 300M autoextend on maxsize 2000M;

For Default SALES DATA ENGINE INDEX tablespace
create tablespace TS_SALES_DATA_ENGINE_X datafile '.../dmants_sales_data_engine_x01.dbf' size 300M autoextend on maxsize 2000M;
alter system tablespace ....(Required Size)

2.Installing Oracle iAS 10.1.3 Middle Tier

Pls See the Post Oracle iAS(10.1.3.1.0) Installing Step on Windows

3.Install Oracle Demantra 7.2
Download Oracle Demantra 7.2.0(6617634)
Installing Steps for Oracle Demantra 7.2
Run Setup.exe

Select Complete


Select Oracle

Oracle DBA Username: system
Oracle DBA Password : xxxxxx
TNS Name : orcl

Oracle Dramntra Username : dp Password : xx

Select Tablespace Name For Demantra





Click Install





Click Done.

Run Tamcat WebServer

%DEMANTRA_HOME%\Collaborator\Tomcat\bin\startup.bat

Demantra Home Page

http://sys50.doyen.in:8080/demantra

4.Upgrade R12 to R12.0.4

Pls See the Post Upgrade Oracle E-Business Suite (EBS) R12 to R12.0.4

5.Install Oracle EBS-Demantra Integration Patch

Download Oracle EBS-Demantra Integration Patch(6606568)
1. Apply this patch in Your Oracle R12 EBS

2. If Demantra is installed after this patch has been applied, please run msddemcrsyn.sql from $MSD_TOP/patch/115/sql.

After Apply Patch
1. Login System Administrator Responsibility
2. Nav: Profile -> System
3. Query profile MSD_DEM: Host URL.
4. Change value to http://hostname:port/demantra e.g (http://sys50.doyen.in:8080/demantra)
5. Save.
6. Run the following script on the ASCP/MSC instance which also contains the Demantra Schema to determine the actual schema name for Demantra:

select owner
from all_tables
where table_name = 'SALES_DATA';

7. Set profile option MSD_DEM: Schema = to the value returned from the script in step 1 at the site level and save. System Administrator/Profiles/System - query for MSD_DEM:% - select the Find button - Find/scroll to the profile option MSD_DEM: Schema - set the correct value at the site level - save

8.SQL>select fnd_profile.value('MSD_DEM_SCHEMA') from dual;

9.SQL>select fnd_profile.value('MSD_DEM_HOST_URL') from dual;

10.Login Demand Management System Administrator

6.Create and Deploy demantra.war file to Oracle AS 10.1.3 Middle Tier
Run Create_war.bat (%DEMANTRA_HOME%\Collaborator\demantra)

Copy b2b.war (%DEMANTRA_HOME%\Collaborator\demantra) to temp folder or use same folder
Open Oracle iAS Enterprise Manager
http://sys50/em

Click Applications
Click Deploy
Click Next

Change Application Name : demantra
Click Deploy

After open Page

http://sys50/demantra/portal/loginpage.jsp (iAS)

7.Oracle Demantra Strartup Steps

1.Startup Oracle Database Listener.
2.Startup Oracle Database.
3.Startup Tamcat Webserver.
4.Startup Oracle iAS Services.

Demantra Login Page

http://sys50.doyen.in:8080/demantra/portal/loginpage.jsp

Collaborator Workbench
http://sys50.doyen.in:8080/demantra/portal/loginpage.jsp

Web client
http://sys50.doyen.in:8080/demantra/portal/partnerLogin.jsp

Oracle Demantra Anywhere version of Collaborator Workbench
http://sys50.doyen.in:8080/demantra/portal/remoteloginpage.jsp

Oracle Demantra Anywhere version of Web client alone
http://sys50.doyen.in:8080/demantra/portal/anywhereLogin.jsp

Offline access to Oracle Demantra worksheets
http://sys50.doyen.in:8080/demantra/portal/launchDPWeb.jnlp

Dynamic Open Link (DOL) access for third-party reporting tools
http://sys50.doyen.in:8080/demantra/portal/DOL_HTML.htm

User Management
http://sys50.doyen.in:8080/demantra/portal/userManagement.jsp

Collaborator Workbench Administration
http://sys50.doyen.in:8080/demantra/portal/adminLogin.jsp

Workflow Manager
http://sys50.doyen.in:8080/demantra/workflow/login.jsp

Technical Administration
http://sys50.doyen.in:8080/demantra/admin

Metalink ID: 434991.1 - EBS-Demantra Integration Installation Overview and Diagram