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



 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 ( which are full of information and knowledge.

6.      Your feedback on

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 ( )