How To: install Demantra application?

How To: install Demantra application?

For basic demo environment setup, single tier architecture suits which comprises of having Oracle Database, Demantra application server and Analytical engine, all in one machine.
Demantra installation can be very easily done using the Demantra installer file. But before you start ensure, that you have Oracle DB installed up and running. Also one should keep handy details like Oracle SID, Database system user login, etc. More details on installation can be gathered from following links:

A blog on Oracle Demantra 7.2 installation:
http://applicationsdba.blogspot.com/2008/01/r12-demantra-integration-part-ii.html

Previously published blog on Demantra installation 7.1.1:
http://oracledemantra.blogspot.com/2007/10/installing-demantra-711-on-windows.html

My Oracle Support(Metalink): Oracle Demantra Installation for Release 7.1.1http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=428495.1

My Oracle Support(Metalink): EBS-Demantra Integration Installation Overview and Diagramhttp://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=434991.1

Post installation activities:
1. Set up Environment variable "JAVA_HOME"
2. Launch and verify tomcat(web server) runs fine
3. Launch and test Collaborator workbench application
4. Launch and validate that desktop based application are working fine. (like Business modeler, Demand planner, Engine Administrator etc.)

How to: get hold of Demantra documentation ? |

There are multiple sources to access Demantra documentation, few of them includes:

1. Online documentation for Oracle Demantra available at:
"http://download.oracle.com/docs/cd/E11885_01/demantra/html/homeset.html".

2. My Oracle Support (previously known as Metalink):
If you have Metalink login access, then you can search and find all the available documentations released by Oracle.
https://metalink.oracle.com/

3. Oracle Demantra installed folder:
Few basic documents are available when you install Demantra application. These can be found under the installed folder "Oracle Demantra Spectrum".

News: Kyocera gets Demantra

"In a bid to help wireless manufacturer, to improve planning and forecasting functions, BearingPoint, Inc. has announced it deployed Oracle Demantra Demand Management for the San Diego, California- based company.

With the solution in place, Kyocera is able to improve accuracy and no longer depends on a manual process for planning and forecasting Also, with Oracle Demantra the company can generate more consistent reports and maintain a better audit trail.

All of these new capabilities also help Kyocera Wireless to better respond to demand as well as generate forecasts and consensus plans without the need of any special expertise. ........................................"
For complete story visit "http://call-center-software.tmcnet.com/topics/call-center-solutions/articles/40585-kyocera-gets-oracle-demantra-from-bearingpoint.htm"

Demantra: "How to" Series

We will be starting a "How to" series, for Demantra which will bring answers to various setup and configuration related queries on Demantra. We will start with basics and then move on to more complex world of Demantra product. In case you have any specific question, then put in comments and we would be glad to include that question in this series.

Installing Demantra on SQL server

Installing Demantra on SQL server
Demantra application can be installed on Oracle Database as well as on Micrsoft's Database SQL server. Oracle's recent Demantra release 7.2.0.1 is well supported on MS SQL server 2005 database. If you have already are familiar with Demantra installation on Oracle DB, then installing it on MS SQL sever should be pretty easier.

Pre-requisite for Demantra installation on SQL server can be listed as:
1. The client machine where Demantra is being installed should have MS SQL client (same version as server) installed on it.
2. You should extract standard backup file from the installer, say from "F:\Demantra 7.1.1 installer\Disk1\InstData\Resource1.zip >>unzip>>Infra/Database Objects/Microsoft SQL Server/dumps", and put it in the SQL server machine.
3. Keep handy DB server connectivity information and 'sa'(system administrator) login details.



Installing Demantra on SQL Server:
1. Click on "Setup.exe" (Launch anywhere application for installing Demantra) to initiate the installation.
2. Click on option "Install Demantra Spectrum" and then Click on "Next" button at the bottom.
3. In installation tab, Select component of application to be installed. (say, DM) >> Click on Next >>
4. Select Path where you would like to install Demantra.>> Click on Next >>
NOTE: You will have to put backup file in the same path location on Server machine, as mentioned in point 2 of Pre-requisite section above.
5. Select from options available to create Product launch shortcuts. (say, In a new Program Group)>> Click on Next >>
6. Choose Database type as "SQL Server". >> Click on Next >>

