R12 - Demantra Integration Overview

Oracle Acquired DEMANTRA(DEMANd management, sales and operations planning, and TRAde promotions management) on 1st June 2006. Together with Oracle's existing ERP solutions one can proactively manage complex, global supply chain operations.

I am going to cover Demantra Installation and integration of Demantra with Oracle Ebiz Suite in this and forthcoming articles. Integration benefits much of the customers of Oracle. 75% of Demantra customer using Oracle's ERP. More details can be found here

I have done DEMANTRA integration recently with R12.0.3 ebiz suite.
I thought of covering the details of the integration. In this post, I will be covering the high level picture of the integration.

Demantra UI looks alike the one is shown here


My Integration involved:

1) R12 with RUP3 in OEL Linux 3.0- R12.0.3 - Ebiz Installation R12 with RUP3 patch
2) Separate 10.1.3 AS installation in windows 2000 server - (do not confuse with 10.1.3 OH comes along with ebiz suite).
do fresh install of 10.1.3 Application Server installation ( installation type Integrated Web Server, J2EE Server, and Process Management).
Its just a mid-tier J2EE installation of 10g 10.1.3 AS. I assume that I do not register my Demantra and ebiz suite as partner application in SSO.
3) Separate 10g DB Client Oracle software in windows 2000 server.
4) Demantra 7.2 Installation - Windows 2003 server where you have installed 10g Client Oracle software.

In my implementation I had ebiz instance in one of the Oracle Enterprise Linux 3.0 and in windows 2003 server I had 10.1.3 AS installation + Client 10g DB installation + Demantra installation



You must be knowing now the techstack involved with the integration of Demantra with Ebiz.
I will cover the detailed step by step in my next post. Stay Tuned.

57 comments:

Michael Taylor said...

Hi Suresh, I saw your blog on Demantra with 12.0.3. Nice work

- Michael Taylor

Hemant said...

Hi Suresh,
Thanks to you for maintaining this Blog , especially i really thanks to you for sharing information about Dmantra , i hardly find any relevent information on dmantra than this Blog.
Further i have one query from you that , my client having 11.5.9 environment and want to go for Dmantra without upgrading Oracle Applications. Is it possible to have dmantra installed on stand-alone server(without integrating with 11i) can you give me some idea about it .
Thanks for your help
Hemant Kumar
Apps DBA

Suresh Lakshmanan said...

Hemant,

Your question is not clear. You want to integrate with 11i system or just you want to have Demantra alone(no integration with EBS).

In the case where you do not want to Integrate with EBS, yes - you can do that, just install demantra and iAS and deploy the war file - posts clearly gives you information about the installation and deployment of war on iAS.

