R12 - Demantra Integration Part II

Hi Everyone!!

In my last post, I have covered Demantra 7.2- R12 ebiz suite integration overview.
You may would like to review my earlier post Demantra - R12 integration overview.

System Requirement Analysis:

You can verify the requirement of Client, Server,network requirements for installing Demantra 7.2 can be found at 468679.1.
The configuration I have done is represented as "Stack ST" in the above metalink note.

Ebiz R12.0.3:

I Assume that You have R12 instance installed/upgraded and you are at 12.0.3 Patchset level. I had the apps system in Oracle Enterprise Linux 3.0

Run the below sql as apps user,

SQL> select RELEASE_NAME from fnd_product_groups;
RELEASE_NAME
--------------------------------------------------
12.0.3

If you have plan to install R12 freshly you may review the earlier R12 installation post. Apply R12 RUP3 (6141000) on top of R12. Prerequisite and other steps can be found for upgrading the apps system from R12 to R12.0.3 at the note 445192.1.
Apply 7.2 Demantra - 12.0.3 EBS Integration Patch - 6606568

Your Apps System is now ready for integrating with Demantra.
What you need to know is

1) System Password
2) DB SID
3) DB listener port
4) Tablespace where you want to have Demantra data
5) Tablespace where you want to have Demantra indexes

Data	Parameters
Default	APPS_TS_TX_DATA
Temporary	TEMP
Sales	APPS_TS_TX_DATA
Index	APPS_TS_TX_IDX
Simulation	APPS_TS_TX_DATA
Simulation index	APPS_TS_TX_IDX
Sales_data_engine_index_space	APPS_TS_TX_IDX
Sales_data_engine_space	APPS_TS_TX_DATA

Client Oracle Home:

I have Installed Oracle Client Home 10g as my ebiz DB was 10g. Make sure to have both client and oracle home are at same major version level even if its not at same patch set level.

Once I have installed client oracle home 10g, Added the tns entry of ebiz suite to client$ORACLE_HOME/network/admin/tnsnames.ora and verify sqlplus system/systempassword@ebizsid

Demantra7.2 Installation:

Demantra 7.2 Install Patch - 6617634, download and unzip. you will see setup.exe
double click on setup.exe

1) Select Demantra Spectrum


2) click next3) select complete installation


4) select spectrum group, I have selected already existing group, As i have reinstalled for demonstration purposes

5) Select DB type Oracle

6) Client Oracle Home Location
since my windows 2000 Service Pack 4 box had two client oracle home's installed, it is showing both 9i/10g client Oracle Homes.
select 10g as R12.0.3 comes with 10g DB. Otherwise installer will give warning.


7) Feed schema Name - DMTRA_TEMPLATE and password

8) Feed System password


9) Installer verifies the connection


10) select application type


11) Select the Tablespaces

12) Select the URL

13) Plug-in version


14) Admin account, I have selected designate later

15) I didn't select anything

16) installation starts here


17) Installation progresses and completes




Now the installation of Demantra completed. You need to configuration of demantra and you need to deploy the war file in 10.1.3 AS j2ee instance. Stay Tuned for the next update on this journey of integration of demantra with Apps R12.0.3

Happy Learning.!!

Disclaimer:
Readers can use this document only for reference purposes. Please use the metalink document for the source of the truth. And if you are in doubt please consult oracle support before your proceed.