Search Results pa_cost_bases_pk

Overview

The PA_COST_BASES table is a core configuration table within the Oracle E-Business Suite Projects module (PA). It serves as the master definition for cost bases, which are implementation-defined groupings of expenditure types used for the burdening (indirect cost calculation) process. The table's role is to establish the fundamental categories against which burden schedules and rates are applied, enabling organizations to allocate overhead and other indirect costs to projects accurately based on the nature of the underlying expenditures.

Key Information Stored

The table's structure, as indicated by its primary and foreign keys, centers on uniquely identifying each cost base definition. The primary key is a composite of two columns: COST_BASE and COST_BASE_TYPE. The COST_BASE column holds the name or code for the grouping (e.g., 'LABOR', 'MATERIAL', 'OVERHEAD'). The COST_BASE_TYPE provides a classification for the base, which is critical for differentiating between various burden calculation methodologies. Other columns, while not explicitly listed in the provided metadata, typically include descriptive fields (e.g., DESCRIPTION), effective date ranges, and who columns (CREATION_DATE, CREATED_BY). The integrity of the data is enforced by the primary key constraint PA_COST_BASES_PK.

Common Use Cases and Queries

The primary use case is the setup and maintenance of the burdening structure during implementation and ongoing configuration. Common reporting and validation queries involve listing all defined cost bases and their types, or identifying which expenditure types are assigned to a specific cost base via the related PA_COST_BASE_EXP_TYPES table. A typical SQL pattern for verification is:

• SELECT cost_base, cost_base_type, description FROM pa_cost_bases WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE) ORDER BY 1;

Another critical use case is troubleshooting burden calculation issues, where analysts trace from a transaction's expenditure type through PA_COST_BASE_EXP_TYPES to the PA_COST_BASES table to confirm the correct cost base assignment for rate derivation.

Related Objects

PA_COST_BASES is a parent table referenced by several key burdening configuration tables. As per the metadata, two primary foreign key relationships exist:

• PA_COST_BASE_EXP_TYPES: This junction table maps expenditure types from PA_EXPENDITURE_TYPES to a specific cost base, defining the membership of the grouping.
• PA_COST_BASE_COST_CODES: This table links cost bases to specific burden cost codes, which are the accounting flexfields used to credit the burden pool and debit the project.

Furthermore, the definitions in PA_COST_BASES are ultimately utilized by burden schedules (PA_BURDEN_SCHEMES, PA_BURDEN_SCHEDULES) which assign rates to these bases, and are referenced throughout the burden calculation engine.