R12 Demanta - Integration Part V

Hi Everyone!!

This post I will be covering the configuration portion of R12 - Ebiz to complete the integration of Demantra with R12.

If you want to view the previous posts

R12-Demantra Integration overview
R12-Demantra Integration Part II
R12-Demantra Integration part III
R12-Demantra Integration Part IV

After deploying the b2b.war file in 10.1.3 OC4J(external to R12 instance) - in my case I have done the separate 10.1.3 J2EE instance in windows box, you will be having the URL to access collaboration workbench. ie. http://hostname.domainname:HTTPport/*contextname of b2b.war application deployment*

After applying the integration patch to ebiz environment you will be seeing profile MSD_DEM_HOST_URL in ebiz suite.

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

FND_PROFILE.VALUE('MSD_DEM_HOST_URL') --------------------------------------------------------------------------------
SQL>


By default value of the profile is null.

You need to update the above profile to Demantra collaboration workbench URL.

New Responsibility added to the environment by the integration patch is "Demand Management System Administrator"

Menu"Demand Management Workbench"
You will be taken to the demantra portal.

1) Add
"Demand Management System Administrator" to the user accessing Demantra applications

2) Select the responsibility "Demand Management System Administrator" menu "Demand Collaboration Workbench"

3) You will be prompted to feed password - this is where you need to integrate with SSO to avoid the request of password. If you want to integrate with SSO you need to have 10.1.2 10g AS infra - again this is separate installation - should not be confused with 10.1.2 OH of R12. Please see the Demantra implementation guide
http://download.oracle.com/docs/cd/E11821_01/demantra/acrobat/E05136_04.pdf
for SSO setup. Register both ebiz and demantra as partner application in Single Sign-on.


4) Demantra UI is being accessed from R12


I hope you all have enjoyed this series of posts explaining Demantra Integration with Ebiz R12.

User Synchronization

From implementation Guide -
"When an E-Business Suite user is granted any responsibility containing the Demand
Management Workbench (MSD_DEM_DEMPLANR) function grant, an Oracle
Demantra user of the same username is created in the Oracle Demantra Demand
Management component. Users assigned E-Business Suite Demand Management System Administrator orDemand Analyst responsibilities are automatically assigned mirrored responsibilities in Oracle Demantra. When a user is created in the E-Business Suite and mirrored in Oracle Demantra, the default password in Oracle Demantra is 'Oracle Demantra'. The Web Server must be restarted for a new user to be available in Oracle Demantra."

To Summarize,

Demantra 7.1.1 can be integrated with 11.5.10 CU2
Demantra 7.2 can be integrated with R12

Please leave your comments/questions. I will get back to you as soon as I can.

Happy reading!!


Disclaimer:
Opinions expressed here are not necessarily those of Oracle and its affiliates. Please use Oracle Metalink documents/guides as source of truth and Use this series of integration journey posts as reference.

49 comments:

john said...

Hi Suresh,
Appreciated lot for your sharing and also surprised can find such a valueable posts from the blogs.
Here is my question may or may not link to the Demantra integration: Do you have more ideas how to integrate the Demantra S&OP(7.2.0.1) to ASCP (12.04)? We have a interesting case here that client has no EBS but bought the Demantra S&OP and Oracle ASCP. I knew the integration between S&OP and ASCP is kind of new functions but could you help the steps to their integrations ? (more details like your installation guide of Demantra the better) I have busy around for weeks on documents but limited to get the clear picture on it. Thanks and appreciated any supports.
John

Suresh Lakshmanan said...

Hi John,

