Tuesday Apr 26, 2016

Demantra Upgrade To - Advanced Queueing: ERROR: Failed to initialize notification queue for Engine Starter ID

Hello!  Issue is where the Advanced Queues in the Oracle database are corrupted.

Demantra Upgrade To - Advanced Queueing: ERROR: Failed to initialize notification queue for Engine Starter ID

As of the version of Demantra, the engine is utilizing functionality in the Oracle Database called “Oracle Advanced Queuing”. This is existing database functionality but it is the first time it is being utilized by Demantra.

We have seen issues with some of the customers upgrading to where the Advanced Queues (AQ) are corrupt and the corruption was never detected because they were not being used. 

The steps detailed in MOS note 2129902.1 resolve this AQ issue for customers having trouble running the engine in  Please see MOS Note:

Demantra Upgrade To ERROR: Failed to initialize notification queue for Engine Starter ID (Doc ID 2129902.1)

Tuesday Apr 19, 2016

Demantra 12.2.1, 12.2.2, 12.2.3, 12.2.4, and Install Upgrade ADVISOR: Demantra (Doc ID 1664177.2

Hello Demantra Customer!  Beginning with it will be easier to find release specific My Oracle Support notes, alerts, TOIs, etc.  At note 1664177.2, the Install Upgrade ADVISOR.  Start at the VCP Informationa Center, 2007934.2, click DM, bottom right click on Install Upgrade Advisor, click Release Specific.  The current My Oracle Support install upgrade and related notes are presented.

Wednesday Apr 13, 2016

Demantra and In Memory Planning using Oracle RDBMS 12c Configure, Troubleshoot

Configuring Demantra and 12c In Memory Columns and Tables for Faster Read Transactions!  Demantra starting from version, is certified to work with Oracle DB 12c.

This DB version includes the ability to load data into memory to enable faster read transactions from the database; this provides a significant performance gain on some of the Demantra operations, mainly worksheet run time.  Guidelines and suggestions have been compiled based on internal work done by Oracle Demantra Development team, as well as real customer experience with this capability and configuration.   Check out the note.   Let me know if you have questions.   


Wednesday Apr 06, 2016

Upgrading to There is a mandatory Patch Required 21959406. See below.

Hello Please see MOS Note: Demantra Demand Management Release This is a mandatory Patch Required 21959406 AFTER applying Demantra Patch 21951481

Of course this is also available at the VCP Information Center (IC), MOS note 2007934.2.   Click on the DM tab, Install - Upgrade tab.


Monday Mar 21, 2016

Demantra Upgrade Workflow Security Enhancements Callouts UTL_HTTP, URL and EBS

Hello Demantra Customers!  Upgrading to  There are changes in the workflow.  There is a new alert white paper that describes some of the new security measures implemented in Oracle Demantra as part of Oracle’s continuous security assertion.  This focuses on 3 types of workflow callouts: UTL_HTTP, URL and EBS.  For more information, see MOS note Calling Demantra Workflow using HTTP POST method in Oracle Demantra and up. New enhanced security measures. ACL permission error. (Doc ID 2118871.1)

Friday Mar 18, 2016

Oracle Cloud IaaS is now available and has support for PRODUCTION Issues

Oracle's Infrastructure as a Service (IaaS) enables you to create new instances of Oracle Value Chain Planning in Oracle Cloud, or clone your on-premises Oracle Value Chain Planning environments to Oracle Cloud.

Hosting Oracle Value Chain Planning environments in the cloud can benefit your organization in multiple ways, including:

  • Reducing infrastructure costs.
  • Providing the capability to allocate infrastructure temporarily for short-term projects such as proof of concept testing, functional and technical training and testing, and customization development.
  • Providing the capability to use Oracle Application Management Suite for Oracle Value Chain Planning to monitor on-premises and cloud environments simultaneously, and to automate the deployment of patches and customizations.

Note: Oracle Value Chain Planning Cloud support is limited to release 12.2 and 12.1.3-based environments on Oracle Linux, and currently excludes configurations with Oracle RAC, DMZ, and external integrations.

See MOS Note: Getting Started with Oracle Value Chain Planning in the Oracle Cloud (Doc ID 2095953.1)

Friday Mar 04, 2016

Premier support for Oracle Demantra has been extended from September 2016 to December 2019!

We are pleased to announce that the Premier support for Oracle Demantra has been extended from September 2016 to December 2019.
This aligns with the support lifecycle of VCP

Note that to receive support for this version you will need to be on latest cumulative patch set of
All other versions of 7.3.1 will end their Premier support after September 2016.

For additional information regarding Oracle Applications support timelines please see http://www.oracle.com/us/support/library/lifetime-support-applications-069216.pdf

Thursday Jan 21, 2016

Announcing availability of 12.2.5 Mandatory Consolidated Patch 2 | Also: Windows 10 and MS IE 11 support

Hello All!

Value Chain Planning is announcing the availability of 22493520:R12.SCP_PF.C - VCP CONSOLIDATED PATCH 2 FOR R12.SCP_PF.C.DELTA.6.

This is a mandatory patch that replaces Consolidated Patch 1 for all 12.2.5 VCP customers.  Any customers on, new 12.2.5 customers, or customers that are upgrading to 12.2.5 need to apply this patch.

The patch addresses performance and other issues that could not be included in CP1, which was released on “day 1” for 12.2.5, but which we deem critical to mandate.

Other recently asked questions on tech certifications:
- Will PS, SNO, and Demantra run on Windows 10 client?
Yes, we have done base certification and  have not found issues when running with IE 11.  (MS Edge browser is not supported for any of our products at this moment due to issues with Forms and Java applets).

- When can we expect 12.1.3 and 12.2.4 to support IE 11 browser for ADF based screens (ASCP, IO)? (12.2.5 supports IE 11 already)
To support IE 11, we need customers to upgrade to a later version of WLS (as we rely on an ADF version that supports IE 11 that is part of a newer WLS version than what we have certified).  
For 12.1.3 and 12.2.4 we are looking at forced upgrades for people that are using ADF as we cannot maintain dual code lines to support multiple ADF/WLS versions.  We are working with Oracle Support to send out Alert Notes to those customers that are on those releases ahead of time (2mo notice), so that they can plan WLS ADF upgrades as part of getting ADF UI bug fixes (that force the issue). While a large number of customers run IE, this also means that customers that use ADF that are not running IE will be impacted. It also means that customers that use our early ADF screens and need IE 11 compatibility will have to move to patch 3 when it becomes available. 12.2.4 customers would automatically be forced to uptake the newer versions, there will not be a separate cumulative patch (ie. for this. 
We will confirm availability to this forum when the code is available.

Monday Jan 11, 2016

New! Available Demantra generic 12.2.x database platform patch that includes four new fixes

Hello! There is a new patch available, 18139794.

A generic 12.2.x database platform patch that includes new fixes. 

PLEASE NOTE: This patch is not to be installed on 12.2.5.x

This patch is accumulative and contains all the bugs fixes from previous builds of this patch.

Before applying the patch please ensure that the Apps server , Engine and Business Modeller are all closed / shutdown.

Summary of Latest Bug fixes added to the 12.2.x generic patch  (12.2.1 to 12.2.4.x)    BUT NOT 12.2.5.x

    Fix: INSERT_UNITS calls EXECUTE_PROFILES (Rolling Updates) with the correct rolling group name.
    Fix: EXECUTE_PROFILES (Rolling Updates) where EXTRA_FROM contains ITEMS or LOCATION
    Fix: EP_LOAD issues caused when changing the  TNS DATE FORMAT setting.


Tuesday Dec 15, 2015

Demantra Upgrading to Ideas, Roadmap, Procedures

Hello!  Thank you for your query via the Demantra BLOG!

We have no direct dialogue specifically regarding upgrading from to, we do have the following My Oracle Support (MOS) notes that will
help you navigate the upgrade process.  These will help you create your upgrade procedures.  After reviewing the following, and any additional information that you find, please feel free to submit your plan for review.   We would be glad to review and comment as required.  Not knowing your specific scenario, here is a list that will help.  The proper approach is to review each item.  This will help you develop a solid upgrade plan:

  • Demantra Solutions Advisor Webcast Calendar And Archive (Doc ID 800030.1)
    • January 13, 2016, Setup/Run/Troubleshoot The NEW Demantra Engine
    • September 9, 2015, Oracle Demantra Release, Part 1
    • October 14, 2015, Oracle Demantra Release, Part 2
    • November 11, 2015, The Demantra Engine - Setup, Run and Common Issues
  • Installing Demantra (Doc ID 2069281.1)
  • Engine Deployment Guide (Doc ID 2069139.1)
  • Demantra Demand Planning Known Issues and Workarounds (Doc ID 2068316.1)
  • Demantra Now Available. See Patch 21951481 [Document 2068456.1]
  • Demantra Demand Management Release There is a mandatory Patch Required 21959406 [Document 2068458.1] 
  • Demantra Platform or Application Upgrading - Program Manager Recommendations, Demand Management DM SOP PTP TPO SPF CTO IMCDP [Document 1609763.1]
  • List Of Demantra Versions And Corresponding Java Versions [Document 1346197.1]
  • Oracle Demantra Demand Management Release Notes for Release 12.2.5 (Doc ID 2059390.1)


For a Better Understanding:

  • Oracle Demantra and RDBMS Edition Based Redefinition (EBR) EBS schema - Processing and Hot Patching [Document 1932210.1]
  • Customer RecommendedUpgrading from Demantra 7.3.1.x to 12.2.x? This can produce duplicate rows. There are two ways to solve. See patch 21089579 and the details in this note. (Doc ID 2025954.1)
  • Demantra Performance and Setup Analyzer Script and Monitoring Tool (7.3.1 and Above) (Doc ID 1618885.1)
  • Demantra, DM, Weblogic, Engine Related Files and Paths [Document 2072591.1] 
  • Demantra TABLE_REORG procedure. Did you know that TABLE_REORG has replace REBUILD_SCHEMA mad REBUILD_TABLES? [Document 2005086.1]
  • Demantra Development Suggested Performance Advice Plus Reference Docs [Document 1157173.1] 
  • Demantra Upgrade with Customizations using BAL [Document 1458572.1]
  • Oracle Demantra Customizations BAL White Paper [Document 1627590.1] 
  • Demantra Workbench Access Over The Web For External Vendors (Doc ID 2080717.1)
  • Demantra Worksheet Personalization Does Not Show Worksheet Full Name (Doc ID 1962297.1)
  • Unsupported Java Version When Running createDSInEngineRoot.sh (Doc ID 2007452.1)
  • Demantra Upgrade Fails - ORA-01400: cannot insert NULL into (""DEMANTRA"".""INIT_PARAMS_217"".""PER_NODE"") Error in PROCEDURE (Doc ID 2086982.1)

Friday Dec 11, 2015

Demantra Demand Management DM Permance and Setup Analyzer

Hello!  We are actively changing the Demantra Analyzer until it is stable.   Please check MOS note 1618885.1 for any updates or download the latest on a weekly basis.  Thank You!  Jeffv

Friday Dec 04, 2015

Advanced Demantra Demand Management Training: Best Practices, Diagnostics, APIs, Series Locking, Launch Management, VCP Deployment, User Access Control + More!

Hello!   There is a new 10 module course that is available via MOS!  This course is the Advanced Demantra Demand Management Training and covers: Best Practices, Diagnostics, APIs, Series Locking, Launch Management, VCP Deployment, User Access Control + More!  There are even some quizzes!

Start here:

Advanced Demantra Demand Management Training: Best Practices, Diagnostics, APIs, Series Locking, Launch Management, VCP Deployment, User Access Control + More! This is the Index to a 10 Part Course. (Doc ID 2085264.1)

Let me know what you think.   Take Care!  Jeff

Thursday Dec 03, 2015

New! Demantra Demand Management Performance and Setup Analyzer

Hello!   There is a new version of the Demantra Demand Management Performance and Setup Analyzer.

See MyOracleSupport note

Demantra Performance and Setup Analyzer Script and Monitoring Tool (7.3.1 and Above) (Doc ID 1618885.1)

Let us know if you have any comments.  Comment here, in this BLOG, or follow the link to the Demantra Community where there is an existing thread ready for your comments/suggestions.   Regards!   Jeff

Monday Nov 23, 2015

Looking for Install Guide, System Requirements, Implementation Guide and User Guides? See Below

Hello!  The guides can be found at the following URL.  They have been updated where required.


Doc 443969.1 will be updated as soon as possible.  

Regards!  Jeff

Wednesday Nov 18, 2015

Demantra Demant Planning Analyzer v200.2 is NOW Available!

Hello!  There is a new version of the Demantra Analyzer.  

See the latest in this MOS note: 1618885.1

See the overview doc here: 2079537.1

There are additional data points, a new format that is easier to review.  Additional comprehensive verification!  Give it a try!

Regards!   Jeff


This blog delivers the latest information regarding performance and install/upgrade. Comments welcome


« May 2016