f Get Oracle Apps Traning Here: ORG_ID and Multi Org In Oracle Apps

This work is licensed under a Creative Commons -NonCommercial 2.5 License.



Friday, October 13, 2006

ORG_ID and Multi Org In Oracle Apps

In this Oracle Apps training article, we will learn about org_id. I hope that you have read and understood the significance of profile options that we discussed in the earlier chapter.

Before I tell you what is org_id, lets do some questions & answers:-

Why do we need org_id
In any global company, there will be different company locations that are autonomous in their back office operations. For example, lets take the example of a gaming company named GameGold Inc that has operations in both UK and France.

Please note the following carefully:-
1. This company(GameGold Inc) has offices in both London and Paris
2. UK has different taxation rules that France, and hence different tax codes are defined for these countries.
3.GameGold Inc has implemented Oracle Apps in single instance(one common Oracle Apps database for both UK & France).
4. When "UK order entry" or "UK Payables" user logs into Oracle Apps, they do not wish to see tax codes for their French sister company. This is important because French tax codes are not applicable to UK business.
5. Given the single database instance of GameGold Inc, there is just one table that holds list of taxes. Lets assume that the name of the Oracle table is ap_tax_codes_all
6. Lets assume there are two records in this table.
Record 1 tax code -"FRVAT"
Record 2 tax code - "UKVAT"
7. Lets further assume that there are two responsibilities
Responsibility 1 - "French order entry".
Responsibility 2 - "UK order entry"
8. Now, users in France are assigned responsibility 1 - "French order entry"
9. Users in UK will be using responsibility named "UK order entry"
10. In the Order Entry screen, there is a field named Tax Code(or VAT Code).
11. To the French user, from the vat field in screen, in list of values UKVAT must not be visible.
12. Also, the "French order entry" user should only be able to select "FRVAT" in the tax field.
13. Similarly, UK order entry user, that uses responsibility "UK Order Entry", only "UKVAT" should be pickable.

How can all this be achieved, without any hard coding in the screen.
Well....the answer is org_id

ORG_ID/Multi-Org/Operating Unit are the terminologies that get used interchangeably.


In brief steps, first the setup required to support this....
The screenshots are at the bottom of the article

1. You will be defining two organizations in apps named "French operations" and "UK Operations". This can be done by using organization definition screen.
2. In Oracle Apps, an organization can be classified as HRMS Org, or Inventory Warehouse Org, or Business Group, Operating Unit Org or much more types. Remember, Organization type is just a mean of tagging a flag to an organization definition.
3. The two organizations we define here will be of type operating unit. I will be using words org_Id & operating unit interchangeably.
4. Lets say, uk org has an internal organization_I'd =101
And french org has orgid =102.


Qns: How will you establish a relation betwee uk responsibility and uk organization.
Ans: By setting profile option MO : Operating unit to a value of UK Org, against uk order entry responsibility

