Results for “pa_non_labor_resources”

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

Overview

PA_NON_LABOR_RESOURCES is a foundational Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores non-labor assets utilized during project work. These assets include equipment, machinery, vehicles, and other billable or costed resources that are not people. The table functions as the master definition repository for non-labor resources, capturing the identifying name, the associated expenditure type, and effective dating information that governs when a resource is available for use on projects.

From a data modeling perspective, the heuristic Data Vault classification for this table is hub. This reflects its role as a central entity table that holds the unique business key (NON_LABOR_RESOURCE) around which numerous dependent satellites and link tables are organized. Non-labor resources defined here are consumed across costing, billing, resource assignment, retention, and transaction control processes throughout the Projects suite.

Key Information Stored

The table contains 28 documented columns. The most significant are:

• NON_LABOR_RESOURCE — The business key and primary unique identifier name of the non-labor resource. Enforced by the unique index PA_NON_LABOR_RESOURCES_U1 and serving as the table's primary key via PA_NON_LABOR_RESOURCES_PK.
• NON_LABOR_RESOURCE_ID — A surrogate identifier column, enforced by the unique index PA_NON_LABOR_RESOURCES_U2, providing an alternate unique key reference.
• EXPENDITURE_TYPE — Foreign key to PA_EXPENDITURE_TYPES, defining the expenditure classification applied to transactions involving this resource.
• EQUIPMENT_RESOURCE_FLAG — Indicates whether the non-labor resource is treated specifically as an equipment resource.
• START_DATE_ACTIVE and END_DATE_ACTIVE — Effective dating that controls the period during which the resource is active and available for project use.
• DESCRIPTION — Free-text description of the resource.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The standard Oracle EBS flexible attribute columns supporting descriptive flexfields for customer-specific extensions.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns tracking who created and last modified each record.

Common Use Cases and Queries

Non-labor resources are queried extensively for costing, billing, and resource management reporting. A typical lookup retrieves active resources with their expenditure types:

SELECT nl.NON_LABOR_RESOURCE, nl.DESCRIPTION, nl.EXPENDITURE_TYPE, nl.START_DATE_ACTIVE, nl.END_DATE_ACTIVE FROM PA.PA_NON_LABOR_RESOURCES nl WHERE SYSDATE BETWEEN NVL(nl.START_DATE_ACTIVE, SYSDATE) AND NVL(nl.END_DATE_ACTIVE, SYSDATE + 1);

Common scenarios include validating that a resource is active before assigning it to a project, reconciling billing rates by joining to PA_BILL_RATES_ALL, and auditing which resources have organization-level restrictions through PA_NON_LABOR_RESOURCE_ORGS. Reports frequently join this table to PA_RESOURCE_ASSIGNMENTS to determine resource deployment, and to PA_RESOURCE_LIST_MEMBERS to enumerate resource list composition. Transaction control configuration can be audited by joining on the NON_LABOR_RESOURCE column to PA_TRANSACTION_CONTROLS.

Related Objects

The table participates in extensive referential relationships. Key dependent objects include:

• PA_EXPENDITURE_TYPES — Referenced by PA_NON_LABOR_RESOURCES.EXPENDITURE_TYPE; supplies the expenditure classification.
• PA_BILL_RATES_ALL — Joins via NON_LABOR_RESOURCE to define bill rates for the resource.
• PA_NL_BILL_RATE_OVERRIDES — Joins via NON_LABOR_RESOURCE to capture bill rate overrides.
• PA_NON_LABOR_RESOURCE_ORGS — Joins via NON_LABOR_RESOURCE; restricts resource availability by organization.
• PA_RESOURCE_ASSIGNMENTS — Joins via NON_LABOR_RESOURCE; links resources to project assignments.
• PA_RESOURCE_LIST_MEMBERS — Joins via NON_LABOR_RESOURCE; defines membership in resource lists.
• PA_RESOURCE_MAPS — Joins via NON_LABOR_RESOURCE; maps resources across costing contexts.
• PA_TRANSACTION_CONTROLS — Joins via NON_LABOR_RESOURCE; governs transaction entry rules.
• PA_PROJ_RETN_RULES — Joins via NON_LABOR_RESOURCE; applies retention rules to the resource.
• PA_RESOURCE_TXN_ATTRIBUTES — Joins via NON_LABOR_RESOURCE; stores transaction attribute defaults.