Results for “pa_cint_source_details”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_CINT_SOURCE_DETAILS is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the source detail expenditures used to generate the associated Capitalized Interest transactions. Capitalized interest represents the cost of borrowing attributable to the construction or acquisition of a qualifying asset, and Oracle Projects capitalizes that interest onto the project as a cost. This table records the underlying expenditure lines that drive the calculation, tying each capitalized interest result back to the specific allocation transaction and expenditure item that produced it. The table is owned by the PA schema and is documented as VALID and holding fourteen columns.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this object heuristically as a link. This is a modeling suggestion rather than a physical implementation statement: the table behaves as an associative relationship capturing the intersection of an allocation transaction, a project, and an expenditure item, qualified by fiscal and period context.

Key Information Stored

The table records the classification and measurement of source expenditures feeding capitalized interest. The most significant columns are:

• ALLOC_TXN_ID – Foreign key to PA_ALLOC_TXN_DETAILS; identifies the allocation transaction detail that produced the capitalized interest source line.
• PROJECT_ID – Foreign key to PA_PROJECTS_ALL; identifies the project against which the capitalized interest is computed.
• EXPENDITURE_ITEM_ID – Foreign key to PA_EXPENDITURE_ITEMS_ALL; identifies the specific expenditure item being sourced.
• FISCAL_YEAR and PERIOD_NUM – Define the accounting period context of the source amount, enabling period-by-period reporting.
• RUN_PERIOD_END_DATE – The period end date associated with the capitalization run, used to align the calculation window.
• LINE_NUM – Sequence number ordering source lines within a transaction context.
• PRIOR_AMOUNT and CURRENT_AMOUNT – The prior and current period source amounts, which drive the capitalized interest arithmetic.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN – Standard EBS audit columns capturing who created and modified each row and when.

The documented metadata does not expose a single-column surrogate primary key; the combination of ALLOC_TXN_ID, EXPENDITURE_ITEM_ID, FISCAL_YEAR, and PERIOD_NUM serves as the practical business key that uniquely identifies a source detail line.

Common Use Cases and Queries

Typical applications include reconciliation of capitalized interest transactions to their source expenditures, period-based reporting of prior versus current amounts, and audit trails. A representative query joins the table to its parent allocation and project records:

• Selecting source details for a project in a given period: SELECT project_id, expenditure_item_id, fiscal_year, period_num, prior_amount, current_amount FROM pa.pa_cint_source_details WHERE project_id = :p_project_id AND fiscal_year = :p_year AND period_num = :p_period.
• Joining to PA_ALLOC_TXN_DETAILS on ALLOC_TXN_ID to trace the originating allocation transaction.
• Joining to PA_EXPENDITURE_ITEMS_ALL on EXPENDITURE_ITEM_ID to retrieve expenditure attributes.
• Aggregating PRIOR_AMOUNT and CURRENT_AMOUNT by project and period for capitalized interest reporting.

Related Objects

• PA_ALLOC_TXN_DETAILS – Referenced via ALLOC_TXN_ID; the parent allocation transaction detail.
• PA_PROJECTS_ALL – Referenced via PROJECT_ID; supplies project definition and organization data.
• PA_EXPENDITURE_ITEMS_ALL – Referenced via EXPENDITURE_ITEM_ID; the source expenditure item.
• PA_CINT_TRANSACTIONS (conceptual) – The capitalized interest transaction table populated from these source details.
• PA_PERIODS_ALL – Provides period definitions consumable through FISCAL_YEAR and PERIOD_NUM.