Search Results pa_ind_cost_codes

Overview

The PA_IND_COST_CODES table is a core reference table within the Oracle E-Business Suite Projects (PA) module. It serves as the master repository for implementation-defined classifications of burden costs, commonly referred to as indirect cost codes. These codes are fundamental to the application's complex burdening (or indirect cost allocation) engine. The table enables organizations to categorize and group indirect costs—such as overhead, fringe benefits, and general and administrative (G&A) expenses—for the purpose of calculating and applying burden rates to project transactions. Its role is critical for ensuring accurate project costing, compliance with accounting standards, and the generation of cost-plus billing in project-centric environments.

Key Information Stored

While the provided metadata does not list specific columns, the primary key is documented as IND_COST_CODE. This field is the unique identifier for each indirect cost classification. Based on its functional purpose, the table typically stores descriptive and control attributes for each code. Common columns often include a user-defined name (e.g., IND_COST_CODE_DESC), effective dates (START_DATE_ACTIVE, END_DATE_ACTIVE), and flags controlling its usage in allocation processes. The structure is designed to be flexible, allowing administrators to define a coding scheme that aligns with their organization's specific cost pooling and allocation methodologies.

Common Use Cases and Queries

The primary use case is the setup and maintenance of the indirect cost structure during implementation. Administrators populate this table with codes that logically group indirect expenses. These codes are then referenced when defining burden schedules, multipliers, and allocation rules. For reporting, the table is frequently joined to transaction data to analyze burden costs by classification. A common query pattern involves listing all active cost codes for a setup review:

SELECT ind_cost_code, description FROM pa.pa_ind_cost_codes WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE) ORDER BY 1;

Another critical use is tracing the application of burden in financial reports, requiring joins to allocation result tables via the IND_COST_CODE key.

Related Objects

As indicated by the foreign key relationships, PA_IND_COST_CODES is central to the burdening subsystem. Key dependent tables include:

PA_CINT_RATE_INFO_ALL: Stores burden rates defined for specific indirect cost codes.
PA_IND_COST_MULTIPLIERS: Holds multipliers applied to base rates for specific cost codes.
PA_COST_BASE_COST_CODES: Maps expenditure types to eligible indirect cost codes for allocation.
PA_ALLOC_RUNS_ALL: References cost codes in the context of allocation run definitions.
PA_CINT_EXP_TYPE_EXCL_ALL and PA_CINT_RATE_MULTIPLIERS: Further control the application of specific cost codes to expenditure types and rate calculations.

These relationships underscore that PA_IND_COST_CODES acts as a parent reference table, ensuring data integrity across the entire burden costing process.

