Search Results hr_organization_information_v1




Overview
Explore in AI Chat

Overview

HR_ORGANIZATION_INFORMATION_V1 is a German-localization reporting view owned by the APPS schema in Oracle E-Business Suite. It is delivered by the PER (Human Resources) product and exposes organization-level legislative information stored in the flexible key-flex structure of Oracle HRMS. Specifically, the view filters the base organization information table to the context DE_HR_ORG_INFO, which is the German HR organization information descriptive flexfield context. Its purpose is to present a curated, denormalized result set in which German statutory employer attributes are surfaced with resolved lookup meanings and derived tax office details, so that concurrent programs, forms, reports, and integrations do not need to re-implement the join and decode logic themselves.

The object is defined as a VIEW with a status of VALID in both Oracle EBS 12.1.1 and 12.2.2. Because it is a view rather than a table, it carries no independent storage; all data is read at runtime from the underlying HR organization information entity.

Underlying Base Objects

The documented base objects referenced by the view are:

The join to HR_ORGANIZATION_INFORMATION is a standard equijoin, while the lookup and session joins are outer joins, ensuring that rows remain visible even when no matching lookup code or session row exists.

Key Columns

Common Use Cases and Queries

Typical uses include German payroll and statutory reporting, HRMS extracts for tax and social insurance interfaces, and validation screens that need decoded organization information. A representative query is:

  • SELECT organization_id, org_information6_meaning, org_information7 FROM hr_organization_information_v1 WHERE organization_id = :p_org_id;
  • SELECT o.name, v.org_information1, v.org_information6_meaning FROM hr_organization_information_v1 v, hr_all_organization_units o WHERE v.organization_id = o.organization_id;

Because the view depends on FND_SESSIONS and USERENV('SESSIONID'), queries should be executed within an initialized EBS session; direct database or SQL*Plus access without a valid session may return no rows.