Tuesday, January 12, 2010

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.

Friday, January 8, 2010

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.

Monday, January 4, 2010

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


Thursday, December 31, 2009

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

Monday, October 26, 2009

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.

Wednesday, September 30, 2009

Demand Management Process & Demantra’s Solution

Sensing Demand

Demand data should be collected from various possible sources and which can be treated as “BIBLE” for basing your forecast on. Not only actual sales data but other attributes of sales data like promotional causals, holidays, events etc. should be brought in, which justify the variations in demand data. E.g. Sales data collected from various Retailers’ store varies with days on which store is open, promotions which were launched at the store and competition activities near store’s location. So while predicting sales at these stores we should consider all these factors as well.

Demantra implementation offer real-time Demand sensing capabilities, collect demand data and information from various sources like sales orders, shipments, POS data, distribution center data, customer data and marketing data. Demand can be collected inside Demantra on daily or weekly basis as per the requirements.

Shaping Demand

There are items & locations for which sometime sales data is not available, in that case Demand Planners based on their instincts & experience should be able to enter or edit the sales history. Not only history of sales but forecast numbers generated by engine is likely to be edited to consider inputs which have not been captured by the Analytical Engine.


Oracle Demantra Demand Management provides user ability to define override series for each of collected series and also for forecast series. Demantra provides flexibility to create unlimited number of Causal Factors to capture the information which can describe the demand variance and events which occurred. Causal Factors are created and used to ensure that impacts of these factors are taken into consideration by Engine to generate the Forecast numbers.


Collaboration

For any organization the problem of keeping all the stakeholders who represent various verticals like Manufacturing, Marketing, Sales, Retailers, etc. is very common. Today most of the firms are into global markets and have operations and sales happening in various corners of world. Also to become a demand driven supply chain network, the need of having collaboration with all the demand nodes (e.g., customer’s stores) and supply nodes (e.g., raw material supplier’s factory) becomes vital for most of the industries.

The Demantra application provides an easy to use tool for collaborating with all the stake holders using a web based platform. Users can easily collaborate with their internal stakeholders & customers to better predict their forecast. Also all the stakeholders can be informed and kept in loop to reach to final Consensus Forecast number.


Alerts, Exceptions & Notifications

In most of industrial scenarios it becomes difficult to analyze and to figure out the issues like Demand plan crossing the budget limits, import data failures etc. Thus the automated notifications can assist the planners and managers to take up remedy actions. Alerts can be created within Demantra for notifying stakeholders and concerned group of users on Real-time basis. Automated workflows keep all the users notified and updated if there are any exceptions meeting defined conditions.

Saturday, September 5, 2009

Value Chain Planning R12.1.1

Oracle released following new set of advanced planning applications under "Value Chain Planning" category in R12.1.1 :

- Oracle Manufacturing Operations Center (MOC)
- Oracle Demand Signal Repository (DSR)
- Oracle Service Parts Planning (SPP)
- Oracle Advanced Planning Command Center (APCC)

Demantra has it's own set of role to play in above applications, where it is directly integrated with DSR, SPP and APCC. SPP has it's own inbuild Demantra engine for spare parts forecasting too, while APCC and DSR have an outbound integration from Demantra for forecast and other information.



Perspectives on Managing through Difficult Times