Tuesday Jul 19, 2016

VCP 12.2.5.1 and Higher Certification Matrix Spreadsheet ASCP IO RP DRP SPP CP GOP APCC DM AFDM

Hello Demantra Customers! 

There is a new Development sponsored tech stack and component stack certification matrix that is tailor made for Value Chain Planning!
Introducing MOS note 2162165.1: VCP 12.2.5.1 and Higher Certification Matrix Spreadsheet ASCP IO RP DRP SPP CP GOP APCC DM AFDM.  This note is accessible via MOS notes: 1400486.2, Information Center Overview and Alerts: Oracle Demand Management (Demantra); 2007934.2, Value Chain Planning Information Center Master Index; 1664177.2, 12.2.1, 12.2.2, 12.2.3, 12.2.4, 12.2.4.1 and 12.2.5.1 Install Upgrade ADVISOR: Demantra

Friday Jun 17, 2016

Demantra Upgrade Advisor 12.2.5.1 and more! MOS Note 1664177.2

Hello All!   Note 12.2.1, 12.2.2, 12.2.3, 12.2.4, 12.2.4.1 and 12.2.5.1 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 12.2.5.1 install/upgrade.  They now reflect the main MOS note:

Demantra Demand Management Release 12.2.5.1. Mandatory Patches AFTER applying Demantra 12.2.5.1 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 12.2.5.1 Mandatory Patches Update

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

Tuesday May 17, 2016

Demantra 12.2.5.1 Install / Upgrade Mandatory Patch Update

A customer having a fresh install of 12.2.5.1 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 12.2.5.1, nicknamed "Day-1" because it was released at (about) the same time as version 12.2.5.1.

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

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

No need to install 21959406 anymore.

Please see:  Demantra Demand Management Release 12.2.5.1. There is a Mandatory Patch Change AFTER applying Demantra 12.2.5.1 Patch 21951481. Apply 12250139 and 12250168 NO LONGER 21959406 (Doc ID 2068458.1)

Tuesday Apr 26, 2016

Demantra Upgrade To 12.2.5.1 - 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 12.2.5.1 - Advanced Queueing: ERROR: Failed to initialize notification queue for Engine Starter ID

As of the 12.2.5.1 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 12.2.5.1 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 12.2.5.1.  Please see MOS Note:

Demantra Upgrade To 12.2.5.1- 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, 12.2.4.1 and 12.2.5.1 Install Upgrade ADVISOR: Demantra (Doc ID 1664177.2

Hello Demantra Customer!  Beginning with 12.2.5.1 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 12.2.5.1? There is a mandatory Patch Required 21959406. See below.

Hello Please see MOS Note: Demantra Demand Management Release 12.2.5.1. This is a mandatory Patch Required 21959406 AFTER applying Demantra 12.2.5.1 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.

Jeff

Monday Mar 21, 2016

Demantra 12.2.5.1 Upgrade Workflow Security Enhancements Callouts UTL_HTTP, URL and EBS

Hello Demantra Customers!  Upgrading to 12.2.5.1?  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 12.2.5.1 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 12.2.5.1 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)

Tuesday Dec 15, 2015

Demantra Upgrading 7.3.1.4 to 12.2.5.1 Ideas, Roadmap, Procedures

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

We have no direct dialogue specifically regarding upgrading from 7.3.1.4 to 12.2.5.1, 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 12.2.5.1 Demantra Engine
    • September 9, 2015, Oracle Demantra Release 12.2.5.1, Part 1
    • October 14, 2015, Oracle Demantra Release 12.2.5.1, Part 2
    • November 11, 2015, The Demantra Engine - Setup, Run and Common Issues
  • Installing Demantra 12.2.5.1 (Doc ID 2069281.1)
  • 12.2.5.1 Engine Deployment Guide (Doc ID 2069139.1)
  • Demantra Demand Planning 12.2.5.1 Known Issues and Workarounds (Doc ID 2068316.1)
  • Demantra 12.2.5.1 Now Available. See Patch 21951481 [Document 2068456.1]
  • Demantra Demand Management Release 12.2.5.1. 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)

