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

Friday Oct 31, 2014

Demantra Upgrading to 12.2.x? Critical Known Issues and Lessons Learned

Oracle Demantra customer, are you considering an upgrade to you Oracle Demantra software?  There are three ciritical 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)

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

Monday Aug 11, 2014

Announcing the release of Demantra 12.2.4! Fantastic new functionality!

Hello Demantra Customers!  We are excited to announce that Oracle Value Chain Planning 12.2.4 is now available for new and existing customers. This release includes Demantra 12.2.4.  Providing a wide array of new features driven by customer requirements and needs.  This release includes over 20 key features including; In-Memory Performance Driven Planning, In-Memory Consumption Driven Planning, APCC – Custom Hierarchies and Measures, APCC – End Item Pegging-based Analysis and more!

Please see My Oracle Support note, Oracle Demantra Documentation Library (Doc ID 443969.1), for complete details.

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

Thursday Jun 05, 2014

Upgrading a Customized Environment? There is help available!


Hello Demantra Customers!  Are you upgrading a customized install?  There is are new updates to a white paper that speaks about
using BAL to upgrade a customized environment.  Check out Demantra Upgrade with Customizations using BAL (Doc ID 1458572.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.

Wednesday Feb 12, 2014

Demantra 12.2.2 Upgrade WARNING

We have a MOS note for upgrade problems when upgrading to 12.2.2.

Oracle Demantra Platform Upgrade to 12.2.2 Known Issues Worksheet Performance Calendar Excel ORA-0179 ORA-06512 ORA-31003 java.lang.NullPointerException (Doc ID 1602288.1)

- DO NOT upgrade from 7.3.x, 12.2.0 or 12.2.1 to 12.2.2.

- DO NOT run the 12.2.2 upgrade twice.

Currently there is a bug in the 12.2.2 upgrade that can cause serious corruption in those cases.  Customers should instead upgrade from 7.3.x, 12.2.0 or 12.2.1 to 12.2.3.
I do not know when/if we will fix this issue.  Right now 12.2.2 cannot be downloaded.

Note:  that there is already a section in that MOS note detailing a work-around for a different problem when upgrading from 12.2.1 to 12.2.2.  The existence of that work-around might imply that it is ok to do the upgrade -- but it is NOT ok to do that upgrade

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 Dec 16, 2013

Demantra 12.2.3 Is Now Available!

Greetings!   Demantra 12.2.3 is now available via ARU 17048199, Bug 17921238

1. This release includes both a platform and application upgrade option. Please note the application upgrade installer option is available only to customers who have implemented the *standard* pre-configured applications (available from Demantra 7.1.1 onwards). You should choose the 'Platform Upgrade Only' option only if your implementation is highly customized. A platform-only upgrade will preserve custom configurations and enable new platform functionality. It will not introduce new application objects. Also note Demantra 7.2.1 customers should contact support prior to running an application upgrade, to get latest patch details for that release.

Please note the upgrade process may identify certain objects which have changed between your existing Demantra version (Demantra 7.1.1 or 7.2.0.2, for example) and the current release. This may be due to Oracle extensions in the latest release and/or due to customer extensions in their implementation. In a default upgrade mode, the current versions of these objects will be preserved during the upgrade process and, where there are conflicting definitions with the new Oracle version, we will create duplicate objects with a version suffix.

For example, if you extended the configuration of the workflow 'EBS Price List Download', the upgrade process will maintain this and introduce the Oracle standard workflow as 'EBS Price List Download_730'. In some cases, the original object may be suffixed with its version (for example, 'EBS Full Download_711'and the latest configuration will be 'EBS Full Download'). You will identify the latest version by either a suffix of the latest version, or by a sibling item with an earlier version stamp. You may then review the two and merge as appropriate. In the case of duplicate objects, it is recommended to use the latest version, preferably after removing the ‘_730’ suffix and merging any of your customizations into the latest version.

For Predictive Trade Planning customers, you will note that Promotion Type is no longer a level but instead a series, after application upgrade. This enables promotions to have multiple tactics per promotion, typically for different items or locations being promoted. While promotion type can now vary across different items, locations, it should not vary below the Lowest Promotional Level defined in the forecast tree.

If you are uncertain as to which upgrade option to choose, please contact support for guidance.


2.  If you already installed 12.2.1 or 12.2.2 (using the application upgrade or new installation), please do not choose the "platform and application upgrade" option. Instead, choose to perform only a "platform upgrade."

3.  If you are upgrading from a release that did not support Service Parts Forecasting (SPF) functionality and you want to use SPF, you MUST select the "Platform and Application Upgrade" option when running the Demantra Installer. SPF functionality will not work when upgrading from a pre-SPF supported release to 7.3.1 or later after a PLATFORM-only upgrade.

4. Customers who are on 7.3.1.5 or later who are using In-Memory Consumption Driven Planning (CDP) cannot upgrade to 12.2.3, as 12.2.3 does not support those enhancements.


A future release of the 12.2.x branch will include the 7.3.1.5 CDP enhancements, and upgrading from 7.3.1.5 or later will be supported at that time. Please contact Oracle Support for additional information.



For known issues and work arounds, see MOS note Demantra 12.2.3 Upgrade / Install Known Issues and Workarounds (Doc ID 1608474.1)

Tuesday Dec 03, 2013

Upgrading to 12.2.2? Do you want extra speed? Use a logon trigger for parallelism

When upgrading your Demantra application from an older version directly to 12.2.2, you can minimize the upgrade time.  You can force parallelism using a Logon trigger on the server.

   Creation of new Indexes on sales data can take long time.

   As part of the upgrade there is a script building a new set of indexes, one per engine profile, on each profile quantity_form expression.

   The creation of the index can take a long time on big data tables.

    - Remember to disable or drop that trigger when the upgrade has completed.

   The following trigger was created as SYS database user and tested successfully by creating DEMANTRA database user and logging in with it:

 CREATE OR REPLACE TRIGGER force_parallel_ddl_trg

AFTER LOGON ON database

BEGIN

  IF (USER='DEMANTRA') THEN

    EXECUTE IMMEDIATE 'ALTER SESSION FORCE PARALLEL DDL';

  END IF;

END force_parallel_ddl_trg;

/

 Make sure to:

  1. Modify DEMANTRA to be the database schema name.
  2. drop it after it is not needed anymore using the foillowing:

 DROP TRIGGER force_parallel_ddl_trg;

Monday Nov 25, 2013

New Demantra Version 7.3.1.5 - REPLACES - Existing 7.3.1.5

Hello!

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

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

Regards!  Jeff

 

Thursday Nov 21, 2013

Upgrading to Demantra 12.2.2? There are known Issues and Fixes

When upgrading your Demantra application from an older version directly to 12.2.2 there are some issues of which you need to be aware.
- You are upgrading to Oracle Demantra 12.2.2
- ORA errors, Excel missing cut/paste data, performance issues, Notes, Calendar and other known upgrade issues.

See MOS note:

Oracle Demantra Platform Upgrade to 12.2.2 Known Issues Worksheet Performance Calendar Excel ORA-0179 ORA-06512 ORA-31003 java.lang.NullPointerException (Doc ID 1602288.1)

About

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

Search

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