Table: PA_IND_COST_CODES 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_IND_COST_CODES, object_name:PA_IND_COST_CODES, status:VALID, product: PA - Projects , description: Implementation-defined classifications of burden costs , implementation_dba_data: PA.PA_IND_COST_CODES ,
Table: PA_IND_COST_CODES 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_IND_COST_CODES, object_name:PA_IND_COST_CODES, status:VALID, product: PA - Projects , description: Implementation-defined classifications of burden costs , implementation_dba_data: PA.PA_IND_COST_CODES ,
Table: PA_COST_BASE_COST_CODES 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_COST_BASE_COST_CODES, object_name:PA_COST_BASE_COST_CODES, status:VALID, product: PA - Projects , description: Burden cost codes associated with cost bases , implementation_dba_data: PA.PA_COST_BASE_COST_CODES ,
Table: PA_IND_COST_MULTIPLIERS 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_IND_COST_MULTIPLIERS, object_name:PA_IND_COST_MULTIPLIERS, status:VALID, product: PA - Projects , description: Burden multipliers for burden schedule revisions, organizations, and burden cost codes , implementation_dba_data: PA.PA_IND_COST_MULTIPLIERS ,
Table: PA_CINT_RATE_INFO_ALL 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_CINT_RATE_INFO_ALL, object_name:PA_CINT_RATE_INFO_ALL, status:VALID, product: PA - Projects , description: Stores information used to determine how capitalized interest is calculated for each operating unit , implementation_dba_data: PA.PA_CINT_RATE_INFO_ALL ,
Table: PA_COST_BASE_COST_CODES 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_COST_BASE_COST_CODES, object_name:PA_COST_BASE_COST_CODES, status:VALID, product: PA - Projects , description: Burden cost codes associated with cost bases , implementation_dba_data: PA.PA_COST_BASE_COST_CODES ,
Table: PA_CINT_EXP_TYPE_EXCL_ALL 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_CINT_EXP_TYPE_EXCL_ALL, object_name:PA_CINT_EXP_TYPE_EXCL_ALL, status:VALID, product: PA - Projects , description: Stores expenditure type exclusions by interest rate code for each operating unit. Cost associated with each expenditure type is excluded from the capitalized interest calculation , implementation_dba_data: PA.PA_CINT_EXP_TYPE_EXCL_ALL ,
Table: PA_ALLOC_RUNS_ALL 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_ALLOC_RUNS_ALL, object_name:PA_ALLOC_RUNS_ALL, status:VALID, product: PA - Projects , description: Information for allocation runs , implementation_dba_data: PA.PA_ALLOC_RUNS_ALL ,
View: PA_CDL_BURDEN_DETAIL_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:IPA.PA_CDL_BURDEN_DETAIL_V PA.PA_CDL_BURDEN_DETAIL_V, object_name:PA_CDL_BURDEN_DETAIL_V, status:VALID, product: PA - Projects , description: Summarization criteria for burden summarization of expenditure items.This view is based on PA_CDL_BURDEN_DETAIL_V. It is a User customizable view defined over the PA_CDL_BURDEN_DETAIL_V. User can change the columns to be included in summary , implementation_dba_data: APPS.PA_CDL_BURDEN_DETAIL_V ,
Table: PA_CINT_RATE_MULTIPLIERS 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_CINT_RATE_MULTIPLIERS, object_name:PA_CINT_RATE_MULTIPLIERS, status:VALID, product: PA - Projects , description: Stores complied capitalized interest schedule revisions, denormalized by revision, organization and rate name. The multipliers in this table are used during the calculation and generation of Capitalized Interest transactions. , implementation_dba_data: PA.PA_CINT_RATE_MULTIPLIERS ,
Table: PA_IND_COST_MULTIPLIERS 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_IND_COST_MULTIPLIERS, object_name:PA_IND_COST_MULTIPLIERS, status:VALID, product: PA - Projects , description: Burden multipliers for burden schedule revisions, organizations, and burden cost codes , implementation_dba_data: PA.PA_IND_COST_MULTIPLIERS ,
Table: PA_CINT_RATE_INFO_ALL 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_CINT_RATE_INFO_ALL, object_name:PA_CINT_RATE_INFO_ALL, status:VALID, product: PA - Projects , description: Stores information used to determine how capitalized interest is calculated for each operating unit , implementation_dba_data: PA.PA_CINT_RATE_INFO_ALL ,
Table: PA_CINT_EXP_TYPE_EXCL_ALL 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_CINT_EXP_TYPE_EXCL_ALL, object_name:PA_CINT_EXP_TYPE_EXCL_ALL, status:VALID, product: PA - Projects , description: Stores expenditure type exclusions by interest rate code for each operating unit. Cost associated with each expenditure type is excluded from the capitalized interest calculation , implementation_dba_data: PA.PA_CINT_EXP_TYPE_EXCL_ALL ,
Table: PA_ALLOC_RUNS_ALL 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_ALLOC_RUNS_ALL, object_name:PA_ALLOC_RUNS_ALL, status:VALID, product: PA - Projects , description: Information for allocation runs , implementation_dba_data: PA.PA_ALLOC_RUNS_ALL ,
View: PA_CINT_TXN_DETAILS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_CINT_TXN_DETAILS_V, object_name:PA_CINT_TXN_DETAILS_V, status:VALID, product: PA - Projects , description: This is an Internal view created for Generate Capitalized interest Transaction process , implementation_dba_data: APPS.PA_CINT_TXN_DETAILS_V ,
Table: PA_CINT_RATE_MULTIPLIERS 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_CINT_RATE_MULTIPLIERS, object_name:PA_CINT_RATE_MULTIPLIERS, status:VALID, product: PA - Projects , description: Stores complied capitalized interest schedule revisions, denormalized by revision, organization and rate name. The multipliers in this table are used during the calculation and generation of Capitalized Interest transactions. , implementation_dba_data: PA.PA_CINT_RATE_MULTIPLIERS ,
View: PA_CINT_TXN_DETAILS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_CINT_TXN_DETAILS_V, object_name:PA_CINT_TXN_DETAILS_V, status:VALID, product: PA - Projects , description: This is an Internal view created for Generate Capitalized interest Transaction process , implementation_dba_data: APPS.PA_CINT_TXN_DETAILS_V ,
Lookup Type: BURDEN_SUM_REJECTION_CODE 12.2.2
product: PA - Projects , meaning: Burden Sum Rejection Code , description: Burden_Sum_Rejection_Code ,
Lookup Type: BURDEN_SUM_REJECTION_CODE 12.1.1
product: PA - Projects , meaning: Burden Sum Rejection Code , description: Burden_Sum_Rejection_Code ,
View: PA_CDL_BURDEN_DETAIL_V_R 12.1.1
product: PA - Projects , description: Summarization criteria for burden summarization of expenditure items.This view is based on PA_CDL_BURDEN_DETAIL_V. It is a User customizable view defined over the PA_CDL_BURDEN_DETAIL_V. User can change the columns to be included in summary , implementation_dba_data: Not implemented in this database ,
View: PA_CDL_BURDEN_DETAIL_V_R 12.2.2
product: PA - Projects , description: Summarization criteria for burden summarization of expenditure items.This view is based on PA_CDL_BURDEN_DETAIL_V. It is a User customizable view defined over the PA_CDL_BURDEN_DETAIL_V. User can change the columns to be included in summary , implementation_dba_data: Not implemented in this database ,
View: PA_CDL_BURDEN_DETAIL_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IPA.PA_CDL_BURDEN_DETAIL_V PA.PA_CDL_BURDEN_DETAIL_V, object_name:PA_CDL_BURDEN_DETAIL_V, status:VALID, product: PA - Projects , description: Summarization criteria for burden summarization of expenditure items.This view is based on PA_CDL_BURDEN_DETAIL_V. It is a User customizable view defined over the PA_CDL_BURDEN_DETAIL_V. User can change the columns to be included in summary , implementation_dba_data: APPS.PA_CDL_BURDEN_DETAIL_V ,
View: PA_CMT_BURDEN_DETAIL_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_CMT_BURDEN_DETAIL_V, object_name:PA_CMT_BURDEN_DETAIL_V, status:VALID, product: PA - Projects , description: This view displays the indirect cost components of all the non-summarized Commitment transactions of a project using the proper indirect rate schedules and revisions. , implementation_dba_data: APPS.PA_CMT_BURDEN_DETAIL_V ,
View: PA_CMT_BURDEN_DETAIL_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_CMT_BURDEN_DETAIL_V, object_name:PA_CMT_BURDEN_DETAIL_V, status:VALID, product: PA - Projects , description: This view displays the indirect cost components of all the non-summarized Commitment transactions of a project using the proper indirect rate schedules and revisions. , implementation_dba_data: APPS.PA_CMT_BURDEN_DETAIL_V ,