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 OraERP.com 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:
  • 3 Vote(s) - 4 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Interview Questions on Oracle Demantra with Answers
#1
Hello,

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.
Reply
Thanks given by:
#2
Thanks a lot for sharing this.
Reply
Thanks given by:


Possibly Related Threads...
Thread Author Replies Views Last Post
  HCM Cloud Consultant Interview Renee_Ora 0 535 08-19-2017, 01:51 AM
Last Post: Renee_Ora
  Oracle Order Management Functional Interview Questions and Answers Sadia Amjad 1 9,869 07-12-2016, 05:47 PM
Last Post: gsmy02
  Fusion/Cloud HCM Certification Questions admin 0 3,457 12-29-2015, 10:23 PM
Last Post: admin
  OBIEE Interview Questions Sadia Amjad 0 1,940 12-03-2014, 06:53 PM
Last Post: Sadia Amjad
  Oracle Inventory Functional Questions and Answers Sadia Amjad 0 1,948 12-03-2014, 06:23 AM
Last Post: Sadia Amjad
  Oracle HRMS Interview Questions - Part 3 fanni339 0 1,643 08-11-2014, 01:31 AM
Last Post: fanni339
  Oracle General Ledger Basic Questions & Answers Nari Yadav 0 2,360 09-10-2013, 06:40 PM
Last Post: Nari Yadav
  Oracle General Ledger Questions and Answers Usman 0 2,660 05-14-2013, 11:22 PM
Last Post: Usman
  Interview Questions - Oracle Payable admin 0 2,883 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!