ALL ORACLE APPS

All Oracle Apps

Skip to content

 HOME
o ABOUT US
o CONTACT US

 REASON BEHIND

 ARTICLES

 ORACLE
o ORACLE SCRIPTS FOR PRACTICE
o ORACLE INTERVIEW QUESTIONS
o SQL
o PLSQL

 ORACLE APPS
o APPS TECHNICAL
 APPS TECHNICAL INTERVIEW QUESTIONS
 APPS TECHNICAL MODULES
 ORACLEWORKFLOW
 XML/BI
 OAF
o APPS DBA
 APPS DBA INTERVIEW QUESTIONS
 APPS DBA MODULES
o APPS FUNCTIONAL
 APPS FUNCTIONAL INTERVIEW QUESTIONS
 APPS FUNCTIONAL MODULES
 TCA
 HR
 OM
 AR
 INV
 QP
 SLA

 ANDRIOD APPS
o ANDRIOD TRAINING
 SCRIPTS
o API’S/INTERFACES
 OM API’S
 SHIPPING API’S
 TCA API’S
 INV API’S
o ANONMYS SCRIPTS
 AOL
 SLA

 VIDEO TUTORIALS

Setting Up Multi Org Structure in R12

(MOAC)
19 Replies

Setting up Multi Org Structure in R12:

Sequence of steps to be carried out:

Develop or Design a structure:

All Oracle Apps Org Structure

 Define Location

Open the E-Business Suite and navigate to Human Resources, Vision Enterprises Responsibility:
Human Resources

Navigate to Work Structures –> Location:

Navigation

Enter the details as shown in the screen shot

Script to see the rows inserted:

PgSQL
1 SELECT *

2 FROM HR_LOCATIONS_ALL

3 WHERE location_code = 'XXAOA';

5 SELECT *

6 FROM HR_LOCATIONS_ALL_TL

7 WHERE location_code = 'XXAOA';

After selecting the Address style you will be prompted to enter the details of the location as shown in
the form below.
After entering the location details click on OK button and enter the time zone as shown in the screen
shot.
Navigate to the shipping tab and the values are populated as shown.
Now navigate to the Other Details tab. Save the changes.
  Define Business Group

Open the E-Business Suite and navigate to Human Resources, Vision Enterprises Responsibility:
Human Resources

Navigate to Work Structures –> Organization –> Description

Select New button

Enter the business group name and the location created in the previous step and save the changes.
Script to find the records:

PgSQL
1 SELECT *

2 FROM HR_ORGANIZATION_UNITS

3 WHERE name LIKE 'AllOracleApps%';

Select the LOV as business group under the Name field in the organization classifications block
Check the enabled check box for the business group name and save the changes
Click on the Others button and select the Business Group Info from the additional information
window click on ok
The below window is Visible

Press TAB and enter the mandatory fields:

With details:
Click OK Button

You will be prompted to save the changes. Click on Yes button

PgSQL
1 SELECT *

2 FROM HR_ORGANIZATION_INFORMATION

3 WHERE org_information_context = 'Business Group Information';

 Create Legal Entity

As per the structure defined above we have our business in 2 different geographical locations, hence
we need to create 2 legal entities. The 2 legal entities to be created are:

1. India Legal Entity

2. USA Legal Entity

Switch responsibility to General Ledger, Visions Operations (USA)

Navigate to Setup –> Financials –> Accounting Setup Manager –> Accounting Setups
Select the Legal Entity Tab
Click on Create Legal Entity
Enter the details:
Click on Create New Address radio Button and enter the details:
Go to the General Information and enter the details

Click on the Apply Button to save the legal entity created.

Create the legal entity for USA also in the similar manner.
Confirmation message:
Script:

PgSQL
1 SELECT *

2 FROM XLE_ENTITY_PROFILES EntityProfileEO,

3 HZ_GEOGRAPHIES HzGeographies,

4 HZ_ORG_PROFILES_CPUI_V HzOrgProfiles,

5 XLE_LOOKUPS lkp

