Oracle EBS-Demantra Integration Patch

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

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