Qns: How will the system know that UKVAT belongs to uk org?
Ans: In VAT code entry screen(where Tax Codes will be entered), following insert will be done
Insert into ap_vat_codes_all values(:screenblock.vatfield, fnd_profile.value('org_id').
Alternately, use USERENV('CLIENT_INFO')

Next question, when displaying VAT Codes in LOV, will oracle do: select * from ap_vat_codes_all where org_id=fnd_profile.value('ORG_ID')?
Answer: almost yes.

Oracle will do the following
1. At the tme of inserting data into multi-org table, it will do insert into (vatcode,org_id) ....
2. Creates a view in apps as below
Create or replace view ap_vat_codes as Select * from ap_vat_codes_all where org_id = fnd_profile.value('ORG_ID')
3. In the lov, select * from ap_vat_codes ,

If the above doesn't make sense, then keep reading.

May be quick revesion is necessary:_
1. In multi org environment(like uk + france in one db), each Multi-Org Table will have a column named org_id. Tables like invoices are org sensitive, because UK has no purpose to see and modify french invoices. Hence a invoice table is a candidate for ORG_ID column.
By doing so, UK Responsibities will filter just UK Invoices. This is possible because in Apps, Invoice screens will use ap_invoices in their query and not AP_INVOICES_ALL.
2. Vendor Sites/Locations are partitined too, because UK will place its ordersfrom dell.co.uk whereas france will raise orders from dell.co.fr. These are called vendor sites in Oracle Terminology.
3.
Any table that is mutli-org (has column named org_id), then such table name will end with _all
4. For each _all table , Oracle provides a correspondong view without _all. For examples create or replace view xx_invoices as select * from xx_invoices_all where org_id=fnd _profile.value('org_id').
5. At the time of inserting records in such table, org_id column will always be populated.
6. If you ever wish to report across all operating units, then select from _all table.
7. _all object in APPS will be a synonym to the corresponding _all table in actual schema. For example po_headers_all in apps schema is a synonym for po_headers_all in PO schema.
8. When you connect to SQL*Plus do the below
connect apps/apps@dbapps ;
--assuming 101 is French Org Id
execute dbms_application_info.set_client_info ( 101 );
select tax_code from ap_tax_codes ;
---Returns FRVAT


--assuming 102 is UKOrg Id
execute dbms_application_info.set_client_info ( 102 );
select tax_code from ap_tax_codes ;
---Returns UKVAT


Now some screenshots














Thanks,
Anil Passi

Comments on "ORG_ID and Multi Org In Oracle Apps"

 

Anonymous Anonymous said ... (2:40 AM) : 

Hi anil,

As we know org_id is all about the operating unit and organization_id is about the inventory org.How about the HR org.In HR tables organization_id is what?

 

Anonymous Anonymous said ... (2:51 AM) : 

Hi anil,

As we know org_id is all about the operating unit and organization_id is about the inventory org.How about the HR org.In HR tables organization_id is represents what?

 

Blogger Anil Passi said ... (2:54 AM) : 

Hi Anonymous,

Whether it is an ORG_ID or Inventory Organization Id or HR Organization, all these Organizations are stored in one single table.
That table is named HR_ALL_ORGANIZATION_UNITS.

select organization_id, name from HR_ALL_ORGANIZATION_UNITS ;


Now, each such Organization record in HR_ALL_ORGANIZATION_UNITS can be assigned Classifications.

One snigle Organization can be assigned multiple classifications if required.

For example, if you attach it a classification of "Operating Unit", then it can be used as a ORG_ID, by the virtue of profile option "MO: Operating Unit"

If you attach that Organization record in
HR_ALL_ORGANIZATION_UNITS a classification of "HR Organization", then it becomes HR Org.

You can assign a classification of "Inventory Organization", hence flagging it as Inventory Warehouse.

Other possible classifications are
Business Group
GRE / Legal Entity
Project Expenditure/Event Organization
Project Invoice Collection Organization
Project Task Owning Organization
Asset Organization
MRP Organization

There are several more, to find the complete list fo classifications run below SQL
SELECT hl.meaning, hl.lookup_code
FROM hr_lookups hl
WHERE hl.lookup_type = 'ORG_CLASS'
AND hl.enabled_flag = 'Y'
AND trunc(SYSDATE) BETWEEN nvl(hl.start_date_active
,trunc(SYSDATE)) AND
nvl(hl.end_date_active
,trunc(SYSDATE))
ORDER BY meaning

 

Anonymous Anonymous said ... (11:01 PM) : 

Anil,
I am new to Oracle apps and trying to learn as much as I can. I like your blog and learn a lot from it.
I understand (I think) the value of org_id in filtering the result.
I need, however to be able to run a query for ALL org_id(s) in my organization without setting it as: begin fnd_client_info.set_org_context("org_id"). Is it possible? If so how? Is there a table that has all defined org_ids that I can use to loop throught, possibly?
Thanks,
Eugene

 

Blogger Anil Passi said ... (1:09 AM) : 

Hi Eugene

Simply run your query using _ALL table. I mean, use the table which ends with _ALL

By doing so, you will be retrievnig data straight from the tables.

Thanks,
Anil

 

Anonymous Smrati Saxena said ... (3:45 AM) : 

Hi Anil,
Awesome Information.......
Really appreciate your effort of sharing knowledge with all of us.
I would like to know the difference and relationship between org_id and organization_id.
As when we write queries for report, it realy confuses us that waht stands for what...and as i am new to apps..donn have much knwledge of all these..
Thanks in advace,
Smrati

 

Anonymous Anonymous said ... (3:46 AM) : 

Hi Anil,
Awesome Information.......
Really appreciate your effort of sharing knowledge with all of us.
I would like to know the difference and relationship between org_id and organization_id.
As when we write queries for report, it realy confuses us that waht stands for what...and as i am new to apps..donn have much knwledge of all these..
Thanks in advace,
Smrati

 

Blogger Anil Passi said ... (5:37 AM) : 

Hi Smrati,

organization_id is the Unique Id of the Organization that you have defined.

Lets take an example,
1. Your company name is Smrati Inc
2. Smrati inc has various departments like IT, Payables, Purchasing Dept etc.

In such case, you will define 4 records in hr_all_organization_units table
record 1:- smrati inc [id=101]
record 2:-payables dept [id=102]
record 3:-it dept [id=103]
record 4:-purchasing dept [id=104]

However, only Smrati Inc will be registered as an operating unit in this case.

Hence your org_id will be 101, i.e. hr_all_organization_units.organization_id of Smrati Inc.


Thanks,
Anil Passi

 

Anonymous Anonymous said ... (10:44 PM) : 

Hi Anil,
Great Thanks for the explanation!!..
However i still have one doubt...
There must be so many Operating Units in an organization...so how to find which all inventory organizations comes under which operating unit..
Like in ur example..where this relationship is defined that 102,103 and 104 comes under 101..
Appreciate if u can explin bit more on this..
Thanks..

 

Anonymous Anonymous said ... (11:30 AM) : 

Anil,

I have been working as an apps developer for a year now...I find your blog is full of real life situations which an apps consultant faces everyday. I appreciate the service you are doing..Kudos to you!!

Imran Khan

 

Anonymous Anonymous said ... (9:28 AM) : 

Hi Anil,

After reading multi org structure, I am struggling to co-relate this to real life scenario. I mean if I have a Global Compnay called ABC and this Compnay now want to implement Oracle Apps. So for this Company which all will be the probable Business Group, Legal Entity, Balancing Entity,Operating Unit, Inventory Org

 

Blogger Anil Passi said ... (9:38 AM) : 

Think of these as below:-

1. Inventory:- Each of your physical warehouse
2. Operating Unit :- Think of this units within different taxation rules, accounting rules
3. Business Group
Think of it, Mittal Steel and Arcelor have merged. If you were to integrate their systems, you will have two different business groups.
4. Mittal Steel UK and Arcelor steel UK will both belong to same Legal Entity

 

Anonymous Anonymous said ... (6:17 PM) : 

Anil, Excellent write ups. Keep up the good work...

 

Anonymous Anonymous said ... (10:13 PM) : 

Hi Anil,

This is jay, Really I appreciate your knowledge sharing attitude.

Just now i have joined one project and its very critical multi-org structure with OPM inventory.

First of all can you please help me how can I understand the multi-org set up in my existing porject like LE attached to OU, OP attached to IO, and OU attached to Responsibilities...hope i have not mistaken somewhere...:) which tables I need to query in this regard.

