Search Results pa_capital_events




Overview
Explore in AI Chat

Overview

The PA_CAPITAL_EVENTS table is a core transactional table within the Oracle E-Business Suite Projects (PA) module, specifically for releases 12.1.1 and 12.2.2. It serves as the central repository for capital event records, which are fundamental to the capitalization and retirement accounting processes for project-related assets. These events are used to logically group project costs and assets for subsequent capitalization into fixed assets or to generate retirement cost adjustments. The creation of these events is governed by the Event Processing Method defined at the project level; they can be system-generated automatically or manually created by users to fulfill specific accounting requirements.

Key Information Stored

The table's primary identifier is the CAPITAL_EVENT_ID. Each record is tied to a specific PROJECT_ID, linking the event to a project in PA_PROJECTS_ALL. Key descriptive and control columns include the EVENT_NUMBER, EVENT_DATE, and a STATUS_CODE to track the event's lifecycle (e.g., PENDING, PROCESSED). The EVENT_TYPE_CODE distinguishes between standard capitalization events and retirement adjustment events. The table also captures system control information, such as the REQUEST_ID of the concurrent request that created or processed the event, and PROGRAM_APPLICATION_ID for integration purposes. Additional columns store accounting attributes like the GL period and date for posting, ensuring costs are capitalized in the correct accounting period.

Common Use Cases and Queries

A primary use case is tracing the capitalization flow from project expenditure to fixed assets. Analysts often query this table to list all capital events for a project or to identify events pending processing. For reporting, a join with expenditure items is essential to summarize costs grouped by a specific capital event. A typical query pattern involves:

  • Identifying events for asset creation: SELECT event_number, event_date, status_code FROM pa_capital_events WHERE project_id = :p_project_id AND event_type_code = 'CAPITALIZATION';
  • Linking events to their source costs: SELECT e.capital_event_id, e.event_number, SUM(i.raw_cost) FROM pa_capital_events e, pa_expenditure_items_all i WHERE e.capital_event_id = i.capital_event_id GROUP BY e.capital_event_id, e.event_number;
  • Troubleshooting processing errors by checking events stuck in a 'PENDING' status along with their associated concurrent request ID.

Related Objects

PA_CAPITAL_EVENTS has defined foreign key relationships with several key tables, as documented in the ETRM metadata. It is a parent table to expenditure items and project asset records, and a child table to projects and application entities.