Results for “org_information9”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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:
- HR_ORGANIZATION_INFORMATION (SYNONYM) — the primary source of rows. All 20 ORG_INFORMATIONn segments and the standard WHO columns originate here.
- HR_LOOKUPS (VIEW) — outer-joined on ORG_INFORMATION6 with LOOKUP_TYPE = 'YES_NO' to translate the stored code into a user-facing MEANING.
- FND_SESSIONS (SYNONYM) — joined on SESSION_ID = USERENV('SESSIONID'), used to enforce the current application session context.
- HR_DE_GENERAL (PACKAGE) — supplies GET_TAX_OFFICE_DETAILS, invoked to decompose the tax office identifier held in ORG_INFORMATION7.
- HR_API (PACKAGE) — referenced by the view definition metadata as part of the HRMS programmatic surface.
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
- ORG_INFORMATION_ID — primary identifier of the organization information row.
- ORGANIZATION_ID — the organization to which the German information applies.
- ORG_INFORMATION_CONTEXT — always
DE_HR_ORG_INFOdue to the view predicate. - ORG_INFORMATION6_MEANING — the decoded YES/NO meaning derived from HR_LOOKUPS.
- ORG_INFORMATION7 — cast to NUMBER and passed to HR_DE_GENERAL.GET_TAX_OFFICE_DETAILS; the returned string is split into a four-character tax office code and a secondary 240-character detail segment.
- ORG_INFORMATION1–20 — the remaining German statutory attributes (for example tax and social insurance identifiers).
- ROW_ID, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — audit and concurrent program lineage.
- ATTRIBUTE1–20, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, OBJECT_VERSION_NUMBER — standard descriptive flexfield and WHO/versioning 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.
-
German HR Organization information view for ORG_INFORMATION_CONTEXT = 'DE_HR_ORG_INFO'
APPS.HR_ORGANIZATION_INFORMATION_V1·↳ FND_SESSIONS·↳ HR_API·↳ HR_DE_GENERAL·Explore PER module →
-
This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to organization info while data upload is in progress.
-
This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to organization info while data upload is in progress.
-
Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for organization info
APPS.HR_H2PI_ORGANIZATION_INFO_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_INFORMATION·↳ HR_ORGANIZATION_UNITS·Explore PER module →
-
No longer used
APPS.OE_HR_ORGANIZATION_INFO_V·↳ HR_ORGANIZATION_INFORMATION·Explore ONT module →
-
Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for organization info
APPS.HR_H2PI_ORGANIZATION_INFO_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_INFORMATION·↳ HR_ORGANIZATION_UNITS·Explore PER module →
-
Additional attributes of an organization, dependent on class or organization information type.
-
View: HR_DM_EXP_ORG_INFO_V 12.2.2
View to export hr_organization_information
APPS.HR_DM_EXP_ORG_INFO_V·↳ HR_DM_EXP_IMPS·Explore PER module →
-
German HR Organization information view for ORG_INFORMATION_CONTEXT = 'DE_HR_ORG_INFO'
APPS.HR_ORGANIZATION_INFORMATION_V1·↳ FND_GLOBAL·↳ FND_SESSIONS·↳ HR_API·Explore PER module →
-
Additional attributes of an organization, dependent on class or organization information type.
-
Used to support user interface
APPS.HR_ORGANIZATION_INFORMATION_V·↳ FND_GLOBAL·↳ HR_API·↳ HR_LOOKUPS·Explore PER module →
-
No longer used
APPS.OE_HR_ORGANIZATION_INFO_V·↳ HR_ORGANIZATION_INFORMATION·Explore ONT module →
-
View: HR_DM_EXP_ORG_INFO_V 12.1.1
View to export hr_organization_information
APPS.HR_DM_EXP_ORG_INFO_V·↳ HR_DM_EXP_IMPS·Explore PER module →
-
Used to support user interface
APPS.HR_ORGANIZATION_INFORMATION_V·↳ HR_API·↳ HR_LOOKUPS·↳ HR_ORGANIZATION_INFORMATION·Explore PER module →
-
VIEW: APPS.HR_CA_TAX_UNITS_V 12.1.1
-
VIEW: APPS.HR_CA_TAX_UNITS_V 12.2.2