And secondly the how we define relationship between OPM Inv Org and Discreet Inv Org...

It would gr8 help for me.

Thanks

Jay

 

Anonymous Anonymous said ... (6:20 AM) : 

Hello Anil,

This page was very informative about Multi-Org. Youo have explained about how it can be used in forms with the profile option. Can you also give an exmple as how this can be achieved in OAF pages? Thanks in advance!

 

Anonymous Gayathri said ... (4:11 AM) : 

Hi Anil

Excellent way in which u explain things in teh simplest way!!

THat makes a lot of difference to people who read the article.

I appreciate ur dedication and knowledge sharing attitude

Regards
Gayathri

 

Blogger Sanjay said ... (12:52 AM) : 

Hi Anil

After having a look at the topic. I am very clear with multi-org situation. I have understood the relation between ORGANISATION_ID and BUSUNESS_GROUP_ID as you have explained to Smrati in your comment section.
I have a doubt Anil, I just want to clear that what is the difference/Similarity between ORG_ID and ORGANISATION_ID?

 

Blogger Anil Passi said ... (4:16 PM) : 

to simply explain, org_id is the organization_id of the operating unit.

Ah, now lets explain this.

You have three records in hr_all_organization_units
1. Reliance Petrochemical
2. Reliance Petro - Finance Deparment
3. Reliance Petro - Sales Deparment

In this case, lets assume the organization_id of these three records are 1000,1001,1002

In this case, lets say "Reliance Petrochemical" is defined as MultiOrg Operating Unit.

Hence, all the tables that have column org_id, will have a value of 1000 in org_id column, assuming the transaction was created for "Reliance Petrochemical"

another way, just translate column org_id to organization_id.
Think that there is no such thing as org_id. In your mind replace each occurance of org_id with organization_id, for which the master table is hr_all_organization_units

thanks,
anil

 

Anonymous Anonymous said ... (2:32 AM) : 

Anil,

Excellent job !!!!

Thanks for sharing your knowldge...

Saran

 

Blogger vemula said ... (3:41 AM) : 

Hi Anil,
Iam a fresher to Oracle apps.But you made the "operating unit" concept very easy.Always think of freshers and post your articles. This makes the concept very clear and complete.
Thanks,
Surya.

 

Blogger vivek said ... (2:35 AM) : 

Hi Anil,

Wonderful Job !!
Keep it up.

Thanks
Vivek

 

Blogger reddy said ... (8:20 AM) : 

Hi Anil,
Now i am very clear about ORG_ID and multi org in oracle apps.
Very much thank you.
Here i have one doubt.

For each _all table , Oracle provides a correspondong view without _all. For examples create or replace view xx_invoices_all as select * from xx_invoices_all where org_id=fnd _profile.value('org_id').

In this explanation the view should not have _all but in your example the view is contain _all.
Could you please clarify this.
Thanks in advance.

 

Anonymous Anonymous said ... (8:21 AM) : 

Hi Anil,
Now i am very clear about ORG_ID and multi org in oracle apps.
Very much thank you.
Here i have one doubt.

For each _all table , Oracle provides a correspondong view without _all. For examples create or replace view xx_invoices_all as select * from xx_invoices_all where org_id=fnd _profile.value('org_id').

In this explanation the view should not have _all but in your example the view is contain _all.
Could you please clarify this.
Thanks in advance.

 

Blogger Anil Passi said ... (9:22 AM) : 

You are right, sorry for the typo

It should be
create or replace view xx_invoices as select * from xx_invoices_all where org_id=fnd _profile.value('org_id')

Thanks
anil

 

Anonymous Anonymous said ... (1:28 AM) : 

Hi Anil,

Thanks for your effort of sharing knowledge.

Could you please explain why Oracle provide so many types of ORG.

Rgds
NK

 

Blogger subrat said ... (9:35 AM) : 

Appreciate all your valuable topics.It helps a lot lot....