Greetings.. I am not sure this is what you are saying, Oracle ASCP - Oracle 11i/R12 ASCP??(I had worked with ERP ASCP team. But not sure you meant ERP ASCP or there is a standalone ASCP project which I am not aware of. You have mentioned ASCP version as 12.04. Is it 12.04 or 12.0.4? If its 12.0.4 then, I believe its ERP ASCP. If 12.0.4 ASCP and Demantra 7.2.0.1 then the steps are same (which are mentioned in this blog from DeamntraI - Demantra V posts).

Thanks
Suresh

Suresh Lakshmanan said...

John,

I have gone through some of the ASCP links http://mhabib.wordpress.com/2007/04/30/what-is-oracle-ascp/
But still not sure there is a separate standalone ASCP product or its same as part of EBiz Suite of products.

Thanks
Suresh

shekhar said...

Hi John,
Can you please eplain in details what your problem is in the integration front (ASCP-Demantra)?What I could imagine from your blog is that, the integration is between ASCP(version 12.0.4 of Oracle) and Demantra S&OP module(version 7.2.0.1). As per your blog,its mentioned that the client has bought only ASCP and Demantra Modules. Can you tell how the core modules are taken care of?I mean,ASCP is one of the modules on Planning side and to bring data into it you need to have some mechanism.How do they bring the inventory data into ASCP without having the base modules of Oracle like Inventory/BOM/WIP etc?

Secondly I would like to thank Suresh for such an intersting Blog on Demantra.As he pointed the integration is quite similar to what he has mentioned in his earlier entries.

The Responsibilities that become available in case of this integration would be
1)Sales and Operations Planning System administrator and
2)Sales and Operations Planner

I hope my entry makes some sense.

Suresh Lakshmanan said...

Hi Shekhar,

Thanks for input on John's question.
Thanks for your boosting words.

Best Regards
Suresh

shekhar said...

Hey Suresh,
I thought it wise to blog on some issues that make sense rather than on issues like films etc.
Thanks again for including my blog so that more functional queries could be brought out for others who may find this blog very helpful(Also to me to understand different scenarios of Implementation :)).

Regards,
Shekhar

shekhar said...

Hi Suresh,
Any info on installation of Demantra 7.2.1(Demantra-Siebel integration)front?I am reading the docs on metalink(cudnt figure out much!!) so i thought u cud b of help.

Suresh Lakshmanan said...

Hi Shekhar,

Nope, I havent done the integration.
If I find any doc I will post it.
Thanks
Suresh

Jashua said...

Hi Suresh

Thanks for sharing this document. Is it possible for you to elaborate step 3 or put screen shot required in step 3 for demantra/EBS R12 integration where we don't want to input the loginid/password again while navigating to Demantra from EBS.

3) You will be prompted to feed password - this is where you need to integrate with SSO to avoid the request of password. that is detailed steps on how to Register both ebiz and demantra as partner application in Single Sign-on.

Regards
Jashua

July 23, 2008 3:32 AM

Suresh Lakshmanan said...

Hi Jasuva,

Basically when you do the integration of EBS with Demantra without SSO, you will be prompted the password again. Unfortunately I do have any instance to put the screen shot. If I get one I will post it for you. If SSO is not in place both applications are different, but EBS calls the Demantra URL when menu is clicked. Its as simple as that.


Thanks
Suresh

Ram said...

Hi,

I have installed oid infrastructure..

whe i login to em console ...

i cant see Cluster Topology screen..

Please help ..
Ram

Suresh Lakshmanan said...

Ram,

Its hard to find the root cause of the issue from this statement. Have you bounced the infra tier and EM cleanly? Any errors reported in installation logs?

Thanks
Suresh

Anonymous said...

Hi,
I have successfully integrated Oracle 12i with Demantra 7.2.

From the machine that has demantra installed, I could easily execute the Business Modeler, Memeber Management and Chaining Management. But when I try exeuting the Business Modeler and the rest of the programs, I get the followin error:

Process executaion failed with the following error : 'modeler.exe' is not recognized as an internal or external command,operable program or batch file.

What do I need to do?

Thank You
Ven

VB said...

Hi Suresh,

Thank You for this wonderful blog. I could easily integrate R12(12.0.4) and Demantra 7.2. From the Demantra machine I could easily access the Business Modeler, Member Management and Chaining Management Tools. But from another computer, when I execute for these tools, I get the following error:

"Process executaion failed with the following error : 'modeler.exe' is not recognized as an internal or external command,operable program or batch file."

Note: The machine I am using is not configured to the same domain as the R12 and Demantra.

Can you plz help.

Thx
VB

Suresh Lakshmanan said...

Hi Ven,

The error suggests exe is not in %PATH% variable. You may try after setting the %PATH% correctly in your system.

Thanks
Suresh

varun said...

