Search Results pa_cint_rate_info_all




Overview
Explore in AI Chat

Overview

The PA_CINT_RATE_INFO_ALL table is a core data structure within the Oracle E-Business Suite Projects (PA) module, specifically for releases 12.1.1 and 12.2.2. It functions as the central repository for configuration rules governing the calculation of capitalized interest. Capitalized interest refers to the accounting practice of adding incurred interest costs to the value of a capital asset, rather than expensing it immediately. This table stores the operational parameters that define how this calculation is performed for each operating unit, linking specific project financial controls—such as budget types and financial plan types—to the applicable interest calculation methods and rates. Its role is critical for ensuring accurate financial reporting and compliance with accounting standards for capital projects.

Key Information Stored

While the full column list is not provided in the metadata, the documented foreign key relationships and description indicate the table holds key configuration identifiers. The primary columns include ORG_ID, which stores the operating unit identifier, linking the configuration to a specific business entity in HR_ALL_ORGANIZATION_UNITS. The table also contains BUDGET_TYPE_CODE, referencing PA_BUDGET_TYPES, and FIN_PLAN_TYPE_ID, referencing PA_FIN_PLAN_TYPES_B, to specify which budget and financial plan types the capitalized interest rules apply to. Furthermore, IND_COST_CODE links to PA_IND_COST_CODES, indicating the specific indirect cost code used for the interest calculation. Additional columns likely store the effective dates, interest rate sources, calculation methods (e.g., average balance, specific identification), and status controls.

Common Use Cases and Queries

The primary use case is the setup and maintenance of capitalized interest calculation rules during project financial configuration. Financial administrators query this table to audit or report on the established rules across operating units. A common reporting query involves joining to the referenced tables to display a comprehensive view of the setup.

Sample Query:
SELECT pcria.org_id,
haou.name operating_unit,
pcria.budget_type_code,
pbt.name budget_type_name,
pcria.ind_cost_code,
picc.ind_cost_code_description
FROM pa_cint_rate_info_all pcria,
hr_all_organization_units haou,
pa_budget_types pbt,
pa_ind_cost_codes picc
WHERE pcria.org_id = haou.organization_id
AND pcria.budget_type_code = pbt.budget_type_code
AND pcria.ind_cost_code = picc.ind_cost_code
AND pcria.org_id = :p_org_id;

Related Objects

The table maintains defined foreign key relationships with several master tables, as documented in the ETRM metadata:

  • PA_IND_COST_CODES: Joined via PA_CINT_RATE_INFO_ALL.IND_COST_CODE to define the applicable indirect cost code for interest.
  • PA_BUDGET_TYPES: Joined via PA_CINT_RATE_INFO_ALL.BUDGET_TYPE_CODE to specify the budget type for the rule.
  • PA_FIN_PLAN_TYPES_B: Joined via PA_CINT_RATE_INFO_ALL.FIN_PLAN_TYPE_ID to specify the financial plan type for the rule.
  • HR_ALL_ORGANIZATION_UNITS: Joined via PA_CINT_RATE_INFO_ALL.ORG_ID to scope the rule to a specific operating unit.

This table is a parent to transactional data, and its configurations are referenced during the automated capitalized interest calculation and posting processes within the Projects module.