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 )    

Data flow for Order-to-Cash cycle

Data flow for Order-to-Cash cycle  

Hello friends, here we are having one of the contribution from “Devendra Gulve” , very precise and useful explaination on O2C cycle. hope this be helpful to you.

For more details please visit http://functionalguy.blogspot.com


1. Order Entry 
This is first stage, When the order is entered in the system, it creates a record in order headers and Order Lines table.

  • Enter header details: Once you enter details on the order header and save it or move it to lines, record goes to one table oe_order_headers_all
    • No record exists in any other table for this order till now.
  • Enter Line details for this order: Enter different item numbers, quantity and other details in line tab. When the record gets saved, it goes to one table. Order header details will be linked with line details by order HEADER_ID.

2. Order Booking 
This is next stage, when Order is booked then the Flow status changed from Entered to Booked. At this stage, these below table get affected.

  • oe_order_headers_alL
  • oe_order_lines_all
  • wsh_delivery_details
  • wsh_delivery_assignments

*In shipping transaction form order status remains “Ready to Release”.

At the same time, Demand interface program runs in background and insert into inventory tables mtl_demand.

3. Reservation 
This step is required for doing reservations SCHEDULE ORDER PROGRAM runs in the background and quantities are reserved. Once this program get successfully get completed, the mtl_demand and mtl_reservations table get updated.

4. Pick Release 
Pick Release is the process of putting reservation on on-hand quantity available in the inventory and pick them for particular sales order.

Pick release can be done from ‘Release Sales Order’ form or ‘Pick release SRS’ program can be scheduled in background. In both of these cases all lines of the order gets pick released depending on the Picking rule used. If specific line/s needs to be pick release it can be done from ‘Shipping Transaction form. For this case Pick Release is done from ‘Release Sales Order’ form with Pick Confirm=NO. 
Once pick release is done these are the tables get affected:

  • If step 3 is not done then MTL_RESERVATIONS gets updated now.
  • wsh_new_deliveries
  • wsh_delivery_assignments
  • wsh_delivery_details
  • Mtl_material_transactions_temp

*In shipping transaction form order status remains “Released to Warehouse” and all the material still remains in source sub-inventory. We need to do Move Order Transaction for this order. Till this no material transaction has been posted to MTL_MATERIAL_TRANSACTIONS

5. Pick Confirm/ Move Order Transaction

Items are transferred from source sub-inventory to staging Sub-inventory. Here material transaction occurs.

Order line status becomes ‘Picked’ on Sales Order and ‘Staged/Pick Confirmed’ on Shipping Transaction Form.

  • oe_order_lines_all
  • mtl_transaction_accounts
  • wsh_delivery_details
  • wsh_delivery_assignments

* This step can be eliminated if we set Pick Confirm=YES at the time of Pick Release 

6. Ship Confirm 
Here ship confirm interface program runs in background. Data removed from wsh_new_deliveries. 

The items on the delivery gets shipped to customer at this stage.

  • oe_order_lines_all
  • wsh_delivery_details
  • mtl_transaction_interface
  • mtl_material_TRANSACTIONS
  • mtl_transaction_accounts
  • mtl_demand, MTL_reservations

7. Enter Invoice 

After shipping the order the order lines gets eligible to get transferred to RA_INTERFACE_LINES_ALL. Workflow background engine picks those records and post it to RA_INTERFACE_LINES_ALL. This is also called Receivables interface, that mean information moved to accounting area for invoicing details. Invoicing workflow activity transfers shipped item information to Oracle Receivables. At the same time records also goes in the table RA_INTERFACE_SALESCREDITS_ALL which hold details of sales credit for the particular order.

ra_interface_lines_all (interface table into which the data is transferred from order management) Then Auto-invoice program imports data from this table which get affected into this stage are receivables base table. At the same time records goes in ra_customer_trx_all and ra_customer_trx_lines_all

8. Complete Line 
In this stage order line level table get updated with Flow status and open flag. 

