{"id":8062,"date":"2019-02-26T11:54:11","date_gmt":"2019-02-26T11:54:11","guid":{"rendered":"https:\/\/rax-stg-wp-aws.com\/blogs\/understand-and-install-oracle-demantra-and-spwa\/"},"modified":"2026-11-03T19:29:15","modified_gmt":"2026-11-03T19:29:15","slug":"understand-and-install-oracle-demantra-and-spwa","status":"publish","type":"blogs","link":"https:\/\/www.rackspace.com\/en-gb\/blogs\/understand-and-install-oracle-demantra-and-spwa\/","title":{"rendered":"Understand and install Oracle Demantra and SPWA"},"content":{"rendered":"<p><strong>Introduction<\/strong><\/p>\n<p>Demantra&nbsp;&nbsp;\u00a9&nbsp;and advanced Supply Planning Work Area (SPWA) are demand management&nbsp;and supply chain management tools provided by Oracle&nbsp;\u00a9. These products&nbsp;integrate with the Oracle E-Business Suite (EBS) and Oracle Advanced Planning&nbsp;Suite (APS) (which are part of the Oracle Advanced Supply Chain Planning (ASCP))&nbsp;to best leverage Demantra demand management and supply chain management<br \/>\nfunctionalities.<\/p>\n<p>This blog covers Demantra and SPWA configuration with&nbsp;Oracle EBS and APS Value Chain Planning (VCP) from an Oracle database<br \/>\nadministrator (DBA) and architecture perspective. It also provides high-level&nbsp;installation steps for Demantra and advanced SPWA.<\/p>\n<p>ASCP is a comprehensive, internet-based planning solution that decides when and&nbsp;where you should deploy supplies (for example, inventory, purchase orders, and&nbsp;work orders) within an extended supply chain.<\/p>\n<p>Demantra is a best-in-class provider of demand management, sales, and operations&nbsp;planning, as well as trade promotions management solutions.<\/p>\n<p>Advanced SPWA allows you, as a planner, to view plan data or plan inputs by using&nbsp;pre-seeded layouts or user-defined page layouts. These layouts enhance your&nbsp;productivity because they allow you to see an aggregate analytical view with&nbsp;guided analysis and can also create multiple page layouts with real world&nbsp;business processes and analysis.<\/p>\n<p><strong>Note:&nbsp;<\/strong> The integration of Oracle Demantra and Oracle APS and ASCP is out of scope of this post. Demantra also supports legacy systems by using flat-file&nbsp;loads, but this post focuses on using Demantra with Oracle APS and ASCP.<\/p>\n<p><strong>Demantra, advanced SPWA, EBS, and APS integration architecture<\/strong><\/p>\n<p>You must install Demantra in the same database as APS and ASCP. The EBS source&nbsp;instance can be in a separate database, but, for the integration of ASCP and&nbsp;Demantra to work, ASCP and Demantra must be in the same database. Oracle&nbsp;supports the following configurations:<\/p>\n<ul>\n<li>&#8211; Single instance<\/li>\n<li>&#8211; Separate destination and source instances<\/li>\n<\/ul>\n<p><strong>Single instance<\/strong><\/p>\n<p>The single instance can include Oracle EBS, ASCP and APS, advanced SPWA, and&nbsp;Demantra. This instance must be a supported combination of EBS and Demantra&nbsp;releases. Oracle support can provide an up-to-date list of certified versions&nbsp;for integration.<\/p>\n<p>The following image shows the single instance architecture:<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26593-body-Picture1_5.png\" alt=\"demantra pic 1\" \/><\/p>\n<p><strong>Separate destination and source instances&nbsp;<\/strong><\/p>\n<p>With separate instances, the APS instance includes APS and ASCP, advanced SPWA,&nbsp;and Demantra. The EBS database is on a separate instance. The destination&nbsp;instance must be a Demantra-certified version of APS.<\/p>\n<p>The following image shows the separate instances architecture:<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26593-body-Picture2_5.png\" alt=\"demantra pic 2\" \/><\/p>\n<p><strong>High-level installation steps for Demantra&nbsp;<\/strong><\/p>\n<p>The installation of the Demantra application is a multistep process.<\/p>\n<p><strong>Note:<\/strong> You need to install Demantra on a Microsoft&nbsp;\u00a9 Windows&nbsp;\u00a9 server&nbsp;because only Windows platforms support the Demantra Installer and Demantra&nbsp;administrative utilities (BusinessModeler, and Demand Management Tools, and so on).<\/p>\n<p>The Demantra Installer on Windows servers creates the database schema (in an APS database), and you need to use the administrator tools to configure the application.<br \/>\nAfter you install Demantra on the Windows server, the process transfers the&nbsp;application to the Unix&nbsp;\u00a9&nbsp;servers that host the Demantra Web server and&nbsp;Analytical Engine server.<\/p>\n<p>Use the following high-level installation steps to install Demantra version 12.2.6.2.<\/p>\n<p><strong>Install Demantra on the Windows server<\/strong><\/p>\n<p>1.&nbsp;&nbsp; &nbsp;Prepare the database for Demantra by creating a 16 K block size table space<br \/>\n&nbsp; &nbsp;(tbs) in the APS database (DB).<br \/>\n2.&nbsp;&nbsp; &nbsp;Install the 64-bit Oracle Database 12c (12.1.0.2) client on the Windows server.<br \/>\n3.&nbsp;&nbsp; &nbsp;Install Demantra version 12.2.6.2 on the Windows server.<\/p>\n<p><strong>Configure the Demantra web server and deploy the Demantra application (demantra.ear) on Linux<\/strong><\/p>\n<p>\n4.&nbsp;&nbsp; &nbsp;Install Java&nbsp;\u00a9 JDK 8 64-bit on the Linux&nbsp;\u00a9&nbsp;server (Demantra web server).<br \/>\n5.&nbsp;&nbsp; &nbsp;Install Weblogic&nbsp;\u00a9 12c (12.1.3.0.0 ) on the Linux server (Demantra web server).<br \/>\n6.&nbsp;&nbsp; &nbsp;Configure the domain for Demantra deployment.<br \/>\n7.&nbsp;&nbsp; &nbsp;Configure the JDBC data source.<br \/>\n8.&nbsp;&nbsp; &nbsp;Enable the archived real path (`archived-real-path-enabled`).<br \/>\n9.&nbsp;&nbsp; &nbsp;Create the Demantra <strong>WAR<\/strong>&nbsp;file on the Windows server.<br \/>\n10. Deploy <strong>demantra.ear<\/strong>.<br \/>\n11. Activate the Demantra application.<\/p>\n<p><strong>Configure and deploy the Demantra Analytical Engine on Linux<\/strong><\/p>\n<p>12. Install Java JDK 8 64-bit and the Oracle client on the Linux server (Demantra Analytical Engine).<br \/>\n13. Copy the engine <strong>tar<\/strong>&nbsp;file from the Windows server to the Linux server.<br \/>\n14. Create the Engine data source file.<br \/>\n15. Configure the Demantra Analytical Engine on the Analytical Server with a&nbsp;new Oracle Wallet Repository.<br \/>\n16. Start the Analytical Engine starter.<br \/>\n&nbsp;<\/p>\n<p><strong>High-level installation steps for advanced SPWA (Advanced Planning UI)<\/strong><\/p>\n<p>Use the following high-level steps to install the Advanced SPWA (Planning User<br \/>\nInterface (UI)).<\/p>\n<p><strong>&nbsp;Installation steps<\/strong><\/p>\n<p><strong>Note: The following WebLogic installation <em>must be<\/em><\/strong><em>&nbsp;<\/em>separate from the&nbsp;WebLogic installation that comes with EBS applications.<\/p>\n<p>1.&nbsp;&nbsp; &nbsp;Install J-Rockit or install the required Java Developer Kit: JDK 1.7.0_80+.<br \/>\n2.&nbsp;&nbsp; &nbsp;Install the WebLogic server 10.3.6 version 11gR1 (10.3.6).<br \/>\n3.&nbsp;&nbsp; &nbsp;Install ADF 11.1.1.9.0 on top of WLS 10.3.6. For the <strong>Install location&nbsp;<\/strong>select the WebLogic server home (10.3.6). This is very important. If you&nbsp;incorrectly select the WebLogic server home that comes with the version&nbsp;12.2.x technical stack, then you will have to redo all the steps from the&nbsp;&nbsp; &nbsp;beginning for the VCP Application Development Framework (ADF) UI.<br \/>\n4.&nbsp;&nbsp; &nbsp;Apply the ADF patches for the planning UI.<\/p>\n<p><strong>&nbsp;Configuration and Setup<\/strong><\/p>\n<p>1.&nbsp;&nbsp; &nbsp;Create the ASCP domain and admin server.<br \/>\n2.&nbsp;&nbsp; &nbsp;Create the ASCP managed server.<br \/>\n3.&nbsp;&nbsp; &nbsp;Apply the JRF &#8211; Enterprise Manager.<br \/>\n4.&nbsp;&nbsp; &nbsp;Create the JDBC data source.<br \/>\n5.&nbsp;&nbsp; &nbsp;Set up the Metadata Services (MDS) repository.<br \/>\n6.&nbsp;&nbsp; &nbsp;Start the admin server and the managed server.<br \/>\n7.&nbsp;&nbsp; &nbsp;Copy <strong>$MSC\\_TOP\/patch\/115\/ear\/PlanningUI.ear<\/strong>&nbsp;from APS (VCP).<br \/>\n8.&nbsp;&nbsp; &nbsp;Deploy <strong>$MSC\\_TOP\/patch\/115\/ear\/PlanningUI.ear<\/strong>&nbsp;and start the planning&nbsp;application.<\/p>\n<p><strong>&nbsp;Set up the VCP side after installation completes<\/strong><\/p>\n<p>1.&nbsp;&nbsp; &nbsp;Apply ADF patches for the Fusion middleware.<br \/>\n2.&nbsp;&nbsp; &nbsp;Edit <strong>$FND\\_TOP\/secure\/allowed\\_redirects.conf<\/strong>&nbsp;by adding the following lines:<\/p>\n<p><em>&nbsp; &nbsp; &nbsp; &nbsp; profile MSC_ASCP_WEBLOGIC_URL<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; profile FND_OBIEE_URL<\/em><\/p>\n<p>3.&nbsp;&nbsp; &nbsp;Set the profile option <strong>MSC: ASCP Planning URL<\/strong>&nbsp;at the site level in the<br \/>\n&nbsp; &nbsp;APS instance with the Advance SPWA URL.<\/p>\n<p><strong>&nbsp;Conclusion<\/strong><\/p>\n<p>ASCP provides database-based holistic planning and optimization that rapidly&nbsp;and significantly improves supply chain performance.<\/p>\n<p>Demantra enables you, as a planner, to sense demand in real time, improve forecast&nbsp;accuracy, and shape demand for profitability.<\/p>\n<p>The SPWA enables you to view plan data and inputs by using pre-seeded&nbsp;layouts or custom layouts.<\/p>\n<p>The following benefits result from integrating of these products:<\/p>\n<p>&#8211;&nbsp;&nbsp; &nbsp;Enhance planner productivity because you can see an aggregate analytical&nbsp;view with guided analysis.<br \/>\n&#8211;&nbsp;&nbsp; &nbsp;Make informed and faster decisions because you can share unified supply&nbsp;chain planning information across the enterprise.<br \/>\n&#8211;&nbsp;&nbsp; &nbsp;Improve supply chain performance by analyzing all aspects of a supply chain&nbsp;and develop optimal plans across the virtual supply chain.<br \/>\n&#8211;&nbsp;&nbsp; &nbsp;Take advantage of a demand-driven organization with higher service levels and&nbsp;sales, more satisfied customers, and lower inventory and distribution costs.<br \/>\n&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Understand and install Oracle Demantra and SPWA<\/p>\n","protected":false},"author":2,"featured_media":8064,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","format":"standard","meta":{"content-type":"","nid":"26593","content_type":"blog","created_by":"10130","authored_on":"2024-02-09T11:54:11+00:00","field_article_industries":"","tag_category":"Technical","field_blog_author_text":"by Rackspace Technology Staff","seo_description":"Gain insights into Oracle Demantra and Supply Planning Work Area (SPWA) for demand and supply management.\r\n","field_featured_image":"","insights_image":"\/wp-content\/uploads\/2026\/blog_technical_images\/26593-insights_image-oracle-technical-blog-1-insights.jpg","field_partners":"","rxt_platforms":"Oracle, Oracle E-Business Suite","product":"","publisheddate":"2019-02-26T11:54:11","rxt_solutions":"Applications, Application Management & Operations, Application Modernization","opengraph_tag":"","x_tag":"","teaser_flag":"Technical Blog","seo_titile":"Understand and Install Oracle Demantra and SPWA | Rackspace Technology","field_topics":"","field_slug":"understand-and-install-oracle-demantra-and-spwa","footnotes":""},"categories":[178],"tags":[204],"class_list":["post-8062","blogs","type-blogs","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-technical"],"_links":{"self":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/8062","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs"}],"about":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/types\/blogs"}],"author":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/comments?post=8062"}],"version-history":[{"count":3,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/8062\/revisions"}],"predecessor-version":[{"id":9855,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/8062\/revisions\/9855"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media\/8064"}],"wp:attachment":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media?parent=8062"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/categories?post=8062"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/tags?post=8062"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}