Search Results per_information1




Overview
Explore in AI Chat

Overview

POS_PER_PEOPLE_X_V is a public APPS view in the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, owned by the APPS schema and associated with the Purchasing (PO) product family. It exposes person-level records sourced from the Oracle Human Resources foundation layer and presents them through a Purchasing-specific lens. The suffix "_X_V" indicates that the view maps to the dated, non-translated extension logical entity PER_PEOPLE_X rather than the base PER_PEOPLE table. Its primary role is to give Purchasing module components, including supplier registration, contingent worker onboarding, and procurement-facing person lookups, a stabilized interface to HR person data without requiring those components to query HR tables directly.

The view is frequently referenced in reporting and integration scenarios where applicant and employee identity must be reconciled against purchasing documents such as requisitions, purchase orders, and supplier records.

Underlying Base Objects

The documented definition of POS_PER_PEOPLE_X_V is a straightforward projection over PER_PEOPLE_X, the dated extension view on the PER_PEOPLE base table. The metadata identifies the following referenced base objects: HR_GENERAL (PACKAGE), HR_PERSON_NAME (PACKAGE), HR_SECURITY (PACKAGE), and PER_PEOPLE_X (VIEW). These packages are constituent parts of the HR foundation that supplies security, name formatting, and general person utilities; PER_PEOPLE_X is the direct source from which every column is selected.

Because the view is defined over PER_PEOPLE_X (itself a dated view), it inherits date-tracked semantics for attributes such as EFFECTIVE_START_DATE and EFFECTIVE_END_DATE, and it carries the denormalized DFF attribute set (ATTRIBUTE1 through ATTRIBUTE30) and the PER_INFORMATION1 through PER_INFORMATION20 flexfield segments. The view adds no joins of its own; it is a thin, read-only wrapper whose column list matches its parent exactly.

Key Columns

APPLICANT_NUMBER is the column most relevant to the user's search. In Oracle HRMS it holds the applicant tracking number assigned to a person who is registered as an applicant rather than an employee. Related control flags include CURRENT_APPLICANT_FLAG, CURRENT_EMPLOYEE_FLAG, and CURRENT_EMP_OR_APL_FLAG, which together indicate the person's current status. Identity columns embrace PERSON_ID, BUSINESS_GROUP_ID, PERSON_TYPE_ID, FIRST_NAME, MIDDLE_NAMES, LAST_NAME, FULL_NAME, KNOWN_AS, PREVIOUS_LAST_NAME, and the formatted name generated by HR_PERSON_NAME.

Common Use Cases and Queries

Typical usage involves resolving an applicant or employee identity when processing purchasing transactions, validating supplier contacts, and building HRMS-to-Purchasing reconciliation reports. Because HR_SECURITY participates in the underlying stack, row-level access is governed by the security profile of the querying user, so results vary by responsibility.

To locate a person by applicant number:

  • SELECT person_id, full_name, applicant_number, current_applicant_flag FROM apps.pos_per_people_x_v WHERE applicant_number = :p_applicant_number;

To list active applicants within a business group:

  • SELECT applicant_number, full_name, email_address FROM apps.pos_per_people_x_v WHERE business_group_id = :p_bg AND current_applicant_flag = 'Y';

To link persons to suppliers:

  • SELECT p.person_id, p.full_name, p.vendor_id FROM apps.pos_per_people_x_v p WHERE p.vendor_id IS NOT NULL;