Search Results pa_ci_comments




Overview
Explore in AI Chat

Overview

The PA_CI_COMMENTS table is a core data repository within the Oracle E-Business Suite (EBS) Projects module, specifically for the Control Items functionality. It serves as the central audit log for all textual commentary associated with project control items, which are used to track issues, changes, and other action items. Its primary role is to store the complete history of comments made throughout a control item's lifecycle, including comments from requestors, assignees, and other stakeholders. This ensures a persistent and auditable record of communication and rationale for actions taken, which is critical for project governance and compliance.

Key Information Stored

The table's structure is designed to link comments to specific control items and their associated actions. The primary key, CI_COMMENT_ID, uniquely identifies each comment record. Two critical foreign keys establish the core relationships: CI_ID links the comment to its parent control item in the PA_CONTROL_ITEMS table, and CI_ACTION_ID links it to a specific workflow action recorded in the PA_CI_ACTIONS table. Other essential columns typically include COMMENT_TEXT for storing the comment body, COMMENT_TYPE to classify the comment (e.g., as a requestor, closure, progress, or unsolicited comment), and CREATION_DATE/CREATED_BY for audit purposes. As per the documentation, a key business rule is enforced: for each action, there can be only one requestor comment and one closure comment.

Common Use Cases and Queries

A primary use case is generating audit reports for project control items, tracing the complete discussion and resolution history. Support personnel often query this table to understand the context behind an action when troubleshooting. Common SQL patterns involve joining to PA_CONTROL_ITEMS and PA_CI_ACTIONS. For example, to retrieve all comments for a specific control item, a query would join PA_CI_COMMENTS on CI_ID to PA_CONTROL_ITEMS. To see the sequence of actions and their corresponding comments, a three-way join between PA_CONTROL_ITEMS, PA_CI_ACTIONS, and PA_CI_COMMENTS (on CI_ACTION_ID) is standard. Reporting often focuses on comments of a specific type, such as extracting all closure comments to analyze resolution notes.

Related Objects

  • PA_CONTROL_ITEMS: The parent table. The PA_CI_COMMENTS.CI_ID column is a foreign key to PA_CONTROL_ITEMS.CI_ID.
  • PA_CI_ACTIONS: The action log table. The PA_CI_COMMENTS.CI_ACTION_ID column is a foreign key to PA_CI_ACTIONS.CI_ACTION_ID, linking each comment to a specific workflow step.
  • PA_CI_COMMENTS_PK: The primary key constraint on the CI_COMMENT_ID column.
  • User & Lookup Tables: The CREATED_BY column typically joins to FND_USER, and COMMENT_TYPE may reference a lookup (e.g., PA_CI_COMMENT_TYPES).