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 12.2.5.1, 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 12.1.3.8 customers that use our early ADF screens and need IE 11 compatibility will have to move to 12.1.3.9 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. 12.2.4.2) 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

  • THE ROLLING GROUP FEATURE CAUSED THE DEMANTRA ENGINE INSERT_UNIT TO ERROR
    Fix: INSERT_UNITS calls EXECUTE_PROFILES (Rolling Updates) with the correct rolling group name.
  • ROLLING PROFILE DATA EXECUTION IS NOT GIVING THE REQUIRED OUTPUT
    Fix: EXECUTE_PROFILES (Rolling Updates) where EXTRA_FROM contains ITEMS or LOCATION
  • DEMANTRA DATA LOADING - TNS DATE FORMAT ISSUES
    Fix: EP_LOAD issues caused when changing the  TNS DATE FORMAT setting.

 

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)

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 12.2.5.1 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.

http://docs.oracle.com/cd/E26401_01/nav/vcp.htm

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

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

Monday Oct 19, 2015

New Demantra Information Center White Papers - Topical Essays

 See the Information Center Overview and Alerts: Oracle Demand Management (Demantra) (Doc ID 1400486.2)

 

From this link you can click into the VCP Information Center Master Index or drill into the Demant White Papers and Topical Essays.

Regards!  Jeff

Wednesday Oct 07, 2015

Are you on 12.2.4.1? There is a mandatory patch that requires application.

Hello!   If you have upgraded to version 12.2.4.1 there is a mandatory patch:

Oracle Demantra Post Release 12.2.4.1 Mandatory Patch Application - Patch 19945449, patch 1960180.1.

 

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

Please refer to Oracle Support note 453127.1 if more then 1 instance of Demantra is installed on the same machine.

If you are using a WAR file to deploy the application to the web server, recreate and redeploy the WAR file after applying the patch on the centralized machine, in order to ensure the changes made by the patch are propagated to the web server.

It is necessary to clear the Java Plug-in cache on the client machine in order to ensure the changes made by this patch are loaded by the browser.
To clear the Java Plug-in cache click Start -> Control Panel -> Double-click the Java icon in the control panel.
Then Click Settings under Temporary Internet Files section -> Delete Files.

Monday Oct 05, 2015

Patch 21089579 Avoiding Duplicate Rows During Import Generic Patch for 7.3.1.x and 12.2.x

Hello!  A customer brought patch 21089579 to my attention.  Please consider this a mandatory patch if you are importing data.  This will help you avoid duplicate rows during the import process.  If you have this issue after importing data please note that as these are only descriptive values I would expect the data load process to synchronize them on the next data load.  The level table descriptions should be updated to match with the staging table after the EP_LOAD_ITEMS and EP_LOAD_LOCATIONS procedures complete.

Please apply this patch if you are on Demantra Version: 7.3.1.x to 12.2.x

Bug 20455336 - AFTER APP UPGRADE SITE_TYPE_CODE AND ACCT_TYPE_CODE COLUMNS HAVE WRONG DEFAULTS

Fixed in 12.2.5.1

* Please note that this patch does not remove any existing "duplicate" rows in ITEMS, LOCATION, MDP_MATRIX or SALES_DATA.v

Monday Sep 21, 2015

New Demantra Log File Parser in PERL

Hello!  There is a new Demantra Log File Parser available.  This is written in PERL.  Take a look.  As always, comments are welcome.

MOS Note 2053982.1:  Demantra Demand Planning Log File Parser

Monday Aug 24, 2015

How to avoid ORA-06512 and ORA-20000 when Concurrent Statistics Gathering is enabled. New in 12.1 Database, Concurrent Statistics Gathering, Simultaneous for Multiple Tables or Partitions

Oracle Database 12.1 introduces a new feature, Concurrent Statistics Gathering. 

Concurrent statistics collection is simply the ability to gather statistics on multiple tables, or table partitions, at the same time.  When CONCURRENT statistics gathering is enabled, you can execute each statistics gathering job in parallel.  This combination is useful when you need to analyze large tables, partitions, or subpartitions.  This is accomplished  using a combination of the job scheduler, advanced queuing and resource manager.  Concurrent statistics collection can reduce the time it takes to gather statistics, provided the system can accommodate the extra workload.

Functionality wise, it is a way to gather stats on multiple tables, table partitions or subpartitions at the same time.

From a user perspective, the concurrent statistics collection functionality is very simple.  You set the CONCURRENT global preference to the required value using the DBMS_STATS package.  The RDBMS determines if concurrency is appropriate and if so, the level of concurrency to use. 
See MOS Note: 2034376.1, How to avoid ORA-06512 and ORA-20000 when Concurrent Statistics Gathering is enabled. New in 12.1 Database, Concurrent Statistics Gathering, Simultaneous for Multiple Tables or Partitions

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)

About

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

Search

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