MULT-ORG ACCESS CONTROL (FULL SETUPS)
------------------------------------------------------------

/*****************************************MULTI-ORG Implementation********************************************/
*****************
12:21 PM 8/17/2013
*****************
/*****************************************Create User/Responsibility********************************************/
1.Create Responsibility:
-------------------------
N:-System Administrator->Security->Responsibility->Define
Table:-FND_RESPONSIBILITY_TL
2.Create User in Oracle Apps:
--------------------------------
N:-System Administrator->Security->User->Define
Table:- FND_USER
3.Assign Resposibility to Own User:
--------------------------------------
Table:-FND_USER,FND_RESPONSIBILITY_TL,FND_USER_RESP_GROUPS
/*****************************************Create Set Of Books/Ledger********************************************/
1.Create Calendar:
-------------------
N:-HIL General Ledger Custom Super User->Setup->Financials->Calendars->Types
Table:-SELECT * FROM GL_PERIOD_TYPES
           WHERE USER_PERIOD_TYPE LIKE 'HIL%'
2.Create Accounting:
----------------------
N:-HIL General Ledger Custom Super User->Setup->Financials->Calendars->Accounting
Table:-SELECT * FROM GL_PERIODS
           WHERE PERIOD_SET_NAME LIKE 'HIL%'
Run Program:- Other - Calendar Validation Report (For Validation of Periods)
N:-View->Request->Submit a New Request
3.Create Currency: (Take Predefine Currency)
--------------------
N:-HIL General Ledger Custom Super User->Setup->Currencies->Define
Table:-FND_CURRENCIES
4.Create Chart of Account:
----------------------------
N:-HIL General Ledger Custom Super User->Setup->Financials->Flexfields->Key->Segments
Table:-FND_ID_FLEX_STRUCTURES,FND_ID_FLEX_SEGMENTS
           GL_CODE_COMBINATIONS_KFV
5.Create Set Of Books/Ledger:
---------------------------------
N:-HIL General Ledger Custom Super User->Setup->Financials->Accounting Setup Manager->Accounting Setups
Click on Create Accounting Setup
/******************************************Create Legal Entity***************************************************/
Click on Create Legal Entity
Check on Create New Address
Apply
Click on Add Another Row
HIL LE (Renukoot)
Next
Table:-HR_LOCATIONS
/******************************************Create Ledger*******************************************************/
Primary Ledger:
-----------------
File
Name                      Chart of A/C    Accounting Calendar      Currency   Subledger Accounting Method
------                     ---------------   ---------------------      ----------   --------------------------------
HIL Ledger (INR)      HILCOA           HIL AC                        INR           Standard Accural
Next->Finish
Recompile the Chart of Account
Again Goto Accounting Setup
Click on Update Accounting Options
Click on Update
Retained Earning Account:01.000.3310
Next->Next->Finish->Complete->Yes
Table:-GL_LEDGERS
Assign The Ledger To Responsibility
N:-System Administrator->Profile->System
Responsibility:HIL General Ledger Custom Super User
Profile:GL Ledger Name
Find
Select Ledger:HIL Ledger (INR)
Seve
***Program name :Open Period
N:-HIL General Ledger Custom Super User->Setup->Open/Close
Run Program:-Open Period
After Run Program-Show All Period Which is open
/******************************************Create Business Group*************************************************/
Make this resp. HIL Human Resources Custom Super User as HR User Type
N:-System Administrator->Profile->System
Resp:-HIL Human Resources Custom Super User
Profile:-HR:User Type :-(Find)
Select Responsibility Lable:-HR User
Save
1.Create Business Location
N:-HIL Human Resources Custom Super User->Work Structures->Location
Table:-HR_LOCATIONS
2.Create Business Group
N:-HIL Human Resources Custom Super User->Work Structures->Organization->Description
Name:HIL BG
Select Location
Save
Select Organization classifications Name:-Business Group       Tick on Enabled
Save
Click on  Others
Select ( *Business Group Info.)
Select Organization classifications Name:-HR Organization       Tick on Enabled
Save
Table:-PER_BUSINESS_GROUPS
Assign B.G. to the Responsibility:-
-----------------------------------
N:-System Administrator->Profile->System
Resp:-HIL Human Resources Custom Super User
Profile:-HR:Business Group
Find
Select :- HIL BG (Under Responsibility Lable)
Save
Press F11
N:-System Administrator->Profile->System
Resp:-HIL Human Resources Custom Super User
Profile:-HR: Security Profile
Find
Select :- HIL BG (Under Responsibility Lable)
Save
Press F11
N:-System Administrator->Profile->System
Resp:-HIL Human Resources Custom Super User
Profile:-MO: Security Profile--optional
Find
Select :- HIL BG (Under Responsibility Lable)
Save
/*********************************************Create Operating Units*********************************************/
1.Create Operating Unit Location
N:-HIL Human Resources Custom Super User->Work Structures->Location
Table:-HR_LOCATIONS
2.Create Operating Unit
N:-HIL Human Resources Custom Super User->Work Structures->Organization->Description
Name:HIL OU-RKT
Select Location
Save
Select Organization classifications Name:-Operating Unit        Tick on Enabled
Save
Click on  Others
Select ( *Operating Unit Information)
Table:-HR_OPERATING_UNITS
Assign O.U. to the Responsibility:-
-----------------------------------
N:-System Administrator->Profile->System
Resp:-HIL Purchasing Custom Super User
Profile:-MO: Operating Unit
Find
Select :- HIL OU-RKT (Under Responsibility Lable)
Save
/******************************************Create Master/Child Inventory Location**********************************/
For Master Inventory Location
---------------------------------
N:-HIL Human Resources Custom Super User->Work Structures->Location
Name:-HIL MI (RKT)
For Child Inventory Location
------------------------------
N:-HIL Human Resources Custom Super User->Work Structures->Location
Name:- HIL CI (Kanoria)
N:-HIL Human Resources Custom Super User->Work Structures->Location
Name:- HIL CI (Renusagar)
Table:-HR_LOCATIONS
/******************************************Create Master Inv. Organization****************************************/
1.Create Workday Calendar
N:-HIL Inventory Custom Super User->Organizations->Calendars
Name:- HIL IC-----Hindalco Inventory Calendar
Table:-BOM_CALENDARS
Click On Shift
Shift Num                Description
           1                   Day Shift
