Results for “org_information1”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

HR_H2PI_ORGANIZATION_CLASS_V is a seeded, read-only database view owned by the APPS schema in Oracle E-Business Suite, delivered under the PER (Human Resources) product family. Its documented purpose is to expose data related to the Oracle HR to Oracle Payroll Interface (H2PI) for organization classes. The H2PI process transfers organization and assignment information between Oracle HRMS and external or third-party payroll systems, and this view supplies the organization classification data that the interface consumes when building its extraction. In Oracle EBS 12.1.1 and 12.2.2 the object is delivered with a status of VALID and is not intended for end-user maintenance; it is a query-only construct used by interface logic and by reporting against organization classification information.

Underlying Base Objects

According to the documented view text, the view is defined over two base objects: HR_ALL_ORGANIZATION_UNITS (exposed via a synonym) and HR_ORGANIZATION_INFORMATION (also exposed via a synonym). The two are joined on ORGANIZATION_ID. HR_ALL_ORGANIZATION_UNITS supplies the organization identity and the owning business group, while HR_ORGANIZATION_INFORMATION stores the flexible, context-driven descriptive flexfield rows attached to each organization. The join is deliberately narrow: it retains only rows where ORG_INFORMATION_CONTEXT equals 'CLASS' and ORG_INFORMATION1 equals 'HR_ORG'. In other words, the view filters HR_ORGANIZATION_INFORMATION down to the organization classification flexfield entries whose first segment carries the HR_ORG classification value, then pairs them with the corresponding organization unit record.

Key Columns

The view projects a compact set of columns from the joined rows:

• LAST_UPDATE_DATE — the last modification date of the underlying HR_ORGANIZATION_INFORMATION row, commonly used for incremental extraction and audit.
• BUSINESS_GROUP_ID — the business group that owns the organization, sourced from HR_ALL_ORGANIZATION_UNITS; it is the primary partitioning key in multi-business-group HRMS installations.
• ORG_INFORMATION_ID — the surrogate primary key of the HR_ORGANIZATION_INFORMATION record, uniquely identifying the classification flexfield row.
• ORGANIZATION_ID — the organization unit identifier, the join key linking classification data back to HR_ALL_ORGANIZATION_UNITS.
• ORG_INFORMATION_CONTEXT — the flexfield context; in this view it is always 'CLASS', indicating the row represents an organization classification.
• ORG_INFORMATION1 — the first classification segment, filtered to the literal value 'HR_ORG' by the view definition.
• ORG_INFORMATION2 — the second classification segment, typically carrying the specific classification value associated with the organization.

Common Use Cases and Queries

The view is most often used to verify which organizations carry the HR_ORG classification, to reconcile H2PI extraction contents, and to drive custom reports that require classified organizations without re-implementing the flexfield filter logic. A typical query lists all classified organizations for a business group:

SELECT organization_id, business_group_id, org_information1, org_information2 FROM apps.hr_h2pi_organization_class_v WHERE business_group_id = :p_business_group_id;

For incremental interface processing, the LAST_UPDATE_DATE column supports a watermark query:

SELECT organization_id, org_information_id, org_information2 FROM apps.hr_h2pi_organization_class_v WHERE last_update_date >= :p_last_run_date ORDER BY last_update_date;

Because the view hard-codes the 'CLASS' context and the 'HR_ORG' value, users should not expect it to return other organization information contexts; queries requiring those contexts must access HR_ORGANIZATION_INFORMATION directly. All access should be performed through the APPS schema, respecting the standard EBS security and business group access model.