Search Results pa_cint_rate_multipliers




Overview
Explore in AI Chat

Overview

The PA_CINT_RATE_MULTIPLIERS table is a core data repository within the Oracle E-Business Suite Projects (PA) module, specifically supporting the Capitalized Interest (CINT) functionality. Its primary role is to store denormalized, compiled data from capitalized interest schedule revisions. This compiled data, which includes calculated multipliers, is directly utilized by the system's engine during the automated calculation and generation of capitalized interest journal transactions. The table acts as a critical intermediary, holding the processed rate information ready for application to project expenditures, thereby enabling the proper accounting treatment of interest as a capitalizable cost in compliance with relevant accounting standards.

Key Information Stored

The table's structure centers on linking schedule revisions to specific organizations and rate definitions, storing the resultant multipliers. Key columns, as indicated by its foreign key relationships, include IND_RATE_SCH_REVISION_ID, which ties the record to a specific revision in PA_IND_RATE_SCH_REVISIONS. The ORGANIZATION_ID links to HR_ALL_ORGANIZATION_UNITS, enforcing business group or operating unit context. The IND_RATE_SCH_ID references the master schedule in PA_IND_RATE_SCHEDULES_ALL_BG, while RATE_NAME points to a specific rate code within PA_IND_COST_CODES. The table also tracks the process that populated it via REQUEST_ID (linking to FND_CONCURRENT_REQUESTS) and PROGRAM_APPLICATION_ID (linking to FND_APPLICATION). The central data point is the multiplier value itself, which is applied to a base rate during transaction generation.

Common Use Cases and Queries

The primary use case is the backend processing of capitalized interest. Following the compilation of a rate schedule revision, this table is populated. System processes then query it to determine the correct multiplier for a given organization, rate name, and effective period. Common queries involve auditing the multipliers in effect for a specific schedule or troubleshooting calculation discrepancies. A typical analytical query might join to related tables to list compiled rates.

SELECT pcrm.rate_name,
       pcrm.multiplier,
       hou.name organization_name,
       pairs.revision_num
  FROM pa.pa_cint_rate_multipliers pcrm,
       hr.hr_all_organization_units hou,
       pa.pa_ind_rate_sch_revisions pairs
 WHERE pcrm.organization_id = hou.organization_id
   AND pcrm.ind_rate_sch_revision_id = pairs.ind_rate_sch_revision_id
   AND pairs.ind_rate_sch_id = 12345;

Related Objects

  • PA_IND_RATE_SCH_REVISIONS: The source of the revision data stored denormalized in this table.
  • PA_IND_RATE_SCHEDULES_ALL_BG: The master definition of the indirect rate schedule.
  • PA_IND_COST_CODES: Defines the valid rate names (cost codes) that can be associated with a multiplier.
  • HR_ALL_ORGANIZATION_UNITS: Provides the organization context for the multiplier.
  • FND_CONCURRENT_REQUESTS: Tracks the concurrent request that populated the table records.