Search Results pa_ind_compiled_sets




Overview
Explore in AI Chat

Overview

The PA_IND_COMPILED_SETS table is a core data structure within the Oracle E-Business Suite Projects (PA) module, specifically for versions 12.1.1 and 12.2.2. As defined in the ETRM documentation, its primary function is to serve as a repository for "Groups of compiled multipliers." In practical terms, this table is integral to the indirect cost rate calculation engine. It stores distinct sets of compiled overhead or burden multipliers that have been processed and are ready for application to project transactions. These compiled sets are the calculated results of applying indirect rate schedule definitions to specific organizational and accounting contexts, enabling the system to efficiently assign indirect costs to projects, tasks, and expenditure items.

Key Information Stored

While the provided metadata does not list specific columns, the foreign key relationships and the table's purpose indicate the nature of the data it holds. Each record represents a unique compiled set. Critical columns logically include a primary key identifier (likely IND_COMPILED_SET_ID), a link to the source rate schedule via IND_RATE_SCH_REVISION_ID, and an ORGANIZATION_ID to tie the compiled multipliers to a specific business unit or department as defined in HR_ALL_ORGANIZATION_UNITS. The table would also contain columns for the effective date range of the compiled set, compilation status, and timestamps for creation and last update. The core "compiled multipliers" data itself is likely stored in a related detail table, which this set header record groups together.

Common Use Cases and Queries

The primary use case is supporting the real-time and periodic costing of project expenditures. When a cost distribution or invoice is created, the system references the appropriate active compiled set for the associated organization and rate schedule to apply indirect costs. Common reporting and audit queries involve identifying which compiled sets are active for a given organization or tracing the lineage of a compiled set back to its source rate schedule revision. A typical analytical query pattern would be:

  • Listing all compiled sets for a specific organization to review applicable overhead rates.
  • Joining to PA_IND_RATE_SCH_REVISIONS to compare compiled multiplier values against their source schedule definitions for variance analysis.
  • Identifying compiled sets by effective date to audit cost calculations for a specific period.

Related Objects

As per the documented foreign keys, PA_IND_COMPILED_SETS has direct and critical relationships with two other EBS objects. The most significant is PA_IND_RATE_SCH_REVISIONS, which stores the master definitions of indirect rate schedules. Each compiled set is derived from a specific revision of a schedule. The second key relationship is with HR_ALL_ORGANIZATION_UNITS, which provides the organizational context (e.g., department, division) for which the multipliers were compiled. Furthermore, this table is a parent to detail tables (such as PA_IND_COMPILED_MULTIPLIERS) that store the individual rate values. It is also referenced by the costing engine and various project accounting reports to determine the correct indirect cost rates during transaction processing.

  • Table: PA_IND_COMPILED_SETS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_IND_COMPILED_SETS,  object_name:PA_IND_COMPILED_SETS,  status:VALID,  product: PA - Projects ,  description: Groups of compiled multipliers ,  implementation_dba_data: PA.PA_IND_COMPILED_SETS , 

  • Table: PA_IND_COMPILED_SETS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_IND_COMPILED_SETS,  object_name:PA_IND_COMPILED_SETS,  status:VALID,  product: PA - Projects ,  description: Groups of compiled multipliers ,  implementation_dba_data: PA.PA_IND_COMPILED_SETS , 

  • Table: PA_IND_RATE_SCH_REVISIONS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_IND_RATE_SCH_REVISIONS,  object_name:PA_IND_RATE_SCH_REVISIONS,  status:VALID,  product: PA - Projects ,  description: Revisions within burden schedules ,  implementation_dba_data: PA.PA_IND_RATE_SCH_REVISIONS , 

  • Table: PA_IND_RATE_SCH_REVISIONS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_IND_RATE_SCH_REVISIONS,  object_name:PA_IND_RATE_SCH_REVISIONS,  status:VALID,  product: PA - Projects ,  description: Revisions within burden schedules ,  implementation_dba_data: PA.PA_IND_RATE_SCH_REVISIONS , 

  • View: PA_BURDEN_DETAILS_BASE_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_BURDEN_DETAILS_BASE_V,  object_name:PA_BURDEN_DETAILS_BASE_V,  status:VALID,  product: PA - Projects ,  description: View of burden cost components for a given compiled set ID, expenditure type, and expenditure organization. ,  implementation_dba_data: APPS.PA_BURDEN_DETAILS_BASE_V , 

  • 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_BURDEN_DETAILS_BASE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_BURDEN_DETAILS_BASE_V,  object_name:PA_BURDEN_DETAILS_BASE_V,  status:VALID,  product: PA - Projects ,  description: View of burden cost components for a given compiled set ID, expenditure type, and expenditure organization. ,  implementation_dba_data: APPS.PA_BURDEN_DETAILS_BASE_V , 

  • 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.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 , 

  • 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 ,