- OracleApps Epicenter - http://www.oracleappshub.com -

MOAC : From Multi-Org….To Multi-Access

This new Feature in R12 ,enables companies that have implemented or implementing shared services operating model to efficiently process business transactions by allowing them to access, process and report on data for an unlimited number of operating units within a single applications responsibility. Users are no longer required to switch applications responsibilities when processing transactions for multiple operating units.

Data security is maintained using security profiles that determine the data access privileges associated to responsibilities granted to a user.

Because of this you can perform multiple tasks across operating units without changing responsibilities, the simple case can be best described as diagram in the left, where 3 user from three difference OU's required three separate responsibility to perform the task.

MOAC Benefits..

What are the new changes from Multi Organization(Multi Org) to Multiple Organization Access Control.

Where and how to define a security profile?

Using Oracle HRMS, you can define your security profile using two forms:

The Security Profile Form allows you to select operating units from only one Business Group. The Global Security profile Form allows you to select operating units from multiple Business Groups.

The decision on which form to use is really up to you and depends on your HR implementation and how you want to partition data. All you need to do is enter a name, and select the Security Type called “Secure organizations by organization hierarchy and/or organization list”. This allows you to assign multiple OUs. When assigning operating units, first select classification Operating Unit, and then select the organization or Operating Unit name. You can assign as many operating units as you want.

11 Comments (Open | Close)

11 Comments To "MOAC : From Multi-Org….To Multi-Access"

#1 Comment By Sayed Mohamed On December 3, 2007 @ 1:23 am

Illustration clear and new feature will enhance peformance as I expect

#2 Pingback By SAP-ORCL: “Security” On January 12, 2008 @ 2:44 am

[…] MOAC : From Multi-Org….To Multi-Access […]

#3 Pingback By Highlights:Release 12 Financials On February 5, 2008 @ 12:48 am

[…] MOAC : From Multi-Org….To Multi-Access […]

#4 Comment By Vineet On May 11, 2008 @ 1:46 am


I have a query wrt R12 MOAC …as we know one of the purpose of defining multiple operating unit was just to bifarcate the data via the help of security rule , in earlier version of oracle apps we used to do the same. But in R12 , we can have a look at multiple OU’s via a single responsibility, but we stand on the same position , if we want to query the invoice of a different OU , but it wont get populated as there has been a security rule being applied. Is there any workaround to by pass the security rule and see the transaction ..

#5 Comment By Sanjit Anand On May 11, 2008 @ 7:07 pm

Thats true as you know in R11i, we are using Org Specific Views to filter rows with a specific ORG_ID.

As told you earlier in above document, In R12, the views are no longer used. Instead, Synonym together with Security Policy are used to return rows for a single operating unit.

Followings provide the steps to retrieve Org Specific rows from a Synonym. (In R12, we are using “mo_global.set_policy_context” instead of “dbms_application_info.set_client_info” as in R11i.)

This was , you can acheive
To filter rows from synonym using ORG_ID :

if you are using SQL*Plus
exec mo_global.set_policy_context(‘S’, &org_id);

if using Toad
mo_global.set_policy_context(‘S’, &org_id);

#6 Comment By Sanjit Anand On May 11, 2008 @ 7:17 pm

Get use of MO_GLOBAL Package to handle such kind of senarios.

1. For setting the org context:

MO_GLOBAL.init :
Manages Initialization code for Organization Security Policy.

2. For setting global initialization :



In SQL :
execute fnd_global.apps_initialize(&user_id,&responsibility_id,&responsibility_application_id);
execute mo_global.init(‘&product_short_name’);

you can get these values through this query


and then these two query

execute mo_global.init(

#7 Pingback By MOAC : Technical Insight On May 12, 2008 @ 1:23 am

[…] [1] […]

#8 Pingback By MOAC :”Multi-Org Preferences” On May 12, 2008 @ 4:04 am

[…] MOAC : From Multi-Org….To Multi-Access […]

#9 Comment By Sam On September 22, 2008 @ 5:51 am

Can we use the MOAC in HRMS. Like in people screen. I want to create a responsibility ‘TEST HRMS MANAGER’ and implement MOAC. so that one can see the selected organization/business employee…

#10 Pingback By Highlights:Release 12 Oracle EBS Financials | OracleApps Epicenter On October 10, 2008 @ 4:13 pm

[…] MOAC : From Multi-Org To Multi-Access […]

#11 Comment By Murali On February 8, 2012 @ 2:36 am

good collections