9. Close Order 
This is last step of Order Processing. In this stage only oe_order_lines_all table get updated. These are the table get affected in this step. 


 You will get the details of column values getting updated at different stages and table joins information at http://functionalguy.blogspot.com/2008/05/data-flow-for-order-to-cash-cycle.html

devendra gulve — Expert’s page – click here

special Thanks TO dEVENDRA gULVE ( http://functionalguy.blogspot.com/2008/05/data-flow-for-order-to-cash-cycle.html )

Thanks – Shivmohan Purohit

11i Manufacturing Expert – Devendra Gulve


Devendra Gulve


Module: INV, BOM, OM, Depot Repair

 skill area: Manufacturing and Distribution


Current: Zensar Technologies, Pune, India

Past: Mahindra & Mahindra Nashik, Valley Gauges, Pune.



blog/site: http://functionalguy.blogspot.com/


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

Ans: I was in Manhindra and Mahindra, Nashik for some days as a Trainee Engineer. After Engineering I joined Valley Gauges in Pune. In 2005 I joined Symbiosis for doing full time MBA in IT. After MBA I joined Zensar Technologies, Pune. In Zensar I am working as a Oracle Apps Associate Consultant. The project I am working in has only one Functional person and that’s me, so I need to handle all the issues irrespective of the module or domain. I am getting very wide exposure to the system in this project.

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

Ans: Anybody who wants to be a functional consultant in any domain has to have the knowledge of the processes followed in that particular domain. For example a Finance consultant has to know the accounting entries, details of P/L, Balance sheet etc and a Manufacturing consultant must know how material flows on the shop floor, how material is managed, classified, located, controlled as well as process to fulfill the order etc. The list of things one must know is unlimited but to start one shall know the basic standard processes followed in the particular functional area.

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

Ans: I do not a great experience of taking / giving interviews, still I can try list down some points. But the questions definitely flow on the basis of past experience and the requirement of the client.

·        Types of transactions, actions associated with the transaction.

o       E.g. Sub-inventory transfer, Sales order issue, PO receipt, etc

o       Actions associated will the accounting entries, change in on-hand, sub-inventory valuation, etc.

·        Order-to-cash cycle

·        Organization structure

·        What are the various intra-operation steps?

o       Queue, run, to move, reject, scrap

·        What are the different types of Bill of Material?

o       Standard, Model, Option class, Planning, Product Family

·        What are the item attributes for an item to enter the sales order?

o       Customer ordered, Customer order enabled, OE transactable.

·        What is a modifier?

o       Modifiers enable you to set up price adjustments (for example, discounts and surcharges), benefits (for example, free goods, coupons) and freight and special charges that the pricing engine applies immediately to pricing requests or accrues for later disbursement.

·        MRP, MPS, MDS

·        Use of Bill of Material.

I will try to list down more questions modules / process wise at add it to my blog i.e. http://functionalguy.blogspot.com/

4.      What Oracle Configurator module does what the general feature and how it used in Oracle Applications.

Ans:  Oracle Configurator is the product from Oracle which gives you the flexibility to configure the BOM at the time of entering as order as per the customer requirement. You don’t need to defined deferent combination of your offerings prior the order. It saves times, maintenance cost etc. To use this in Oracle Apps you need to do some setups which are summarized at http://functionalguy.blogspot.com/2008/04/setup-for-oracle-configurator.html if one needs to use complex logic to define the dependencies of the option selected then he/she can go for Oracle Configurator Developer for the complex logic.

5.      What is Kanban method, how it used and implement in Oracle Inventory. What are the other related concepts with kanban and oracle inventory?

Ans: Kanban is a material control / management system, which is a part of Lean manufacturing. In this kanban cards are used to show status (Empty / Full) of the bin carries components. Once the bin become empty the process to fulfill it starts. For more details please visit http://functionalguy.blogspot.com/2007/04/kanban-introduction-and-benefits.html

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

Ans: I can’t give suggestions just like that. Improvement comes with time and combination of success and failure.

7.      Your feedback on Knoworacle.wordpress.com

Ans: I really appreciate your efforts towards this blog. It is well manages and in the easy language to understand. You are also planning to start free on-demand training through your blog is appreciable. One more thing which I liked is you are coming-up with the T-shirt with your blog’s logo and name. Great work, please keep-up and let me know in case I can help you.

here you can find his contribution here– click here

Thanks – Shivmohan Purohit ( knoworacle.wordpress.com )    


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


 Raju Ghosal


Oracle Application SysAdmin /Cloning


Email: raju.ghosal@gmail.com

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

Ans: Currently working with a Multinational in Developing strategic projects deployment plans; analyzing and coordinating ERP business applications across all phases of an entire Software Application Life Cycle (SALC).

I was involved in through out implementation of E-Business Financials module in my earlier assignment which includes interfaces of legacy data, GAP analysis, customization of FORMS, Reports and Maintaining 5 instances with scheduled refreshes, up to date patching etc.

I was also a part of management advisory board for all BCP activities.

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

Ans:  I was involved in through out implementation of E-Business Financials module in my earlier assignment which includes interfaces of legacy data, GAP analysis, customization of FORMS, Reports and Maintaining 5 instances with scheduled refreshes, up to date patching etc.

 3.      What is term Environment Management in context of Oracle Applications, How it is relevant for Oracle Applications setups in various organizations

Ans: Environment management duties include:

Instance Management – Work with DBAs, SA’s and CT Application Teams in coordinating instance refreshes, downtimes, usage for initiatives.

Oracle Patch Management – Coordinating with Functional teams /DBA Teams /Prod Support teams/Oracle Teams, etc on Patches/SRs for Oracle Application Instances. 

Opening SR Reviews and Follow Ups – Host weekly status calls

Coordinating Finance Technology Environment Initiatives – examples:  10G Upgrades, Partitioning, etc with DBAs, Functional Teams, App Leads and Prod Support.

Status Reports – Produce various surveys, reports, logs, etc pertaining to Technology Initiatives, issues and standard operations.

Conducting Business Continuity Planning initiatives which includes Crash and Recovery test and High Availability Test etc.

 4.      You take lot of interview, what are the common professional skills you look in candidates, how you advise candidates to focus on to improve their interview performance.

Ans: The common qualifications I look for in a candidate are:

Should be confident of what he is speaking. Should have sound knowledge on the business impact of the task he is doing or has done. He/She should understand the business logic involved or the process flow of the application he is working on.

He/She should have excellent attitude towards work and always willing to learn.

5.      How you differentiate between Support, Development, Implementation and other different kind of activities as part of team scope and work. How they different and how a professional should identify his role and relevance. What are skills require for different kind of activities.

Ans: Implementation is the whole of processes that defines a complete method to implement software in an organization. It is based on best practices and case studies from various literature sources and presents a collection of processes and products that make up a complete implementation method to allow any organization to plan and execute the implementation of ERP software.

Developer Role is to prepare the Technical Specification (based on a Functional Specification given by a Functional Consultant), build the code, Review the code and finally to prepare the Unit Test Cases. Sometimes the developer may be asked to do a technical research for an optimal solution.

After a go live, the application needs a maintenance/support to resolve the issues/tickets raised by the users when using the application. Ticket is like a request for changes/bug fixing or a request for a new Developer Role includes bug fixing/change the existing code due to new requirements/build a new code etc.

 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: Techno Functional professionals has always the advantage over Functional or Technical guys specially in cracking the Interviews as they are very good to map the Business needs with the jobs they are doing moreover they are in very high demands among Multinationals where you need to gel well with the actual business users.

To my understanding a professionals should be well versed with the business needs along with the technical jobs they are expected to perform. This gives a win-win feeling to both the Business needs and the technologies as a whole.

7.      Your feedback on Knoworacle.wordpress.com

Ans: Good going…I wish all the best for future Endeavour.

8.      Please any additional questions/ thoughts from your sides

Ans: You should publish few DBA related articles which are in high demands in current market scenarios.

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 )