6 WHERE EntityProfileEO.GEOGRAPHY_ID=HzGeographies.GEOGRAPHY_ID

7 AND EntityProfileEO.PARTY_ID=HzOrgProfiles.PARTY_ID

8 AND lkp.LOOKUP_TYPE='XLE_YES_NO'

9 AND lkp.LOOKUP_CODE=EntityProfileEO.TRANSACTING_ENTITY_FLAG

 Create Ledgers

In the above scenario we need to create 2 ledgers and this depends on the following:

1. Currency
2. Calendar
3. Chart of Accounts
In multi org structure we will follow the same calendar,currency and chart of accounts for the
companies. In the above scenario as we have the companies in 2 different countries we will have 2
different ledgers.

1. India Ledger
2. USA Ledger

Navigate to General Ledger Visions Operations (USA)

Navigate to Setup –> Financials –> Accounting Setup Manager –> Accounting Setups
Click on Create Accounting Setup
As we have already created the legal entity we can move forward and click on the next button
Enter the details and click the next button

Click Finish
The ledger for USA is created in a similar manner
PgSQL
1 SELECT *

2 FROM gl_ledgers;

 Create and assign operating units and legal entities

Navigate to General Ledger Visions Operations (USA)

Navigate to Setup –> Financials –> Accounting Setup Manager –> Accounting Setups
Enter the ledger name and click on GO button:
Click on the update button:

Assign legal entity to the ledger by clicking on the add legal entity button
Click on add legal entity button
Search for the legal entity created above and select the legal entity created for INDIA

Click on apply button

The legal entity has now been assigned to the ledger. Now click on the update button next to the
operating unit setup options

Click on Add operating unit

Enter the details. Assign the business group and legal entity created from the above steps to the
operating unit and click on apply button

Click complete

After completing all the ledger options click on complete.

Click on yes to complete the accounting setup

Verify the confirmation message and note down the request number and verify the status of the
request.
Create the operating nit for the USA legder in the similar manner :
PgSQL
1 SELECT *

2 FROM HR_ORGANIZATION_INFORMATION

3 WHERE org_information_context = 'Operating Unit Information';

 Create Inventory Organizations

Switch responsibility to Human Resources Vision Operations

Human Resources

Navigate to Work Structures –> Organization –> Description

Click on New button:
Enter the inventory organization name and save the changes
Select the list of values icon under the name filed in the organization classifications
Select Inventory organization from the list of values
Check the enabled button and save the changes. Then click the others button
Select accounting information and click ok
Press TAB

Select the ledger and legal entity name from the list of values and click ok
Click ok

Click yes to save the changes entered

Click others

Select inventory information and click ok

PgSQL
1 SELECT *

2 FROM HR_ORGANIZATION_INFORMATION

3 WHERE org_information1 = 'INV'

Enter details in Inventory Parameters TAB

Enter details in Costing Information TAB
Accept defaults in Revision, lot, serial, and LPN TAB
Accept defaults in ATP, Pick, Item Sourcing TAB
Accept defaults in Inter Org Information TAB
Enter details in Other Accounts TAB
Save the changes and read the note carefully to understand the implications of inventory
organization costing method

Script:

PgSQL
1 SELECT *

2 FROM MTL_PARAMETERS_VIEW
Reports/Programs:

In order to use the operating unit we need to run the Replicate seed data concurrent program from
system administrator responsibility

Run the same concurrent program for all the operating units
Run the Multi-Org Validation Report and check the output for no validations
Multi-Org Access Control:

Multi org access control is implemented in R12 to allow the users to submit requests and access
data of different operating units in a single responsibility.

This can be achieved by setting the security profile in HRMS

There are 2 security profiles:

 SECURITY PROFILE: is used for the selection of operating units from the same business
group
 GLOBAL SECURITY PROFILE: is used for the selection of operating units from the different
business group

Set up of Multi-Org Access Control:

  Setup Security Profile in HRMS

Navigate to Human Resources Vision Enterprises responsibility:

Human Resources

Navigate to Profile function under the Security menu:

Select a name for the profile and attach the business group created.
Select the security type as “Secure organizations by organization hierarchy and/or organization list”
Select operating unit under classification and the operating unit name created under the organization
name. Save the changes

Add the operating units for which the MOAC feature needs to be shared.
Navigate to Process And ReportsàSubmit Processes and Reports
Select single request and click on OK
Select the parameters and submit the concurrent program
In order to test the profile created we need to create a new responsibility.

Navigate to the system administrator responsibility

Navigate to Security –> Responsibility –> Define to create a new responsibility

Enter the mandatory fields and save the changes.
Add the created responsibility to the user.

Navigate to Security –> User –> Define

Query for the user and assign the responsibility
Navigate Profile –> System
Select the responsibility created and enter the profile as MO: Security Profile and click on the find
button
Select the security profile name created from the LOV and save the changes.
Please let us know if any questions or comments.

+297

Related posts:

TCA Create Org Contact API

Party Site Use API

Create Customer Profile API

Assemble To Order

Assemble To Order

This entry was posted in Apps Functional, Apps Functional Modules, HR, Oracle Apps on January 21,
2013 by All Oracle Apps.
Post navigation
← Date FunctionsMISCELLANEOUS FUNCTIONS →
 19 thoughts on “Setting Up Multi Org Structure in R12 (MOAC)”

1. kalyanApril 9, 2013 at 12:42 pm

hi
iam a functional consultant oracle SCM,if i want to become techno functional what should i learn ?

Log in to Reply ↓

1. All Oracle Apps Post authorApril 10, 2013 at 6:40 am

Hi Kalyan,

Let me tell you an answer in brief.. You just saw the above article right all the job is done by
a pure functional Consultant. But, a techno-functional consultant also knows what are the
tables hit and can they be populated from back end using an Oracle API or using FNDLOAD
and things like that.

Please let me know if you need more details.

Regards,
All Oracle Apps

Log in to Reply ↓

2. srinivasJuly 4, 2013 at 1:05 am

hello there…
i just created the same steps mentioned above…but when i tried to enter calendar in inventory
parameters tab, it is saying list of values has no entries…
please help me.
srinivas

Log in to Reply ↓

1. All Oracle Apps Post authorJuly 4, 2013 at 10:35 pm

Hi Srinivas,

You need to define the Calendar before this setup. Let us know if you need full details.

Regards,
All Oracle Apps
Admin
 Log in to Reply ↓

1. srinivasJuly 8, 2013 at 11:12 pm

thank you very much for ur help….this article is really helpful…..

Log in to Reply ↓

3. FakhraAugust 21, 2013 at 12:41 am

great work , keep it up!

Log in to Reply ↓

4. FakhraAugust 21, 2013 at 12:42 am

can u guide me same in 11i

Log in to Reply ↓

1. All Oracle Apps Post authorAugust 21, 2013 at 2:45 am

Sure Will post that as well.

Log in to Reply ↓

5. ripendra kumarSeptember 21, 2013 at 11:58 am

HI ,

Thanks for your post and in the mean a small request can you please provide some information
regarding to the back end tables which will be get affected while doing all these setups .if you
provide these information along with these setup document it will be a great pleasure for all of the
learners.

Log in to Reply ↓

1. All Oracle Apps Post authorSeptember 22, 2013 at 4:44 am

Hi Rependra,

Updated the post with table information.

Regards,
Admin
 Log in to Reply ↓

6. MahendraOctober 10, 2013 at 2:28 am

Thanks very much – its very helpful.

I have a question – till now i have gained experience as an end user and first line of support roles.
Now if i want to get some good information like above and learn these setups – will that be helpful to
stwich in to implementation or implementation support role like pre or post production. What all
knowledge should i need to cover to stwich for examples which documents are mandatory and basic
steps in financials and projects.
I will be great full to you if can you help me with above.

Thanks
Mahendra

Log in to Reply ↓

1. All Oracle Apps Post authorOctober 10, 2013 at 4:12 am

Hi Mahendra,

Try to move to functional support by gaining knowledge on Setups/Business Flows on

