Shivmohan – Oracle 11i Multi Org – Definition

What is the MultiOrg and what is it used for?

MultiOrg or Multiple Organizations Architecture allows multiple operating units and their relationships to be defined within a single installation of Oracle Applications. This keeps each operating unit’s transaction data separate and secure. Further all organizations can share some master data like supplier, customer, bank, AFF, payment terms, price lists etc.

Use the following query to determine if MuliOrg is intalled:

select multi_org_flag from fnd_product_groups;


Thanks – Shivmohan Purohit

Oracle Application – A Brief Introduction

Oracle Financials, part of Oracle E-Business Suite, helps financial officers create an information-driven enterprise that synchronizes data centrally from all systems-including third-party systems-so financial information is consistently collected, calculated, analyzed, and stored, ensuring data integrity while reducing costs. This approach improves visibility into business, financial, and compliance performance across the enterprise; strengthens your control to enforce compliance with company and regulatory policy; and increases operational efficiency.

NoetixViews for Oracle E-Business Suite

NoetixViews for Oracle E-Business Suite

NoetixViews includes an extensive set of reporting objects (metadata) that deliver best-practice business views of the application’s database using an expert blend of table joins, cross operational functionality, customizations and indexes.

Ø      Business views for Oracle Financials, Order Management, Procurement, Projects, Discrete and Process Manufacturing, Human Resources, Grants, Service, Advanced Supply Chain Planning, and Enterprise Asset Management.

Ø      Metadata tailored to your configuration of Business Groups, Sets of Books, Operating Units, and Inventory Organizations.

Ø      Basic views for reports mapped to the Oracle screens; value-added views that integrate data from more complex business processes; and cross-functional views that integrate data from multiple application modules for full business process end-to-end reporting.

Ø      Unique features include special columns for key and descriptive flexfields, and lookups; support for multiple currencies and language translations; and special primary and foreign key columns for joining multiple views together for advanced reporting.

Ø      Built-in security seamlessly integrates with the data access rules of your Oracle responsibilities. Also included is support for module-specific data access controls such as GL flexfield security rules and HR security profiles.

This set of views enhances the following AOL components:

– Audit Trail

– Common Quick Picks

– Concurrent Manager Rules

– Concurrent Program Executables

– Concurrent Programs

– Currencies

– Database Conflicts in Concurrent Processing

– Descriptive Flexfields and Segments

– Flexfield Hierarchies, Values and Security

– Flexfield and Segment Qualifiers

– Key Flexfield Cross-Validation Rules

– Indexes

– Languages

– Printers

– Profile Options

– Report Request Groups

– Requests and Arguments

– Responsibilities

– Security

– Shorthand Flexfield Aliases


Thanks – shivmohan purohit

New feature added – Email subscription & more….

Friends, you must have observe, we have added few useful feature, first like to know your view on header image, we tried to outline the purpose and approach about this site.

also we encourage you to participate and enroll yourself of email subscription, so that you can get regular updates automatically in your emails also.


Thanks – Shivmohan Purohit

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

Let’s join – learn and share together with knowOracle


As an Individual, I can see you can join and participate in following 5 levels with KnowOracle and you can start with level 1 and based on your interest you can explore more, here are some detail as follows

1. Email Subscription – This is helpful to get all lastest articles/ post in email and also stay in touch with new notificaiton for upcoming FREE trainings and advisory sessions. 

 ko email

2. Reviewer / Supporter – If you are using articles / posts for your purpose, plz share your thoughts / opinion through feedback/ comments. this will help us to improve and understand what to do to bring more quality articles. Also if you think that KnowOracle is useful for other, do share links / articles with your friends/ collegues/ seniors/ juniors. You will be part of our reviewer/ support group.

If you have 7 or more people for any kind of training need or advisory help, we would arrange an exculsive FREE training / session for the group. this way we like to show gratitude for your effort as supporter for KnowOracle. Also special invitations for upcoming exclusive briefing on specific topics ( by invitations only )

3. Author – If you have article / articles / white papaer/ tutorials / how to / tips / faq / demos / scripts etc , any kind of study material which you like to contribute and share , do send us, we will review it and will format and publish it. As a author you will be owner of that and will get full credit and copyright. We will be just publishing and sharing along with your name.

4. Contributor – If you have more articles or you like to join as contributor , then first you need to be author to join and if you contributing more than 10 documents , subsequently we will involve you as contributor, where you yourself can write , format and design your posts / articles and publish on KnowOracle.

5. Expert – If you have expertise/ mastery on any particular topic/ tool/ module and you are interested to write or give session/ training, do let us know, we will arrange logistics and audience to showcase your skills. We wont charge to you or anyone. All activities on KnowOracle is FREE. Ofcourse you will have complete rights on your contents ( audio, video, demos ) — to know about Current Experts — Clike here