Search Results pa_nl_bill_rate_overrides_pk

Overview

The PA_NL_BILL_RATE_OVERRIDES table is a core transactional data object within the Oracle E-Business Suite (EBS) Projects module (PA). It serves a critical function in project financial management by storing non-standard, negotiated billing rates for non-labor resources. These overrides are applied at a granular level for specific projects, tasks, expenditure types, and non-labor resources, allowing organizations to deviate from standard rate schedules to honor unique client contracts or project-specific agreements. Its existence is fundamental to ensuring accurate revenue recognition and client invoicing for project-related expenses such as equipment usage, materials, or other purchased items.

Key Information Stored

The table's structure is designed to uniquely define a rate override and its effective period. The primary key is a composite of five columns, ensuring a unique rate for a specific combination: PROJECT_ID and TASK_ID define the project and task context; EXPENDITURE_TYPE categorizes the cost; NON_LABOR_RESOURCE identifies the specific resource (e.g., a piece of equipment or material item); and START_DATE_ACTIVE marks the effective date of the rate. While not part of the primary key, an END_DATE_ACTIVE column is typically present to manage rate expiration. The table's central data column is the negotiated BILL_RATE, which holds the monetary value used for billing calculations. The integrity of this data is enforced through foreign key relationships to master data tables, including PA_PROJECTS_ALL, PA_TASKS, PA_EXPENDITURE_TYPES, and PA_NON_LABOR_RESOURCES.

Common Use Cases and Queries

The primary use case is the calculation of bill amounts for non-labor project expenditures. When a transaction is processed, the Projects module queries this table to find a matching override rate before applying a standard rate. Common reporting and audit queries include listing all active overrides for a project or validating rates against contract terms. A typical SQL pattern retrieves override details for analysis:

• SELECT project_id, task_id, expenditure_type, non_labor_resource, start_date_active, bill_rate FROM pa_nl_bill_rate_overrides WHERE project_id = :p_project_id AND sysdate BETWEEN start_date_active AND NVL(end_date_active, sysdate);
• Data maintenance involves inserting new overrides for a new contract or updating the END_DATE_ACTIVE to inactivate a rate, rather than deleting records, to preserve audit history.

Related Objects

PA_NL_BILL_RATE_OVERRIDES is centrally connected to several key master and transactional tables via foreign key constraints, as documented. It is directly referenced by PA_PROJECTS_ALL, PA_TASKS, PA_EXPENDITURE_TYPES, and PA_NON_LABOR_RESOURCES for data validation. In transaction processing, it is closely linked to tables holding expenditure data, such as PA_EXPENDITURES_ALL and PA_COST_DISTRIBUTION_LINES_ALL, which consume the override rates for billing calculations. For reporting, it is often joined with PA_PROJECTS_ALL and PA_TASKS to include project names and task numbers. Administratively, its primary key constraint (PA_NL_BILL_RATE_OVERRIDES_PK) and the listed foreign keys are essential related database objects.