Search Results pa_nl_bill_rate_overrides




Overview
Explore in AI Chat

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.

  • Table: PA_NL_BILL_RATE_OVERRIDES 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_NL_BILL_RATE_OVERRIDES,  object_name:PA_NL_BILL_RATE_OVERRIDES,  status:VALID,  product: PA - Projects ,  description: Non-standard non-labor bill rates negotiated for specific projects and tasks ,  implementation_dba_data: PA.PA_NL_BILL_RATE_OVERRIDES , 

  • Table: PA_NL_BILL_RATE_OVERRIDES 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_NL_BILL_RATE_OVERRIDES,  object_name:PA_NL_BILL_RATE_OVERRIDES,  status:VALID,  product: PA - Projects ,  description: Non-standard non-labor bill rates negotiated for specific projects and tasks ,  implementation_dba_data: PA.PA_NL_BILL_RATE_OVERRIDES , 

  • Table: PA_NON_LABOR_RESOURCES 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_NON_LABOR_RESOURCES,  object_name:PA_NON_LABOR_RESOURCES,  status:VALID,  product: PA - Projects ,  description: Non-labor assets utilized during project work ,  implementation_dba_data: PA.PA_NON_LABOR_RESOURCES , 

  • Table: PA_NON_LABOR_RESOURCES 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_NON_LABOR_RESOURCES,  object_name:PA_NON_LABOR_RESOURCES,  status:VALID,  product: PA - Projects ,  description: Non-labor assets utilized during project work ,  implementation_dba_data: PA.PA_NON_LABOR_RESOURCES , 

  • Table: PA_EXPENDITURE_TYPES 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_EXPENDITURE_TYPES,  object_name:PA_EXPENDITURE_TYPES,  status:VALID,  product: PA - Projects ,  description: Implementation-defined classifications of expenditures charged to projects and tasks ,  implementation_dba_data: PA.PA_EXPENDITURE_TYPES , 

  • Table: PA_EXPENDITURE_TYPES 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_EXPENDITURE_TYPES,  object_name:PA_EXPENDITURE_TYPES,  status:VALID,  product: PA - Projects ,  description: Implementation-defined classifications of expenditures charged to projects and tasks ,  implementation_dba_data: PA.PA_EXPENDITURE_TYPES , 

  • Table: PA_TASKS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TASKS,  object_name:PA_TASKS,  status:VALID,  product: PA - Projects ,  description: User-defined subdivisions of project work ,  implementation_dba_data: PA.PA_TASKS , 

  • Table: PA_TASKS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TASKS,  object_name:PA_TASKS,  status:VALID,  product: PA - Projects ,  description: User-defined subdivisions of project work ,  implementation_dba_data: PA.PA_TASKS , 

  • Table: PA_PROJECTS_ALL 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECTS_ALL,  object_name:PA_PROJECTS_ALL,  status:VALID,  product: PA - Projects ,  description: PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects. ,  implementation_dba_data: PA.PA_PROJECTS_ALL , 

  • Table: PA_PROJECTS_ALL 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECTS_ALL,  object_name:PA_PROJECTS_ALL,  status:VALID,  product: PA - Projects ,  description: PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects. ,  implementation_dba_data: PA.PA_PROJECTS_ALL ,