Results for “bill_rate”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PA_NL_BILL_RATE_OVERRIDES is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores non-standard, negotiated non-labor bill rates for specific projects and tasks. Standard non-labor bill rates are typically driven by the resource-and-expenditure-type combination defined in the billing rate schedules; this table provides the override layer that allows an organization to substitute a project- and task-specific rate, markup percentage, discount percentage, or discount reason when the standard schedule rate is not commercially appropriate. The table is owned by the PA schema and is classified as VALID in the ETRM 12.2.2 data dictionary, with 18 documented physical columns.
From a Data Vault modeling perspective, the mined foreign key structure suggests this object behaves as a link, since it joins multiple independent business entities — project, task, expenditure type, and non-labor resource — rather than representing a single business key or descriptive satellite. Each row captures a negotiated commercial agreement between those entities, which is consistent with link semantics.
Key Information Stored
The table has a composite primary key defined by PA_NL_BILL_RATE_OVERRIDES_PK on (PROJECT_ID, TASK_ID, EXPENDITURE_TYPE, START_DATE_ACTIVE, NON_LABOR_RESOURCE). This composite key is also reflected in the unique index PA_NL_BILL_RATE_OVERRIDES_U1, making it a strong business-key candidate. A second unique index, PA_NL_BILL_RATE_OVERRIDES_U3, is defined on NL_BILL_RATE_OVERRIDE_ID, which serves as the internal surrogate identifier.
- PROJECT_ID — the project to which the negotiated rate applies (foreign key to PA_PROJECTS_ALL).
- TASK_ID — the task within the project for which the override is effective (foreign key to PA_TASKS).
- EXPENDITURE_TYPE — the expenditure type the override governs (foreign key to PA_EXPENDITURE_TYPES).
- NON_LABOR_RESOURCE — the non-labor resource being billed, such as equipment or a purchased item (foreign key to PA_NON_LABOR_RESOURCES).
- START_DATE_ACTIVE / END_DATE_ACTIVE — the effective date range during which the override is valid.
- BILL_RATE and RATE_CURRENCY_CODE — the negotiated bill rate and the currency in which it is expressed.
- MARKUP_PERCENTAGE — the markup applied where the override is defined as a margin rather than a flat rate.
- DISCOUNT_PERCENTAGE and RATE_DISC_REASON_CODE — the negotiated discount and the coded reason justifying it.
- NL_BILL_RATE_OVERRIDE_ID — the surrogate primary-key candidate.
- RECORD_VERSION_NUMBER — used for optimistic locking / concurrency control.
- Audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.
Common Use Cases and Queries
Typical reporting scenarios include identifying which projects or tasks carry non-standard negotiated rates, auditing discount usage, and validating that override validity windows are consistent with project or task date ranges.
- List all overrides for a given project and task:
SELECT nlbr.project_id, nlbr.task_id, nlbr.expenditure_type, nlbr.non_labor_resource, nlbr.bill_rate, nlbr.rate_currency_code, nlbr.start_date_active, nlbr.end_date_active FROM pa_nl_bill_rate_overrides nlbr WHERE nlbr.project_id = :project_id AND nlbr.task_id = :task_id; - Identify currently active overrides within a date window:
SELECT * FROM pa_nl_bill_rate_overrides WHERE start_date_active <= SYSDATE AND (end_date_active IS NULL OR end_date_active >= SYSDATE);
- Aggregate discount exposure by reason code:
SELECT rate_disc_reason_code, COUNT(*), AVG(discount_percentage) FROM pa_nl_bill_rate_overrides GROUP BY rate_disc_reason_code;
- Audit changes via audit columns ordered by LAST_UPDATE_DATE for reconciliation against rate schedules.
Related Objects
The following objects are documented as directly related through the foreign key structure:
- PA_PROJECTS_ALL — joined on PROJECT_ID; source of the project definition.
- PA_TASKS — joined on TASK_ID; defines the task context for the override.
- PA_EXPENDITURE_TYPES — joined on EXPENDITURE_TYPE; defines the classification of cost being billed.
- PA_NON_LABOR_RESOURCES — joined on NON_LABOR_RESOURCE; identifies the billable non-labor item.
These four tables provide the reference integrity for PA_NL_BILL_RATE_OVERRIDES and should be joined when building reporting queries that need descriptive project, task, expenditure type, or resource information.
-
Non-standard non-labor bill rates negotiated for specific projects and tasks
-
Table containing invoice details NCU records prior to EFC switch
-
Table containing invoice details NCU records prior to EFC switch
-
View of detail expenditure items included on project invoices. Full Description: is a view that displays the detailed expenditure items that backup a project invoice. You can use this view to easily report the expenditure item informatio
APPS.PA_PROJ_INVOICE_DETAILS_VIEW·↳ PA_CUST_REV_DIST_LINES·↳ PA_DRAFT_INVOICE_ITEMS·↳ PA_EXPENDITURES_UTILS·Explore PA module →
-
View of detail expenditure items included on project invoices. Full Description: is a view that displays the detailed expenditure items that backup a project invoice. You can use this view to easily report the expenditure item informatio
APPS.PA_PROJ_INVOICE_DETAILS_VIEW·↳ PA_CUST_REV_DIST_LINES·↳ PA_DRAFT_INVOICE_ITEMS·↳ PA_EXPENDITURES_UTILS·Explore PA module →
-
10SC Only
APPS.PA_EXPND_ITEMS_REVIEW_V·↳ PA_CURRENCY·↳ PA_EXPENDITURE_COMMENTS·↳ PA_EXPENDITURE_ITEMS·Explore PA module →
-
Non-standard non-labor bill rates negotiated for specific projects and tasks
-
Unbilled expenditure items for projects
APPS.PA_PROJ_UNBILLED_EXPEND_VIEW·↳ PA_CUST_REV_DIST_LINES·↳ PA_DRAFT_INVOICE_ITEMS·↳ PA_EXPENDITURES_UTILS·Explore PA module →
-
Information about the accounting distributions related to transfer price for cross charged expenditure items.
-
Unbilled expenditure items for projects
APPS.PA_PROJ_UNBILLED_EXPEND_VIEW·↳ PA_CUST_REV_DIST_LINES·↳ PA_DRAFT_INVOICE_ITEMS·↳ PA_EXPENDITURES_UTILS·Explore PA module →
-
This view is used in Financial Planning to customize the non-periodic budget/forecast download to Excel Spreadsheet.
APPS.PA_FP_WEBADI_NP_CUSTOM_V·↳ FND_PROFILE·↳ PA_CROSS_BUSINESS_GRP·↳ PA_FIN_PLAN_UTILS·Explore PA module →
-
APPS.PA_CUST_REV_DIST_LINES_EI_V·↳ PA_CUST_REV_DIST_LINES_ALL·Explore PA module →
-
This view is used in Financial Planning to download non-periodic budget/forecast data into Excel Spreadsheet.
APPS.PA_FP_WEBADI_NON_PERIODIC_V·↳ CST_COST_TYPES_V·↳ FND_PROFILE·↳ PA_BUDGET_VERSIONS·Explore PA module →
-
This view is used in Financial Planning to customize the non-periodic budget/forecast download to Excel Spreadsheet.
APPS.PA_FP_WEBADI_NP_CUSTOM_V·↳ FND_PROFILE·↳ PA_CROSS_BUSINESS_GRP·↳ PA_FIN_PLAN_UTILS·Explore PA module →
-
10SC Only
APPS.PA_CUST_REV_DIST_LINES_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PA module →
-
Information for the smallest expenditure units charged to projects and tasks in each reporting currency.
-
View: PA_EXPENDITURE_ITEMS_V 12.1.1
10SC Only
APPS.PA_EXPENDITURE_ITEMS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PA module →
-
10SC Only
APPS.PA_DRAFT_INV_LINE_DETAILS_V·↳ FND_LOOKUP_VALUES·↳ GL_DAILY_CONVERSION_TYPES·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PA module →
-
Pa_MC_Exp_Items_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
-
Information for the smallest expenditure units charged to projects and tasks in each reporting currency.
-
APPS.GMS_EXPEND_ITEMS_ADJUST_V·↳ FND_LOOKUP_VALUES·↳ GMS_AWARD_DISTRIBUTIONS·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore GMS module →
-
Pa_MC_Exp_Items_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
-
Pa_Cust_Rev_Dist_Lines_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
-
10SC Only
APPS.PA_EXPND_ITEMS_REVIEW_V·↳ PA_CURRENCY·↳ PA_EXPENDITURE_COMMENTS·↳ PA_EXPENDITURE_ITEMS·Explore PA module →
-
This view is used in Financial Planning to download non-periodic budget/forecast data into Excel Spreadsheet.
APPS.PA_FP_WEBADI_NON_PERIODIC_V·↳ CST_COST_TYPES_V·↳ FND_PROFILE·↳ PA_BUDGET_VERSIONS·Explore PA module →
-
View: PA_CUST_RDL_ALL_MRC_V2 12.1.1
Multi-org, single currency view
APPS.PA_CUST_RDL_ALL_MRC_V2·↳ MO_GLOBAL·↳ PA_CUST_REV_DIST_LINES_ALL·↳ PA_EXPENDITURE_ITEMS_ALL·Explore PA module →
-
Multi-org, single currency view for pa_cc_dist_lines_all
APPS.PA_CC_DIST_LINES_ALL_MRC_V·↳ PA_CC_DIST_LINES_ALL·↳ PA_MC_CC_DIST_LINES_ALL·Explore PA module →
-
View: PABV_EXPENDITURE_ITEMS 12.1.1
- Retrofitted
APPS.PABV_EXPENDITURE_ITEMS·↳ PA_EXPENDITURE_ITEMS_ALL·↳ PA_TASKS·Explore PA module →
-
View: PABV_EXPENDITURE_ITEMS 12.2.2
- Retrofitted
APPS.PABV_EXPENDITURE_ITEMS·↳ PA_EXPENDITURE_ITEMS_ALL·↳ PA_TASKS·Explore PA module →
-
10SC Only
APPS.PA_CUST_REV_DIST_LINES_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PA module →
-
Information about the accounting distributions related to transfer price for cross charged expenditure items.
-
10SC Only
APPS.PA_DRAFT_INV_LINE_DETAILS_V·↳ FND_LOOKUP_VALUES·↳ GL_DAILY_CONVERSION_TYPES·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PA module →
-
View: PA_EXPENDITURE_ITEMS_V 12.2.2
10SC Only
APPS.PA_EXPENDITURE_ITEMS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PA module →
-
Multi-org, single currency view for pa_cc_dist_lines_all
APPS.PA_CC_DIST_LINES_ALL_MRC_V·↳ PA_CC_DIST_LINES_ALL·↳ PA_MC_CC_DIST_LINES_ALL·Explore PA module →
-
Intercompany invoice details for cross charged transactions
-
Intercompany invoice details for cross charged transactions
-
View: PAFV_EXPENDITURE_ITEMS 12.1.1
Business view to show information about the expenditure items entered.
APPS.PAFV_EXPENDITURE_ITEMS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PA_CONVERSION_TYPES_V·Explore PA module →
-
APPS.PA_CUST_REV_DIST_LINES_EI_V·↳ PA_CUST_REV_DIST_LINES_ALL·Explore PA module →
-
Pa_Cust_Rev_Dist_Lines_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
-
View: PA_PROJ_EXPEND_VIEW 12.1.1
Expenditure items for projects, which includes cost and revenue. PA_PROJ_EXPEND_VIEW is a view of all project expenditure items. This view displays all relevant information for all expenditure items, including labor, expense reports, usage
APPS.PA_PROJ_EXPEND_VIEW·↳ PA_COST_DIST_LINES_ALL_BAS·↳ PA_EXPENDITURES_ALL·↳ PA_EXPENDITURES_UTILS·Explore PA module →
-
View: PAFV_EXPENDITURE_ITEMS 12.2.2
Business view to show information about the expenditure items entered.
APPS.PAFV_EXPENDITURE_ITEMS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PA_CONVERSION_TYPES_V·Explore PA module →
-
View: PA_PROJ_EXPEND_VIEW 12.2.2
Expenditure items for projects, which includes cost and revenue. PA_PROJ_EXPEND_VIEW is a view of all project expenditure items. This view displays all relevant information for all expenditure items, including labor, expense reports, usage
APPS.PA_PROJ_EXPEND_VIEW·↳ PA_COST_DIST_LINES_ALL_BAS·↳ PA_EXPENDITURES_ALL·↳ PA_EXPENDITURES_UTILS·Explore PA module →
-
Stores the resource assignment level data for internal use of Oracle Projects
-
View: PA_CUST_RDL_ALL_MRC_V2 12.2.2
Multi-org, single currency view
APPS.PA_CUST_RDL_ALL_MRC_V2·↳ MO_GLOBAL·↳ PA_CUST_REV_DIST_LINES_ALL·↳ PA_EXPENDITURE_ITEMS_ALL·Explore PA module →