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 Jun 18, 2015

Demantra Certification Study Guides, Exam Preparation

Hello All!   We have the certification documents available!  They are located at

https://community.oracle.com/docs/DOC-916146

There you will find:

  • The PDF from May 2015 webcast, Demantra Certification.  Are you attempting to get certified?  Let's walk through the process!
  • Mfg_DEM_Advisor_Webcast_2015_0610.pdf
  • Mfg_DEM_Advisor_Webcast_Certification_2015_0610-Part-2.pdf
  • Demantra-Certification-Technical.pdf
    • This is still in draft however, plenty of technical points that will add to your understanding of Demantra troubleshooting and management
  • Demantra-Certification-Topics.pdf

Of course, there are plenty of webcasts, as noted in Demantra-Certification-Topics.pdf.  Remember, the test is based on 7.3.1.4.  I would advise that you stay with manuals that are available for 7.3.1.4 as made available at Oracle Demantra Documentation Library, DOCs, TOIs and Training Available(Doc ID 443969.1). 

There is one more site that will help you drill into specific topics.  This site has whitepapers from Demantra DEV and Support Proactive Services that will provide detailed analysis and direction to Demantra functional and technical topics.  The MOS note is:

Development and Proactive Services Document Library. CRITICAL Updates, Comprehensive, Impactful White Papers, Guides, Notes +! Oracle Value Chain Planning Suite ASCP GOP Demantra RP APCC SNO IO DSR PS SPP, Note 1669052.1

Additionally, the Demantra Information Center is being updated and integrated into the NEW Value Chain Planning (VCP) Information Center!  I will provide details as soon as they are available.

As always, feel free to contact me.   Best to you in your efforts!   Jeff

Saturday Jun 13, 2015

Demantra Certification Training Inventory Coming Soon!

Hello All!   As promised during the 10-Jun-2015 Demantra webcast, I will be publishing the following on Monday in the Demantra Community.   There will be additional docs that will help you move towards certification success.  Remember, if you fail, you will know where to refocus your study for attempt two OR even attempt 3!!  These are the docs that I have so far:

Mfg_DEM_Advisor_Webcast_Certification_2015_0513.pdf
Mfg_DEM_Advisor_Webcast_Certification_2015_0610-Part-1.pdf
Mfg_DEM_Advisor_Webcast_Certification_2015_0610-Part-2.pdf
Demantra-Certification-Topics.txt
Demantra-Certification-SQL.sql

I will be in touch soon.   Thank You!   Jeff

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 Dec 10, 2014

Hello Demantra Customers! Are you at version 12.2.4.1? A new cumulative patch will be released soon.

Hello Demantra Customers!  Are you at version 12.2.4.1?  A new cumulative patch will be released soon.  This 12.2.4.1 cumulative patch is different to the 12.2.x patch strategies in the respect
that it will only contain fixes that are new to 12.2.4.1.  This cumulative patch is scheduled to be released later this month, December 2014.  To monitor, see this note, 1952805.1 or visit the Oracle Demantra BLOG at https://blogs.oracle.com/demantra/

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

Monday Nov 24, 2014

UPDATED: Does Demantra support Edition Based Redefinition (EBR)? How do I address EBR in my EBS instance?

Hello Demantra Customers!  Do you know what Edition Based Redefinition (EBR) is or how it impacts Demantra?  EBS uses EBR for online patching.

There is a new update to the referenced MOS note below.  Demantra DOES NOT support Edition Based Redefinition. 

Edition-Based Redefinition enables you to upgrade an application's database objects while the application is in use, thus minimizing or eliminating down time. This is accomplished by changing (redefining) database objects in a private environment known as an edition.  Only when all changes have been made and tested do you make the new version of the application available to users.

Edition-based redefinition allows multiple versions of PL/SQL objects, views and synonyms in a single schema, which makes it possible to perform upgrades of database applications with zero down time.

Large, mission critical applications built on Oracle Database 11g Release 1 and earlier versions are often unavailable for tens of hours while the application’s database objects are patched or upgraded.  Oracle Database 11g Release 2 introduces edition-based redefinition, a revolutionary new capability that allows online application upgrades with uninterrupted availability of the application.  When the installation of the upgrade is complete, the pre-upgrade application and the post-upgrade application can be used at the same time.

EBS supports EBR from the 12.2 release onwards in the online patching feature.

To read about EBR and Demantra, see the new white paper, Oracle Demantra and RDBMS Edition-Based Redefinition (EBR) EBS schema - Processing and Patching (Doc ID 1932210.1)

Friday Oct 31, 2014

New White Papers in Development Sponsored White Paper Library!

