Search Results pa_cost_base_exp_types

Overview

The PA_COST_BASE_EXP_TYPES table is a core setup and validation table within the Oracle E-Business Suite Projects (PA) module. It functions as a junction table that defines the permissible associations between specific expenditure types and cost bases. Its primary role is to enforce business rules for cost-plus billing structures, ensuring that only approved expenditure types can be allocated to a given cost base for the purpose of calculating indirect costs (burdening) and generating customer invoices. This table is critical for maintaining data integrity in project costing and billing processes across both Oracle EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure centers on a composite primary key that uniquely identifies each valid association. The key columns are: COST_PLUS_STRUCTURE, which identifies the specific cost-plus billing structure; COST_BASE, which specifies the cost base within that structure; COST_BASE_TYPE, which classifies the cost base; and EXPENDITURE_TYPE, which is the specific type of cost being associated. This design allows for granular control, enabling different sets of expenditure types to be linked to different cost bases across multiple billing structures. The table primarily stores these relationship identifiers and does not typically contain descriptive or transactional amounts.

Common Use Cases and Queries

A primary use case is the validation performed during transaction entry (e.g., expenditure item creation) and during the generation of cost distributions and invoices. The system references this table to confirm if an incurred expenditure type is eligible for inclusion in a project's cost base calculations. Common queries involve listing all setup relationships for audit or troubleshooting purposes. For example, to review all expenditure types tied to a specific cost structure and base, one might use:

• SELECT expenditure_type FROM pa_cost_base_exp_types WHERE cost_plus_structure = '&STRUCTURE' AND cost_base = '&BASE';

Reporting use cases often involve joining this table to PA_COST_BASES and PA_EXPENDITURE_TYPES to produce user-friendly setup reports for functional consultants, ensuring the burdening setup aligns with contractual requirements.

Related Objects

PA_COST_BASE_EXP_TYPES maintains strict referential integrity through foreign key relationships to several fundamental setup tables, as documented in the ETRM. It references PA_COST_PLUS_STRUCTURES (via COST_PLUS_STRUCTURE), PA_COST_BASES (via COST_BASE and COST_BASE_TYPE), and PA_EXPENDITURE_TYPES (via EXPENDITURE_TYPE). These relationships ensure that associations are only created for valid, pre-defined components. This table is a direct child of PA_COST_BASES and is essential for the functioning of the cost accumulation and billing engines within the Projects module. Updates to this table are typically performed through the Oracle Projects application interface to maintain consistency.