OCP Advisor – Mohan Dutt


Mohan Dutt, a.k.a. OCP Advisor


Oracle 11i, Oracle R12, Project Management


Oracle, Hyperion, PwC and a few others


Email: ocp.advisor@gmail.comhttp://ebizocp.blogspot.com  


Site : www.mohandutt.com

1.      Tell something about you, your professional experience/ background, past assignment, Interests.

Ans: Started my professional career in exports for a global electrical power equipment manufacturer. Those were exciting times when software companies like Oracle were launching an integrated application to address all the operations of a global company. I joined the consulting practice of Pricewaterhouse Coopers. PwC was perhaps the Oracle consulting organization at that time. Later I joined an Oracle Advantage Partner. About four years ago, I joined Hyperion and today I am part of the Oracle ecosystem.

2.      Please share any of your Oracle work related professional /project experience.

Ans:  For more than a decade, I have implemented, upgraded, migrated, managed and supported various releases of Oracle E-Business Suite from 10.7 to 12. I was fortunate to work in global implementations on a single global instance for multiple projects. Oracle Release 12 addresses many of the requirements that I came across the projects over the years and would highly recommend to any organization planning to scale their operations globally without worrying about their enterprise application scalability.

3.      What would be your recommendation for Oracle Applications/ Financials professional in regard to available certification paths? Also what are pre-requisite for any of 11i or R12 Certification

Ans: There are several certification options for the Oracle E-Business Suite professionals. Oracle offers Oracle Certified Expert track and Oracle Certified Professional tracks. Based on an individual’s work experience and expertise, one can choose their certification roadmap. The certification exams ask real-life case study based questions and hence an expert knowledge level for the application module (e.g. General Ledger, Payables, Receivables etc) is required.  Certification is the recognition of one’s superior skill and expertise. Hence, I encourage individuals to get certified through this globally recognized credential. Certification opens new doors and also provides an implicit assurance to your clients or users of your professional ability.

4.      Please advise how an individual interested in Oracle Applications related certification, i.e. Payables, how she/he should go for it i.e study material, duration, practice etc

Ans: As mentioned in my previous answer, it is assumed that the individual has working knowledge and exposure to the application. Oracle University provides instructor led training (ILT) classes for each of the modules. Attending an ILT class would help one get a very good idea about the exam content since the exams are based on the courses. In case one is already an expert implementer or power user, only a quick revision of the exam content topics is necessary. For this profile of candidates, I have recommended reviewing the Oracle Tutor documents. Oracle Tutor documents are available as patch downloads on Metalink. Both the ILT student guides and Oracle Tutor documents have practice exercises that reinforce the module concepts. In case one is not confident about a specific exam topic I would suggest a review of the Oracle user guide and implementation guide for the module. Lastly, I would recommend the #1 habit for highly successful OCP individuals – read the EBS OCP blog as often as you can! There are practice questions that one can answer and evaluate one’s exam preparedness.

5.      You have received lots of recognition and accolades; please share some information about those.

Ans: I have been working closely with the Oracle Applications community for a decade now. I have participated in many roles at the Oracle Application User Group (OAUG) over the years. It was a pleasant surprise to be recognized in 2007 as the Member of the Year for my contributions. Today, I continue to participate in various forums and engage in conversation (offline and online) with Oracle professionals from all around the world. I hope to continue my self-described role as an Oracle Applications Evangelist in the future too.

6.      Need your view on terms Functional, Technical and Techno-Functional. How you think these have relevance. Do techno-functional professional real advantageous or it is kind of overlapping.

Ans: An individual’s education background typically determines their intial role – functional or technical. For example, with an accounting background one would probably start as an end user or implementer in a functional role. As one adds experience across projects and over the years, an individual becomes more techno-functional with the relative percentages depending on their interest and expertise. To be a solution expert as an implementor or any super user, one has to pick up both functional as well as technical knowledge. So I feel for further career advancement, one should pick up both the skills. In a senior position, one is assumed to have both the skill sets to architect any solution.