Best regards
Subrat

 

Anonymous Anonymous said ... (11:24 AM) : 

Can u explain me the concept of multi-org?

 

Blogger Anil Passi said ... (1:07 PM) : 

On olden days, when Oracle ERP was launched, each Operating Unit within a Global company had to implement their own Oracle ERP.

This was done because we had one installation per organization.

Latter in Mid-1990s Oracle introduced Multi-org model , which has been explained in this article.
Each Organization specific transaction is attached an Operating Unit. This is done by means of OrgId, which is explained in this article.

Please feel free to ask any questions on this if anything is unclear.

Thanks,
Anil Passi

 

Anonymous shankar said ... (12:20 AM) : 

hi anil,
first i would like to thank you for your wonderful job.this is my doubt.
with reference to your 'reliance petrochemical ' - example , do you mean to say that
entries for org_id (column in other tables) will be found only if a organization is declared as operating unit?
or is it just a alias name given to the organization_id in the case of operating unit?
can you shed more light on the 'reliance example' as to what exactly happens in the back end (along with the column names and table names)?
thanx in advance.

 

Blogger Anand said ... (2:41 AM) : 

Hi anil,
I like the way you share your knowledge.I would like to leave a suggestion here.
All your explaination are terrific.
my suggestion is this"Will it be better if you leave a HYPER LINK to the screenshot right adjacent to the explaination instead of screenshots at the bottom as it might reach the dumb people like me very easily".

Thanks and Regards
Anand.R

 

Blogger Anil Passi said ... (2:47 AM) : 

You have a valid point, but I disagree with the "dumb" remark.

Thanks for your valuable suggestion

Anil

 

Anonymous Anonymous said ... (12:30 AM) : 

Hi Anil,

You are excellent in explaining the concept of multi org.

But i have a small doubt regarding the multi-org.

When an installation can be said that it has got multi org structure?????...as of now i am thinking that if an installation has got more than 1 bussiness group only multiorg structure is available...is that true????????

 

Blogger Shaik said ... (5:11 AM) : 

Hi, Anil,

Just today i have seen ur blog and the answers u have given to questions,
Ur excellent in explaning the things to the ground level that a lay man gets understand easily,

thanks a lot.,
Shaik Ghouse

 

Blogger shireen said ... (5:41 AM) : 

Hi Anil,

Your site is really helpful, It made the concept of procure to pay n order to cash very easy..which was otherwise very difficult..I am planning to take up oracle financials fundamental exam,I have queries on workflow, can u please tell explain what are business event system functions ??n is the workflow architecture same as business event system architecture??

 

Blogger Anil Passi said ... (10:38 AM) : 

Hi Shireen

The Business events engine is a part of workflow engine, as said by Oracle. However for all practical reasons you can think of Business Events to be a totally different entity that Workflows.

I have some examples on Business Events on http://oracle.anilpassi.com

Thanks,
Anil Passi

 

Anonymous Anonymous said ... (12:04 PM) : 

Hi Anil,

One clarification required from Your example, Consider a scenario that the french responsibility user want to see the UK responsibility data also,

so by just avoiding the MO:operating unit Profile option setting for French Responsibility.
Can we achieve this

Thanks
Tony

 

Blogger Tejprakash said ... (8:51 AM) : 

Hi Anil, Great Explanations. I do have a query? What would be the scene if the Organization is Defined as GRE/Legal Entity,OU,& Inventory Organization at the same time.What will be the Org_id & Organization_id in that scenario.
Thanks
Tej Prakash Tiwari

 

Blogger Anil Passi said ... (8:55 AM) : 

Hi Tej

The org_id and organization_id will still be the same, because there will be just one record in hr_all_organization_units table.
but this record will be a foreign key to multiple classifications

Thanks
Anil

 

Anonymous Anonymous said ... (12:16 PM) : 

Hi Anil,

Thanks for this an other wonderful post from your cap i was able to understand the org_id aka multiorg concept except for one thing ie., what exactly does this condition 'where org_id = fnd_profile.value('ORG_ID')'.

Thanks and i appreciate your help,
Jay.

 

Blogger Anil Passi said ... (12:57 PM) : 

Hi Jay

Lets do some further Q&A

The purpose of multi org view?
------------------------------
The purpose of multi-org view is to partition the data based upon the value of current org_id.


How does this partitioning work?
----------------------------
The MO view has a where clause that filters the records relevant to to the current org_id


How does Oracle know the current Org Id
--------------------------
Org Id is setup as a profile option. Short name of profile option is ORG_ID. To get the current profile value assigned to the user, simply do fnd_profile.value('ORG_ID')

Note: A client info session variable named org_id is also populated by Oracle, within a package procedure named fnd_global.initialize


When is fnd_global.initialize called?
This is called as soon as a user logs onto a responsibility

Thanks,
Anil Passi

 

Anonymous Anonymous said ... (6:30 PM) : 

Thanks so much for the earlier reply..I am a fresher, I have completed functional training recently, I am an MBA(Finance and marketing) with graduation in B.E(Instrumentation and electroncs), I have completed financials functional training, I have the knowldege of c-language, SQL/PL SQL.In the same institute where i underwent functional training are offering 2months of technical training, i would get a good discount if i join it.Please suggest me if it will be useful if join it as a functional consultant...

 

