Friday Jun 17, 2016

Demantra Upgrade Advisor and more! MOS Note 1664177.2

Hello All!   Note 12.2.1, 12.2.2, 12.2.3, 12.2.4, and Install Upgrade ADVISOR: Demantra (Doc ID 1664177.2)
is meant to be the clearing house of important install / upgrade MOS notes.   If you click into the note you will see the tab Release Specific.

If you have the need to install / upgrade Demantra use this note for install/upgrade issues.  This advisor is available at 2007934.2 which is the clearing house of all things VCP.   Go to 2007934.2, click on DM and there you will find the install / upgrade advisor.

I have reviewed and updated most all notes related to install/upgrade.  They now reflect the main MOS note:

Demantra Demand Management Release Mandatory Patches AFTER applying Demantra Patch 21951481. Apply 12250139 and 12250168 NO LONGER 21959406 (Doc ID 2068458.1)

2068458.1 is accessible at the advisor 1664177.2.   There was confusion regarding the correct patch path to take to make Demantra development stable.   

Regards!   Jeff

Demantra Release Mandatory Patches Update

Hello Demantra Customers!  There is an update to mandatory patches required for release  You can find the details in My Oracle Support (MOS)
note 2068458.1.  Please review if you are upgrading to

Tuesday May 17, 2016

Demantra Install / Upgrade Mandatory Patch Update

A customer having a fresh install of needs to install patches 12250139 (bug 22254051) and Patch 12250168 (bug 23088083).  No need to install 21959406 anymore.

 This is a mandatory patch for Demantra version, nicknamed "Day-1" because it was released at (about) the same time as version

All customers must apply this patch before Development will investigate any open bugs.

A customer having a fresh install of needs to install patches 12250139 (bug 22254051) and Patch 12250168 (bug 23088083).

No need to install 21959406 anymore.

Please see:  Demantra Demand Management Release There is a Mandatory Patch Change AFTER applying Demantra Patch 21951481. Apply 12250139 and 12250168 NO LONGER 21959406 (Doc ID 2068458.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 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.


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)

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 Oct 21, 2015

Demantra is available!

Hello!  Demantra does not have version 12.2.5 available.  Demantra provides with a mandatory patch 21959406.  

Please see MOS notes 2068456.1 and 2068458.1. 

It is best to keep ASCP and Demantra at the same level but not 100% required unless otherwise advised.  Regards!  Jeff

Thursday Apr 02, 2015

Demantra Installing as SYS or SYSTEM Installer Fails or is Failing

We are aware of a bug that might raise an error during the installation of the Generic Patch recently released.

In some cases, when using SYS as the DBA user and “Enable Automatic Table Maintenance” checkbox has been checked, sys_grants.sql script which is being
run as part of the installation may fail.

sys_grants.sql is using an internal function in with a specific combination of hardware/platform may generate invalid value.

Run the installer using SYSTEM and not SYS, then, after the installation completes, replace sys_grants.sql with the attached file and run it as sys.
Make sure to add “TRUE” as the 4th parameter.

For example:


This has been addressed in release


Uptake of VCP is mandatory for all VCP and Demantra 12.2.4 installations.

Are you already at

Demantra has a new required patch 19945449, ARU# 18420277, Demantra patch 12240066 - is now available. It was discovered that the engine throws a segmentation fault while running CDP consumption profile.  Please see the additional information in the readme Notes.

Reference Notes:
Oracle Demantra Post Release Mandatory Patch Application - Patch 19945449 (Doc ID 1960180.1)
Demantra Cumulative Patch. This CU is Specifically for r12.2.4.1. There are 13 Issues Patched and or Improved. (Doc ID 1952805.1)
Oracle Demantra Release Notes for Release (Doc ID 1947062.1)
Demantra Release Known Upgrade and Known Product Issues with Workarounds (Doc ID 1948769.1)
Oracle Demantra Demand Planning Announcing New Release is Now Available (Doc ID 1948684.1)
Troubleshooting Demantra Installation (Doc ID 1986634.1)