Hello Demantra Customers!  There is a new Development sponsored Value Chain Planning and Demantra library!  This library is exclusive to Demantra Development and Oracle Proactive Support.  There are excellent white papers and more!  See Development and Proactive Services Document Library White Papers (Doc ID 1669052.1)

 As of today, we provide

    Value Chain Planning
    - ASCP Data Collections
    - Demantra Demand Planning  * see below
    - Strategic Network Optimization
    - Rapid Planning
    - Global Order Promising
    - Collaborative Planning
    - WebLogic
    - IO Inventory Optimization
    - SPP Service Parts Planning
    - DP Distribution Planning
    - Integration
    - Information Centers

    Specifically for Demantra
    - Architecture
    - Install and Upgrade
    - Integration, Data Loading and CTO
    - Workflow Issues
    - Worksheet Related
    - Engine Related
    - Performance
    - User Interface Use and Design
    - Diagnostic Tools
    - Weblogic Related

Demantra Development Sponsored White Paper Library, NEW ADDITIONS!

Hello Demantra Customers!  As you know we a Development and Proactive Services document library.  These are hand picked, powerful notes.  Two new notes have been added;

Custom Hierarcies and Demantra SSO using Oracle Access Manager (OAM) 11g - synchronization between Demantra and Oracle Identity Management / Oracle Virtual Directory (OID/OVD).

Look under Demantra Worksheets and Demantra Integration.  See My Oracle Support note 1669052.1.

New Development Sponsored White Paper Single Sign On Using OAM OID and OVD

Hello Demantra Customers!   There is a new Development sponsored white paper! Single Sign-on Setup for Demantra Using the Oracle Access Manager (OAM) 11g - synchronization between Demantra and Oracle Identity Management / Oracle Virtual Directory (OID/OVD) (Doc ID 1940438.1).  This doc will guide you through the steps to achieve integration.  

 

This white paper covers the following topics and much more.   Complete with references and guides.

  • Prerequisites
  • Configuring Single Sign-on
  • Configure a new Oracle HTTP Server (OHS) instance specifically to protect the Demantra WebLogic server
  • Install the new Oracle Access Manager Webgate 11g
  • Ensure that the global logout work properly
  • Configuring Demantra application server(weblogic) to setup OAMIdentityAsserter security provider
  • Authentication in the web.xml file of the Demantra Application
  • Modifying security realm of the weblogic server to setup Identity asserter provider
  • Create a new Authentication Schemes (DemAuthScheme)
  • Resolve the issue of java applets that are not loading in OAM 11g or 10g
  • Demantra with OAM supports the following links
  • Test that you have successfully configured SSO for Demantra

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 Oct 06, 2014

Does Demantra support Edition-Based Redefinition (EBR)? How do I address EBR in my EBS instance?

Hello Demantra Customers!  Do you know what Edition-Based Redefinition (EBR) is or how it impacts Demantra?  EBS uses EBR for online patching.

Edition-Based Redefinition enables you to upgrade an application's database objects while the application is in use, thus minimizing or eliminating down time. This is accomplished by changing (redefining) database objects in a private environment known as an edition.  Only when all changes have been made and tested do you make the new version of the application available to users.

Edition-based redefinition allows multiple versions of PL/SQL objects, views and synonyms in a single schema, which makes it possible to perform upgrades of database applications with zero down time.

Large, mission critical applications built on Oracle Database 11g Release 1 and earlier versions are often unavailable for tens of hours while the application’s database objects are patched or upgraded.  Oracle Database 11g Release 2 introduces edition-based redefinition, a revolutionary new capability that allows online application upgrades with uninterrupted availability of the application. When the     installation of the upgrade is complete, the pre-upgrade application and the post-upgrade application can be used at the same time.

EBS supports EBR from the 12.2 release onwards in the online patching feature.

To read about EBR and Demantra, see the new white paper, Oracle Demantra and RDBMS Edition-Based Redefinition (EBR) EBS schema - Processing and Patching (Doc ID 1932210.1)

Thursday Sep 25, 2014

Demantra Performance and Setup News

Hello!   Sorry for being away so long!  I have been preparing version 2 of the Demantra Performance and Setup Analyzer.  More on that soon.


Have you seen the latest 12.2.1, 12.2.2, 12.2.3 and 12.2.4 Install Upgrade ADVISOR: Demantra (Doc ID 1664177.2)?  This is an excellent store
of hand picked notes and white papers.  Including White Papers, How To +! Documents from Development.  Check it out and let me know what you think.
Regards!  Jeffv

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

About

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

Search

Archives
« July 2015
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
30
31
 
       
Today