Search Results pa_bill_rates_all

Overview

The PA_BILL_RATES_ALL table is a core data repository within Oracle E-Business Suite (EBS) Projects (PA) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master table for storing detailed bill rate and markup information associated with standard bill rate schedules. These schedules are critical for project costing and revenue generation, as they define the monetary rates at which labor, non-labor resources, and expenditures are billed to customers or charged to projects. The table's role is to provide the granular rate data that the system applies during transaction processing, such as the generation of revenue, invoicing, and the calculation of project margins. Its multi-organization enabled structure, indicated by the ORG_ID column, supports deployments across multiple operating units.

Key Information Stored

The table's primary key uniquely identifies a rate record through a combination of organizational and descriptive attributes: BILL_RATE_ORGANIZATION_ID, STD_BILL_RATE_SCHEDULE, PERSON_ID, START_DATE_ACTIVE, JOB_ID, EXPENDITURE_TYPE, NON_LABOR_RESOURCE, and ORG_ID. Key data columns include the RATE_CURRENCY_CODE, which specifies the currency for the billing amount, and the START_DATE_ACTIVE and END_DATE_ACTIVE, which manage the effective date range of the rate. The table holds specific bill rates or markup percentages for defined combinations of resources, which can be a person (PERSON_ID), a job role (JOB_ID), a type of expense (EXPENDITURE_TYPE), or a specific non-labor resource (NON_LABOR_RESOURCE). This structure allows for highly specific and tiered billing rules within a given schedule and organization.

Common Use Cases and Queries

A primary use case is the reporting and audit of active bill rates for financial analysis and project setup validation. Administrators often query this table to verify rate assignments before running critical processes like revenue accruals or draft invoice generation. A common SQL pattern retrieves all effective rates for a specific schedule:

• SELECT person_id, job_id, expenditure_type, rate_currency_code, start_date_active FROM pa_bill_rates_all WHERE std_bill_rate_schedule = 'ENG_SCHEDULE' AND org_id = 204 AND sysdate BETWEEN start_date_active AND NVL(end_date_active, sysdate);

Another frequent operational need is to identify rate overlaps or gaps for a resource, which involves checking for overlapping date ranges for the same combination of key attributes. Data from this table is also essential for custom reports calculating projected revenue or analyzing billing rate compliance against contract terms.

Related Objects

The PA_BILL_RATES_ALL table maintains integral relationships with several master and reference tables in EBS, as defined by its foreign key constraints. The primary relationship is with PA_STD_BILL_RATE_SCHEDULES_ALL, to which it is a child table, linking via BILL_RATE_ORGANIZATION_ID, STD_BILL_RATE_SCHEDULE, and ORG_ID. It references resource and costing master data through foreign keys to PER_JOBS (JOB_ID), PA_EXPENDITURE_TYPES (EXPENDITURE_TYPE), and PA_NON_LABOR_RESOURCES (NON_LABOR_RESOURCE). Furthermore, it validates currency codes against the FND_CURRENCIES table via the RATE_CURRENCY_CODE column. These relationships ensure referential integrity and that all bill rates are defined against valid, existing setup entities within the system.