Demantra, OracleAS 10.1.3 and the E-Business Suite

There's been a recent surge of questions asking whether the E-Business Suite can be used with Oracle Application Server 10g 10.1.3 and Demantra, one of our new product family members. 

Demantra Demand Management screenshot:

I'm not a Demantra specialist, but from an Apps architectural perspective, the short answer is:  yes.  There are a few things to remember about this integration:
  1. The E-Business Suite Release 11i's application-tier runs on Oracle9i Application Server only.  It must stay at this level.  It may not be upgraded to either Oracle Application Server 10g 10.1.2.x or 10.1.3.x.
  2. The E-Business Suite Release 11i can be integrated with an external server running Oracle Application Server 10g 10.1.3.x.  There are no restrictions on integrating Apps 11i with OracleAS 10.1.3.x.  We have not certified this configuration but it's supported.  Remember that there's an important distinction between certification and support.
  3. Alternately, if you have sufficient capacity on your existing E-Business Suite application server, you can install Oracle Application Server 10g 10.1.3.x in a separate ORACLE_HOME on an existing E-Business Suite server.
  4. You then install Demantra on top of the external Oracle Application Server 10g 10.1.3.x environment.  The standalone Demantra environment then connects to the E-Business Suite environment.
  5. Demantra is an Oracle SSO-enabled partner application, too.  If your E-Business Suite environment has been integrated with Single Sign-On 10g and Oracle Internet Directory 10g, you can integrate that combined environment with Demantra, too, to provide Single Sign-On capabilities across Apps and Demantra.
Possible Java Runtime Engine Conflicts

Demantra runs on the latest Sun Java Runtime Engine (JRE) plug-in on the desktop.  Oracle E-Business Suite's Forms-based products run on Oracle Jinitiator on the desktop.  Depending on how your end-users run Demantra, there may be conflicts between these two Java plug-ins, notably if the same users wish to access the E-Business Suite's Forms-based content at the same time that they're running Demantra. 

If so, there's light on the horizon:  we're still in the process of certifying the native Sun JRE plug-in with the E-Business Suite.  Once that certification is complete, E-Business Suite users can use the native Sun JRE plug-in instead of Jinitiator, eliminating any conflicts.

If your organization wishes to deploy Demantra now, before the E-Business Suite's certification of the native Sun JRE plug-in is complete, you may wish to register in our E-Business Suite Early Adopter Program.  I'm still accepting customer nominations for this Early Adopter Program; for details, see:


Any idea if there will be a R12 Demantra, OracleAS 10.1.3 and the E-Business Suite integration patch, of if one is required?

Posted by Michael Taylor on June 05, 2007 at 01:36 PM PDT #

Michael,I believe that the Demantra team is working on a Release 12 version of their integration now.  I don't have many details on this, but as usual, if I hear more, I'll post a follow-up article here.Regards,Steven 

Posted by Steven Chan on June 06, 2007 at 02:42 AM PDT #

Hi Michael,As Steve pointed out, we are currently working on integrating Demantra Demand Management and Real Time Sales & Operations Planning with EBS R12. The integration will be available later this year.[Editor note:  Zia is part of the Oracle Advanced Planning team responsible for Demantra development]

Posted by Zia Ahmed on June 06, 2007 at 11:33 PM PDT #

If there are any Demantra team members watching, the 7.1.1 installation guide has NLS_LANG settings that will prevent the database client from ever connecting to the database.

Make sure that the database uses the following encodings:

The export was done with NLS_LANG=American_America.WE8MSWIN1252, and that one seems to work for the import used during the installation.

Oracle Demantra Installation for Release 7.1.1

Posted by Michael Taylor on June 17, 2007 at 12:00 PM PDT #

Michael,I've forwarded your note to the Demantra team.Regards,Steven 

Posted by Steven Chan on June 18, 2007 at 01:50 AM PDT #

Has anybody upgraded Demantra 6.2.6 TO 7.2 x / 7.1 VERSIONS.

What is the mechanism - documentation available on the same ?

Appreciate your response.
thx and rgds,

Posted by Pankaj Kumar on January 08, 2009 at 02:29 PM PST #

Hi, Pankaj,

I'm not a Demantra expert, but I see Demantra documentation here (for EBS 11i, anyway):

If that's not what you're looking for, I'd suggest logging a formal Service Request via Metalink against the Demantra product for pointers.


Posted by Steven Chan on January 09, 2009 at 02:46 AM PST #

Hi Steven,

I am installing Demantra on a windows Vista machine. All the demantra components are not installed even after choosing complete install option.

Can you please share some information on whether this
configuration is certfied.


Posted by Girish Turlapati on February 06, 2009 at 12:05 PM PST #

Hi, Girish,

Demantra platform certifications (including desktop clients) are handled by a different group than mine. I'm afraid that I'm not a Demantra specialist and don't have any insight into the expected behaviour here. I'd recommend logging a formal Service Request via Metalink against Demantra for this one.


Posted by Steven Chan on February 09, 2009 at 01:18 AM PST #

Hi Girish,
I hope you must have got the reply for your query by now.
But in case if you are still searching then as per the system requirements documented,

Oracle Demantra has been tested on the following operating systems and no problems have been detected:

- Windows XP (use for demos only)
- RedHat Linux AS 3.1 (applies only to the Oracle Demantra Web Platform Server; the Admin Utilities and the Analytical Engine run only on Windows operating systems); note that less testing has been done for Linux than for XP.

Windows 98, however, is not recommended.

Thanks and Regards,

Posted by Shekhar on April 08, 2009 at 08:15 PM PDT #

Hi Steve,

Can we have database, demantra installed on same machine?


Posted by Krishnamoorthy. R on October 14, 2010 at 04:14 PM PDT #

Hi, Krishnamoorthy,

Yes. You should ensure that they're installed in separate ORACLE_HOMEs and that the server has sufficient resources to handle their coexistence.


Posted by Steven Chan on October 15, 2010 at 01:36 AM PDT #


If I deploy demantra on OAS 10g, is it required to start web server("Start web server" from start menu) along with starting OAS for accessing collaborator workbench?


Posted by Hussain on November 17, 2011 at 05:07 AM PST #

Hi, Hussain,

I'm afraid that I'm not familiar-enough with Demantra to answer that.

Your best bet would be to log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our Demantra specialists engaged.


Posted by Steven Chan on November 17, 2011 at 05:29 AM PST #

Hello Steven,

We are implementing Demantra 3.71 on a client, and we have to do SSO with Microsoft Active Directory. Do you have any suggestions or help on how I could do this integration?

This customer does not have EBS!


Fabio Guidotti

Posted by Fabio Guidotti on May 11, 2012 at 06:30 AM PDT #

Hello, Fabio,

I'm in EBS Development. I'm afraid that I don't have any expertise with Demantra. I'd recommend logging a Service Request against Demantra to get some help with this one.


Posted by Steven Chan on May 30, 2012 at 09:08 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed


« April 2016