How to Define Operating Unit in R12

 Define Operating Unit.

An organization that uses Oracle subledgers, such as Oracle Cash Management, Order Management and Shipping Execution, Oracle Payables, Oracle Purchasing, Oracle Receivables, and related products. It may be a sales office, a division, or a department. Operating units are not associated with legal entities. Operating units are assigned to ledgers and a default legal context. Information is secured by operating unit for these applications using responsibilities. Each user can access, process, and report on data only for the operating units assigned to the MO: Operating Unit or MO: Security Profile profile option. The MO: Operating Unit profile option only provides access to one operating unit. The MO: Security Profile provides access to multiple operating units from a single responsibility. You can define operating units from the Define Organization window in Oracle HRMS or from Accounting Setup Manager in General Ledger. For further reference: Visit Google.com and search for "Oracle Multiple Organization Manual". download the pdf file for detailed information on multiple ORG.
  



Prerequisites for defining operating unit:

 1. Define Location.
 2. Define Business Group.
 3. Define Ledger.


 Navigation: HRMS --> Work Structures --> Organization --> Description.

Click on New.

 


Type your operating unit name, type ,location and organization classification.

   
Click on Others.

Select operating unit information.

   

Enter the Primary Ledger name, Legal entity name and Operating unit short code
 

click on ok and then save.

Query :-

  SELECT   gls.short_name,
           gls.NAME newname,
           hou1.SHORT_CODE,
           hou.NAME,
           hou.INTERNAL_EXTERNAL_FLAG,
           hou.TYPE,
           hou.DATE_FROM,
           hou.DATE_TO,
           hoi.ORG_INFORMATION1_MEANING,
           hoi.ORG_INFORMATION2,
           hou.organization_id
    FROM   HR_ORGANIZATION_INFORMATION_V HOI,
           HR_ORGANIZATION_UNITS_V HOU,
           hr_all_organization_units hao,
           hr_operating_units hou1,
           gl_sets_of_books gls
   WHERE       HOU.ORGANIZATION_ID = HOI.organization_id
           AND HOU.ORGANIZATION_ID = hao.ORGANIZATION_ID
           AND hao.ORGANIZATION_ID = hou1.ORGANIZATION_ID
           AND hou1.set_of_books_id = gls.set_of_books_id
           AND hao.NAME = 'New Org V23'
           -- and hou.ORGANIZATION_ID =8924
           AND ('' IS NULL
                OR EXISTS
                     (SELECT   1
                        FROM   pay_restriction_values prv
                       WHERE       prv.customized_restriction_id = ''
                               AND prv.restriction_code = 'ORG_CLASS'
                               AND (HOI.org_information_context = 'CLASS'/*AND prv.VALUE = HOI.org_information1*/
                                                                         )))
           AND (HOI.ORG_INFORMATION_CONTEXT = 'CLASS')
/* AND (HOI.ORGANIZATION_ID = :DISPOSITION_ID2)*/
ORDER BY   HOI.org_information1_meaning