In the case you want to integrate with 11i - 11.5.9 - you need to check the certification matrix whether Demantra is certified with 11.5.9 or not.(I haven't done with 11.5.9). I hope this helps. If certification matrix doesn't say any info, please check with Oracle support to get more info. there is possibility that applying Demantra integration patches on top of 11.5.9 will be okay to integrate with Demantra.(this you have to confirm from Oracle support/ oracle demantra team - if certification is not done)

Its glad to see that posts helping folks out there in Demantra, EBS industry.

Hemant said...

Hi suresh,
Thanks For your Reply.I am going ahead without integrate.My doubt is what to install Database client or server.Before 11.5.10 , we have tablespace of every product, here i see that you have given APPS_TS_TX_DATA , but in my case what should i do? if i need to create Tablespace which datafiles i need to add? Thanks for your help.
Hemant

Suresh Lakshmanan said...

Hemant,

After reading the reply from you, I infer that you are in the process of integration, first of all check with support whether 11.5.9 certified with demantra or not. Proceed only if its certified.

For the tablespace issue, you can create one tablespace and you can place the tables and indexes you want.(if you are not integrating with EBS then I would suggest to have different DB for storing the data rather than using EBS).

you have to install client Oracle Home in the box where you install Demantra software.

Sathyendra said...

Hi Suresh,

Its nice to see a good and valuable document on Demantra. Thanks for sharing the knowledge.

I would like to know if I have to install the Oracle10g Client, Demantra and 10g AS on each and every client machine or can we install all the 3 softwares on one single server separate from where R12 was installed.


Also, is 10g AS mandatory for R12 too?

Please advise

Thanks
Kishore

Suresh Lakshmanan said...

My updates are in between ***

I would like to know if I have to install the Oracle10g Client, Demantra and 10g AS on each and every client machine or can we install all the 3 softwares on one single server separate from where R12 was installed.

***(Only at server is required)****

Also, is 10g AS mandatory for R12 too?

***(Yes, it is required though R12 comes with 10.1.2 and 10.1.3)****

Suresh

Sathyendra said...

Hi Suresh,

Thanks for the quick reply..

Since I being a novice in Demantra, the question may sound stupid but I would like to know if all the 3 softwares i.e, Demantra, Oracle10gAS and oracle10g Client are installed on one single server different from R12 installed server, then how an end user/ technical/functional guys accesses it. Is it only thru URL or do they have to install something at thier machine.

Thanks
Kishore

Suresh Lakshmanan said...

Kishore,

Its through URL as well as from the Local access to the windows box where you have installed the Demantra software. sometime they access Business Modeler.

I didn't see anytime they had installed piece of s/w in their local machine.

Hope this helps you.

-Suresh

Krishna Kumari said...

Hi Suresh,

Thanks for sharing such valuable information for appsdba’s through this Blog.

We are working on Demantra from last one week by following your blog. We installed 10 client,Demantra in separate machine which is separated from R12 instance.

Now I would like to know the is it mandatory installing the 10AS separate installation. If so where we will get the software for 10g AS as per your Blog.


Thanks & Regards

Krishna Kumari

IGATE GLOBAL SOLUTIONS LTD.

Suresh Lakshmanan said...

Hi Krishna Kumari,

Happy to see that Demantra posts are helping folks around the globe.

You will be able to download from edelivery.oracle.com

select the product as EBIZ and end of the page there is a download link for 10g AS. (Please get the license from Oracle. If you get
licensee from Oracle, I think they will send you DVD/CD bundle). But always you can download for trial purposes for 30 days using edelivery(read license agreement terms for using the download).

I hope this helps you.

Regards
Suresh

krishna said...

Hi Suresh,

Thanks for giving the quick reply. Completed download of the Software from link which you provided for us.

we are in the processes of installing, if we require any help we will get back to you.


Once again thanks a lot to you for sharing such a valuable information acrose the Blog.

Krishna Kumari
Apps DBA

Suresh Lakshmanan said...

Krishna Kumari,

Its my pleasure!!

Suresh

Sini said...

Hello All,

I could be the newest person in Demantra community. Some of our Sales/Mkt leaders are looking to implement Demantra...and i being in IT looking for some common install architecture that most of the Demantra customer have for their PTP (or) DM module setup.
-----
We have Oracle ERP 11i (11.5.9) with Oracle 10g.
- Does Demantra has to be integrated to our ERP system to extract Sales/Mkt data?
- What would be a typical setup for Demantra deployment?
like...(Demantra apps + Oracle client + Web Server) in One Win Server. Note sure any std on how to integrate data extract from source systems?
We have Data Warehouse that extract all ERP/CRM data into..

Sorry for the long list of question..

Thanks,
Sini (siniks@gmail.com)

Suresh Lakshmanan said...

Hi Srini,

- Does Demantra has to be integrated to our ERP system to extract Sales/Mkt data?

Not Sure Srini, Any functional analyst will be able to tell.

- What would be a typical setup for Demantra deployment?

Setup steps are explained in this blog - read the full series of demantra articles.

Thanks
Suresh

Anonymous said...

hi suresh,
I was NOT able to create Database ,it got struck in the "step" while creating database

Regards
Lok

Suresh Lakshmanan said...

Hi Lok,

Please check whether you are meeting the oracle client requirements.
otacle 10g ebuiz suite(11i with 10g db) integration requires 10g client.
Best of Luck!!

Thanks
Suresh

lokesh said...

Hi Suresh,
I was NOT able to login from IE(To Colabrator WorkBench).It is giving me Invalid Username/Passowrd

Buy i was able to login(with same username/passowrd) to Demand Planner

Suresh Lakshmanan said...

Hi Lokesh,

please review the user Synchronization section of the post
http://applicationsdba.blogspot.com/2008/01/r12-demanta-integration-part-v.html
That may help you. If you SSO authentication this issue will not come!!

Thanks
Suresh

Atul from Infosys said...

Hi Suresh,



I came across your blog, really very useful.



I was installing Demantra 7.2, I have some doubt, if the integration between 7.2 and EBS 11.5.10 is available.


I came across following text in metalink note:468679.1 which is “Oracle Demantra System Requirements for Release 7.2 “



“For Java/Oracle e-Business Suite integration with release 7.2:


- Demantra is certified against Oracle Application Server 10g but Oracle e-Business Suite 11.5.10 ships with Oracle Application 9i, so they each have to run on separate Oracle Application Server instances.

- Oracle e-Business Suite 12 is certified on JDK 1.4 and 1.5, so you can deploy Oracle Demantra Demand Management 7.2 with e-Business Suite 12 on Oracle Application Server10g. Oracle recommends deploying with JDK 1.4.
- If you want to have Oracle Demantra Sales and Operations Planning and Oracle Demantra Demand Management integrated with Oracle e-Business Suite 12, the possibility exists for putting Oracle Demantra and Oracle e-Business Suite on the same application server because Oracle e-Business Suite12 ships with Oracle Application Server 10g. and Oracle e-Business Suite 12 is certified on JDK 1.5.”







I am not able to decipher if 7.2 will run EBS 11.5.10 or not.

Can you please throw some light on this, If Demantra 7.2 has integration with EBS 11.5.10 or not and what has to done to integrate both.



Regards



Atul Jain

Associate Consultant – SCM

Suresh Lakshmanan said...

Hi Atul,

apologies for the late response.
I have worked with R12 with 7.2 and 11.5.10 with 7.1, Ideally 7.2 with 11.5.10 CU2 should work. as you will be
installing 10g AS server separately in other box where you will be deploying b2b war. other than that demantra_template
schema will be residing in 11i ebiz instance. Ideally there is no logical bottlenecki am seeing. Highlighted sentence saying it will
be working. But check with Oracle support, whether they have certified for 11i with 7.2 configuration.

Ideally it should work/it will work per my understanding.

Thanks
Suresh

shekhar said...

Hi Atul & Suresh
I have been working on Demantra & EBS integration as well as Demantra Siebel Integration.

I have tried various permutations and combinations between Demantra 7.1.1/7.2 and EBS 11.5.10/12 and found out that

EBS 11.5.10CU2 is integrated with Demantra Version 7.1.1
whereas
EBS R12 is integrated with Demantra version 7.2

While Demantra 7.2.1 is exclusively for working with Siebel 7.8 and above(CPG industry specific integration).

Further you can view the Note:727237.1 on metalink which substantiates my view.

For further guidance/discussion feel free to contact.

Suresh Lakshmanan said...

Hi Shekhar,

Thanks for the wonderful information.

Atul,

Hopefully this will be helping you much.

Thanks
Suresh

Radhika Ganganna from Oracle said...

Hi Suresh,

Saw your blog. It’s quite interesting.

Do you have nay docs on Demantra Architecture overview?

Please let me know.

Regards,

Radhika

Suresh Lakshmanan said...

HI Radhika,

Sorry for the late reply. I was on long vacation. Demantra Implementation guide has the information you are looking for.
http://www.oracle.com/technology/documentation/demantra.html is the link contains the documentation set. in that look out of index.html and in that you can find implementation guide.
chapter 1 contains the pictures.
PDF: E05136_04.pdf

Let me know if you need more on this.

Thanks
Suresh

Radhika said...

Hi Suresh,

Thanks for your help.

Regards,
Radhika

Ashutosh, Mindtree said...

Dear Suresh ,

I am ashutosh Mishra from Bangalore . we are working in demantra standalone version . we are trying to intregrate EBS with demantra . your document is very good . I want to thanks you for this document this very helpful to us.

Thanks & Regards
Ashutosh Mishra (#M1008293)
Assoicate IT -services, Mindtree Ltd
phase 1, 3rd floor , MTW, bangalore-59

Suresh Lakshmanan said...

Ashutosh,

I am very happy to hear that the docs are helping the engineers around the globe.

Thanks for your positive encouraging comment.

Thanks
Suresh

Utkarsha said...

Hi Suresh,

I am a APS suite fucntional consultant and need to learn Demantra for implementing it for one of my clients. From the info you have provided in the blog... looks like its poosible to have it installed on a laptop (standalone mode...not integrated with EBS). Can you guide me in getting this done. I am not a DBA. Will I be able to do it myself? Whats the way?

Thanks and Regards,
Utkarsh

Suresh Lakshmanan said...

Hi Utkarsh,

yes its possible to install demnatra standalone. its just exe. double click will let you and prompt you all the required info. you should have db installed.

Thanks
Suresh

Madhu said...

Hi Suresh,

This blog is really helpful.

I am beginner in demantra.

Is there any way/possibility where demantra7.1 can be integrted with 11.5.9 EBS..

let me know..

Thanks,
Vishal

Suresh Lakshmanan said...

Hi Vishal,

as far as I know. No. I haven't heard of 11.5.9 integration with demantra. Please check with Oracle Support. I think there is no integration patch for ebiz 11.5.9. please confirm with oracle support. update me if you have any answer for that. thank you.

Thanks
Suresh

Shekhar said...

Hi Vishal,
I hope by now you might have received response for your query from Oracle support too.

As per my knowledge there is no standard integration available between Oracle Apps 11.5.9 and Demantra 7.1.But there have been instances of custom integration between nonstandard versions of EBS and Demantra.

Regards,
Shekhar

Suresh Lakshmanan said...

Thank you Shekhar.

Shekhar said...

Hi Suresh,
You have any experience in AIA implmentation that you can share?

Thanks and Regards,
Shekhar

Suresh Lakshmanan said...

No Shekhar,

I didn't get a chance. I update this blog with interesting info.

Thanks
Suresh

rajkumar.singh said...

i have seen ur blogs on demantra install .. really appreciate ur work and enthusiasm twds it

Suresh Lakshmanan said...

Thanks Rajkumar.

Louis said...

Hi Suresh,

I require to install demantra 7.3 standalone and integrate the same with JD Edwards EnterpriseOne 9.0

Kindly send me required details,

Thanks & Regards,

Louis

Louis said...

Hi Suresh,

I require to install demantra 7.3 standalone and integrate the same with JD Edwards EnterpriseOne 9.0

Kindly send me required details,

Thanks & Regards,

Louis

Suresh Lakshmanan said...

Hi Louis,

Here is the metalink note that will help you to integrate.

ID 746460.1

Thanks
Suresh

Louis said...

Thanks Suresh

Louis said...

Hi Suresh,

During Demantra Spectrum installation there is an error displayed " TNS name 'E1Local' cannot be resolved.Please verify the entered TNS Name."
I am not able to proceed further on this.
1.Pls find below the tnsnames file and listener file.

E1LOCAL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = E1Local)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\Oracle\E1Local)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