Blogger Anil Passi said ... (1:00 AM) : 

It appears you wish to be Functional consultant. If so, then basic SQL knowledge is enough for you to carry out your functional duties in project. After having done MBA, there is no much value for you to go back to technical programming job. Hence you do not require Apps technical training.

Anyway, I did my BE in instrumentation and process control too.

Thanks,
Anil

 

Anonymous Anonymous said ... (7:29 AM) : 

Hi Anil, Thank you so much for suggesting me , U got it right that i am interested in Fucnctional.And you saying there is no value in going back to technical has given me very good justification to be in functional...thanks again..

 

Anonymous Anonymous said ... (7:57 AM) : 

Hi!Could you please tell me how important is oracle certification for freshers...and how to prepare best for the exams..

 

Blogger Anil Passi said ... (8:20 AM) : 

Certification increases your probability of getting the job, surely.

As this shows your prospective employer
1. You are commited to the cause of learning
2. you add to the value of the organization and having a lot of certified professionals will them win more projects

What is the subject matter you wish to certify on?
Thanks
Anil

 

Anonymous Anonymous said ... (3:31 AM) : 

Certification in oracle 11i financials functional( In AP which includes three exams fundamental, Gl and AP)

 

Anonymous Anonymous said ... (10:48 AM) : 

hi!Please let me know how to prepare for the above exam...

 

Blogger Anil Passi said ... (11:32 AM) : 

The best way to prepare is to run end to end processes in these respective modules.

The exam contents are listed on Oracle website

Please see
http://education.oracle.com/pls/web_prod-plq-dad/show_desc.redirect?redir_type=13&group_id=58&p_org_id=1080544&lang=US&media=1

and
http://www.oracle.com/global/us/education/certification/ebus11i_appteccourses.html

thanks,
anil passi

 

Anonymous Vasanth said ... (10:11 PM) : 

Anil,

You are simply great in sharing your knowledge.
Can you shed light on the difference between the following with example as in the case of Reliance Industries Ltd
1. Business group
2. Organization_id
3. Org_id
4. Operating Unit
5. Legal Entity
6. Set of books
7. Inventory Organization

Thanks in advance

Rgds,
Vasanth

 

Anonymous Anonymous said ... (7:30 AM) : 

Hi Anil,
Thanks for your valuable tutorial. Also i have a question.

How will you set the MOAC org context in a OA Framework screen. Iam desigining a OA
screen in R12 based on a view object. But it does not return any rows since the org id is not set.

Please let me know how do i need to set the org id ..
I think it can be done in
Controller of the page , but how ?

Thanks in Advance.

 

Blogger Anil Passi said ... (8:03 AM) : 

R12 MOAC should be picked up automatically from the MOAC Setup

Please read the below links for details to ensure that this has been setup on your system.

When OAF forms the WebAppsContext, the MOAC code will be executed too.

R12 Multi Org Basics
R12 Multi Org Details

Thanks,
Anil Passi

 

Anonymous Anonymous said ... (2:38 PM) : 

hi Anil,
are site level and org_id same???what is site level actually?

 

Anonymous Anonymous said ... (11:14 PM) : 

can you explain on what is the difference between operating unit and inventory organization?

 

Anonymous Anonymous said ... (4:53 AM) : 

Can you please explain the concept of multi org in detail??

 

Anonymous Anonymous said ... (6:37 AM) : 

hi...can you please explain about subinventory and locators?

 

Blogger sam said ... (9:28 PM) : 

hi anil

can we link two tables like

1.Hr_operating_units hr
2.RA_ADDRESSES_ALL RAA


RAA.ORG_ID = HR.ORGANIZATION_ID

 

Blogger swapna said ... (2:13 AM) : 

organization_id is the Unique Id of the Organization that you have defined.

Lets take an example,
1. Your company name is Smrati Inc
2. Smrati inc has various departments like IT, Payables, Purchasing Dept etc.

In such case, you will define 4 records in hr_all_organization_units table
record 1:- smrati inc [id=101]
record 2:-payables dept [id=102]
record 3:-it dept [id=103]
record 4:-purchasing dept [id=104]

However, only Smrati Inc will be registered as an operating unit in this case.

Hence your org_id will be 101, i.e. hr_all_organization_units.organization_id of Smrati Inc


Hi Anil,
As you said in above example,i understood that org_id and organization_id are same.ie (operating unit),101 and how abt remaining 102,103and 104 id's.
can you explain me?
thanks in advance
swapna

 

Blogger swapna said ... (2:14 AM) : 

organization_id is the Unique Id of the Organization that you have defined.

Lets take an example,
1. Your company name is Smrati Inc
2. Smrati inc has various departments like IT, Payables, Purchasing Dept etc.

In such case, you will define 4 records in hr_all_organization_units table
record 1:- smrati inc [id=101]
record 2:-payables dept [id=102]
record 3:-it dept [id=103]
record 4:-purchasing dept [id=104]