Table:-BOM_CALENDAR_SHIFTS
Click on Workday Pattern
Seq            On                             Off                   Descriptions
1  6                               1                       6 Working days
Table:-BOM_WORKDAY_PATTERNS
Save
Open Shift Times Window
Start                        Stop
09:00:00                 18:00:00
Table:-BOM_SHIFT_TIMES
Save
Go to Tools->Builds   (Assign Workday Pattern Seq On and Off )
Click on Workday Pattern
Seq            On                             Off                   Descriptions
1  6                               1                       6 Working days
Go to Tools->Builds
Run Program Automatic
Program Name:-Build Workday Calendar
2.Create Master Inventory Organization
-------------------------------------------
N:-HIL Human Resources Custom Super User->Work Structures->Organization->Description
Name:- HIL MI
Select Location
Save
Select Organization Classifications Name
                          Inventory Organization                                Tick on Enabled
Save
Click on Others
Select Accounting Information
Save
Click on Others
Select Inventory Information
Fill Inventory Parameters
Organization Code:-HM
Item Master Organization: HIL MI
Calendar:- HIL IC
Click On Costing Information
Costing Method:- Standard
Click on
Material                   :  01.000.1410
Outside Processing    :   01.000.1450
Material Overhead    :   01.000.1420
Overhead                  :   01.000.1430
Resource                   :   01.000.1440
Expense                    :    01.000.2225--Purchasing Goods-PO Form
Click On Revision, Lot,Serial And LPN
Starting Revision : 1
Prefix                 : S
Starting Serial Number: 1
Click On Other Accounts
Purchase Price Variance : 01.000.5210
Invoice Price Variance : 01.000.5220
Inventory AP Accrual : 01.000.2929

Sales  : 01.000.5110
Cost of Goods Sold  : 01.000.5200

Deferred COGS Account : 01.000.1415
Save
Click On Others
Select Receiving Information
Receipt Days Early : 0
Receipt Days Late   : 0
Over Receipt Tolerance (%) : 0
Receipt Routing : Standard Receipt
Next Receipt Number : 1001
Receiving Inventory Account : 01.000.1410
Clearing Account : 01.000.1250
Save
Table:-ORG_ORGANIZATION_DEFINITIONS,MTL_PARAMETERS

3.Create Two Child Inventory Organization
For HIL CI (Kanoria)
----------------------
N:-HIL Human Resources Custom Super User->Work Structures->Organization->Description
Name:- HIL CI (Kanoria)
Select Location
Save
Select Organization Classifications Name
                          Inventory Organization                                Tick on Enabled
Save
Click on Others
Select Accounting Information
Save
Click on Others
Select Inventory Information
Fill Inventory Parameters
Organization Code:-HCK
Item Master Organization: HIL MI
Calendar:- HIL IC
Click On Costing Information
Costing Method:- Standard
Click on
Material                   :  01.000.1410
Outside Processing    :   01.000.1450
Material Overhead    :   01.000.1420
Overhead                  :   01.000.1430
Resource                   :   01.000.1440
Expense                    :    01.000.2225
Click On Revision, Lot,Serial And LPN
Starting Revision : 1
Prefix                 : S
Starting Serial Number: 1
Click On Other Accounts
Purchase Price Variance : 01.000.5210
Invoice Price Variance : 01.000.5220
Inventory AP Accrual : 01.000.2929

Sales  : 01.000.5110
Cost of Goods Sold  : 01.000.5200

Deferred COGS Account : 01.000.1415
Save
Click On Others
Select Receiving Information
Receipt Days Early : 0
Receipt Days Late   : 0
Over Receipt Tolerance (%) : 0
Receipt Routing : Standard Receipt
Next Receipt Number : 1001
Receiving Inventory Account : 01.000.1410
Clearing Account : 01.000.1250
Save
Table:-ORG_ORGANIZATION_DEFINITIONS,MTL_PARAMETERS