Financials and Oracle Project Accounting. Please let us know if you need more details.

Regards,
All Oracle Apps

Log in to Reply ↓

7. sandeepFebruary 28, 2014 at 7:37 pm

Hi,

Thanks. This is a very nice article and website for learning, specially for a newbie like me.
I have a question: If we have to do a fresh implementation for EBS Suite R12 with HR,FIN, OM,
INV,AP,AR… modules, can you tell me what would be the first steps done by sys admin and/or
functional consultants before creating the business groups and rest of the stuff. Is it like the
sysadmin will create a new user and responsibility, and using that user/resp we start creating the
Business Group and all…? You have used the responsibilities from Vision instance, what about for a
fresh installation?

Thanks,
Sandeep

Log in to Reply ↓
8. smraneApril 28, 2014 at 7:31 pm

Hello All,

Can somebody help me, I have done my org setup in my Vision instance, when I open PO form it
show default OU as Vision Instance, I changed the the MO:Default Operating units profile and set
my OU’s at responsibility level, but getting error as get_po_parameters-10,
Let me know if anyone have solution.

santosh

Log in to Reply ↓

1. All Oracle Apps Post authorMay 6, 2014 at 9:26 pm

Can you please provide the screen shot of the setup which you have done?

Regards,
AOA Admin

Log in to Reply ↓

9. rajashekarMay 12, 2014 at 1:25 am

Dear sir,

IN Create Inventory Organizations, dont we have to enter all the values like in costig tab – valuation
account details, and in Inter-organisation information – inter-organisation transfer accounts.

and also while creating legal entity dont we enter the values of the retained account details. please
confirm.

Log in to Reply ↓

10. rajashekarMay 12, 2014 at 2:50 am

can anybody help me that while setting up MOAC, if the business group has multiple companies so
do we have to create saperate ledgers, Saperate Legal entities, saperate Operation units & saperate
Inventory Org. for each company ???

please confirm.

Log in to Reply ↓

1. All Oracle Apps Post authorMay 13, 2014 at 5:47 pm

 Hi Raja,

It purely depends on how the Company wants to look at the accounting and How the
Business is being done by the company. But for multiple companies it is better to have
different Legal Entities and can have the same ledger if they want to maintain single book.
The way the taxes are paid to the Government is different for multiple companies we need to
have different LE’s.

Regards,
AOAAdmin

Log in to Reply ↓

11. rajashekarMay 20, 2014 at 3:52 am

Can anybody help me that, TO Create Inventory Organizations, do we have to enter all the values
like in costig tab – valuation account details, and in Inter-organisation information – inter-
organisation transfer accounts.

and also while creating legal entity do we have to enter the values of the retained account details.
please confirm.
And how & where we can get these values. please provide the details

Log in to Reply ↓
Leave a Reply
You must be logged in to post a comment.
Search
Search for:

RECENT POSTS

 Create Accounting or SLA Exception Queries

 Useful Month End Process Queries
 Form Functions attached to a Responsibility
 SLA Methods Query
 Employee and Supervisor Details

CATEGORIES

 Anonmys Scripts
 AOL
 AP
 AP API's
 API's/Interfaces
 Apps DBA
 Apps Functional
 Apps Functional Modules
 Apps Technical
 Apps Technical Modules
 AR
 Articles
 Featured
 HR
 INV
 INV
 OAF
 OM
 OM API's
 Oracle
 Oracle Apps
 Oracle Scripts For Practice
 OracleWorkflow
 PLSQL
 QP
 Scripts
 Shipping API's
 SLA
 SQL
 TCA
 TCA API's
 XML/BI

ARCHIVES

Archives

RECENT COMMENTS

 Jaya Daggula on Useful Month End Process Queries

 Trups on Creating workflow from scratch 2
 All Oracle Apps on Creating workflow from scratch 2
 All Oracle Apps on Reason Behind
 Trups on Creating workflow from scratch 2
Proudly powered by WordPress

ShareThis Copy and Paste

- See more at:
[Link]
[Link]