MOAC feature in Oracle Apps R12 allows a user to access data from multiple operating units with a single responsibility. The security profile is defined with the list of Operating Units. This profile is then attached to responsibility.
Oracle introduced a parameter operating unit mode in the definition of the concurrent program to support the MOAC (Multi-Organization Access Control) feature.
Check the below screenshot for the difference in the submit request window.
Submit request form in Oracle Apps 11i
Submit request form in Oracle Apps R12
You can clearly see the additional field Operating Unit in Oracle Apps R12.
Operating Unit Mode Values,
S – Single Org
When you set the operating unit mode value to S, the operating unit field gets enabled while submitting a concurrent program. You need to select the respective operating unit from the drop-down list.
M – Multi-Org
When you set it to M, the operating unit field remains to disable and Oracle will run the concurrent program for operating units which are specified in the security profile.
Set operating unit mode parameter
Let’s see how to set the operating unit mode parameter from the front end.
Navigate to System Administrator Responsibility and then System Administration > Concurrent Programs.
Note: This is not available under the standard form to define the concurrent program available in Application Developer Responsibility.
It opens an OAF page showing the definition of the concurrent program. Query your concurrent program and edit it.
Navigate to the request tab and update the Operating Unit Mode to ‘S’ or ‘M’ depending on your requirement.
I hope you find this article helpful, do let me know in the comments section below.
Reference – Overview of Multiple Organizations Reporting
