Model codes used in MDP_MATRIX

Here is a list of the coding convention used by Demantra, when populating MDP_MATRIX with information about which models were used(column MODEL) and which weren't.(column DELMODEL)

H Holt
J Regression FOR Intermittent
K Multiplicative Monte Carlo Regression FOR Intermittent (ICMRegr)
L Transformation Model (log)
R Regression
E Combined Transformation Model (elog)
C Multiplicative Monte Carlo Regression (CMReg)*
B Integrated Causal Exponential Model (BWint)
F Croston For Intermittent
G Logistic*
A ARLogistic*
X Auto and Linear Regression (ARX)
V Integrated Auto and Linear Regression (ARIX)*
D DailyMultiplicativeRegression*

T Naive Holt
N Naive (if all models failed, a moving average forecast is generated)
NULL No forecast attempt made on this combination.
M Modified Ridge Regression*
NONE Combination remains non forecasted yet, not processed by engine.

E.g. MODEL column has value BFR for a combination, this means engine used models B, F and R to generate Bayesian combined model forecast.

Detailed information about models and parameters is available in Demantra implementation guide.
Refer to "My Oracle Support"
Oracle Demantra Documentation Library [ID 443969.1]

News: Oracle Integrates Financial, Operational Planning

Oracle Corp. today introduced a packaged integration between its enterprise performance management application and its sales and operations planning software, making it easier for manufacturers to quickly analyze the financial implications of changing customer demand.

Oracle said the new integration between its Oracle Hyperion Planning EPM product and its Oracle Demantra Real-Time Sales and Operations Planning platform is available now. Based on Oracle’s Application Integration Architecture (AIA), the new EPM-S&OP integration provides manufacturers with a way to more easily tie together operational and financial planning processes

.............................................................read the complete article @

http://www.manufacturing-executive.com/news/read/Oracle_Integrates_Financial_Operational_Planning_33238

Engine enhancements in Demantra 7.3 release

Demantra's 7.3 version has come up with quite a few new enhancements on Analytical engine side. The focus has been on improving the forecast performance, making the AE more robust and faster.

The list of few interesting available features are:
1. Forecast split based on series: Earlier the forecast generated at aggregated level used to get allocated down based on monthly proportions calculated during the proport process. This functionality let's you select a series based from where the proportions shall be picked up for splitting the future forecast.

2. Engine deployment on Linux: Analytical engine is no more restricted to be installed on a windows box, you can install Engine on a Linux box. Engine can be even started and stopped remotely from a browser after doing the required configurations.

3. Forecast output threshold: This functionality provides you more control on engine output, by stating whether or not to write engine output to database, if the forecast numbers are not a lot different from the previous forecast numbers. E.g. if new forecast is 10010, while previous forecast was 10000, then you can mention a threshold so that engine would not try to write the new 10010 output to database.

For complete list of enhancements, refer to metalink's Demantra documentation library.

Bajaj Electrical success story - Oracle ERP, JDE, Demantra & Siebel

A video presentation on Oracle's yet another success story on a big bang implementation of Oracle ERP, JDE, Demantra and Siebel.

Updates: Oracle Rapid planning 1.0

Oracle's latest release in VCP suite, Oracle Rapid Planning(RP)'s version 1.0 can be installed only with VCP version 12.1.1

Rapid Planning, an addition to Value Chain Planning products suite

In May 2009, during Collaborate 2009 event Oracle provided a preview of it's new product "Rapid Planning" and they made a timely release of the product by announcing it's availability on 16th Nov 2009. Rapid planning will benefit customers with it's quicker, real-time, event driven planning and simulation abilities.

Extending the Information-Driven Value Chain

Leveraging its unique web services and open, standards-based architecture, Oracle Rapid Planning customers can enable reduced supply chain decision-making time with the following capabilities:

Fast, event-driven simultaneous material and capacity planning for rapid scenario analysis and real-time evaluation of supply chain events.

Fast sales and operations planning scenario simulation, integrated with Oracle’s Demantra.

Compatible and complementary capabilities to Oracle Advanced Supply Chain Planning.

Mass edit of supply chain data, enabling customers to conduct ad-hoc, rapid scenario modeling without the need to make changes to the ERP data or transactions.

Predictive and actionable insight via embedded analytics, a spreadsheet-style flexible user-interface, and embedded exceptions and scenario comparisons.

Comprehensive constraint modeling to mimic real-life planner decision making such as alternate bills of material, routings, sources and shipping methods, substitution and lead times.

Multi-enterprise visibility and planning, spanning internal facilities and contract manufacturers.

Multi-planner collaboration and simulation to help speed up the analysis and decision-making process.

Integration with ERP to help quickly translate decisions into actions and release planning recommendations directly to execution without latency.

For complete details about product read the complete release article on Oracle's site @ http://www.oracle.com/us/corporate/press/040402

Demantra 7.3 comes clean

Oracle's latest release 7.3 of Demantra Suite comes with an empty schema, unlike previous versions which had demo data. This surely would be a good news for those who have faced problems while cleaning up the demo data in older versions.

DB issue: Business modeler/Engine Admin cannt connect to database

Problem: When trying to open Demantra Business modeler on my local install, started getting error "ORA-01033 ORACLE initialization or shutdown in progress ". Also found that while connecting to Engine Administrator I started getting error "Cann't connect to database".

Analysis: Found that even while tnsping to database works, even SQLplus connection to database using Oralce SQLPLUS wouldn't work. It happens at times when the last DB shutdown didnt happen properly. Database needs to be re-started after shutting down explicitly by using SQL PLUS.

Solution:

Using command prompt,

Login as:
> sqlplus /nolog

Once logged in, use following commands:

SQL> connect / as sysdba
ConnectÚ.
SQL> shutdown abort
Instance ORACLE arrÛtÚe.
SQL> startup nomount
Instance ORACLE lancÚe.

While executing this, I got below error:

Database mounted.

ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],[], [], []

To further fix this issue, used following commands to re-start database:

SQL> startup mount
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size 1264916 bytes
Variable Size 264241900 bytes
Database Buffers 801112064 bytes
Redo Buffers 7122944 bytes
Database mounted.
SQL> recover database
Media recovery complete.
SQL> alter database open;

Database altered.

Verify that you are able to login into Database and then into Demantra applications. All set and we are back to action.