Monday Mar 17, 2014

Demantra 16 Newly Published White Papers from PMO and Proactive Support

Hello Everyone!   There are 16 newly published white papers from Demantra PMO and Proactive Services.   Take a look.  As always, email Jeffery.goulette@oracle.com

if you have questions.    Regards! 

  1. Configuring an Audit Log in Demantra Using Database Triggers, Doc ID 1629974.1
  2. Demantra Configure to Order (CTO) Integration EBS Model BOM Example How To, Doc ID 1630040.1
  3. Demantra APIs to Facilitate Integration with External - Third Party Source Systems, Doc ID 1630505.1
  4. Demantra Indirect Modeling, Lift Decomposition, Definitions and Issues, Doc ID 1630545.1
  5. Demantra Indirect Customer Modeling, Customer Scenarios, Modeling Approaches, Key Recommendations and More! Doc ID 1630604.1
  6. Demantra PTP – Shipment vs. Consumption Forecasting White Paper, Doc ID 1630628.1
  7. REPLACEMENT OF APS SIZER with VALUE CHAIN PLANNING REFERENCE SIZING TOOL (RAS), Doc ID 1630684.1
  8. Troubleshooting Strategy and Processes that Execute Enormous data sets in Demantra, Doc ID 1634925.1
  9. Oracle Demantra Database Best Practices White Paper, Doc ID 1627586.1
  10. Oracle Demantra Customizations and BAL Upgrade White Paper, Doc ID 1627590.1
  11. Oracle Demantra New Product Introduction (NPI) - Pooled Time Series (PTS), Doc ID 1627623.1
  12. Demantra Platform or Application Upgrading - Program Manager Recommendations, Doc ID 1627664.1
  13. Oracle Demantra Worksheets Caching, Details how the Caching Functionality can be Leveraged to Potentially Reduce Performance, Doc ID 1627652.1
  14. Level Member Caching Purpose Performance Guidance, Doc ID 1627689.1
  15. Oracle Demantra BLE Mechanism Explanation and Details, Doc ID 1627716.1
  16. Demantra Integration Real Time Sales & Operations Planning, Advanced Supply Chain Planning and Strategic Network Optimization, 7.3.1.4 and Higher (Doc ID 1636614.1)

Wednesday Mar 12, 2014

Troubleshooting Strategy and Processes that Execute Enormous data sets in Demantra

Hello Demantra Customers!   There is a new white paper that discusses large data set loading.

See MOS Note 1634925.1

Recently we have encountered a few scenarios where customers tried to process huge amounts of data within a Demantra process.
Examples:

  • Customer wanted to load over 50M records via EP_LOAD process on weekly bases.
  • Customer wanted to process millions of rows via BLE process on daily bases.
  • Customer wanted to load via integration interface 40M rows on weekly bases.


In all of the above the customer complained about the system inability to process the amount of data, either being too slow or it simply could not be completed at all meaning the process erred out.
In all of the above examples an escalated defect was logged, and development worked troubleshooting the problem.

An additional common theme between all the above examples and many more is that there was no real need to have a product fix although performance improvement opportunities may have been identified, they were not the final solution that addressed the problem.
What helped was understanding that there is no real need to process all the data and recognizing the data that really needed to be loaded.  The data could have been loaded in a more efficient way using some best practices and creative thinking.

The scope of this document is to provide some guidance how to troubleshoot such customer situations.
The document will focus on three main areas:

  • Learning and understanding the business needs
  • Understanding the actual data that needs to be loaded, understand the gap between this number and the number of rows that the customer actually tries to load.
  • Provide some best practices that can help the customer work with the data efficiently.


This document will not deal with the initial Data load processes although some of the best practices can be adopted for such situations as well.
We will illustrate the concepts in this document using three real life examples of service requests and/or defects that were logged on behalf of the customer.

 

About

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

Search

Archives
« March 2014 »
SunMonTueWedThuFriSat
      
1
2
3
4
5
6
7
8
9
10
11
13
14
15
16
18
19
20
21
22
23
24
25
26
27
28
29
30
31
     
Today