hi
ineed to configure OLM content server with R12 version 12.0.4 . please tell me which doc i need to follow

var

varun said...

hi
My name is varun .. i need to cofigure OLM content server with 12.0.4 . which document i need to follow. now iam following the document Content_Server_Setup_whitepaper.pdf that is attaching with this mail .. Please tell me which document ineed to follow

Thanks and Regards

Var

varun said...

PLEASE SEND ME IF YOU HAVE ,,

Suresh Lakshmanan said...

Hi Varun,

I haven't done the content server integration with R12 so far.
I found the metalink note 460518.1 which will be useful for you.
I will try my best to give you some more info on this.

Thanks
Suresh

Anonymous said...

Hi Suresh,

I am trying to implement OID SSO with Demantra 7.2.0.1. I have followed the steps recommended in metalink to setup SSO with Demantra. When I go to Demantra URL (http://host:port/demantra/portal/loginpage.jsp), I was redirected to SSO login page.

However After I entered the correct login/password, I am being redirected back to Demantra Login page and I am required to enter login and password again.

I am expecting SSO to pass user authentication and log me in directly to Demantra Collaborator Workbench. Do you know what may be wrong in the setup?

For your reference this is the setup that I did:

1. Register EBS with OID/single sign-on server to enable single sign-on for EBS
applications by following the Metalink notes above.

2. Register Demantra applications with OID/single sign-on server.

Run ssoreg on the machine where the SSO Application server is installed.

If SSO is installed on a linux machine:

$ORACLE_HOME/sso/bin/ssoreg.sh
-oracle_home_path (orcl_home_path]
-site_name (machine name eg: ap7001dma.us.oracle.com ]
-config_mod_osso TRUE
-mod_osso_url [Base URL for the application server
eg:http://ap7001dma.us.oracle.com:80 ]
-remote_midtier [optional]
-config_file [config_file_path/config_file_name*]


This creates a config file on the specified path or updates the local osso.conf
if the config_file parameter is not specified.

Remote_midtier is required if the Oracle Application Server for Demantra is on
a different host. If you are using the remote midtier option please specify the
config_file parameter so that the existing osso.conf is not updated. Copy this
config file to the Application Server on which Demantra is deployed. The path
should be [ORACLE_HOME]\Apache\Apache\conf\osso

3. Enable mod_osso (in httpd.conf file).

- Locate the file httpd.conf in the directory [ORACLE_HOME]\Apache\Apache\conf
- Locate the commented statement #include
"[ORACLE_HOME]\Apache\Apache\conf\mod_osso.conf"
- Uncomment by removing the # character

4. Protect the required Demantra URLs in mod_osso.conf file.

- Locate mod_osso.conf in [ORACLE_HOME]\Apache\Apache\conf
- Make the following changes:

Change
OssoConfigFile conf/osso/[sso config file(name given at *)]
OssoIpCheck off
OssoIdleTimeout off

Add the following text after the statement [IfModule mod_osso.c]

[Location /demantra/portal/loginpage.jsp]
require valid-user
AuthType Basic
[/Location]

[Location /demantra/portal/userManagement.jsp]
require valid-user
AuthType Basic
[/Location]

[Location /demantra/portal/adminLogin.jsp]
require valid-user
AuthType Basic
[/Location]

[Location /demantra/workflow/login.jsp]
require valid-user
AuthType Basic
[/Location]

[Location /demantra/portal/prelogin.jsp]
require valid-user
AuthType Basic
[/Location]

[Location /demantra/workflow/prelogin.jsp]
require valid-user
AuthType Basic
[/Location]

Suresh Lakshmanan said...

Hi,

Please leave your name to address you. Will get back to you on this.

thanks
Suresh

Antony said...

Hi Suresh,
Thanks for your help. Looking forward to hear from you.
Antony

Suresh Lakshmanan said...

Hi Antony,

here is the note 434991.1
did you apply the integration patches? you are hitting the bug 7304463. I can resolve your issue provided screen sharing. Please have a tar with oracle as well and indicate this bug.

good luck with your integration.

Thanks
Suresh

Suresh Lakshmanan said...

Antony,

You are following the correct steps. few typos could cause the issue too. after the configurations did you bounce the AS services?

Thanks
Suresh

Girish said...

Hello Suresh,

I saw your Demantra blog applicationsdba blog, have some questions

Following is my environment
- Linux Running 12.0.4 Apps
- 10G

I am trying to install Demantra 7.2 on windows XP. Do i need a separate 10G database & Client on windows machine.? just the client

I did the following on Windows
1. Install oracle 10g Software and Create Database
2. Install OracleAS 10.1.4 Infrastructure / Identity Management Instance
3. Install OracleAS 10.1.3 Application Server Middle Tier Instance
4. Demantra 7.2 Install Patch - 6617634

I am getting an error,
Mismatch Oracle Client 10.2.0.3.0 and Oracle Server 10.1.0.5.0

please help. I may be doing something incorrect.


regards
girish

Suresh Lakshmanan said...

HI Girish,

Just client in the windows machine will do.


I did the following on Windows
1. Install oracle 10g Software and Create Database - database not required. you will be using ebiz db.
2. Install OracleAS 10.1.4 Infrastructure / Identity Management Instance - ok
3. Install OracleAS 10.1.3 Application Server Middle Tier Instance - ok
4. Demantra 7.2 Install Patch - 6617634 -ok

I am getting an error,
Mismatch Oracle Client 10.2.0.3.0 and Oracle Server 10.1.0.5.0 - what is the client version you have installed?. make the client same as of the ebiz db version say 10gr2 db client 10gr2.

Hope this helps.


Thanks
Suresh

Girish said...

Hi Suresh,

Thanks for your reply.

eBiz DB is on version 10.2.0.3.0. What version of the client i should install 10.2.0.3.0 or release 1.

I have Linux & Windows on separate partitions on single machine, it is configuration ok or should i install on different windows machine.

please advise.

regards
girish

Suresh Lakshmanan said...

Hi Girish,

As per my understanding if you have 10gR2 server you should have 10gR2 client.(first two digits should match 10.2).
you should be able to run both windows services and Linux services at the same time test the configuration etc.

Thanks
Suresh

Raghu Bandla said...

Hi Suresh,

Excellent Post...Keep itUp..

Thanks
Raghu Bandla

Suresh Lakshmanan said...

Thanks Raghu

-Suresh

VB said...

Hi Suresh,

I successflly installed 12.1.1 vision instance. Demantra, AS and 11g client on a saperate win2003 server. The MSD_DEM: Host URL: http://tstdemantra.mysite.com/dmo. AppServerURL is set to: http://tstdemantra.mysite.com/dmo, server.generalurl is set to: http://tstdemantra.mysite.com/dmo.
When I login to demantra and click Planning Application->Business Modeler, I get the following error: Can't connect to database ORA-12541: TNS:no listener. What amd I missing?
VB

Suresh Lakshmanan said...

Hi VB,


>>do you have updated tnsnames.ora in 10g client to connect to your EBS database?

>> are you able to tnsping r12 ebs database? are you able to make sql connection from 10g client?

Thank you.

Suresh

VB said...

Hi Suresh,

I am using 11g client. The tnsnames.ora:
VISR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = viserp.mysite.com)(PORT = 1526))
)
(CONNECT_DATA =
(SERVICE_NAME = vis)
)
)

