Search Results pa_cint_source_details




Overview
Explore in AI Chat

Overview

The PA_CINT_SOURCE_DETAILS table is a core data object within the Oracle E-Business Suite (EBS) Projects (PA) module, specifically for releases 12.1.1 and 12.2.2. It serves a critical function in the management of capitalized interest. The table's primary role is to store a detailed audit trail of the source expenditure lines that were used as the basis for generating specific capitalized interest transactions. This establishes a direct and traceable link between the original project costs and the subsequent financial adjustments for interest capitalization, ensuring compliance with accounting standards and enabling detailed reconciliation.

Key Information Stored

The table's structure is designed to capture the relationship between a capitalized interest transaction and its originating costs. While the full column list is not detailed in the provided metadata, the documented foreign key relationships reveal its most critical data points. The ALLOC_TXN_ID column is a key identifier, linking each record to a specific transaction detail line in the PA_ALLOC_TXN_DETAILS table, which represents the generated capitalized interest entry. The PROJECT_ID column links the data to a specific project in the PA_PROJECTS_ALL table. Collectively, each record in this table answers the fundamental question: which source expenditure detail (the "source") was used to calculate a given portion of capitalized interest (the "target" transaction).

Common Use Cases and Queries

The primary use case for this table is audit and reconciliation reporting for capitalized interest. Financial controllers and project accountants query this table to verify the calculation integrity of capitalized interest amounts and to trace them back to original project expenditures. A common reporting pattern involves joining to the transaction and project master tables. For example, to list all source expenditures for capitalized interest transactions on a specific project, one might use a query such as:

  • SELECT psd.* FROM pa_cint_source_details psd, pa_projects_all ppa WHERE psd.project_id = ppa.project_id AND ppa.segment1 = '&PROJECT_NUMBER';

Another critical scenario is troubleshooting during period close or during the execution of the capitalized interest process itself, where verifying the source data for specific transaction batches is required. Queries typically join through ALLOC_TXN_ID to PA_ALLOC_TXN_DETAILS and related transaction tables to pull both the source reference and the resulting interest amounts.

Related Objects

The PA_CINT_SOURCE_DETAILS table has defined foreign key relationships with two primary tables, as per the provided metadata. These relationships are fundamental to its integrity and reporting utility.

  • PA_ALLOC_TXN_DETAILS: This is the most direct relationship. The column PA_CINT_SOURCE_DETAILS.ALLOC_TXN_ID references PA_ALLOC_TXN_DETAILS. This links each source expenditure detail to the actual capitalized interest transaction line it helped create.
  • PA_PROJECTS_ALL: The column PA_CINT_SOURCE_DETAILS.PROJECT_ID references PA_PROJECTS_ALL. This ensures all sourced expenditures are tied to a valid project, providing the necessary context for project-specific reporting and controls.

While not listed in the provided excerpt, this table is also logically related to other Projects module tables such as PA_EXPENDITURE_ITEMS_ALL, which likely holds the detailed source expenditure records referenced by the data stored in PA_CINT_SOURCE_DETAILS.

  • Table: PA_CINT_SOURCE_DETAILS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_CINT_SOURCE_DETAILS,  object_name:PA_CINT_SOURCE_DETAILS,  status:VALID,  product: PA - Projects ,  description: Stores the source detail expenditures used to create the associated Capitalized Interest transactions. ,  implementation_dba_data: PA.PA_CINT_SOURCE_DETAILS , 

  • Table: PA_CINT_SOURCE_DETAILS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_CINT_SOURCE_DETAILS,  object_name:PA_CINT_SOURCE_DETAILS,  status:VALID,  product: PA - Projects ,  description: Stores the source detail expenditures used to create the associated Capitalized Interest transactions. ,  implementation_dba_data: PA.PA_CINT_SOURCE_DETAILS , 

  • Table: PA_ALLOC_TXN_DETAILS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_ALLOC_TXN_DETAILS,  object_name:PA_ALLOC_TXN_DETAILS,  status:VALID,  product: PA - Projects ,  description: Transactions created by an allocation run ,  implementation_dba_data: PA.PA_ALLOC_TXN_DETAILS , 

  • Table: PA_ALLOC_TXN_DETAILS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_ALLOC_TXN_DETAILS,  object_name:PA_ALLOC_TXN_DETAILS,  status:VALID,  product: PA - Projects ,  description: Transactions created by an allocation run ,  implementation_dba_data: PA.PA_ALLOC_TXN_DETAILS , 

  • Table: PA_PROJECTS_ALL 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECTS_ALL,  object_name:PA_PROJECTS_ALL,  status:VALID,  product: PA - Projects ,  description: PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects. ,  implementation_dba_data: PA.PA_PROJECTS_ALL , 

  • Table: PA_PROJECTS_ALL 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECTS_ALL,  object_name:PA_PROJECTS_ALL,  status:VALID,  product: PA - Projects ,  description: PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects. ,  implementation_dba_data: PA.PA_PROJECTS_ALL ,