Search Results pa_cost_base_cost_codes




Overview
Explore in AI Chat

Overview

The PA_COST_BASE_COST_CODES table is a core data structure within the Oracle E-Business Suite Projects (PA) module, specifically for the management of project costing. Its primary function is to define the relationship between burden cost codes and their associated cost bases. This mapping is fundamental to the system's burdening engine, which calculates indirect costs (overhead) to be applied to direct project expenditures. The table acts as a junction, linking the definition of a cost base—a logical grouping of costs for burden calculation—with the specific indirect cost codes that should be applied to it, thereby enabling complex and multi-layered overhead structures.

Key Information Stored

The table stores the essential linkages for burden cost calculations. Its primary key is the system-generated identifier, COST_BASE_COST_CODE_ID. The most critical foreign key columns define the relationships that give the table its purpose: COST_BASE and COST_BASE_TYPE together reference a specific cost base definition in the PA_COST_BASES table. The IND_COST_CODE column references the specific indirect cost code from the PA_IND_COST_CODES table that is to be applied. Furthermore, the COST_PLUS_STRUCTURE column links the record to an overarching cost-plus structure in the PA_COST_PLUS_STRUCTURES table, which governs the overall burdening framework for a set of projects.

Common Use Cases and Queries

This table is central to configuration and inquiry related to project burdening. A common use case is validating or reporting on the burden structure assigned to a specific cost base. For instance, a consultant might run a query to list all indirect cost codes linked to a particular cost base to verify setup accuracy. Another critical scenario involves troubleshooting burden calculation errors, where tracing the cost base associations through this table is a necessary diagnostic step. Sample queries often join this table with PA_COST_BASES and PA_IND_COST_CODES to produce human-readable reports.

  • Sample Query: SELECT cbbc.cost_base, cic.name ind_cost_code_name FROM pa_cost_base_cost_codes cbbc, pa_ind_cost_codes cic WHERE cbbc.ind_cost_code = cic.ind_cost_code AND cbbc.cost_plus_structure = '&STRUCTURE';

Related Objects

The PA_COST_BASE_COST_CODES table is a nexus within the burdening schema, with documented foreign key relationships to several key tables. It is a child of PA_COST_BASES, PA_IND_COST_CODES, and PA_COST_PLUS_STRUCTURES, drawing its defining parameters from these entities. Crucially, it is a parent table to PA_COMPILED_MULTIPLIERS, which stores the pre-calculated burden multipliers used for transaction processing. This relationship underscores its role as a configuration point that feeds the runtime calculation engine.

  • PA_COST_BASES: Joined via COST_BASE and COST_BASE_TYPE. Defines the source cost base.
  • PA_IND_COST_CODES: Joined via IND_COST_CODE. Defines the indirect cost code to apply.
  • PA_COST_PLUS_STRUCTURES: Joined via COST_PLUS_STRUCTURE. Defines the governing burden structure.
  • PA_COMPILED_MULTIPLIERS: Child table joined via COST_BASE_COST_CODE_ID. Stores calculated rates derived from this mapping.