listner.ora:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\app\Administrator\product\11.1.0\client_2)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = tstdemantra.mysite.com)(PORT = 1526))
)
)

sqlnet.ora:
SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

When I do a tnsping, I am getting this:
TNS Ping Utility for 32-bit Windows: Version 11.1.0.7.0 - Production on 14-MAY-2
009 15:47:05

Copyright (c) 1997, 2008, Oracle. All rights reserved.

Used parameter files:
C:\app\Administrator\product\11.1.0\client_2\network\admin\sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTO
COL=TCP)(HOST=10.90.15.2)(PORT=1521)))
TNS-12541: TNS:no listener

Why is tnsping pointing to port 1521 when it is port 1526?

Thank you
VB

Suresh Lakshmanan said...

Hi VB,

It seems its trying using EZConnect.
try to have local naming service to resolve.

Thanks
Suresh

Tony Van.Cauter from Oracle said...

Hi,
I'm trying to setup Demantra for a R12 environment, but I am facing installation issues ... The Demantra installer hangs at the screen, the one you can see in attachment. I'm running Demantra 7.2 on my XP, R12 is running on 32-bit Linux ...

Thanks,
Tony

Suresh Lakshmanan said...

HI Tony,

Installation log will be generated in C:/tmp with the name IA.properties
please review the log.

