Oracle Supply Chain Planning and Business Intelligence Products - A blog dedicated to Oracle's Fusion/On Prem VCP and BI offering.
Sunday, January 18, 2015
Saturday, November 8, 2014
Demantra: Logs to look for while debugging
- Demantra installation log: Installer's first screen has option to enable logging at various level to capture installation activity.
- Collaborator.log: This log captures any error during server start, shutdown, restart, etc. The log is available under the web server directory.
- Systemlog: Captures various issues around logs encountered by end user on worksheets, while running methods, etc. LoggerManager utility available through URL can be used to configure logging level and setup.
- IntegrationLog: Captures various logs around data integration runs done via Demantra's inbuild integration interface tool.
- DBExecptionLog: DB_EXCEPTION_LOG table captures logs generated by some of the Demantra's procedures. (ep_load_xxx, chaining etc.)
- EngineLog: EngineManagerLog & Engine2Klog files carry details of engine run activity, logging level can be controlled for engine logs too.
- WFProcessLog: Captures workflow run related logs and is accessible through URL too.
Thursday, September 20, 2012
New "Guided Resolution" for Demantra
They have started with five topics:
- Data loading related issues (Note Id 1461899.1)
- Data loading issues not related to error codes (Note Id 1468884.1)
- Workflow related issues (Note Id 1353217.l)
- Worksheet related issues (Note Id 1486639.1)
- Engine related issues (Note Id 1486634.1)
How to Use the Demantra Guided Resolution, a Proactive Services Tutorial. Note 1473992.1
Sunday, July 8, 2012
Demantra: Engine Status Check
Checking status of Engine:
To determine if engine is running or not, one can use the work_status parameter in init_params_0 table. Value_float column indicates if the current or the last engine run was in batch mode or simulation mode.
- 99 => Simulation Run
- 1=> Batch Run
Value_date reflects the current state of engine. If the value_date changes every 22 sec then it would mean that Engine is running currently.
As Engine can only run in one mode at a time, it helps to be aware of the current state of engine prior to launching engine run.
Wednesday, November 17, 2010
Demantra 7.3: Engine split based on series
Demantra 7.3 has come up with quite few features which customers have been wishing to see. One of these is ability to split statistical forecast which generated at aggregated level to split down to lowest level based on user defined/controlled proportions. Prior to 7.3 this split was always based on historical proportions and there was no workaround for it. These historical proportions were calculated based on every product and location combinations historical monthly sales averages using proport procedure. Split by series option allows user to pick a series which dictates weights for dis-aggregation of baseline forecast.
How we USE it?
1. Define a new series with server expression, the server expression gets used in weight calculation.
2. Using Business modeler setup parameter: ENGINE > PROPORT tab > parameter name "ProportionSeries" shall be populated with the internal name of the above series.
3. Select combinations/population to use SPLIT MECHANISM by using series "Engine Proportion Method" in a worksheet. The series has two dropdown values, Matrix Based Proportions which is the default and Series Based Proportions which is the value required for series based split.
Wednesday, February 10, 2010
Exploring Demantra's BPM capabilities
Monday, October 26, 2009
DB issue: Business modeler/Engine Admin cannt connect to database
> 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.
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.
Friday, June 12, 2009
S&OP Process - Post1 - New Product Planning process
Picture: Product Launch Flow *** Tuesday, June 9, 2009
How to extend Calendar to 2030 in Demantra
Wednesday, June 3, 2009
Notes from Today's Webcast on "The Key to Optimizing Demantra Worksheet Performance"
Wednesday, May 27, 2009
Upcoming Demantra Webcast from Oracle
Advisor Webcasts offer a convenient way for you to interact with professional, technical, and application experts regarding topics such as troubleshooting tips, best practices, new release information and more.
Webcast: The Key to Optimizing Demantra Worksheet Performance
- Topics will include:
- Java Plugin Settings
- Creating Worksheets in the optimal manner
- Backend Database Checks
- Application Server Settings
- Other options when your worksheet performance doesn't meet your needs
A short, live demonstration and question and answer period will be included. "
You can register for this webcast from the link provided in the metalink note. (Id provided at the beginning of this post).
Tuesday, December 9, 2008
Demantra: Analytical Engine - A deeper look - Part1
What is Forecasting
Forecasting empowers one to predict the futuristic tendencies of supply chain, influenced by seasonal and other predictable factors. The result of forecast is a projected curve that has been smoothed to show tendencies and de-emphasize the exceptional variations.
Demantra engine is capable of multidimensional forecasting with mixed modeling techniques. It has been designed to be robust enough for handling large scale installations. It is capable of modeling hundreds of thousands of data sets with various data patterns.
Modeling is performed according to forecast tree, in which each node in the tree is defined by an item-location combination in the Enterprise Data model. Engine tries to generate forecast at lowest level of item-location combination, but in situations where due of data insufficiency's , it is unable to generate a good forecast, then it traverses the Forecast tree to higher level for generation of forecast at an aggregated level. Forecast generated at higher level is split down to lowest level, using a splitting mechanism called “proport”.
Batch verses Simulation
Engine can be executed in two modes, Batch or Simulation.
Batch Run:
Traverses a large forecast tress, described in database. Each node in tress represents a time based data series that is subjected to forecast.
Performs model calculation on a large subset of data series (each node of forecast tree)
Writes the processed data series to a new forecast table in database.
Executes a post-process procedure which updates new forecast table
Simulation Run:
Same steps as above are performed but on a selective subset of data, as chosen by user for “what-if” kind of simulation run.
Engine Components
Engine consists to two components, Engine manager and Engine server. There is one instance of Engine manager and one or more instances of engine server. The engine server scans a portion of the forecast tree according to the traversal rules, and sends the output to the split mechanism.
The engine server receives IDs of tasks from Engine manager, which divides the forecast tree into sub-trees (tasks). The engine manager is responsible for the engine run as a whole.Based on Engine settings done via Engine Administrator application, Engine managers tries to initiate an engine server on list of machines on network having engine registered and server component installed.
Reference “Details of Engine Manager & Server”. (source: Oracle Demantra Engine Guide v.5.2.6)
Causal Factors
Factors which cause the deviation from a trend, are known as Causal Factors. E.g. a sales promotion, due of it’s result you expect sales to rise. On the other hand, a sales promotion by your competitor can impact your sales negatively, which also becomes a causal factor.
Causal factors such as promotions, marketing campaigns and production stoppages are essential components when analyzing demand pattern.
Global Causal Factors effect all the nodes of forecast tree, seasonal CFs are normally global.
Local CFs can be different for each item-location combination.
Event is another word for CF, it can be loaded easily with Code, value and intensity information. Event information is not necessarily required to be loaded in future.
............to be continued.
Monday, November 3, 2008
How to: "Create a Data Series"
Tuesday, October 21, 2008
Demantra: How to "Create a new Worksheet"
In this post you can see how to create a simple new worksheet.
Download and study the "Demand Management User Guide" , for more details on Worksheet application.
Document is avaialble @ http://download.oracle.com/docs/cd/E11051_02/demantra/acrobat/ddmug.pdf
Monday, October 20, 2008
How to : "Launch Worksheet application"
Friday, October 17, 2008
How To: "Personalize Collaborator Workbench"
You can easily select & manage the panes, change their order of arrangement, select relevant KPI dashboards, member browser content panes, etc. This all can be done by simply using the "Personalize" option available on top-right corner of Collaborator workbench. You will see all the available contents and one can choose based on their usage and need, which contents should be shown on their personal collaborator workbench. One can also move the contents up and down, e.g. you can have "My Tasks" pane on the top and can push the "My Worksheets" pane down.
Personalize "My Worksheets" pane:
It starts with selecting most common and most used worksheets under pane "My Worksheets", by clicking on "Personalize" button on up right corner of pane "My Worksheets". You shall see all the relevant worksheets in and then you can pick ones you want to be shown in the workbench.
Manage "My Tasks" pane:
"My Tasks" pane is like your mail box for Demantra environment, you will get tasks/notifications/alerts/attachments as list items under your content pane "My Tasks". One should ensure completed tasks are removed from the list, so that list of tasks doesn't grow like anything.
Note:
1. Remember that you should not keep lot of Dashboards on your workbench as it can significantly increase the loading time.
2. Treat your collaborator workbench as your office desk, and try to keep only important items on it. Keep it simple and clean to improve your efficiency.
For more details on Collaborator Workbench, read "Demantra Collaborator Workbench User's Guide 7.0.2 " @ http://download.oracle.com/docs/cd/E11885_01/demantra/html/docset.html
Thursday, October 16, 2008
How To: Login into Demantra application
Demantra installer adds a folder with name like "Oracle Demantra Spectrum" under "Start>>Program Files" menu option. (Remember: This startup program option is created only if during installation you have selected the corresponding option)
How To: install Demantra application?
For basic demo environment setup, single tier architecture suits which comprises of having Oracle Database, Demantra application server and Analytical engine, all in one machine.
Demantra installation can be very easily done using the Demantra installer file. But before you start ensure, that you have Oracle DB installed up and running. Also one should keep handy details like Oracle SID, Database system user login, etc. More details on installation can be gathered from following links:
A blog on Oracle Demantra 7.2 installation:
http://applicationsdba.blogspot.com/2008/01/r12-demantra-integration-part-ii.html
Previously published blog on Demantra installation 7.1.1:
http://oracledemantra.blogspot.com/2007/10/installing-demantra-711-on-windows.html
My Oracle Support(Metalink): Oracle Demantra Installation for Release 7.1.1http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=428495.1
My Oracle Support(Metalink): EBS-Demantra Integration Installation Overview and Diagramhttp://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=434991.1
Post installation activities:
1. Set up Environment variable "JAVA_HOME"
2. Launch and verify tomcat(web server) runs fine
3. Launch and test Collaborator workbench application
4. Launch and validate that desktop based application are working fine. (like Business modeler, Demand planner, Engine Administrator etc.)
Wednesday, October 15, 2008
How to: get hold of Demantra documentation ? |
1. Online documentation for Oracle Demantra available at:
"http://download.oracle.com/docs/cd/E11885_01/demantra/html/homeset.html".
2. My Oracle Support (previously known as Metalink):
If you have Metalink login access, then you can search and find all the available documentations released by Oracle.
https://metalink.oracle.com/
3. Oracle Demantra installed folder:
Few basic documents are available when you install Demantra application. These can be found under the installed folder "Oracle Demantra Spectrum".
Demantra: "How to" Series
We will be starting a "How to" series, for Demantra which will bring answers to various setup and configuration related queries on Demantra. We will start with basics and then move on to more complex world of Demantra product. In case you have any specific question, then put in comments and we would be glad to include that question in this series.


