link between legal entity and operating unit in oracle apps

Link between legal entity and operating unit in oracle apps

In this post , We will be discussing about the link between legal entity and operating unit in oracle apps. As per the Organization structure in Oracle apps, Legal entity comes second from top and operating unit comes fourth from top. Both Legal entity and operating unit links with each other using GL ledger. After creating legal entity, we do create the GL Ledger under legal entity. Operating Unit, we do create Under the Ledgers in oracle apps. In Oracle apps, there is no direct link between the legal entity and operating unit. In this post, I will share the SQL table link between legal entity and operating unit. Please find below the detail information about link between legal entity and operating unit in oracle apps.

Organization Structural link between legal entity and operating unit in oracle apps

Important tables to link between legal entity and operating unit in oracle apps

1.XLE_ENTITY_PROFILES

2.XLE_REGISTRATIONS

3.HR_LOCATIONS_ALL

4.GL_LEDGERS

5.HR_OPERATING_UNITS

Detail SQL query to Extract legal entity and operating unit information using link between legal entity and operating unit in oracle apps

select

  LEP.LEGAL_ENTITY_ID,

  LEP.name LEGAL_ENTITY,

  gl.name ledger_name,

  HRO.name OU_NAME

from apps.XLE_ENTITY_PROFILES LEP,

  apps.XLE_REGISTRATIONS REG,

  apps.HR_LOCATIONS_ALL HRL,

  apps.gl_ledgers gl,

  apps.HR_OPERATING_UNITS HRO

where LEP.TRANSACTING_ENTITY_FLAG      = 'Y'

and LEP.LEGAL_ENTITY_ID                = REG.SOURCE_ID

and REG.SOURCE_TABLE                   = 'XLE_ENTITY_PROFILES'

and HRL.LOCATION_ID                    = REG.LOCATION_ID

and REG.IDENTIFYING_FLAG               = 'Y'

and HRO.SET_OF_BOOKS_ID=GL.LEDGER_ID

and LEP.LEGAL_ENTITY_ID                = HRO.DEFAULT_LEGAL_CONTEXT_ID