ALL ORACLE APPS
All Oracle Apps
HOME
REASON BEHIND
ARTICLES
ORACLE
ORACLE APPS
ANDRIOD APPS
SCRIPTS
VIDEO TUTORIALS
Setting Up Multi Org Structure in R12 (MOAC)
12 Replies
Search
Setting up Multi Org Structure in R12:
Sequence of steps to be carried out: Develop or Design a structure:
RECENT POSTS
Query to Find Schema and its status SQL Queries for practice Create Receivable Invoice Ship Confirm the Sales Order
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Pick Release Sales Order
CATEGORIES
Anonmys Scripts API's/Interfaces Apps Functional Apps Functional Modules Apps Technical Apps Technical Modules AR Articles Featured HR INV
All Oracle Apps Org Structure
OAF OM OM API's Oracle Oracle Apps Oracle Scripts For Practice OracleWorkflow PLSQL
[Link]
Define Location Open the E-Business Suite and navigate to Human Resources, Vision Enterprises Responsibility:
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
QP Scripts Shipping API's SQL TCA TCA API's XML/BI
ARCHIVES
Select Month
RECENT COMMENTS
Human Resources
All Oracle Apps on Setting Up Multi Org Structure in R12
Navigate to Work Structures > Location:
(MOAC) Mahendra on Setting Up Multi Org Structure in R12 (MOAC) All Oracle Apps on Setting Up Multi Org Structure in R12
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Multi Org Structure in R12 (MOAC) ripendra kumar on Setting Up Multi Org Structure in R12 (MOAC) All Oracle Apps on Setting Up Multi Org Structure in R12 (MOAC)
Navigation
Enter the details as shown in the screen shot
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Script to see the rows inserted:
1 2 3 4 5 6 7 SELECT FROM WHERE SELECT FROM WHERE * HR_LOCATIONS_ALL location_code = 'XXAOA'; * HR_LOCATIONS_ALL_TL 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.
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
After entering the location details click on OK button and enter the time zone as shown in the screen shot.
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Navigate to the shipping tab and the values are populated as shown.
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Now navigate to the Other Details tab. Save the changes.
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Define Business Group Open the E-Business Suite and navigate to Human Resources, Vision Enterprises Responsibility:
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Human Resources
Navigate to Work Structures > Organization > Description Select New button
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Enter the business group name and the location created in the previous step and save the changes.
Script to find the records:
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
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Check the enabled check box for the business group name and save the changes
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Click on the Others button and select the Business Group Info from the additional information window click on ok
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
The below window is Visible
Press TAB and enter the mandatory fields:
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
With details:
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Click OK Button
You will be prompted to save the changes. Click on Yes button
1 SELECT * 2 FROM HR_ORGANIZATION_INFORMATION
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
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)
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Navigate to Setup > Financials > Accounting Setup Manager > Accounting Setups
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Select the Legal Entity Tab
Click on Create Legal Entity
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Enter the details:
Click on Create New Address radio Button and enter the details:
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
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.
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Confirmation message:
Script:
1 SELECT * 2 FROM XLE_ENTITY_PROFILES EntityProfileEO, 3 HZ_GEOGRAPHIES HzGeographies, 4 HZ_ORG_PROFILES_CPUI_V HzOrgProfiles, 5 XLE_LOOKUPS lkp 6 WHEREEntityProfileEO.GEOGRAPHY_ID=HzGeographies.GEOGRAPHY_ID 7 ANDEntityProfileEO.PARTY_ID=HzOrgProfiles.PARTY_ID open in browser PRO version Are you a developer? Try out the HTML to PDF API
[Link]
7 ANDEntityProfileEO.PARTY_ID=HzOrgProfiles.PARTY_ID 8 ANDlkp.LOOKUP_TYPE='XLE_YES_NO' 9 ANDlkp.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)
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Navigate to Setup > Financials > Accounting Setup Manager > Accounting Setups
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Click on Create Accounting Setup
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
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
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
The ledger for USA is created in a similar manner
1 SELECT *
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
1 SELECT * 2 FROM gl_ledgers;
Create and assign operating units and legal entities Navigate to General Ledger Visions Operations (USA)
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Navigate to Setup > Financials > Accounting Setup Manager > Accounting Setups
Enter the ledger name and click on GO button:
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Click on the update button:
Assign legal entity to the ledger by clicking on the add legal entity button
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Click on add legal entity button
Search for the legal entity created above and select the legal entity created for INDIA
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Click on apply button
The legal entity has now been assigned to the ledger. Now click on the
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
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
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Click complete
After completing all the ledger options click on complete.
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
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 :
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
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
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Human Resources
Navigate to Work Structures > Organization > Description
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Click on New button:
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Enter the inventory organization name and save the changes
Select the list of values icon under the name filed in the organization classifications
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Select Inventory organization from the list of values
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Check the enabled button and save the changes. Then click the others button
Select accounting information and click ok
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Press TAB
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Select the ledger and legal entity name from the list of values and click ok
Click ok
Click yes to save the changes entered
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Click others
Select inventory information and click ok
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
1 SELECT * 2 FROM HR_ORGANIZATION_INFORMATION 3 WHERE org_information1= 'INV'
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Enter details in Inventory Parameters TAB
Enter details in Costing Information TAB
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Accept defaults in Revision, lot, serial, and LPN TAB
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Accept defaults in ATP, Pick, Item Sourcing TAB
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Accept defaults in Inter Org Information TAB
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Enter details in Other Accounts TAB
Save the changes and read the note carefully to understand the implications of inventory organization costing method Script:
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
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
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Run the same concurrent program for all the operating units
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Run the Multi-Org Validation Report and check the output for no validations
Multi-Org Access Control:
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
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:
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Human Resources
Navigate to Profile function under the Security menu:
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Select a name for the profile and attach the business group created.
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Select the security type as Secure organizations by organization hierarchy and/or organization list
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
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 ReportsSubmit Processes and Reports
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Select single request and click on OK
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Select the parameters and submit the concurrent program
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
In order to test the profile created we need to create a new responsibility. Navigate to the system administrator responsibility
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Navigate to Security > Responsibility > Define to create a new responsibility
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Enter themandatoryfields and save the changes.
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Add the created responsibility to the user. Navigate to Security > User > Define
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Query for the user and assign the responsibility
Navigate Profile > System
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Select the responsibility created and enter the profile as MO: Security Profile and click on the find button
open in browser PRO version
Are you a developer? Try out the HTML to PDF API
[Link]
Select the security profile name created from the LOV and save the changes.
[Link]