However, only Smrati Inc will be registered as an operating unit in this case.

Hence your org_id will be 101, i.e. hr_all_organization_units.organization_id of Smrati Inc


Hi Anil,
As you said in above example,i understood that org_id and organization_id are same.ie (operating unit),101 and how abt remaining 102,103and 104 id's.
can you explain me?
thanks in advance
swapna

 

Blogger M. Yousuf said ... (3:37 AM) : 

Hi Anil,

I have question about
difference between multi-org and Global Consolidation System

could you please explain...

Let me intro you something about our current business cycle....

1st : We dont have Multi-Org.
Our SOB contain:
Company
Cost Center
Division
Brand
Account
Sub-Account

2nd: Now we are looking to open new Operating Unit in other country with different SOB

How do I manage with above SOB...
Using Consolidation or recommending to go for fresh Installation with multi-org....what you recommend?...if you were in my place what you will recommend to you Directors..

I hope you got exactly what i am looking..
Please waiting your quick reply.

 

Blogger M. Yousuf said ... (5:40 AM) : 

Hi anil,

Thanks for training all of us what is multi org and how its work!

Could you please explain what is different between Multi-Org and Converting to Multi-Org.

Converting to Multi-Org will secure our history data, and how exactly its work...

Need quite in details.

thanks in advance
waiting....

 

Blogger sridhar said ... (11:17 AM) : 

Hi Anil,

Your site is very helpful.I have one basic doubt is that what is the Difference between Organization_ID and Org_Id.

Are they both same.Because in some base tables the column name is Org_id and in some tables it is Organization_id

Thanks,
Sridhar

 

Blogger sridhar said ... (11:26 AM) : 

Hi Anil,

I have one morething to ask you.What is the Difference between an Open Inteface and an API??

Thanks,
Sridhar

 

Blogger Jude said ... (11:41 PM) : 

Hi Anil
Thanks for all the info but have some doubts

Kindly correct me if I wrong

The org_id in the _all tables refers to the operating unit
I need to have put a filter on a report for operating unit as well as Legal entity .
Where do I find the relation for this operating unit-->Legal entity

Kindly Help

Regards
Jude

 

Anonymous Anonymous said ... (7:52 AM) : 

Anil,

I am a oracle apps Consultant since couple of years in US. I am really like your way of capturing and sharing the knowledge. Anil I can not stop my self to say that you got Excellent, God gifted spirit to share the knowledge.

Many many thanks....keep it up.

Raj

 

Anonymous Anonymous said ... (11:47 PM) : 

Good explanation..

 

Anonymous Anonymous said ... (12:29 AM) : 

Hi Anil,

Your explanations have cleared many doubts about MO. Still one thing is not clear to me.

When we assign the profile "MO: Operating Units" to the responsibility "UK Order Entry Superuser" with the value "GameGold Inc UK Operations", how the Org_ID value 101 is tagged? In none of the screen I found that value (101) is provided.

Rgds,
Arindam

 

Anonymous Anonymous said ... (2:04 PM) : 

Anil,

I Appreciate for sharing the knowledge. I learnt a confusing concept easily from your blog.

Thanks a lot

Regards
Bala

 

Anonymous Anonymous said ... (1:10 PM) : 

Excellent job , good work keep it up..!!!!!

 

Anonymous Anonymous said ... (1:49 AM) : 

Hi Anil,
All your articles are really good.They are very informative and easy to understand.Thanks a lot for such wonderful articles

 

Anonymous Mrs. Lakshmi said ... (10:26 PM) : 

Hi Anil,

Good Morning,

I'm neither a professional developer nor an active member of the IT world--A house wife who just keeps update with good site on search of what is e-commerce and oracle integrtion ..

it's more than a training in a phased manner, I wonder and am perturbed , for I see a Teacher in born, revealed in this way-- in you. Very rare is the combination of Excellence with departing of Knowledge

God Bless you!!!!!!

Mrs.Lakshmi

 

Blogger Anil Passi said ... (11:13 PM) : 

Hello Mrs Lakshmi,

You must be a poet to be able to write such lovely words.

Thanks for your compliment on my teaching abilities.

Anil

 

Blogger stephen said ... (11:24 AM) : 

Can two Operating Units within the same set of books have different key flex-fields for inventory items? Similar question for asset id's?

My understanding was that all KFF's and DFF's are shared but your lucid article makes me wonder if org_id enables non Accounting KFF's to be different for each org.

 

Anonymous swapneel said ... (3:45 AM) : 

Hi Anil,
I appreciate the way you share information..i have a doubt in multi-org structure,Can you tell me the need to have multiple Business Groups in Multi-Org structure?

 

Blogger gandhi said ... (2:16 AM) : 

Hi need help.
How can we find out the operating unit of a particular company (GL Code combinations segment1).
I'm looking for the table links.

Thanks a lot in advance for the help.

 

Blogger blesson said ... (12:30 PM) : 

"Invoice screens will use ap_invoices in their query and not AP_INVOICES_ALL."

Could you please explain what is the difference bte ap_invoices and AP_INVOICES_ALL w.r.t above comments.

 

