Search Results pa_txn_accum_details




Overview
Explore in AI Chat

Overview

The PA_TXN_ACCUM_DETAILS table is a core transactional table within the Oracle E-Business Suite Projects (PA) module, specifically in versions 12.1.1 and 12.2.2. It functions as a detailed drilldown ledger, providing the essential link between summarized project transaction data and its originating source distribution lines. Its primary role is to store the granular relationships that connect aggregated financial amounts in the PA_TXN_ACCUM summary table to the underlying cost distributions, revenue distributions, event revenue distributions, and commitment transactions. This structure is critical for audit trails, detailed reporting, and enabling users to navigate from high-level project performance figures to the individual transaction lines that compose them.

Key Information Stored

The table's structure is primarily defined by its foreign key columns, which serve as pointers to source transaction lines. The central column is TXN_ACCUM_ID, which links each detail record back to its parent summary record in PA_TXN_ACCUM. The other key columns identify the specific source transaction, with their usage dependent on the transaction type. These include EXPENDITURE_ITEM_ID and LINE_NUM for linking to PA_COST_DISTRIBUTION_LINES_ALL, the same pair for PA_CUST_REV_DIST_LINES_ALL, and PROJECT_ID, EVENT_NUM, TASK_ID, and LINE_NUM for linking to PA_CUST_EVENT_RDL_ALL. For commitments, the CMT_LINE_ID column references PA_COMMITMENT_TXNS. The table also denormalizes PROJECT_ID and TASK_ID for direct querying and validation against PA_PROJECTS_ALL and PA_TASKS.

Common Use Cases and Queries

This table is indispensable for reconciliation and investigative reporting. A primary use case is drilling down from a project or task's summarized cost or revenue to view all constituent transactions. For instance, to analyze the detailed cost lines behind a summarized amount, a query would join PA_TXN_ACCUM, PA_TXN_ACCUM_DETAILS, and PA_COST_DISTRIBUTION_LINES_ALL. It is also critical for audit purposes, providing a verifiable path from project-level general ledger postings back to the original project expenditure items or revenue events. Standard report customizations often leverage this table to add source document identifiers or dates to summary project performance reports. A typical query pattern involves filtering the parent PA_TXN_ACCUM by a specific PROJECT_ID and PERIOD_NAME, then joining to the detail table and the appropriate source distribution table based on the transaction type.

Related Objects

PA_TXN_ACCUM_DETAILS is a central hub with defined foreign key relationships to several key transactional and master tables in the Projects schema. The documented relationships are as follows:

  • PA_TXN_ACCUM: The parent summary table. Joined via PA_TXN_ACCUM_DETAILS.TXN_ACCUM_ID.
  • PA_COST_DISTRIBUTION_LINES_ALL: For cost transaction details. Joined via EXPENDITURE_ITEM_ID and LINE_NUM.
  • PA_CUST_REV_DIST_LINES_ALL: For revenue transaction details. Joined via EXPENDITURE_ITEM_ID and LINE_NUM.
  • PA_CUST_EVENT_RDL_ALL: For event revenue details. Joined via PROJECT_ID, EVENT_NUM, TASK_ID, and LINE_NUM.
  • PA_COMMITMENT_TXNS: For purchase order and requisition commitments. Joined via CMT_LINE_ID.
  • PA_PROJECTS_ALL: Project master validation. Joined via PROJECT_ID.
  • PA_TASKS: Task master validation. Joined via TASK_ID.