Tuesday Jan 20, 2015

Demantra Large Table Partitions and Using the Flashback Recycle bin, recyclebin, dba_recyclebin and sys.RECYCLEBIN$ Purge Best Practice

This is covered using MOS note:

Demantra Large Table Partitions and Using the Flashback Recycle bin, recyclebin, dba_recyclebin and sys.RECYCLEBIN$ Purge Best Practice (Doc ID 1962730.1)

When you are using the  feature and Oracle partitions are involved you will need to perform additional due diligence.  After the automatic
purge that occurrs when the quota is reached or after you issue a purge command to the recyclebin, you will notice that there are orphaned
BIN$ objects that consume the same space as the original partition that was dropped and the purged.

 

This was the solution based off of a customer SR that puzzled us at first.  The flashback documentation does not discuss the flashback purge
and partitions.  We recommend following the current best practice when managing the flashback feature and partitions.

If you have already performed or if the auto purge has occured, you will need to perform the following.  Of course customized to you BIN$ object name:

ALTER SESSION SET RECYCLEBIN=OFF;
drop table lpudemantra."BIN$A3+yI1NBASrgUwoVBkIBKg==$0";
drop table lpudemantra."BIN$A4gGznhiAVbgUwoVBkIBVg==$0";
.
.
.
.
drop table lpudemantra."BIN$9WCVYRl3BGbgQwoVBkIEZg==$0";

If you have not experienced the purge of the recycle bin, attempt the following:

  1) select count(*) from sys.recyclebin$;

  2) Instead of simply trying to purge the table we can use the following alternative:

     a) flashback table <table_name> to before drop;

          or

          if  <table_name> is currently used by another object:

        flashback table <table_name> to before drop rename to <new_table_name>;


     b) create a script that will drop all the partitions one by one :

        spool drop_<table_name>_partitions.sql

        select 'alter table '|| table_owner|| '.'|| table_name ||' drop partition '|| partition_name||';'
        from dba_tab_partitions
        where table_name='<table_name>'
        /

        spool off


     c) run drop_<table_name>_partitions.sql


     d) drop table <table_name>;


     e) purge recyclebin;


To turn off the recyclebin
  - alter system set recyclebin=off scope=spfile;

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 17, 2014

Demantra 12.2.4.1 Has Been Released. See details below

Hello Demantra Customers!  Are you at version 12.2.4?  A new cumulative patch has been released.  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.  

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.

see MOS Note:

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)

and

Oracle Demantra Demand Planning Announcing New Release 12.2.4.1 is Now Available (Doc ID 1948684.1)

and

Demantra Release 12.2.4.1 Known Upgrade and Known Product Issues with Workarounds (Doc ID 1948769.1)

and

Oracle Value Chain Planning (VCP) Readme, Release 12.2.4.1 (Doc ID 1931390.1)

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

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)

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)

Wednesday Oct 01, 2014

Demantra Performance and Setup Analyzer v2.00 is FINALLY Available!

Hello Demantra Customer!  There is a new release of the Demantra Performance and Setup Analyzer!  Version 2.00 has been released!
You can pick and choose any SQL that you prefer to see given any type of task at hand.   See MyOracleSupport note
Demantra Analyzer script for Setup and Performance Monitoring (11.5.X and R12), 1618885.1

I am considering adding more topical analysis and deeper digging into additional details for the next release. 

Any questions / comments, please email Jeffery.goulette@oracle.com

Thank You!

Demantra 12.2.4 Performance Enhancement Data Points that you need to know!

Demantra 12.2.4 Customers, There is a new MyOracleSupport note highly recommended by Demantra Development.  There are new performance enhancements available!  However, there is additional information in this note that is critical to implement some of these new enhancements.

Please see, Demantra 12.2.4 Worksheet Performance Enhancements Parameter dynamic_hint_enabled. Development Recommended Proper Setup and Use (Doc ID 1923933.1)

Thursday Sep 25, 2014

Demantra Integration Webcast 24-Sep-2014

Hello!   Were you able to attend the the Demantra webcast 24-Sep-2014?   The topic was integration.  You can watch a replay found at:
Demantra Solutions Advisor Webcast Calendar And Archive (Doc ID 800030.1) and scroll to Integrating Demantra With Oracle Applications.

 

Coming up:

1) 8th OCT, V2 Analyzer review and Data Mining Live Demo

2) I am thinking about breaking the 24-Sep-2014 into two presentations.  This would allow us to dig deeper into debugging the integration and workflow.  These would concentrate on data once it arrives into the denorm table AND data mapping. 

Has anyone used the e_plan_tree database object?

SQL> desc msdem.e_plan_tree
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 E_PLAN_NODE_ID                            NOT NULL NUMBER(10)
 E_PLAN_CHILD_NODE                                  NUMBER(10)
 TABLE_NAME                                NOT NULL VARCHAR2(30)
 FIELD_NAME                                NOT NULL VARCHAR2(30)
 E_PLAN_NAME                                        VARCHAR2(30)
 E_PLAN_TITLE                                       VARCHAR2(100 CHAR)
 E_PLAN_BASE_DIM                                    VARCHAR2(30)
 E_PLAN_TYPE                                        VARCHAR2(10)
 E_PLAN_DATA_TYPE                                   VARCHAR2(10)
 E_PLAN_RELATION                                    NUMBER(10)
 SOURCE_NAME                                        VARCHAR2(30)
 E_PLAN_AGGRI                                       VARCHAR2(400)
 MODEL_VERSION                             NOT NULL NUMBER(5)
 VERSION_NAME                                       VARCHAR2(30)
 FICTIVE_COLUMN_NAME                                VARCHAR2(30)
 E_PLAN_TABLE_NAME                                  VARCHAR2(30)
 HYRARCHY_NO                                        NUMBER(5)
 ENABLE_LEVEL                                       VARCHAR2(20)
 USE_EP_GEN_ID_FOR_FILTER                           NUMBER(1)
 USE_ITEM_LOC_ID                                    VARCHAR2(20)
 AGGRI_FUNC                                         VARCHAR2(400)
 WAVG_DEPENDANT                                     VARCHAR2(30)
 PARTS_VERSION                             NOT NULL NUMBER(5)
 IS_HIERARCHY_LEVEL                                 NUMBER(1)
 PARENT_FIELD_NAME                                  VARCHAR2(30)
 APPLICATION_ID                                     VARCHAR2(63)

 

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