7.      Your advice/ Suggestion for Oracle Technical and Functional Professions

Ans: We are fortunate to be working on Oracle technologies, which are always the leading edge, and with a complete roadmap for any enterprise and business. This is also a time for introduction of new platforms and tools. As a professional in the Oracle space, focus on upgrading your skills to the latest releases and tools. Once you have gained expertise, have a plan for certification because that also serves as a measurable goal for your personal growth.

8.      Your feedback on Knoworacle.wordpress.com

Ans: Knoworacle.wordpress.com is an excellent blog that explains Oracle application concepts in a very lucid and interesting manner. Subscribe to the blog and read the posts everyday. We are very lucky to have blogs like knoworacle teaching us the finer points of the application. Learning never stops till you knoworacle.

9.      Please any additional questions/ thoughts from your sides

Ans: Thank you very much for the opportunity to speak to your blog readers. Once again, I encourage all Oracle certification aspirants to visit the #1 ranked (on Google search) blog on certification topics. Best of Luck from your OCP Advisor!

Disclaimer:  Opinions expressed by the OCP Advisor is entirely his own and do not reflect the position of Oracle or any other corporation. Any advice or recommendations discussed are not validated by Oracle.

Thanks – Shivmohan Purohit ( knoworacle.wordpress.com )    

Oracle Expert – Mandeep Dhami

Hello Friedns, as in continuation to involve Subject Matter Experts to improve and get to knowledge, here today we showcasing Mr Mandeep Dhami, An Oracle Application experts in his area. I encourage you all to ask ur query/ question to him.


Mandeep Dhami


Module: Payables, Assets, Internet Expense and GL


Current: Merrill Lynch

Past: J.P. Morgan Chase


Email: mandeepdhami4u@hotmail.com

 1.      Tell something about you, your professional experience/ background, past assignment, Interests.

Ans: I have just got into the world of Oracle Professionals, working as Functional Consultant on Payable, Assets, Internet Expense and GL modules. So far I have been involved in implementing the above modules of Oracle across various locations in Asia Pacific region. I have been involved from operations side giving requirements to the deployment team, who then sets up the system and then I get involved in doing System Integration Testing (SIT). Once SIT is successfully done we get the same testing done by end users as part of Users Acceptance Testing (UAT). This also involves giving training and preparing training material for the end users.

2.      If any professional want to become functional consultant (either in manufacturing or financials), how she/he should take it and go ahead?

Ans: It will be too early for me to comment on this as I am quit novice in this role. But whatever I have experienced so far I can say that the functional consultant should have good knowledge about the working of various modules from end users perspective.

3.      Give some commonly used Functional Concepts/ Questions in Oracle Applications’ Financials Modules.

Ans:  What accounting entries are generated when an invoice is entered and paid?

What’s the difference between cross validation rule and security rule?

4.      What is your favorite Oracle Applications modules, share some of your interesting professional work experience.

Ans: My favorite module is Payables. In terms of interesting experience I can recollect one when implementing oracle payables for one of the locations where they were giving cash advance to employee. This was also a new learning for me. I got the solution for the same after consultation with my colleagues from the team. The real problem was to sale this solution to the location as first of all this application was new for them and this functionality was to be used by them only in the region. It took couple of training sessions with detailed flow chart and training material to get them agree to the solution suggested.

5.      Your advice/ Suggestion for Oracle Technical and Functional Professions

Ans: I would say that the professional should have good knowledge about the modules they are working on and should always strive to be up to date with latest happenings on their areas of work. I would also suggest visiting such blog (http://knoworacle.wordpress.com/) which are full of information and knowledge.

6.      Your feedback on Knoworacle.wordpress.com

Ans: Very good initiative by you to share knowledge on Oracle. There are various articles on different modules of Oracle and all these is from your own practical experience which makes this initiative all that more special, important and accurate.

Thanks – Shivmohan Purohit ( knoworacle.wordpress.com )