oracle r12 multi org
DESCRIPTION
TRANSCRIPT
![Page 1: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/1.jpg)
G.Balaji contact:+91 8897262601 Email:[email protected]
MULTI ORG
MULTI ORG: Multi Org is a feature to store the data of multiple organization in a single instance. By partitioning thae data of H.R’s, Financials,Sales,Purchases,Material etc.,.1)Bussiness Group: Is a highest level in the Organization structure. At this level we secure Work structure and Remuneration policies. Ex: TATA GROUP | ------------------------------ | | |
TATA TATA TATA MOTORS CEMENTS SOFTWARES (WORK STRUCUTRES)
LEDGERS: Is use to secure Journals and Ledgeral balances of a company. A ledger is a collection of 1) currency 2)calendar 3)charted of accounts 4) subledger accountsCurrency : For India - INR USA US-D And some other countries need conversion.Calendar: FISCAL TYPE: financial calendar 01-April to 31-March Its divided into Periods like months,quarterly ,weely ,yearly etc.,Subledger accounting: Accural (not yet pay) Cash
LEGAL ENTITY:
![Page 2: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/2.jpg)
Is a legal Bussiness purpose at this level we are goin to prepare INCOME TAX REPORTS., We need pan(perminant account number) for taxations, other use for internal banking task.OPERATING UNIT: Is a strategic Bussiness Unit.At this level we secure and partition sales and purchase transaction data.
How About a Close to Real Life Case Study?
Before we dive into this topic, let us draw a multi org structure on a whiteboard. It would help to analyze a real picture, as we pick at the concepts that go into designing a multi org structure.
The above is the organization structure for Office Smart Solutions, which is a major office supplies retailer, headquartered in Naperville, Illinois, USA. The organization operates in three countries – the US, Canada and India.
Office Smart has an organization structure with the following:
![Page 3: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/3.jpg)
2 Business Groups – one in the US, which controls the organization structure in North America, and one in India
3 Legal Entities – one in the US, one in Canada, and one in India
3 Primary Ledgers – one in the US, one in Canada, and one in India
3 Operating Units – one in the US, one in Canada, and one in India
5 Inventory organizations – two in the US, one in Canada, and two in India
Subinventories and locators exist beneath the inventory organizations, but they are not relevant for the session on multi org structures.
With this, let us step back and reflect…
TAKE THE SYSTEM ADMINISTRATOR RESPONSIIBILITY FOR DEFINING HRMS
![Page 4: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/4.jpg)
![Page 5: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/5.jpg)
XSWITCH RESPONSIBILITY AS SYSTEM ADMINISTRATOR
X
NAV: SECURITY RESPONSIBILITYDEFINE
![Page 6: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/6.jpg)
ASSIGN RESPONSIBILITY TO THE USER:NAV:SECURITYUSERDEFINE
![Page 7: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/7.jpg)
SELECT HRMS RESPONSIBILITY FOR DEFINING BUSSINESS GROUP:
![Page 8: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/8.jpg)
NAV:WORKSTRUCTUREORGANIZATIONDESCRIPTIONTAKE A NEW WINDOW FOR DEFINE BUSSINESS GROUP
![Page 9: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/9.jpg)
IN THE ABOVE FORM YOU SHOULD SAVE THE NAME,TYPE DEFINE AND SAVE.AFTER THAT COMES UNDER ORGANIZATION CLASSIFICATION IS BUSSINESS GROUP AND ENABLE IT AND SAVE.CLICK OTHERS TAB. SAVE AND CHOOSE BUSSINESS GROUP INFO OPTION SELECT.
![Page 10: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/10.jpg)
SAVE THIS.WHEN WE DEFINE A BUSSINESS GROUP SYSTEM INTERNALLY GENERATES A DEFALT SECURITY PROFILE.WITH THE SAME AS OUR BUSSINESS GROUP.
![Page 11: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/11.jpg)
THE DEFAULT SECURITY PROFILE WLL GIVE ACCESS TO ALL THE ORGANIZATIONS.DEFINE UNDERA A BUSSINESS GROUP.ALL THE ORGANIZATIONS COMES UNDER THE BUSSINESS GROUP.LIKE OPERATONG UNITS INVENTORY ORG HR ORG ETC.,
WE CAN ALSO DEFINE A NEW SECURITY PROFILE TO SECURE OUR OWN ORGANIZATIONS.
PLANNING BY LEDGER: 1.CURRENCY 2.CALENDERS 3.SUBLEDGER ACCOUNTING METHOD 4.CHARTED OF ACCOUNT
Create Acounting Calender:Define accounting Calender: Switch responsibility---->System Administrator First you should create responisibilty ex: tata gl ( calendar is comes under general ledger). Nav: securityresponisibilitydefine
![Page 12: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/12.jpg)
Define period types: Nav: setup financialcalendertypes Switch responsibility is general ledger
![Page 13: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/13.jpg)
Period type:tata ptYear type is not calendar.. that is fiscal . Fiscal ----financial calendar(April 01 to March 31)Calendar---- work day calendar (Jan to Dec)
Nav:setupfinancialcalenderaccounting
![Page 14: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/14.jpg)
Choose current option click
Calendar was completed.
Define Chart of Account:
Switch responsibility is GENERAL LEDGER(TATA GL)
NAV:SETPFINANCIALKEYSEGMENT
![Page 15: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/15.jpg)
SEARCH OPTION : SELECT GENERAL LEDGERAFTER YOU SHOULD GIVE YOUR NEW CHART OF ACCOUNT NAMETHEN GO FOR SEGMENTS.
Company ,branch ,account ,cost center,productIs a chart of account number ex: 01-00-00-1414-0001—company00—branch00—division or some other1410—accounting information00—product
![Page 16: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/16.jpg)
Click Value set option
![Page 17: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/17.jpg)
Highlight the cursor on company nameAnd click value set.
![Page 18: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/18.jpg)
Create value set name for company n format type n maximum size .In this way highlight coursor on division,
![Page 19: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/19.jpg)
Dept:
![Page 20: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/20.jpg)
Account:
![Page 21: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/21.jpg)
Now completed valusets for all .Then assign all names in chart of account previous list window ie.,
![Page 22: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/22.jpg)
Assign values set items to value set option under like tata company Tata div1 Tata dept1, Operation accountHere operations accounts is for account value set name.. bt I can not create any valuset name for account simply I created account value set is like Operations Account and enable all thing n save.
Flex Field Qualifiers:
Highlight the cursor on company n click on FLEX FIELD QUALIFIER
![Page 23: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/23.jpg)
Enable balancing segment for company.Similarly highlight account n click flex field qualifier Enable natural account segment
![Page 24: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/24.jpg)
After that Compile : Complie all the things.
![Page 25: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/25.jpg)
Click compile n enable freeze,allow dynamic inserts what you want like periods,dashes etc.,
![Page 26: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/26.jpg)
Compliling flexfield definition.Ok.Compile successfully:
![Page 27: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/27.jpg)
Key flex field values: Nav: keyflexfieldskeyvalues
![Page 28: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/28.jpg)
Assign application,title structure n comes under the value option choose Like 01 for company 02 for division 03 for department
![Page 29: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/29.jpg)
For department you should gve values in this way for all names like division,dept,account etc.,
![Page 30: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/30.jpg)
Chart of account part completed .
Created Accounting setupd: Accounting setups are the commn setups, to process.,
1) financial transactions2) financial applications
Switch responsibility is General ledger .Nav: setupfinancialaccountng setup manageraccountng setupClick on create accounting setupCreate Legal entityLegal Entity: Is a legal Bussiness at this level we prepare 1)Tax Reports 2)Maintain Interanal bank AccountsCreate Legal Entity:
![Page 31: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/31.jpg)
Click this
![Page 32: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/32.jpg)
![Page 33: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/33.jpg)
“Click apply option”Create another legal entity Same process
![Page 34: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/34.jpg)
Primary ledger:
Go for step 3 of 3 or 2 of 3 for finding the primary ledger
![Page 35: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/35.jpg)
![Page 36: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/36.jpg)
Click on finish button
![Page 37: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/37.jpg)
Click “Defining Options”Update here “ledger options”
![Page 38: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/38.jpg)
![Page 39: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/39.jpg)
Go direct step 2 of 4
![Page 40: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/40.jpg)
Assign retained Earnings Accounts ex: 01-00-00-1410 How can I assign reatained earnings accounts are
![Page 41: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/41.jpg)
Directly you can go step 4 of 4
![Page 42: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/42.jpg)
Click on to finish
![Page 43: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/43.jpg)
Click on yesGo to add legal entities
![Page 44: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/44.jpg)
Click on Apply
![Page 45: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/45.jpg)
Search “tata “Select all (tata motors,tatacars)Click applyUpdate balancing segment values for tata motors legal entitySelect 01 ,tata motorsStart date:Click on applySimilarly select update balancing segment values for tata cars legal entity
01 , tata carsHere only I have taken 2 legal entities. (tata motors,tata cars)Click on applyclick on complete
Confirm option after test all things in subledger accounting setups.
![Page 46: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/46.jpg)
OPERATING UNITS:Nav: setupfinancialsaccounting manageraccounting setups
![Page 47: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/47.jpg)
Click on update accounting options
Operating units update
![Page 48: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/48.jpg)
Click Add Operating Units
![Page 49: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/49.jpg)
![Page 50: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/50.jpg)
Operating Units:
ADD 2 OPERATING UNITS
![Page 51: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/51.jpg)
![Page 52: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/52.jpg)
How do we defne Operating Units to HRMS: Switch system administrator responsibility Nav: profilesystem
![Page 53: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/53.jpg)
Click find
![Page 54: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/54.jpg)
When we set HR security profile system internallygoing to set one more profile option that is HR Bussiness group. To associate to business group here that is tata group.
![Page 55: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/55.jpg)
HR;User type---------------HR WITH PAYROLL USER
![Page 56: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/56.jpg)
Take switch responsibility HRMSNAV: WORKSTRUCTUREORGANIZATIONSDESCRIPTON
![Page 57: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/57.jpg)
HRMS name tata consultancySaveOrganization classification isOPERATING UNIT ,ENABLE AND SAVEClick OthersOperating Unit information option choose OkSave
![Page 58: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/58.jpg)
Choose information click
![Page 59: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/59.jpg)
Assign all thing.. take ur own primary ledger(tata pl) default legal context(tata motors1)Operating Unit code (tata cons) Ok
Now,Defne Inventory Organization: Nav: work structureorganizationdescriptionSwitch HRMS RESPONSIBILITY
![Page 60: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/60.jpg)
ACCOUNTING INFORMATION:
![Page 61: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/61.jpg)
INVENTORY INFORMATION:
![Page 62: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/62.jpg)
![Page 63: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/63.jpg)
![Page 64: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/64.jpg)
RECEIVING OPTIONS:
Give values accounting information,delay time early time etc., save
![Page 65: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/65.jpg)
Define HR Organization:Same navigation n switch responsibilityNav:workstructureorganizatinDescription
![Page 66: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/66.jpg)
Assign name classification etc.,No need to go for others now.. bt just see the optionsAnd save
![Page 67: Oracle r12 multi org](https://reader033.vdocuments.us/reader033/viewer/2022061300/54c958ef4a7959127b8b4644/html5/thumbnails/67.jpg)
This is briefly about MULTI ORG