Blogger blesson said ... (12:40 PM) : 

"execute dbms_application_info.set_client_info ( 101 );
select tax_code from ap_tax_codes ;"

Should it be ap_tax_codes_all as you said earlier all the nulti org tabel should have _all attached.

 

Blogger Anil Passi said ... (4:05 PM) : 

In Oracle 11i, when a Payables user for GE-UK logs in, they must not be able to view invoices of GE-US.

AP_INVOICES_ALL will contain the invoices of all the organizations, i.e. GE-UK, GE-US etc.

Hence the screen queries ap_innvoices, which is a view on top of ap_invoices_all.

select * from ap_invoices
is equivalent to
select * from ap_invoices_all where org_id = fnd_profile.value('ORG_ID')

Thanks,
Anil Passi

 

Blogger SURYA said ... (5:02 AM) : 

HI ANIL,
WHAT EXACT THIS CCID MEANS
AND HOW CAN WE DEFINE IT

 

Anonymous Anonymous said ... (6:11 AM) : 

Weldone anil

 

Blogger raj said ... (11:16 PM) : 

hi anil,
Information abt org_id and multi_org was excellent.

in profile we see site,application,
user,organization.
can u plz explain abt its purpose.

 

Blogger Ashish said ... (3:41 PM) : 

Hi Anil,

I have done MBA & working as a fresh Apps consultant. Can you plz suggest the useful links for financial modules from functional & implementation perspective.

Thanks in advance.
Ashish

 

Blogger Vikas said ... (8:26 PM) : 

Hi anil,
Really wonderful. First I repect and pend my head for you..Even i share with people only around to me and who worked and working with me. But you are sharing with anonymous...Good job Keep it up..

Best wishes..
Vivek Ramasamy

 

Blogger shreya said ... (10:26 AM) : 

Hi Anil,
Thanks a lot for all the efforts u are putting to share your knowledge....

i am new to oracle apps and im trying to understand the multiorg concepts. your blogs are very helpful but it would be nice if you can explain multiorg structure with an example from buissness group to inventory organization level...like when we have our operating units in multiple countries....

thanks in advance shreya...

 

Blogger shreya said ... (10:37 AM) : 

Hi anil,
I was going through your blog...as per your example of arcelor,mital i have a doubt.

According to the example if my understanding is correct ,If they implement oracle apps...there will be payables responsibilities like pay_arcelor_boston and pay_arcelor_newyork which is attached to arcelor business group and boston,newyork operating units respectively...and another responsibilities like pay_mittal_boston and pay_mittal_newyork which is attached to mittal business group and boston,newyork operating units respectively...can u plz tell me whether my understanding is corrrect.

thanks shreya

 

Blogger Vikas Sathidev said ... (5:32 AM) : 

Hi Anil,

Thank you for those wonderful examples but I'm a little confused with the concepts of Set of books, Inventory Organization and Ooperating Unit, could you kindly help me out with a small example?

 

Anonymous Anonymous said ... (12:46 PM) : 

Hi,

