Search Results pa_events




Overview
Explore in AI Chat

Overview

The PA_EVENTS table is a core data structure within the Oracle E-Business Suite Projects (PA) module, specifically in versions 12.1.1 and 12.2.2. It serves as the master repository for event entities. An event is a business occurrence, such as a milestone or deliverable, that is assigned to a specific project task. Its primary function is to facilitate revenue recognition and billing for project work that is not directly tied to the consumption of labor or materials (expenditure items). This enables organizations to invoice clients based on contractual milestones or completion percentages, independent of the actual costs incurred.

Key Information Stored

The table stores the defining attributes for each project event. Its primary key is a composite of PROJECT_ID and EVENT_NUM, ensuring uniqueness within a project. Critical foreign key columns establish its relationships within the Projects data model. The TASK_ID links the event to a specific work breakdown structure element in PA_TASKS, while PROJECT_ID ties it to the master project definition in PA_PROJECTS_ALL. The EVENT_TYPE column references PA_EVENT_TYPES_B, classifying the event (e.g., milestone, progress payment). For funded projects, PROJECT_FUNDING_ID links to the PA_PROJECT_FUNDINGS table. Additional columns support financial planning, including AUDIT_COST_PLAN_TYPE_ID and AUDIT_REV_PLAN_TYPE_ID, which reference PA_FIN_PLAN_TYPES_B for audit trail purposes.

Common Use Cases and Queries

The primary use case is generating revenue and invoice lines for milestone-based or event-driven billing. Common reporting needs include listing all events for a project, summarizing events by type, or identifying events ready for invoicing based on their status. Integration with Oracle Grants Accounting (GMS) is also prevalent, as evidenced by the foreign key relationships, for tracking events against awards. A typical query to retrieve event details for reporting would join to related descriptive tables.

SELECT pe.event_num,
       pe.event_type,
       pt.task_number,
       pet.name event_type_name,
       ppa.segment1 project_number
  FROM pa_events pe,
       pa_tasks pt,
       pa_event_types_tl pet,
       pa_projects_all ppa
 WHERE pe.project_id = :p_project_id
   AND pe.task_id = pt.task_id
   AND pe.project_id = pt.project_id
   AND pe.event_type = pet.event_type
   AND pe.project_id = ppa.project_id
   AND pet.language = USERENV('LANG');

Related Objects

PA_EVENTS is centrally connected to several key tables. It is a child of PA_PROJECTS_ALL, PA_TASKS, and PA_EVENT_TYPES. For funded projects, it relates to PA_PROJECT_FUNDINGS. Its integration with Oracle Grants Accounting is extensive, acting as a parent table to GMS_ENCUMBRANCE_ITEMS_ALL, GMS_EVENT_INTERSECT, and GMS_EVENT_ATTRIBUTE for award management. From a process perspective, events are typically created and managed via the Oracle Projects application programming interfaces (APIs) or through the standard user interface, which ensures proper validation and business rule enforcement.