In the TNSNAME field and the SID field in the Demantr spectrum
'E1Local' has been entered.

The Oracle local database E1Local was automatically installed on the installation of JD Edwards 9.0 standalone (demo) I am trying to integrate Demantra 7.3 with JDE.

Is the local database sufficient for Demantra

Please advise.

Thanks & Regards,

Louis

Suresh Lakshmanan said...

Hi Louis,

Have you tested the database connections.
Are you able to make connections to the database using the tns entry?

Like 'sqlplus username/password@E1Local' ? Are you able to tnsping the listener? (ie. "tnsping E1Local" working in cmd line?)

Can you please document all the activity that you do in a doc. If you are okay send me across, i Can post it with your name. This is new integration that is with JDE and demantra. I have no such post in the blog. Appreciate your documentation.

Thanks
Suresh

Louis said...

Hi Suresh,

The TNS error is resolved, but there is another error popping up,

"Failed to establish administrator connection to the database.it may indicate incorrect JDBC settings or incorrect username/password"

I had checked the username/pswd.

Am i missing something?

Regarding the doc I shall keep you posted.

Thanks & Regards,

Louis

Suresh Lakshmanan said...

Hi Louis,

Good to hear that you are making progress.
One thing I have noticed earlier was password file creation for the database. Make sure you are able to make system/sys connections as sysdba from remote using sqlnet.

