Search Results pa_ci_actions




Overview
Explore in AI Chat

Overview

The PA_CI_ACTIONS table is a core transactional entity within the Oracle E-Business Suite Projects module, specifically for the Control Items functionality. It serves as the definitive action log or audit trail for every control item (CI) created in the system. Each row in this table represents a discrete action performed on a control item, such as its creation, assignment, status update, or closure. Its primary role is to persistently store the complete context of each request and its corresponding response, ensuring a full historical record of the control item's lifecycle for compliance, reporting, and process management.

Key Information Stored

The table's structure is designed to capture the who, what, when, and why of each control item action. The primary key, CI_ACTION_ID, uniquely identifies each logged action. The most critical foreign key is CI_ID, which ties every action to its parent control item in the PA_CONTROL_ITEMS table. Other essential columns include STATUS_CODE, linking the action to a defined project status, and ASSIGNED_TO, which records the party (from HZ_PARTIES) responsible for the action. The table also supports action chaining through the SOURCE_CI_ACTION_ID column, which can reference a prior action within the same table, enabling the tracking of related or follow-up activities.

Common Use Cases and Queries

This table is central to generating audit reports and analyzing the workflow of control items. Common use cases include tracing the complete history of a specific control item, measuring turnaround times between status changes, and identifying bottlenecks in the review process. A typical query would join PA_CI_ACTIONS to PA_CONTROL_ITEMS and HZ_PARTIES to produce a detailed action log. For example:

  • To retrieve the full audit trail for a control item: SELECT a.* FROM pa_ci_actions a WHERE a.ci_id = :p_ci_id ORDER BY a.creation_date;
  • To report on all actions performed by a specific assignee within a date range: SELECT ci.ci_number, a.status_code, a.creation_date FROM pa_ci_actions a, pa_control_items ci WHERE a.ci_id = ci.ci_id AND a.assigned_to = :p_party_id AND a.creation_date BETWEEN :p_start_date AND :p_end_date;

Related Objects

PA_CI_ACTIONS is a hub within the Control Items schema, with several key dependencies. Its primary relationship is with the PA_CONTROL_ITEMS table, the master for all control items. It references the PA_PROJECT_STATUSES table for valid status codes and the HZ_PARTIES table for resource assignment. The self-referencing foreign key on SOURCE_CI_ACTION_ID indicates a hierarchical relationship between actions. Furthermore, the PA_CI_COMMENTS table is a direct child, storing comments linked to specific actions via the CI_ACTION_ID column, forming a complete record of communication for each step in the process.