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).
  • Table: PA_CI_COMMENTS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_CI_COMMENTS,  object_name:PA_CI_COMMENTS,  status:VALID,  product: PA - Projects ,  description: This table stores all the comments in the action log. A comment can be a requestor, closure or progress comment on an action, or unsolicited comment to the control item. For each action, there will be only one requestor comment and one cl ,  implementation_dba_data: PA.PA_CI_COMMENTS , 

  • Table: PA_CI_COMMENTS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_CI_COMMENTS,  object_name:PA_CI_COMMENTS,  status:VALID,  product: PA - Projects ,  description: This table stores all the comments in the action log. A comment can be a requestor, closure or progress comment on an action, or unsolicited comment to the control item. For each action, there will be only one requestor comment and one cl ,  implementation_dba_data: PA.PA_CI_COMMENTS , 

  • Table: PA_CI_ACTIONS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_CI_ACTIONS,  object_name:PA_CI_ACTIONS,  status:VALID,  product: PA - Projects ,  description: This table stores the action log for each control item. Each entry stores the complete requesting information and response. ,  implementation_dba_data: PA.PA_CI_ACTIONS , 

  • Table: PA_CI_ACTIONS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_CI_ACTIONS,  object_name:PA_CI_ACTIONS,  status:VALID,  product: PA - Projects ,  description: This table stores the action log for each control item. Each entry stores the complete requesting information and response. ,  implementation_dba_data: PA.PA_CI_ACTIONS , 

  • View: PA_CI_COMMENTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CI_COMMENTS_V,  object_name:PA_CI_COMMENTS_V,  status:VALID,  product: PA - Projects ,  description: This view provides the attribute values from all comments from the table PA_CI_COMMENTS. ,  implementation_dba_data: APPS.PA_CI_COMMENTS_V , 

  • View: PA_CI_COMMENTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CI_COMMENTS_V,  object_name:PA_CI_COMMENTS_V,  status:VALID,  product: PA - Projects ,  description: This view provides the attribute values from all comments from the table PA_CI_COMMENTS. ,  implementation_dba_data: APPS.PA_CI_COMMENTS_V , 

  • View: PA_CI_ACTIONS_QA_V 12.1.1

    product: PA - Projects ,  description: This view lists the action log on the Question/Answer format ,  implementation_dba_data: Not implemented in this database , 

  • View: PA_CI_ACTIONS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CI_ACTIONS_V,  object_name:PA_CI_ACTIONS_V,  status:VALID,  product: PA - Projects ,  description: This view provides the atrribute values for Action Lists ,  implementation_dba_data: APPS.PA_CI_ACTIONS_V , 

  • View: PA_CI_ACTIONS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CI_ACTIONS_V,  object_name:PA_CI_ACTIONS_V,  status:VALID,  product: PA - Projects ,  description: This view provides the atrribute values for Action Lists ,  implementation_dba_data: APPS.PA_CI_ACTIONS_V , 

  • View: PA_CI_ACTIONS_QA_V 12.2.2

    product: PA - Projects ,  description: This view lists the action log on the Question/Answer format ,  implementation_dba_data: Not implemented in this database , 

  • Table: PA_CONTROL_ITEMS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_CONTROL_ITEMS,  object_name:PA_CONTROL_ITEMS,  status:VALID,  product: PA - Projects ,  description: PA_CONTROL_ITEMS stores user-defined control items in a project. Each item is of an item type as specified by the CI_TYPE_ID column. The items are categorized using the Classification, Reason and Priority attributes ,  implementation_dba_data: PA.PA_CONTROL_ITEMS , 

  • Table: PA_CONTROL_ITEMS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_CONTROL_ITEMS,  object_name:PA_CONTROL_ITEMS,  status:VALID,  product: PA - Projects ,  description: PA_CONTROL_ITEMS stores user-defined control items in a project. Each item is of an item type as specified by the CI_TYPE_ID column. The items are categorized using the Classification, Reason and Priority attributes ,  implementation_dba_data: PA.PA_CONTROL_ITEMS , 

  • View: PA_CI_ACTIONS_CHRO_V 12.2.2

    product: PA - Projects ,  description: This view lists the action log in the chronological format. In the view, the requests and the responses will have separate entries. ,  implementation_dba_data: Not implemented in this database , 

  • View: PA_CI_ACTIONS_CHRO_V 12.1.1

    product: PA - Projects ,  description: This view lists the action log in the chronological format. In the view, the requests and the responses will have separate entries. ,  implementation_dba_data: Not implemented in this database , 

  • View: PA_LAUNCH_PAGE_ACTIONS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_LAUNCH_PAGE_ACTIONS_V,  object_name:PA_LAUNCH_PAGE_ACTIONS_V,  status:VALID,  product: PA - Projects ,  description: PA_LAUNCH_PAGE_ACTIONS_V gives the consolidated list of actions ,  implementation_dba_data: APPS.PA_LAUNCH_PAGE_ACTIONS_V , 

  • View: PA_LAUNCH_PAGE_ACTIONS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_LAUNCH_PAGE_ACTIONS_V,  object_name:PA_LAUNCH_PAGE_ACTIONS_V,  status:VALID,  product: PA - Projects ,  description: PA_LAUNCH_PAGE_ACTIONS_V gives the consolidated list of actions ,  implementation_dba_data: APPS.PA_LAUNCH_PAGE_ACTIONS_V ,