How to set multi org in r12 from backend

How to set multi org in r12 from backend

Here we are going to Discuss about Multi org concept in Oracle Apps r12. First of All we need to understand what is Multi org. Multi org is also called MOAC is Oracle apps r12. MOAC is is the Multi org access control. This feature is only come in the Oracle r12. earlier in 11i this was not available. According to Multi org setup ,  One user can access the Multiple Business units in the same responsibility earlier in Oracle 11i this was not feasible. This feature really helps the users to do work in the multi org without switching the Oracle responsibilities. Here in this post, I will share the method to set the multi org in r12 from backend.

 

Oracle has come up with the Security profiles in r12 to implement the Multi org in r12. In the security profiles , we defined the Business Unit orgs which will be access from the Same responsibility and then Attach this security profiles to the System profiles for this responsibility. So that system validates from Profile level this user have access of this Security profile and he/she can access these Business units in the same responsibility.

 

 

 

Steps to set the multi org in r12 from backend

If you are using the Back end procedure to insert some values in the Standard Base tables and you want to follow and to put the control on the basis of Multi Org setup (MOAC) then you need to use these below steps before using any API or Interface code.

 

 

begin
fnd_global.apps_initialize(p_user_id, p_resp_id, p_resp_appl_id);
end;

 

begin
fnd_global.apps_initialize(p_user_id, p_resp_id, p_resp_appl_id);
end;

 

begin
mo_global.init (<APPLICATION SHORT NAME>);
end;

For example

begin
mo_global.init (‘AR’);
end;

 

This is one of the most important package to be use in the backend to set the multi org concept. With the help of this Procedure , Bank end system , able to drive all the profile values assigned to this responsibility and user in Oracle application. So that we can put Data access control on the based of Multi org.

 

To execute fnd_global.apps_initialize procedure we need to Application User id, Responsibility Id and the Responsibility application id.

 

You can set this information's from these below tables.

 

 

fnd_user

fnd_responsibility_tl