Search Results org_information4




Overview
Explore in AI Chat

Overview

APPS.HR_FR_ESTABLISHMENTS_V is a French localization view that presents establishment (établissement) records maintained against organization units in Oracle EBS Human Resources. It exposes the regulatory attributes required for French statutory reporting, including URSSAF registration data, ASSEDIC identifiers, and establishment classification information. The view is not a base table; it is a denormalized reporting construct that flattens the vertical key-flex structure of HR_ORGANIZATION_INFORMATION into horizontal columns. Organizations are only returned when they carry the CLASS context value FR_ETABLISSEMENT with ORG_INFORMATION2 set to 'Y', which is the flag that identifies a valid French establishment. Because the view pre-joins and pre-filters the descriptor contexts, it is commonly used as a source for BI Publisher reports, payroll and statutory extracts, and third-party integration files that require establishment-level identifiers. The view is read-only in practice; DBAs should treat it as a security and performance surface rather than an object to be modified. In 12.1.1 and 12.2.2 the definition is materially the same.

Underlying Base Objects

The ETRM metadata documents the following referenced objects: HR_ALL_ORGANIZATION_UNITS (synonym), HR_GENERAL (package), HR_LOCATIONS (view), and HR_ORGANIZATION_INFORMATION (synonym). The view text confirms five aliased instances of HR_ALL_ORGANIZATION_UNITS (OU1 through OU5) and five aliased instances of HR_ORGANIZATION_INFORMATION (OI1 through OI5). OU1 is the driving establishment row; OU2, OU3, and OU4 resolve parent or related organizations through the establishment information descriptors, while OU5 resolves the organization referenced by the ASSEDIC context. The join to HR_ORGANIZATION_INFORMATION is outer ((+)) for the FR_ESTAB_INFO, FR_ESTAB_URSSAF, FR_ESTAB_ASSEDIC, and FR_ESTAB_PREV_INFO contexts, but inner for the CLASS context. HR_LOCATIONS supplies LOCATION_CODE through a further outer join on LOCATION_ID. HR_GENERAL is referenced indirectly because HR_LOCATIONS and the organization unit views are built on top of it; it is not joined directly in the view text.
The descriptor contexts mapped by the view are FR_ESTAB_INFO (ORG_INFORMATION1-8), FR_ESTAB_URSSAF, FR_ESTAB_ASSEDIC, FR_ESTAB_PREV_INFO, and CLASS.

Key Columns

  • ORGANIZATION_ID, BUSINESS_GROUP_ID — primary identifier and business group of the establishment organization unit (OU1).
  • NAME — organization name from OU1; additional NAME columns are projected from OU2 through OU5.
  • DATE_FROM, DATE_TO — effective dates of the organization unit record.
  • LOCATION_ID, LOCATION_CODE — address identifier and its code from HR_LOCATIONS.
  • INTERNAL_ADDRESS_LINE, COMMENTS — free-form address and remarks from the organization unit.
  • OI1.ORG_INFORMATION1-8 — establishment detail flexfields, including the referenced parent organization in ORG_INFORMATION1.
  • OI2.ORG_INFORMATION1-4 — URSSAF context values; ORG_INFORMATION1 and ORG_INFORMATION4 resolve parent organizations.
  • OI3.ORG_INFORMATION1-2 — ASSEDIC context values.
  • OI4.ORG_INFORMATION1-4 — previous establishment information.
  • OI5.ORG_INFORMATION2, ORG_INFORMATION5 — remaining CLASS context values (the view filters ORG_INFORMATION1 = 'FR_ETABLISSEMENT' and ORG_INFORMATION2 = 'Y').

Common Use Cases and Queries

Typical uses include listing active French establishments for a business group, extracting URSSAF and ASSEDIC identifiers for statutory files, and validating that every establishment carries the CLASS flag. A representative query filtering on the establishment class value is shown below.

SELECT organization_id,
       name,
       location_code,
       org_information1   AS estab_info_1,
       org_information4   AS urssaf_ref
FROM   apps.hr_fr_establishments_v
WHERE  business_group_id = :p_business_group_id
ORDER  BY name;

The view is also joined to PER_ALL_PEOPLE_F or PAY assignment tables to attribute employees to the correct establishment for DSN-style reporting. Because HR_ORGANIZATION_INFORMATION is EAV, direct queries against the base table require pivoting; HR_FR_ESTABLISHMENTS_V eliminates that effort and should be preferred for read-only reporting.