sqlplus sys/password@dbname as sysdba should work!

Thanks
Suresh

Anonymous said...

Hi Suresh

I have installed demantra spectrum. But when i click on Planning activities from collabarator workbench an error is encontered that "tns listner does not currently know of service requested in connect "It may be noted that I can connect to the database instance using SQLPLUS and also I can tnsping the sid.Please suggest the possible solution.

Thank You
Regards

Nitin

Anonymous said...

HI Suresh .

When I click on Planning applciation from collabraotor workbench i get an error stating that "TNS : Listner does not currently know of service requested in connect ".I can conect to the instance using sqlplus and also do a tnsping on to the sid.Please suggest the possile solution.

Thank you
Regards

Nitin

Suresh Lakshmanan said...

Hi Nitin,

Please try connecting to the database with sys as sysdba using remote string. ie. you need to have the password file setup in the database server side.

sqlplus 'sys/password@dbname as sysdba' should work.

make sure tnsnames.ora has the details about the database listener.

Thanks
Suresh

Suman Kanta said...

Hi Suresh,
We are in process of integrating Demantra 7.3 with Oracle Applications 11.5.10. Source and Destination are on seperate instances, both are 11.5.10
Database is 11g

When I run "Collect Shipment and Booking History" the program completes with warning on Collect Shipment and History