7. Provide details for 'sa' login and the SQL server name. >> Click on Next >>

8. Enter SQL DB Schema/User login and Database to be created in case of fresh install. (In case of upgrade you can enter details for existing Demantra database & schema).>> Click on Next >>

9. Select Engine execution type. (Manual or Automated)>> Click on Next >>

10. Wait for Completion of Demantra installation. >> Click on Done>>

Important Note:

1. The SQL DB user should have db_creator and bulkadmin permission
2. Backup file should be extracted out and stored in correct path, prior to installation
3. Password for DB user should respect SQL server security levels(shouldn't be too simple)
4. Ensure SQL server connectivity is established and verified
   

Refer Oracle Metalink for SQL server support related queries.

Demantra integration patches rolled up into R12.0.4

For customers on R12.0.4 instance level, there is no need for applying any integration patch for seeded Oracle EBS-Demantra integration to work.
As Oracle has got the Demantra-EBS Integration patch contents rolled up into 12.0.4, so if you are on 12.0.4 you just need to install Oracle Demantra 7.2.0 or higher version and no other patch is required for integration, unlike with 11.5.10 CU2 and R12.0.3 where EBS-Demantra integration patch needs to be applied.

For more details refer to Oracle Metalink Note:727237.1

Demantra - S&OP (Sales & Operational Planning) : Integration Overview - 3

S&OP module of Demantra 7.2:

Oracle has provided a great solution as out of box offering for Sales & Operational Planning process in form of Demantra's S&OP module, integrated seamlessly with EBS R12, ASCP, and SNO. Oracle has done lot of seeded configuration in Demantra front to support the S&OP processes and integration with Enterprise resource planning(ERP), strategic planning tool(SNO), and tactical planning application(ASCP). We will try to take a closer look at these entities and how it can help you in building a collaborative, integrated, Real time Sales & Operational Planning environment using Demantra.
S&OP configuration in Demantra has been built on top of basic Demand Management module, so all the seeded DM entities co-exist and are used in S&OP module as well. S&OP has been defined as a separate component within Demantra so that S&OP process stakeholders work on entities related to them. Remember that Data model definition remains common for S&OP as well as DM modules of Demantra.

NEW DEMANTRA ENTITIES:

1. Levels & Hierarchies:

New levels and hierachies to support viewing/analyzing supply plan and related data for Supply Review and Executive Reviews have been introduced. For Supply review, Supply plan information is being captured in Plan Scenario (General Levels) with proper statuses in Scenario Status(Plan Scenario>Scenario Status) to maintain and manage Supply plans in Demantra. Also new Supplier level(lowest level) and Resource level (Resource-Scenario>Resource, Linked Scenario) hierarchy also appears for viewing data at Supplier level.

2. Series for RT-S&OP

S&OP involves much more information and collaboration in terms of inputs, recommendations and consensus, thus Oracle has provided seeded series for carrying out S&OP sub processes. All the supply plan related information at Plan Scenario level for item & location population is stored in form on various series:

Plan related data series: Available Resource/Supplier Premium/Standard Capacity, Required Resource/Supplier Capacity, Constrained Forecast, Beginning On-hand, Dependent Demand, Inventory plan, Planned Shipments, Production Plan, Safety Stock.

SCI data series: Actual Production, Actual On-hand, Past due backlog, Total backlog etc. for capturing Supply Chain Intelligence data to monitor KPIs and for exception management.

Consensus related data: Multiple series for handling consensus creation process during Demand Review stage, like for weightages from various stakeholders, their forecasts, Consensus Forecast (in units & amount), etc.

3. Worksheets

To carry out each of the sub-processes in S&OP like Demand Review, Supply Review, etc., Oracle has provided quite a few seeded worksheets for each of these steps.

• 
  
  Worksheets to support Demand Review Process : Marketing Forecast, Sales Forecast, Consensus Forecast related worksheets at various levels of aggregation.


• 
  
  Worksheets to support Supply Review Process: Constrained Plan, Production Plan, Inventory plan and Exception management related worksheets for Supply Demand balancing and analysis of various Supply scenarios, coming from ASCP/SNO.


• 
  
  Consolidated Plan related worksheets for reviewing and approving the final agreed upon Demand & Supply plan, which is further published back to ASCP for further detailed planning and execution.


• 
  
  Worksheets & Content panes for KPIs like Demand Fill%, Production & Inventory plan adherence, etc.

4. Integration Interfaces: Since S&OP process captures, processes and involves much more information as compared to DM, you can find new Integration Interfaces for supporting this inbound and outbound data flow. Few important interfaces which has been seeded by Oracle are described briefly in table below:

Workflows related to Plans, allow you to easily load your Supply plan data in form of Plan scenarios into Demantra for Supply reviews and Plan consolidations.

5. Workflows: Real time Sales & Operational Planning is more of process and people oriented than application oriented, it requires input and approvals from various stakeholders for consolidation Oracle has addressed this front with Demantra's seeded workflows which can be customized further to fit customer's requirements. Workflows automate/semi-automate key processes like Demand Review, Supply plan load, exceptions handling and Publishing Consensus plans.

Besides above discussed entities, there are few more setups and entities, which have been provided with out-of-box S&OP Demantra application. Remember that the configuration flexibility of Demantra provides a huge opportunity for solving your specific S&OP problems. With seeded integration between EBS and APS suite products, S&OP module of Demantra can be easily Incorporated in your organization.

Demantra - S&OP (Sales & Operational Planning) : Integration Overview - 2

What it takes for seeded S&OP integration to work ?
Demantra's 7.2.0 and higher versions have seeded integration for Sales & Operations Planning(S&OP) module with Advanced Supply Chain Planning(ASCP) & Strategic Network Optimizer(SNO) modules of APS. The seeded integration however currently is supported only with Oracle EBS R12.0.4 version and is available as integration patch. Once you fulfill the pre-requisite criterias and apply the patches, on EBS front new responsbilities start appearing(similar to EBS-DM integration).

What's new on EBS side? :

The New Responsbilities for S&OP:
1. Sales & Operations Planning System Administrator : This responsbility is quite similar to Demand Managment System Administrator responsbility and has few Menu options common to DM System Administrator. Users who controls and executes data collection for S&OP planning should have access to this responsbility. S&OP Administrator can collect all the relevant data from EBS into Demantra, using Collection menu options controlled by Setups and Profile options.
The Menus in this responsbility are divided broadly into following:

• Links to Open Demantra S&OP application (which includes : S&OP Workbench, Workflow Manager, Administration, User Management)
• Collections Menu (which includes : Collection > Standard collection, Shipment & Booking History data, SCI Data**, Currency Conversion, UOM Conversion, Returns History, Pricing Data, and Download Calendars)
• Collect from Legacy (Legacy Collection - Flat; Legacy Collection - Self; Shipment & Booking History - Flat; Shipment & Booking History - Self Service)
• Setup ( Instances; Calendar List; New Product List; Price List )

2. Sales & Operations Planning Analyst: S&OP Analyst responsibility is same as Demand Analyst in Oracle's EBS-Demantra DM integration. As an analyst, the menu options have limited authority and can only Open Demantra S&OP applications - S&OP Workbench, Workflow, Administration, and User Management pages.

3. New S&OP enabled plan options: ASCP & SNO plan options have now a new check box saying "S&OP enabled", once selected those Supply plans can be brought inside Demantra for S&OP process as Supply Plan Scenarios.

4. Publish option in SNO: New option to publish SNO plan for S&OP usage has been added in SNO workbench.

** From collection point of view, only Supply Chain Intelligence(SCI) data is added entity as compared to Demand Management integration. SCI data being collected comprises of Order backlog information, Actual production data, etc.

Besides above changes on EBS/ASCP/SNO side, Demantra's S&OP module has been changed a lot to support this seeded integration. There are new Levels, hierarchies, series, worksheets. integration interfaces, workflows etc. which appear if you install S&OP module.