If you're looking for Oracle Demantra Interview Questions for Experienced or Freshers, you are at right place. There are lot of opportunities from many reputed companies in the world. According to research Oracle Demantra has a market share of about 0.8%. So, You still have opportunity to move ahead in your career in Oracle Demantra Advanced Forecasting. Mindmajix offers Advanced Oracle Demantra Interview Questions 2019 that helps you in cracking your interview & acquire dream career as Oracle Demantra Consultant.
Q1) What is Oracle Demantra?
Oracle Demantra is an Oracle tool for demand management and supply chain management. Automated forecast process is enabled, which simultaneously maps demands forecasting against various factors like customer commitments, inventory counts and supply restrictions. Implementation of Oracle Demantra has numerous benefits like higher service levels, lower inventory costs, greater customer satisfaction and lower distribution costs.
Q2) Few benefits of Demantra Implementation?
Demantra implementations results in:
- Higher service levels
- High customer satisfaction
- Cheaper inventory costs
- Lower distribution costs
Q3) List out some of the Demantra Applications.
- Predictive Trade Planning
- Demand Management
- Trade Promotion Optimization
- Deduction and Settlement Management
- Advanced Forecasting & Demand Modeling
Q4) What is the procedure to install the Demantra Base Application or Patches?
Create a directory called C:/Temp in machine. In this location only, setup.exe will be implemented for Demantra Base Application. It will be executed prior to the generation of installation and log file in this directory.
Moreover, there will also be some additional log files under the following directories:
- Oracle back end database log files : Demand PlanneràDatabase ObjectsàOracle Server
- SQL Server back end database log files.Demand PlanneràDatabase ObjectsàMicrosoft SQL Server
Q5) Tell the three modules that can be implemented separately.
- Demand Management
- Advance Forecasting and Demand Modeling(AFDM)
- Real-Time Sales and Operations Planning
Q6) Things to consider while upgrading to 12.2.2 for better and faster output.
To minimize the upgrade time, we can force parallelism using a logon trigger on the server. There is a script in upgrade process, which contains a new set of indexes, one per engine profile and on each profile quantity_form expression. Make sure to disable or drop that trigger once the upgrade has completed.
Q7) Trigger structure used to force parallelism?
Below is the trigger used and tested successfully.
CREATE OR REPLACE TRIGGER force_parallel_ddl_trg
AFTER LOGON ON database
IF (USER='DEMANTRA') THEN
EXECUTE IMMEDIATE 'ALTER SESSION FORCE PARALLEL DDL';
Q8) What will you do if you face any issues starting the web server or Demantra WAR file?
We need to revisit and explore the Collaborator.log file in case of any issues. This log file is located at Collaboratordemantralogs folder in the Demantra webserver. Moreover, every individual webserver will possess logs in different directories. These logs can also help us to dig further. These log locations will be specified in the respective webserver documentation.
Q9) What actions can be taken if we are facing any issues with the Demantra Batch or Simulation Engine?
If any issues with Demantra Batch or Simulation Engine, we should review Key engine logs. These logs are present in the root driver of machine where engine is started. The folder’s name, which is holding these logs, usually has Engine2K in it.
Q10) What is data load or data collect process? Where can we run them?
Data load process is the process of populating Demantra staging properly (through SQL loader or through Collection process in case of integrated EBS-Demantra instance). Once staging tables are populated, we can run EP_LOAD_MAIN procedure in two ways.
2) Workflow for downloading data to Demantra base table.
Demantra admin user can be “dm/dm” or “sop/sop” based on the module installed.
Q11) Where can we see the stored procedure errors with Active_Proc_Dyn in the error message
Navigation for this specific error is as follows.
Subscribe to our youtube channel to get new updates..!
Business Modeler è Tools è Procedure Error Log
This log is stored in backend table - db_exception_log.
Q12) Describe any issues faced while integrating Demantra with EBS
Shipment and bookings collection job moves from EBS database to demantra database. This generally can have extra logs available by turning on the profile MSD_DEM: Debug Mode to Yes (default is No). You will start finding references to Demantra schemas or tables like t_src_sales_tmpl_err, t_src_items_tmpl etc. Errors can be tracked using Active_Proc_Dyn or through workflow.
Q13) If RVWR cannot write to disk, what can be state of database?
If RVWR write operation fails, database state depends on the conditions of write error occurrence.
1. In case of a Guaranteed Restore Point – to guard the restore point guarantee violation, database crashes itself.
2. In case of a Guaranteed Restore Point and a main database – Database will continue to operate normally but the Flashback Mode will be set off automatically for it.
3. In case of a Guaranteed Restore Point and a standby database – Until the resolution of write failure comes, database will hang itself.
Q14) Can we state the size of the Flashback Buffer in the SGA?
Yes, it can be done but indirectly.
The size of the Flashback Buffer = 2 * LOG_BUFFER.
Due to performance reasons, LOG_BUFFER should be set to minimum 8MB for databases running in Flashback mode.
Q15) Can we back up the flashback logs using RMAN?
No. Flashback Logs are temporary log files, which are not backed up using RMAN.
Q16) What is the lifetime of flashback logs?
Flashback logs are kept until DB_FLASHBACK_RETENTION_TARGET parameter is satisfied. In case of any space issue, they may be deleted to create space for other logs or backup.
Q17) Specify the command used to describe restore points in RMAN?
LIST RESTORE POINT [ALL|restore_point_name]
Q7) How can we see the developments of a FLASHBACK DATABASE operation?
By querying V$SESSION_LONGOPS from another session, we can see the developments of the flashback.
Q18) Steps to improve Flashback performance for any database?
1. It is recommended to employ a fast file system for flash recovery area like ASM.
2. Adequate disk spindles should be configured to support the disk throughput and to write the flashback logs successfully.
3. If the storage system holding flashback logs is having a non-volatile RAM, we should configure file system on top of striped storage volumes. This can improve performance as flashback logs will grow across multiple spindles.
4. For any large and production databases, we should set parameter LOG_BUFFER to be minimum of 8MB. This can assure maximum memory allocation for writing flashback database logs.
Q19) What privilege has been given in Oracle database as part of Demantra installation?
As part of Demantra installation process, following privilege is set up in Oracle database, which is required while setting up JD Edwards EnterpriseOne Integration.
GRANT CREATE ANY DIRECTORY TO demantrauser1;
If one doesn’t want to use JD Edwards integration, this privilege can be revoked using REVOKE command.
Q20) What are the three modules in Oracle Demantra that can be processed in a separate manner?
Three modules can be processed separately in Oracle Demantra. They are Real-Time Sales and Operations planning, demand modeling and advanced forecasting and demand management.
Q21) Illustrate the process of installing the base file of Demantra in patches
To install the base file of Demantra in pieces you first need to create a TMP folder on the C drive. You can opt to create a file on the machine where the setup file would be executed. It is so because it would generate a log file in this folder. Moreover, you should also note that some additional logs would also be present in various folders. For instance, the Oracle back-end database would comprise of database objects and demand planner. The SQL, back end database, comprises of demand objects as well as demand planner.
Q22) What is the place where you can run data collection processor data load?
The Demantra staging table can be adequately populated by using a SQL Loader. However, one has to be careful in handling an integrated EBS Demantra case. Moreover, the workflow that comes from the main table has to be in sync with the Demantra base table. In this context, it is interesting to note that the Demantra admin user can be in the form of dm/dm.
Q23) How can you start the errors related to start procedure in case of a message crops up with a mistake?
If you want to view the errors in the source file, you can opt for opening the Business Modeler and then you can begin tools. From tools, you can open the procedure error log, and from there you can view the errors related to the errors in the source file.
Q24) Illustrate the situation when RVWR cannot imprint data on the disk
It is important to note that this position depends on the case where there is an occurrence of the write error. For instance, as an operator, you must note that if there is the presence of guaranteed restore point, the database can crash to ensure that the guarantee related to restoring position is not voided. On the other hand, if there is not a guaranteed restore point and moreover it is a primary database, the mode related to flashback would automatically turn off. It would continue to be in operation in a normal manner. Additionally, there can also be a situation where there is a complete absence of guaranteed restore point, and it is a standby database, this database would create hanging problems and can be solved only when the disk writing problem can be solved.
Q25) Can you use RMAN to facilitate backup to the flashback logs?
The answer is no in the context of creating a backup to the flashback logs. The flashback logs are not backed up in any case. Moreover, you should note that even if the backup area of recovery is used to backup the contents related to FRA contents, various file types are usually backed up. The incremental and full back upsets and data file copies are some files that are typically backed up by the Demantra server. On the other hand, the log files related to flashback are always considered to be files which are ever changing in nature. They cannot be backed up RMAN. Moreover, media recovery is not needed in case of these data.
Q26) How can you set the ever-changing database to improve performance related to flashback performance?
You can improve the performance of the flashback file by the usage of a fast file system. You can also speed up the production of the data by avoiding the usage of a fast file system. It also prevents operating file system caching such as ASM. One can also configure the disk spindles for the file system that would assemble the area of flash recovery.
For the production of large-sized databases, you may require multiple disk sizes so that you can support the enormous file. Moreover, this large file size can also be used to imprint the flashback logs effectively. On the other hand, to facilitate the production of large databases, you can set the parameter to buffer so that it can stay within the permissible size.
On the other hand, if you have used storage system to hold the flash recovery that does not comprise of a non-volatile RAM, you can opt for using a RAM that can be tripped in case the file size exceeds. Moreover, this trip RAM would also allow you to make sure that the flashback logs are spread across multiple ranges of data and thereby improving its performance across various platforms.
Q27) How can you associate the various types of errors with the simulation engine or Demantra Batch?
In most of the situations, the important engine logs are usually located on the root drive. The folder that comprises of these woods typically have various types of error sources somewhere in the folder location. However, one should always pay close attention to the fact that there can be at least Engine 2K logs. On the other hand, if you want to write the master Engine Manager Logs one always need to opt for the Engine Administrator, and you can also change the engine manager tab from STD to FILE. One should still note that it is not advisable to re-register the engine after facilitating this alteration.
Q28) What are the issues that are related with an integration of EBS along with that of Demantra?
It is important to note that a majority of the EBS activities can be logged in by using a specific note. However, the bookings and shipment collection tasks can have extra logging that is always turned on by altering MSD_DEM and debug mode to yes. The reservations and shipment collection assignment can continuously transform into the other side of the wall from the bottom of the EBS to the Oracle Demantra side of the database. Moreover, the errors may also need to be tracked by utilizing the workflow and the troubleshooting sections of the note.
Q29) Illustrate the situation when the flashback logs are deleted
It is important to note that flashback logs are managed by the organization of Oracle. Moreover, Oracle would try to keep various Flashback logs as needed to satiate the parameter. However, if there is the presence of pressure in the Flash Recovery Area (FRA), the records related to flashback may be deleted to accommodate room for other specialized functions like archived logs and backups.
On the other hand, for instance, if the area related to fast recovery has enough space, then a log pertaining to flashback is created so that it can satiate the retention target of flashback. On the other hand, if the log files related to flashback are old enough, it is no longer needed to satisfy the retention target of flashback.
Moreover, in this case, it is worthy to note that the log file related to flashback is reused. In this context, it is also vital to mention that if the area pertaining to the fast recovery is populated, then an archived redo log may be automatically deleted by using the rapid recovery area. In this manner, the flashback log files can be quickly eliminated without removing the original data.
Moreover, you should also note that no file in the area related to the fast recovery is eligible for deletion in case if you are needed to satiate a restore point in Oracle Demantra. In other words, the backup retention policy can also cause the fast recovery area so that it can fill the space completely.
Q30) How can you list the restore points in RMAN?
It is important to note that in RMAN, you can always use the list restore point command. On the other hand, if you are opting for a recovery catalog, you can use the view RC command to make sure that you can witness all the restore points at the same place in a given point of time. This would also reduce the instances of mistakes in the target database.
Q31) How can you witness the progress of a database operation related to flashback?
You can always opt for witnessing the progress of a flashback database. During the operation of the database related to flashback, you can run various query commands from another session to observe the development of the flashback. Quite interestingly, the database associated to flashback has two different phases in the form of the actual flashback and the recovery related to various types of media. It usually happens afterward to bring the database to a state which is consistent. You would see the following message in the actual flashback session which would give you a bright idea about the progress of the operation related to the database. Moreover, this letter would also depict the amount of free RAM which is available at the time of the service.
Q32) How is the creation of new indexes of data related to sales time-consuming?
As a part of the upgrade, there exists a script building on a new set of indexes. It is assigned to an engine profile and on each profile quantity. Quite interestingly, the creation of an index from a big data table can take an extended amount of time. However, always remember to drop or disable that trigger when the upgrade has been completed.
It is usually done in order to facilitate a more robust demand forecasting feature in the system. It is also vital to note that as Demantra is mostly used for supply chain management. Hence, the creation of indexes in a shorter amount of time enables Demantra to bring more forecasts into your sales team so that you can have a clear picture about the demands of your customer in the near future.
On the other hand, the creation of new indexes would also help you to make sure that you can disable or drop that trigger when the upgrade or update has been completed. In this manner, you would always make sure that you can clearly judge the demands of your target audiences which would further boost your product development.
Q33) Shed light on the error associated with web server with deploying the Demantra file on the server
You can opt for reviewing the collaborator log file that is usually situated in the Demantra and collaborator folder. You can also locate it on the web server on which Oracle Demantra is running. You can also opt for checking each web server that would even have their logs in several directories. These can also be taken into due consideration to ensure that the process of command running is free from any underlying errors.