For HIL CI (Renusagar)
-------------------------
N:-HIL Human Resources Custom Super User->Work Structures->Organization->Description
Name:- HIL CI (Renusagar)
Select Location
Save
Select Organization Classifications Name
                          Inventory Organization                                Tick on Enabled
Save
Click on Others
Select Accounting Information
Save
Click on Others
Select Inventory Information
Fill Inventory Parameters
Organization Code:-HCR
Item Master Organization: HIL MI
Calendar:- HIL IC
Click On Costing Information
Costing Method:- Standard
Click on
Material                   :  01.000.1410
Outside Processing    :   01.000.1450
Material Overhead    :   01.000.1420
Overhead                  :   01.000.1430
Resource                   :   01.000.1440
Expense                    :    01.000.2225
Click On Revision, Lot,Serial And LPN
Starting Revision : 1
Prefix                 : S
Starting Serial Number: 1
Click On Other Accounts
Purchase Price Variance : 01.000.5210
Invoice Price Variance : 01.000.5220
Inventory AP Accrual : 01.000.2929

Sales  : 01.000.5110
Cost of Goods Sold  : 01.000.5200

Deferred COGS Account : 01.000.1415
Save
Click On Others
Select Receiving Information
Receipt Days Early : 0
Receipt Days Late   : 0
Over Receipt Tolerance (%) : 0
Receipt Routing : Standard Receipt
Next Receipt Number : 1001
Receiving Inventory Account : 01.000.1410
Clearing Account : 01.000.1250
Save
Table:-ORG_ORGANIZATION_DEFINITIONS,MTL_PARAMETERS

/*************************************Purchasing Modules Setup***************************************************/
Define Financial Options
--------------------------
N:-HIL Purchasing Custom Super User->Organizations->Financial Options
Future Periods : 1
Liability :                      01.000.2210
Prepayment :                  01.000.1340
Bills Payable :                01.000.2580
Discount Taken :            01.000.7825
PO Rate Variance Gain : 01.000.7842
PO Rate Variance Loss : 01.000.7844
Expenses Clearing :        01.000.1110
Miscellaneous :              01.000.7740
Click On Supplier-Purchasing
Ship-to Location : HIL CI (Kanoria)
Bill-to Location   : HIL CI (Kanoria)
Inventory Organization : HCK-HIL CI (Kanoria)
Click on Human Resources
Business Group : HIL BG
Expense Reimbursement Address : Office
Tick on Use Approval Hierarchies
Define Purchasing Options:
----------------------------
N:-HIL Purchasing Custom Super User->Organizations->Purchasing Options
There is not Shown any Documentation Options.
Swith Resp: System Administrator
View->Request->Submit a New Request
Program Name : Replicate Seed Data
Parameter-
Operating Units: HIL OU-RKT
Submit->No
Find
Again
N:-HIL Purchasing Custom Super User->Organizations->Purchasing Options
Document Numbering:
----------------------
Document                         Entry              Type                 Next Number
-------------------            ----------         --------------   ------------------
RFQ Number                   Automatic        Alphanumaric     3001
Quotation Number           Automatic        Alphanumaric     3001
PO Number                     Automatic        Alphanumaric     3001
Requisition Number         Automatic        Alphanumaric     3001

Price Tolerance (%) : 0
Price Tolerance Amount (INR) : 0.00
Requisition Import Group-By : All
Line Type : Goods
Rate Type : Corporate
Price Type : Variable
Expense AP Accrual Account : 01.000.2210

***Must be Opened the period in Purchasing Modules:
N:-HIL Purchasing Custom Super User->Change Organization
N:-HIL Purchasing Custom Super User->Setup->Financials->Accounting->Control Purchasing Periods
Just Open Period->Save

***Must be Opened the period in Inventory Modules:
N:-HIL Inventory Custom Super User->Change Organization
N:-HIL Inventory Custom Super User->Accounting Close Cycle->Inventory Accounting Periods
Select Period whatever want to Open->Click on Change Status

/*********************************************************END MUTLI-ORG SETUP***************************************************************/


MOAC
----


Multi Org difference between 11i and R12
The difference in multi-org in 11i and R12 is "MOAC" concept(Multi-Org Access Control)

In R12 we have a feature call MOAC(Multi-Org Access Control) which allows the user to submit requests, enter, view and access data of different Operating Unit without having to switch between responsibilities.

Profile Options:

MO: Operating Unit - It will restrict the access through responsibility to only one Operating Unit

MO: Security Profile - It enables the user to get access on more than one Operating Unit by defining a security profile with Multiple Operating Unit and assigning it to the responsibility (If MO: Security Profile is set, then MO: Operating Unit is ignored by the system)

MO: Default Operating Unit - It is used when we have more than one OU attached to a responsibility through security profile, among WHICH you want a particular OU to be defaulted during transaction entry stages. When the responsibility is assigned with only one OU then that will become the default OU, without setting the profile option MO: Default Operating Unit





/************************************************************************************************************************/