Wednesday Oct 21, 2015

Demantra 12.2.5.1 is available!

Hello!  Demantra does not have version 12.2.5 available.  Demantra provides 12.2.5.1 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

Tuesday Jun 30, 2015

Upgrading Demantra 7.3.1.x to 12.2.x can produce duplicate rows. There are two ways to solve this issue.

Upgrading Demantra 7.3.1.x to 12.2.x can produce duplicate rows.  There are two ways to solve; apply 21089579 before your upgrade to 12.2.x or wait for 12.2.5.1.  The platform upgrade resolves this issue in 12.2.5.1.  Apply this patch before your upgrade from 7.3.1.x to 12.2.x.  After an application upgrade SITE_TYPE_CODE, SITE_TYPE_DESC, ACCT_TYPE_CODE, ACCT_TYPE_DESC columns do not have a default '0'.  Please note that this patch does not remove any existing "duplicate" rows in ITEMS, LOCATION, MDP_MATRIX or SALES_DATA.


Upgrading 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)

Thursday Apr 02, 2015

Demantra Installing 12.2.4.1 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 12.2.4.1 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:

@sys_grants.sql DEMANTRA ACL_DEFAULT ACL_DEFAULT TRUE

This has been addressed in release 12.2.5.1.

Also:

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

Are you already at 12.2.4.1?

Demantra 12.2.4.1 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 12.2.4.1 Mandatory Patch Application - Patch 19945449 (Doc ID 1960180.1)
Demantra 12.2.4.1 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 12.2.4.1 (Doc ID 1947062.1)
Demantra Release 12.2.4.1 Known Upgrade and Known Product Issues with Workarounds (Doc ID 1948769.1)
Oracle Demantra Demand Planning Announcing New Release 12.2.4.1 is Now Available (Doc ID 1948684.1)
Troubleshooting Demantra 12.2.4.1 Installation (Doc ID 1986634.1)

 

Friday Jan 09, 2015

Demantra 12.2.4.1. Are you upgrading or have upgraded? New Mandatory Patch is available.

Are you already at 12.2.4.1?  Demantra 12.2.4.1 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.

Wednesday Nov 26, 2014

Oracle Demantra Demand Planning Announcing New Release 12.2.4.1 is Now Available MOS Note 1948684.1

Announcing Oracle Demantra Demand Planning 12.2.4.1 Release

We are excited to announce Oracle Demantra Demand Planning 12.2.4.1 is now available for new and existing customers.

Oracle Demantra Demand Planning 12.2.4.1 includes several features in 12.2.4. Key features include:

  • Oracle In-Memory Consumption-Driven Planning
  • 64-bit Analytical Engine
  • User Access Control
  • Additional Demantra Hierarchies in APCC
  • Launch Management Extended to DM and PTP Components
  • APCC Support for Trade Hierarchies and Data
  • Streamlined Promotion Creation and Improved Method Usability
  • Promotion Calendar Enhancements
  • Printing Promotion Calendar
  • Streamlined Simulations
  • Enhanced Shipment and Consumption Planning Support
  • Demantra- Improved Worksheet Performance
  • VCP and Demantra- Support E1 Long Item Code
  • VCP and Demantra- Certified with Oracle 12.1.0.2 DB in Memory


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

  • Demantra Patch Number is 19973580.
  • For E1 customers Long Item Code  Patch Number is 19608405.
  • Demantra 12.2.4.1 will only work with VCP 12.2.4.1.
  • Demantra 12.2.4.1 and VCP 12.2.4.1 will work with EBS 12.1.3 or EBS 12.2.4.


Questions?


If you would like additional information regarding Oracle Demantra 12.2.4.1 functionality, certification and deployment please refer to the Demanta Documentation Library on My Oracle Support (Document  443969.1).

Contact Jeffery.goulette@oracle.com with direct questions.   Regards!   Jeff

About

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

Search

Archives
« July 2016
SunMonTueWedThuFriSat
     
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
20
21
22
23
24
25
26
27
28
29
30
31
      
Today