Thursday Oct 23, 2014

Oracle Demantra 12.2.4 RDBMS 12C Important Updates to Consider

Hello Demantra Customer!   Are you considering an upgrade to you Oracle Demantra software?  Are you implementing Oracle RDBMS 12C with Demantra?  There are critical MOS notes that you may want to review.

  • 12.2.1, 12.2.2, 12.2.3 and 12.2.4 Install Upgrade ADVISOR: Demantra (Doc ID 1664177.2)
  • DEMANTRA WARNING Have you OR are you Planning to Upgrade to Release 12.2.2? Upgrade from 12.2.2 to 12.2.3 or 12.2.4 Collections EP Load is Failing ORA-20002, ORA-00001, ORA-06512 (Doc ID 1917715.1)
  • Upgrading to Demantra 12.2.4? Here are current known issues from Demantra Development, Proactive Services and Oracle Support (Doc ID 1928367.1)
  • Demantra Startup Times can be Longer When Running Demantra on Oracle 12c RDBMS due to RDBMS Defects (Doc ID 1937616.1).

Thursday Jul 24, 2014

Demantra 12.2.x Focusing on 12.2.3 Install, Upgrade, Operation Bug Fixes and Best Practices

Hello Demantra Customers! 

There is a new r12, focusing on r12.2.3, MOS note that summarizes all known issues as of 24-Jul-2014.  Quickly review the
problems and solutions to help you save time!

See Demantra 12.2.x Focusing on 12.2.3 Install, Upgrade, Operation Bug Fixes and Best Practices.  Known Issue Summary (Doc ID 1910650.1).

Monday Feb 24, 2014

Announcement: Oracle Demantra 12.2.3 Available

We are excited to announce Oracle Demantra 12.2.3 is now available for new and existing customers.  All customers who are not incorporating Demantra with other VCP products are welcome to upgrade without any restrictions.  Customers who are using Demantra in conjunction with VCP products will need to upgrade VCP to 12.2.3.
Demantra 12.2.3 encompasses the same functional scope as Demantra 12.2.2 with additional security and functional bug fixes.

Demantra 12.2.3 will work with JD Edwards EnterpriseOne 9.1 using the AIA 11.4 for the Value Chain Planning Base Integration Pack.
Demantra 12.2.3 will only work with VCP 12.2.3.
Demantra 12.2.3 and VCP 12.2.3 will work with EBS 12.1.3 or EBS 12.2.3.
Please review the release readme and all 12.2.3 documentation carefully to determine content details for this patch. You can also find documentation in the Demantra Documentation Library on My Oracle Support (note 443969.1).

The release is currently available on My Oracle Support (formerly known as Metalink) as Patch 17921238.
Release will be available from e-delivery in a few weeks.

It is recommended for all customers who are on 12.2.1 or 12.2.2 to upgrade to 12.2.3 at earliest convenience.   Please do not upgrade to 12.2.2 and then 12.2.3.

Friday Dec 20, 2013

Demantra Platform or Application Upgrading - Program Manager Recommendations

Hello Demantra Customers!  Are you planning on an upgrade?  Should you follow a platform or application upgrade path?  MyOracleSupport (MOS) Note 1609763.1 delivers high impact information from the Demantra Program Management Office (PMO).  Take a look, it will help you make an informed decision for your upgrade path.    Regards!   Jeff

Monday Nov 25, 2013

New Demantra Version - REPLACES - Existing


A new version of Demantra has been released and we want to ensure that all customers/partners who are using uptake it.

This version is meant to replace the existing some of you may have installed.

Regards!  Jeff


Thursday Aug 08, 2013

Worksheet Issues During or After Upgrade?

 Proactive action During/After an Upgrade may help.  Please review the following:

  1. Clean the Java cache by deleting the Java cache windows folder 
  2. Set the Java console debug mode to '5'
  3. Reproduced the issue
  4. Review the Client Java console
  5. Review the collaborator.log
  6. Produce an action plan

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


« June 2016