Search Results pa_ind_compiled_sets

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.