Search Results pa_resource_utils




Overview
Explore in AI Chat

Overview

APPS.PA_EMPLOYEES is a VALID Oracle E-Business Suite internal database view owned by the APPS schema. It is registered under the FND Design Data identifier PA.PA_EMPLOYEES and is flagged in Oracle's Enterprise Technical Reference Manual (ETRM) as Oracle Internal Use Only. This classification means the object is not publicly supported for direct customer access; it may only be referenced through standard Oracle Applications programs. In practice, the view functions as a Projects (PA) module abstraction layer over Oracle Human Resources person data, exposing employee records in the specific shape required by Projects costing, budgeting, billing, and resource management logic. Because the caller searched for "pa_resource_utils," PA_EMPLOYEES is most relevant as one of the underlying data sources consumed by the resource-management utility packages that resolve people to project resources.

Its view type is Internal, indicating it is not a multi-org or secure-top view but rather a filtered projection over HR person entities.

Underlying Base Objects

The view's dependency chain confirms that PA_EMPLOYEES is a thin projection built on Oracle Human Resources foundations rather than on Projects-owned tables. Documented referenced base objects include:

Because HR_SECURITY participates in the definition, the view inherits HR security profile behavior, meaning returned rows are constrained by the querying user's security profile rather than exposing all persons globally.

Key Columns

  • PERSON_ID (NUMBER, 10) — primary identifier of the HR person; the join key to project resource, assignment, and expenditure tables.
  • FULL_NAME (VARCHAR2, 240) — formatted display name.
  • EMPLOYEE_NUMBER (VARCHAR2, 30) — the person's employee number as held in HR.
  • LAST_NAME, FIRST_NAME, MIDDLE_NAMES — individual name components.
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-effective validity window inherited from PER_PEOPLE_F.
  • BUSINESS_GROUP_ID (NUMBER, 15) — HR business group owning the person record.
  • VENDOR_ID (NUMBER, 15) — supplier reference where the person is also an expense or payables vendor (relevant to expense check routing).
  • EXPENSE_CHECK_SEND_TO_ADDRESS (VARCHAR2, 30) — expense check destination indicator.
  • ACTIVE (VARCHAR2, 30) — active/inactive status used for resource validity.
  • PERSON_TYPE (VARCHAR2, 30) — HR person type (employee, applicant, contingent worker, etc.).

Common Use Cases and Queries

The view is referenced by numerous Projects and Grants objects, including PA_AGREEMENT_CORE, PA_BILLING_SETUP_UTILS, PA_BILL_WORKBENCH_INVOICE, PA_BUDGET_ACCOUNT_PKG, PA_BUDGET_WF, PA_CC_BL_CUR_SEL_V, PA_COST_DIST_OVERRIDES_V, PA_EXPENDITURE_HISTORY_V, PA_HR_UPDATE_PA_ENTITIES, PA_EMPLOYEES_RES_V, and PA_KEY, as well as GMS_EMPLOYEES and GMS_AWARD_PVT in Grants. It is consequently used to resolve person identifiers into names for billing, budgeting, cost distribution, and award reporting.

A typical lookup retrieves active employees for a business group:

SELECT person_id, full_name, employee_number, person_type
FROM apps.pa_employees
WHERE active = 'Y' AND business_group_id = :p_bg_id;

A join-style use resolves a project resource to a display name:

SELECT e.person_id, e.full_name, e.employee_number
FROM apps.pa_employees e
WHERE e.person_id IN (:p_person_ids);

Because the object is marked Oracle Internal Use Only, custom code should avoid direct dependency; supported alternatives such as public HR people views or the Projects resource APIs are preferable wherever they satisfy the requirement.