i have a question,
i`m using the ap_supplier_sites table, ( synonym of ap_supplier_sites_all ) but i can not see any records, only if i run a query on the _ALL table.

i try for doing a SET

fnd_client_info.set_org_context also initilize function and i was not able to see the information on the table,

but i created a new synonym over the same table ap_supplier_sites_all and i was able to see the records..

why using ap_supplier_sites i was not able the see the Information ?

 

Anonymous Anonymous said ... (9:09 AM) : 

Hi Anil,

I am newbee to Oracle apps world and i found your blog very much helpful for freshers and especially i should appreciate the way you explain things...looks like your a nice instructor!!!!

I want to share my issue, so that i can get some useful notes from you.

The company i am working for now is going through some business changes effective from june.we are curretly using AP and Gl mainly.From june the company wants to maintain complete new transactions and they decided to create new set of books with out changing the rest.So ultimately there having a different instance with new set of books. Now my questions what are the steps to be considered to implement this. Like what kinnd of data migration if needed? and what all other setups has to be transeffered.

To be precise my question is cant we use multi org concept for this to achieve?

If we create another instance with different set of books.....what all conversions has to be done...like vednors, open po's is example of some.Please suggest

 

Blogger Pankaj said ... (12:54 PM) : 

Hi Anil,

First of all I want to thank you for your effort to put your knowledge before us which is very helpful.

I just wanted to share my understanding about the finding the business group,legal entity,operating unit and inventory organization though you have already explained it in your blog.

All organizations are maintained in HR_ALL_ORGANIZATION_UNITS table and organization classifications like Legal entity or operating unit information are stored in HR_ORGANIZATION_INFORMATION table. There are 3 views provided based on these 2 tables to easily find out the Legal entity, Operating unit and Inventory organization.
These are:1)HR_LEGAL_ENTITIES
2)HR_OPERATING_UNITS
3)ORG_ORGANIZATION_DEFINITIONS
The related query to find the same are as:
Query to find the business groups set up in the instance :
select FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')from dual;

Query to find SOBs set up in the instance :
select FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');

Query to find legal entities associated with a SOB :
select organization_id legal_entity_id
from hr_legal_entities
where set_of_books_id = (SET OF BOOKS ID)
and business_group_id = (BUSINESS GROUP ID)

Query to find operating units for a legal entity :

select organization_id operating_unit
from hr_operating_units
where legal_entity_id= (legal_entity_id)

Query to find inventory organizations for an operating unit :
select organization_id
from org_organization_definitions
where operating_unit= (operating_unit)

Thanks
Pankaj

 

Blogger Jyotsna said ... (9:21 AM) : 

Hi ,

Thanks a lot bcoz I am a fresher in Oracle apps and this article gave me a very clear concept of
profile option..You are just great..

 

Blogger Pankaj said ... (12:02 AM) : 

AP_SUPPLIER_SITES is a view where as ap_supplier_sites_all is a table(Multi Org Table).In general it is suggested to use table to query records instead of View,so if there is not specail requirement of using the view,better u use table,otherwise if u r going to use the view,first u run the following sql query for apps Initialization.
fnd_client_info.set_org_context("org_id").
Give the respective org id.
If it is not working ,try with the following :
begin
fnd_global.apps_initialize(USER_ID,RESP_ID,RESP_APPL_ID);
end;
Cheers!!
Pankaj

 

Anonymous Anonymous said ... (12:07 AM) : 

Great work Anil
Thanks...

 

Blogger Hello said ... (10:34 AM) : 

Hi Anil,

Your site is wonderful!!!!!!!!!

 

Anonymous Anonymous said ... (5:54 AM) : 

Anilji great job really.

 

Blogger michael said ... (5:31 PM) : 

Hi Anil,
thanks a lot for this post. greatly appriciated. Job well done.
Michael.

 

Anonymous Anonymous said ... (3:26 AM) : 

Hi Anil,

hope you could help us on this, do we have API to create and update Legal Entity in R12?

Thanks a lot...

 

Anonymous Anonymous said ... (3:28 AM) : 

hi anil,

do we have an API to create and update legel entity in R12?
can you point me to correct direction.

help would be very much appreciated...

 

Blogger JASMEET said ... (12:27 PM) : 

Hi Anil ,

First of all, thank you so much for explaining the multi org in simple language.

Could you please respond to my below mentioned queries in relation to multi org ?

Say I have 1 Business Group (ABC). 2 Legal Entities (A1 and B1). A1 has got 1 Operating unit (OU1) and B1 has got Operating unit (OU2).

My OU specific responsibilities are AP OU1, AP OU2, PO OU1, PO OU2

1.) Do I need to define OU specific GL, UK HRMS and INV responsibililties ?

2.) I have only 1 BG. Do I need to set Profile HR:Business Group at each responsibility level ? I mean selecting HRMS, GL, AP OU1, OU2, PO OU1, OU2 and INV ?

3.) What is the purpose of profile HR:Secutiry Profile ? It will have my Business Group name . Right? But amongst above mentioned responsibility, Which responsibility do I need to select to attach my BG name to this profile ?

4.) Say I define a new security profile in HRMS and don'e use the profile automatically defined as my BG name. I specify my OU1 and OU2 using organization hierarchy security.

Will it be mandatory to define MO:Security profile to implement this security profile feature ? and amongst above mentioned resp, which one to select to define this profile ? Should this profile contain Business group name or the Security profile name defined ?


Sorry for such a long post but I am really confused and can't move further until I am clear about what I have questioned ?

Thanks in Advace !
Jasmeet

 

Blogger JASMEET said ... (12:52 PM) : 

Hi Anil ,

Also If you could explain the difference between Profiles

HR: Security Profile
MO:Security Profile

Thanks
Jasmeet.

 

Anonymous Anonymous said ... (10:45 PM) : 

hai anil
i completed oracle apps technical training in hyderabad.now i am working in chennai in a small company.could you please explain me how i build my career..i mean on which topics i have to concentrate..please mail me
durgareddygade@gmail.com
thanks,
durga

 

Blogger durga said ... (10:49 PM) : 

i am a oracle apps technical fresher.please tell me what are the steps followed to improve my knowledge as early as possible.. please replay to my mail id
durgareddygade@gmail.com

 

Anonymous Anonymous said ... (1:34 AM) : 

Anil,

Thanks for your time in sharing your knowledge. I have a doubt to be clarified.

I understand that there is a profile by name Org_id created in front-end which is called in coding ( by using fnd_profile.value('org_id') .
What is this MO: Operating Unit then?
Any relation between org_id an MO: Operating unit?

 

Anonymous Brajesh Shukla said ... (8:49 PM) : 

Hi Anil,
you are doing great job.I am very new in apps and this site really helps me in apps concepts.

 

Blogger ANDY said ... (2:44 AM) : 

a new biee..... understanding something.... thanks boss!!!!

 

Blogger Adil A Murad said ... (2:09 AM) : 

Thank Anil for such a wonderfull information about ORG_ID

 

Blogger andrew said ... (7:33 AM) : 

A very well written article indeed!

Reminds me of another series of Multi Org Tutorials I found at:

http://www.oracle-apps-training-online.com/multi-org-structure.html

 

post a comment