Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple.
Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips by upgrading to "Premium Membership".
Oracle Training

Thread Rating:
  • 4 Vote(s) - 4 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Interview Questions on Oracle Demantra with Answers

I would like to share Demantra Interview Questions, hope this helps.

1. Installation of the Demantra Base Application or Patches?

Create a C:/Tmp folder on the machine where the setup.exe will be executed prior to the installation as this will generate a log file to this folder

Note that there will also be some ancillary logs under the following folders:

Demand Planner\Database Objects\Oracle Server (Oracle back end database)

Demand Planner\Database Objects\Microsoft SQL Server (Sql Server back end database)

2. Issues with EBS Integration to Demantra?

In general, most EBS side activities (ex. Planning Data Pull) can be logged using Note 245974.1 however, the Shipment and Bookings Collection job can have extra logging turned on by changing MSD_DEM: Debug Mode to Yes (default is No).

Note that as the Shipment and Bookings Collection job moves to the other side of the wall from EBS side of the database to the Demantra side of the database (usually indicated by when you start seeing references to the Demantra schema or tables like t_src_items_tmpl or t_src_sales_tmpl_err) then the errors may need to be tracked using the Workflow or Active_Proc_Dyn troubleshooting sections of this note.

3. Stored Procedure Errors with Active_Proc_Dyn somewhere in the error message?

To view the errors go to Business Modeler –> Tools –> Procedure Error Log

Note that this looks to the backend table called db_exception_log

For more interview questions please checkout TekSlate

Thanks given by:
Thanks a lot for sharing this.
Thanks given by:

Possibly Related Threads...
Thread Author Replies Views Last Post
  HCM Cloud Consultant Interview Renee_Ora 0 737 08-19-2017, 01:51 AM
Last Post: Renee_Ora
  Oracle Order Management Functional Interview Questions and Answers Sadia Amjad 1 11,053 07-12-2016, 05:47 PM
Last Post: gsmy02
  Fusion/Cloud HCM Certification Questions admin 0 3,831 12-29-2015, 10:23 PM
Last Post: admin
  OBIEE Interview Questions Sadia Amjad 0 2,044 12-03-2014, 06:53 PM
Last Post: Sadia Amjad
  Oracle Inventory Functional Questions and Answers Sadia Amjad 0 2,202 12-03-2014, 06:23 AM
Last Post: Sadia Amjad
  Oracle HRMS Interview Questions - Part 3 fanni339 0 1,722 08-11-2014, 01:31 AM
Last Post: fanni339
  Q&A on Oracle EBS R12 oraebs1979 5 5,507 10-26-2013, 06:50 AM
Last Post: sash1494
  Oracle General Ledger Basic Questions & Answers Nari Yadav 0 2,470 09-10-2013, 06:40 PM
Last Post: Nari Yadav
  Oracle General Ledger Questions and Answers Usman 0 2,762 05-14-2013, 11:22 PM
Last Post: Usman
  Interview Questions - Oracle Payable admin 0 2,996 07-09-2012, 04:17 AM
Last Post: admin

Users browsing this thread: 1 Guest(s)
Get Premium Membership Get Oracle Tutorials, Tips! Post a Question!