**Starts**23-FEB-2010 16:18:32
**Ends**23-FEB-2010 16:53:03
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1674
ORA-29276: transfer timeout

The Launch EP Load process completes with following error

**Starts**23-FEB-2010 16:57:12
**Ends**23-FEB-2010 16:57:12
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1577
ORA-24247: network access denied by access control list (ACL)

I have gone through your blog and executed the below script

sqlplus / as sysdba

DECLARE

ACL_PATH VARCHAR2(32767);

BEGIN

SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS

WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;

dbms_output.put_line('acl_path = '|| acl_path);

dbms_output.put_line('ACL exists. Now checking for privilege and adding the privilege');

IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH,'DEMANTRA73A','connect') IS NULL THEN

DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,'DEMANTRA73A', TRUE, 'connect');

END IF;

EXCEPTION -- When no ACL has been assigned to '*'

WHEN NO_DATA_FOUND THEN

dbms_output.put_line('DEMANTRA73A does not have privilege, creating the ACL now');

DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('users.xml',

'ACL that lets DEMANTRA73A to use the UTL Package',

'DEMANTRA73A', TRUE, 'connect');

dbms_output.put_line('DEMANTRA73A does not have privilege, assigning ACL now');

DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('users.xml','*');

END;
/

Still the same error.
Can you point out what we are missing.

We also executed @GRANT_HTTP_TO_DEMANTRA.sql from sysdba.

Nothing has helped so far.

Thanks in advance,
Suman

Suresh Lakshmanan said...

Hi Suman,

Sorry for the late reply. I was on vacation. please review the metalink notes

NOTE:566733.1 - Executing UTL_HTTP Gives ORA-24247: Network Access Denied by Access Control

ORA-24247 When Executing UTL_HTTP UTL_INADDR Packages [ID 453786.1]

that will resolve your issue.

Thanks
Suresh

Deepankar said...

Hi Suresh

I am going through your post on Demantra -R12 Integration.

It is interesting.Keep up the good work.

I have few clarifications.I am basically a functional consultant and thriving towards making a deep dive to understand Demantra.

At my workplace,according to my DBA he says there is a space constraint on the server , as it occupies a lot of space in RAM.For installing RAM we need to install 10g AS and Demantra.Both would take 1-2 GB in RAM.Already RAM space is a crunch according to him.

I would like to install on my local PC in our company.Already I am using Oracle apps Rel 12.Currently Oracle 10g is not installed ,10g AS is also not on my system.I would like to install Demantra 7.2 or 7.3 on my system.We are using 12.1.1.

The plan which i understand would be right is install 10g and Demantra 7.2 or 7.3 on my PC and 10 g AS on the server where the R12 instance is installed.Will this be right?

Also After i am successful how do i integrate Rel 12 to the Demantra to look into the features available in EBS and Demantra.

Thanks
Deep

Suresh Lakshmanan said...

Hi Deep,

The plan which i understand would be right is install 10g and Demantra 7.2 or 7.3 on my PC and 10 g AS on the server where the R12 instance is installed.Will this be right?

Yes, you can install demantra in your laptop provided you laptop is running on supported OS. 10g AS on the server - you can. you would need to deploy the war files, in my case it was windows box. it should be okay. you can host 10g AS in your laptop too if it is all for testing purposes.

Good luck for your testing.

Suresh

Deepankar said...

Hi Suresh

Thanks for the quick update.

I appreciate it very much.

We are taking up this activity,will update you as soon as we finish and share the experience.In case i need any help i will buzz you again.

Thanks
Deep

Anonymous said...

Hi Suresh,

Would like to know the path where we can find GRANT_HTTP_TO_DEMANTRA.sql as we need to execute this script but cant find it. We are integrating EBS 12.1.1 with Demantra 7.3

Thanks in advance,
Naren

Suresh Lakshmanan said...

Hi Naren,

It is in the patch 7202067.
Hope that helps you.

Thanks
Suresh

srinivas pallela said...

Hi Suresh,

I need to congratulate and appreciate you for sharing such a invaluable knowledge with others.

I am working as Oracle Apps Technical Consultant and looking forward to learn Oracle Demantra.

Can you suggest me the ways to start and how to get the software as I am struggling to find it.

I currently have an R12.1.1 instance on my laptop, please give me steps to get demantra and install it.

Thanks

Srinivas.