Thanks
Suresh

Tony Van.Cauter said...

Well ... something is wrong then, because my c:\tmp has been very clean, during and after the many Demantra installs I've tried ...

Tony

Suresh Lakshmanan said...

Hi Tony,

Did you get any luck?
How did you resolve the issue. Have seen one article where this is mentioned

"NOTE: THIS IS CRITICAL - Create the folder C:\tmp on the windows machine
if it does not already exist. This folder will contain the install log. If there is a
failure you will need this log to troubleshoot any issues."

Thanks
Suresh

Tony Van.Cauter from Oracle said...

Well, no,
I tried on another computer, but he was giving TNS connection issues, so I could not really check the initially mentioned issue..

On my laptop (which is where I am doing all of the testruns), he is still erroring out with the same message, all the way in the end. I may be chasing an issue which is only on my computer, and in the end, I am only testing the software, but if I can't get the software installed ... something is wrong.

I'm creating the c:\tmp all right (in a script), but I don't see install.log there, and actually, I'm not sure it is seen anywhere on my computer ...

Tony

Suresh Lakshmanan said...

we can try doing webex sometime, if time permits.
did you raise any bug with demantra dev?
i am in US Mountain timezone. may be owc sometime to find out what is the issue.

Thanks
Suresh

Sandy said...

Hello Suresh :

Excellent articles !! For some reason we do not see the MSD%Dem%Host%URL profile option on our R12 instance. Also we do not see the Demand Management System Administration responsibility. Could you please let us know the reasons for the same.

Suresh Lakshmanan said...

Hi Sandy,

Check whether you have integration patches in your EBS.

Thanks
suresh

Hussain said...

Hi Suresh,

I have two queries:
1.Do I need to edit opmn.xml file as per Oracle Demantra 7.3.1 Installation guide?If so,the ORACLE_HOME will point to Oracle 11g client home or OAS10g home?

2.If I deploy demantra on OAS10g,then while accessing the collaborator workbench do I need to start the tomcat along with the OAS?

Regards,
Hussain

Suresh Lakshmanan said...

Hi Hussain,

I am not quite sure on your question 1.

for question 2, You would not require to start tomcat. My implemetation didn't have tomcat at all.

hope this will help you.

Thanks
Suresh

Anonymous said...

Hi Suresh,

Iafter generating war file and uploaded suscessfully in demantra weblogic console and bounced managed and admin server iam able to login to console page , but not able to open
http://demantraapplicationhost:port/demantra/portal/loginpage.jsp----getting below error.

Error 503--Service Unavailable
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.5.4 503 Service Unavailable
The server is currently unable to handle the request due to a temporary overloading or maintenance of the server. The implication is that this is a temporary condition which will be alleviated after some delay. If known, the length of the delay may be indicated in a Retry-After header. If no Retry-After is given, the client SHOULD handle the response as it would for a 500 response.

Note: The existence of the 503 status code does not imply that a server must use it when becoming overloaded. Some servers may wish to simply refuse the connection.

Can you please help me.

Suresh Lakshmanan said...

hi Anonymous,

I think it is tough to troubleshoot with just this error, check whether you are on supported configurations. this post was written long back, hence steps might not be applicable for newer versions. Work with Oracle Support, they will help with providing bug fixes etc.

hope you will find solution for your problems.
best wishes
Suresh

Anonymous said...

Hi Suresh,

Thanks for your responce, the collaborator .log file is also not generating in below location

.../user_projects/domains/demantra/servers/dem_ManagedServer_1/tmp/_WL_user/demantra/SOME_RANDOM_STRING/war/logs/collaborator.log and not able to open portal/loginpage.jsp

Anonymous said...

Hi Suresh,

My issue has been resolved with the help of Oracle Support.

Thanks,

Suresh Lakshmanan said...

Very Nice. Happy to hear.