Search Results pa_usage_cost_rate_ovr_all




Overview
Explore in AI Chat

Overview

The PA_USAGE_COST_RATE_OVR_ALL table is a core data structure within Oracle E-Business Suite (EBS) Projects (PA) module, specifically in releases 12.1.1 and 12.2.2. It serves as a repository for override cost rates assigned to non-labor resources and specific organizations. Its primary role is to provide a mechanism for superseding the standard cost rates defined at the expenditure type level. This functionality is critical for accurate project costing when the default rates for a non-labor resource, such as equipment or materials, differ based on the consuming organization or require a unique rate not captured by the standard setup. The table supports multi-organization architecture through its ORG_ID column, allowing for distinct rate overrides across different operating units.

Key Information Stored

The table's structure is designed to uniquely identify and store the override rate information. Key columns include ORGANIZATION_ID, which identifies the specific inventory or expense organization; NON_LABOR_RESOURCE, which references the specific non-labor resource item; and START_DATE_ACTIVE, which defines the effective date from which the override rate is applicable. These three columns, along with ORG_ID, constitute the table's primary key (PA_USAGE_COST_RATE_OVERRIDE_PK), ensuring uniqueness. Other critical columns typically found in such rate tables, though not explicitly listed in the provided metadata, would logically include an END_DATE_ACTIVE for rate expiration, a COST_RATE or similar column storing the monetary value, and a CURRENCY_CODE. The table's existence is predicated on the relationship between a non-labor resource and an organization as defined in the PA_NON_LABOR_RESOURCE_ORGS table.

Common Use Cases and Queries

A primary use case is the calculation of precise costs for non-labor transactions on projects. When a project incurs a charge for a non-labor resource, the costing engine will check this table for an organization-specific override before defaulting to the expenditure type's standard rate. This is essential for accurate cost collection, burdening, and profitability analysis. Common queries involve retrieving the active override rate for a given resource and organization. A sample SQL pattern would be: SELECT cost_rate FROM pa_usage_cost_rate_ovr_all WHERE organization_id = :p_org_id AND non_labor_resource = :p_nlr AND sysdate BETWEEN start_date_active AND NVL(end_date_active, sysdate+1) AND org_id = :p_operating_unit;. Reporting use cases include audits of custom cost rates, analysis of rate variances by organization, and ensuring rate schedule compliance.

Related Objects

The table has documented foreign key relationships that are integral to its data integrity and usage. The primary relationship is with the PA_NON_LABOR_RESOURCE_ORGS table. This foreign key, defined on the columns ORGANIZATION_ID and NON_LABOR_RESOURCE, ensures that an override rate can only be created for a valid, pre-defined association between a non-labor resource and an organization. This prevents orphaned rate records. While not listed in the provided metadata, this table is also fundamentally related to core Projects transactional tables like PA_EXPENDITURE_ITEMS_ALL for cost calculation, and to setup tables like PA_EXPENDITURE_TYPES for the default rates being overridden. It is a key component in the rate hierarchy processed by the costing engine.