Search Results pa_std_bill_rate_schedules_all

Overview

The PA_STD_BILL_RATE_SCHEDULES_ALL table is a core master data object within Oracle E-Business Suite Projects (PA) module, versions 12.1.1 and 12.2.2. It serves as the repository for defining standard bill rate schedules, which are pre-defined sets of billing rates for labor and non-labor resources. These schedules function as reusable templates that can be assigned en masse to projects, tasks, and project types, ensuring consistent and efficient billing rate management across the enterprise. Its multi-org structure, indicated by the *_ALL suffix and the ORG_ID column, supports implementations operating in a shared services model with multiple business units or legal entities.

Key Information Stored

The table stores the header-level definition for each standard bill rate schedule. While the specific column list is not fully detailed in the provided metadata, the primary and foreign key relationships reveal critical fields. The composite primary key consists of ORGANIZATION_ID, STD_BILL_RATE_SCHEDULE, and ORG_ID, uniquely identifying a schedule within a specific operating unit and organization context. The RATE_SCH_CURRENCY_CODE column, referenced by a foreign key to FND_CURRENCIES, defines the currency for the rates within the schedule. Other essential columns typically include descriptive fields like the schedule name, effective dates, and attributes for system control (e.g., CREATION_DATE, LAST_UPDATE_DATE). The ORGANIZATION_ID links to HR_ALL_ORGANIZATION_UNITS, defining the organization for which the rate schedule is valid.

Common Use Cases and Queries

A primary use case is the assignment of standard billing rates during project definition. When creating a project from a template or manually, a user can select a labor and a non-labor standard bill rate schedule, which automatically populates task-level billing rates. Common reporting and validation queries include identifying all active schedules for a given organization or listing projects using a specific schedule. For example, to find schedules for a specific operating unit, one might query: SELECT std_bill_rate_schedule, rate_sch_currency_code FROM pa_std_bill_rate_schedules_all WHERE org_id = :p_org_id. Integration and data migration scripts frequently reference this table when loading or validating standard rate data from external systems, ensuring referential integrity before loading detailed rates into the PA_BILL_RATES_ALL table.

Related Objects

The table is central to the Projects billing rate architecture, with several key dependencies as documented by its foreign keys.

• HR_ALL_ORGANIZATION_UNITS: Provides the organization master data via PA_STD_BILL_RATE_SCHEDULES_ALL.ORGANIZATION_ID.
• FND_CURRENCIES: Validates the schedule currency via PA_STD_BILL_RATE_SCHEDULES_ALL.RATE_SCH_CURRENCY_CODE.
• PA_BILL_RATES_ALL: Stores the detailed rate lines (e.g., by job, person, date) that belong to a schedule. Joined on BILL_RATE_ORGANIZATION_ID, STD_BILL_RATE_SCHEDULE, and ORG_ID.
• PA_PROJECTS_ALL: References a schedule for labor billing (LABOR_BILL_RATE_ORG_ID, LABOR_STD_BILL_RATE_SCHDL, ORG_ID) and non-labor billing (NON_LABOR_BILL_RATE_ORG_ID, NON_LABOR_STD_BILL_RATE_SCHDL, ORG_ID).
• PA_PROJECT_TYPES_ALL: Allows default schedule assignment at the project type level, using the same column pairs as PA_PROJECTS_ALL.