Friday Oct 31, 2014

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

 

Friday Feb 28, 2014

Proactive Support and Oracle Demantra PMO Deliver 13 Excellent Functional and Technical White Papers + Announcement

Hello!   Working together, Oracle Proactive Support and the Demantra PMO organization deliver 13 excellent white papers and a new sizer announcement.   These white papers touch some difficult functional areas, NPI, BLE, BAL, modeling techniques, APIs, CTO integration plus more!   Take a look, you might find some valuable ideas.

Configuring an Audit Log in Demantra Using Database Triggers (Doc ID 1629974.1)
Demantra Configure to Order (CTO) Integration EBS Model BOM Example How To (Doc ID 1630040.1)
Demantra APIs to Facilitate Integration with External - Third Party Source Systems (Doc ID 1630505.1)
Demantra Indirect Modeling, Lift Decomposition, Definitions and Issues (Doc ID 1630545.1)
Demantra Indirect Customer Modeling, Customer Scenarios, Modeling Approaches, Key Recommendations and More! (Doc ID 1630604.1)
Demantra PTP – Shipment vs. Consumption Forecasting White Paper (Doc ID 1630628.1)
Oracle Demantra Database Best Practices White Paper (Doc ID 1627586.1)
Oracle Demantra Customizations and BAL Upgrade White Paper (Doc ID 1627590.1)
Oracle Demantra New Product Introduction (NPI) - Pooled Time Series (PTS) (Doc ID 1627623.1)
Demantra Platform or Application Upgrading - Program Manager Recommendations (Doc ID 1627664.1)
Oracle Demantra Worksheets Caching, Details how the Caching Functionality can be Leveraged to Potentially Reduce Performance (Doc ID 1627652.1)
Level Member Caching Purpose Performance Guidance (Doc ID 1627689.1)
Oracle Demantra BLE Mechanism Explanation and Details (Doc ID 1627716.1)

Announcement:
REPLACEMENT OF APS SIZER with VALUE CHAIN PLANNING REFERENCE SIZING TOOL (RAS) (Doc ID 1630684.1)

Friday Jun 21, 2013

Announcing Oracle-Demantra 12.2.1 Release

We are excited to announce Oracle Demantra 12.2.1 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.1 which requires application and participation in Oracle E-Business Suite early adopter program.

Demantra 12.2.1 includes a wide array of new features driven by customer requirements and needs. Key features include:

·       Streamlined import and export from Microsoft Excel

·       Support Gregorian Month data aggregation in weekly system

·       Multilanguage support for eleven languages

·       Promotion Calendar Optimization

·       Enhanced integration with Advanced Planning Command Center (VCP 12.2.1 Required)

Demantra 12.2.1 will work with JD Edwards EnterpriseOne 9.1 using the AIA 11.4 for the Value Chain Planning Base Integration Pack.

Demantra 12.2.1 will only work with VCP 12.2.1.

Demantra 12.2.1 and VCP 12.2.1 will work with EBS 12.1.3 or EBS 12.2.1.

About

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

Search

Archives
« March 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