Search Results pa_control_items




Overview
Explore in AI Chat

Overview

The PA_CONTROL_ITEMS table is a core data structure within Oracle E-Business Suite Projects (PA) module, versions 12.1.1 and 12.2.2. It serves as the central repository for user-defined control items within a project. A control item is a flexible, configurable object used to track and manage various project artifacts, such as issues, risks, changes, or deliverables. The table's primary role is to store the master definition and current state of each control item, linking it to a specific project and categorizing it by type, status, and other key attributes. Its design enables comprehensive project governance and tracking capabilities.

Key Information Stored

The table stores the essential attributes that define a control item's identity, context, and lifecycle. The primary key is the unique identifier CI_ID. Critical foreign key columns establish core relationships: PROJECT_ID links the item to a specific project in PA_PROJECTS_ALL, and CI_TYPE_ID defines its category (e.g., Risk, Issue) via PA_CI_TYPES_B. Status management is handled through STATUS_CODE and PROGRESS_STATUS_CODE, both referencing PA_PROJECT_STATUSES. The table also stores descriptive attributes like CLASSIFICATION, REASON, and PRIORITY for categorization, as well as ownership and audit information via OWNER_ID, LAST_MODIFIED_BY_ID, and CLOSED_BY_ID (linking to HZ_PARTIES).

Common Use Cases and Queries

Common use cases include generating reports on all open issues for a project, analyzing risk trends by classification, or listing change requests assigned to a specific owner. A typical query retrieves control items with their project and type descriptions:

  • SELECT pci.ci_id, pci.ci_number, ppa.segment1 project_number, pct.name ci_type_name, pci.classification, pci.status_code FROM pa_control_items pci, pa_projects_all ppa, pa_ci_types_tl pct WHERE pci.project_id = ppa.project_id AND pci.ci_type_id = pct.ci_type_id AND pct.language = USERENV('LANG') AND ppa.segment1 = 'P12345';

Another frequent pattern is joining to status tables to get meaningful status names or querying for items based on their lifecycle state, such as all items not yet closed (status_code != 'CLOSED').

Related Objects

PA_CONTROL_ITEMS has extensive relationships, acting as a hub for control item data. Key foreign key relationships, where this table is the parent, include:

It is also referenced in PA_OBJECT_RELATIONSHIPS (via OBJECT_ID_TO1 and OBJECT_ID_FROM1) to establish relationships with other project objects and in PA_OBJ_STATUS_CHANGES (PCM_CI_ID) for auditing status history.

  • 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 , 

  • Table: PA_OBJECT_RELATIONSHIPS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_OBJECT_RELATIONSHIPS,  object_name:PA_OBJECT_RELATIONSHIPS,  status:VALID,  product: PA - Projects ,  description: This table is used to store all relationships relating to projects, structures and tasks. ,  implementation_dba_data: PA.PA_OBJECT_RELATIONSHIPS , 

  • Table: PA_OBJECT_RELATIONSHIPS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_OBJECT_RELATIONSHIPS,  object_name:PA_OBJECT_RELATIONSHIPS,  status:VALID,  product: PA - Projects ,  description: This table is used to store all relationships relating to projects, structures and tasks. ,  implementation_dba_data: PA.PA_OBJECT_RELATIONSHIPS , 

  • Table: PA_PROJECT_STATUSES 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECT_STATUSES,  object_name:PA_PROJECT_STATUSES,  status:VALID,  product: PA - Projects ,  description: Valid project status codes ,  implementation_dba_data: PA.PA_PROJECT_STATUSES , 

  • Table: PA_PROJECT_STATUSES 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECT_STATUSES,  object_name:PA_PROJECT_STATUSES,  status:VALID,  product: PA - Projects ,  description: Valid project status codes ,  implementation_dba_data: PA.PA_PROJECT_STATUSES , 

  • View: PA_CI_SUPPLIER_DETAILS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CI_SUPPLIER_DETAILS_V,  object_name:PA_CI_SUPPLIER_DETAILS_V,  status:VALID,  product: PA - Projects ,  description: Pa_ci_supplier_details_v is view used to desgin UI screen ,  implementation_dba_data: APPS.PA_CI_SUPPLIER_DETAILS_V , 

  • View: PA_CI_SUPPLIER_DETAILS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CI_SUPPLIER_DETAILS_V,  object_name:PA_CI_SUPPLIER_DETAILS_V,  status:VALID,  product: PA - Projects ,  description: Pa_ci_supplier_details_v is view used to desgin UI screen ,  implementation_dba_data: APPS.PA_CI_SUPPLIER_DETAILS_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_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 , 

  • Table: PA_CI_SUPPLIER_DETAILS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_CI_SUPPLIER_DETAILS,  object_name:PA_CI_SUPPLIER_DETAILS,  status:VALID,  product: PA - Projects ,  description: A new entity PA_CI_SUPPLIER_DETAILS, which stores the details of impact of change orders on Suppliers and Purchase Orders. This entity contains the following attributes ,  implementation_dba_data: PA.PA_CI_SUPPLIER_DETAILS , 

  • 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_IMPACTS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_CI_IMPACTS,  object_name:PA_CI_IMPACTS,  status:VALID,  product: PA - Projects ,  description: This table stores impacts identified for the control item. ,  implementation_dba_data: PA.PA_CI_IMPACTS , 

  • Table: PA_OBJ_STATUS_CHANGES 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_OBJ_STATUS_CHANGES,  object_name:PA_OBJ_STATUS_CHANGES,  status:VALID,  product: PA - Projects ,  description: This table records the changes of the status of the objects. ,  implementation_dba_data: PA.PA_OBJ_STATUS_CHANGES , 

  • Table: PA_OBJ_STATUS_CHANGES 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_OBJ_STATUS_CHANGES,  object_name:PA_OBJ_STATUS_CHANGES,  status:VALID,  product: PA - Projects ,  description: This table records the changes of the status of the objects. ,  implementation_dba_data: PA.PA_OBJ_STATUS_CHANGES , 

  • Table: PA_CI_IMPACTS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_CI_IMPACTS,  object_name:PA_CI_IMPACTS,  status:VALID,  product: PA - Projects ,  description: This table stores impacts identified for the control item. ,  implementation_dba_data: PA.PA_CI_IMPACTS , 

  • View: PA_CI_CLASS_DESC_V 12.2.2

    product: PA - Projects ,  implementation_dba_data: Not implemented in this database , 

  • View: PA_CI_CLASS_DESC_V 12.1.1

    product: PA - Projects ,  implementation_dba_data: Not implemented in this database , 

  • View: PA_CI_SECURED_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CI_SECURED_V,  object_name:PA_CI_SECURED_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_CI_SECURED_V , 

  • View: PA_CI_SECURED_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CI_SECURED_V,  object_name:PA_CI_SECURED_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_CI_SECURED_V , 

  • Table: PA_CI_TYPES_B 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_CI_TYPES_B,  object_name:PA_CI_TYPES_B,  status:VALID,  product: PA - Projects ,  description: The table stores the control item type definitions. The values are created by the customer. ,  implementation_dba_data: PA.PA_CI_TYPES_B , 

  • Table: PA_CI_SUPPLIER_DETAILS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_CI_SUPPLIER_DETAILS,  object_name:PA_CI_SUPPLIER_DETAILS,  status:VALID,  product: PA - Projects ,  description: A new entity PA_CI_SUPPLIER_DETAILS, which stores the details of impact of change orders on Suppliers and Purchase Orders. This entity contains the following attributes ,  implementation_dba_data: PA.PA_CI_SUPPLIER_DETAILS , 

  • Table: PA_CI_TYPES_B 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_CI_TYPES_B,  object_name:PA_CI_TYPES_B,  status:VALID,  product: PA - Projects ,  description: The table stores the control item type definitions. The values are created by the customer. ,  implementation_dba_data: PA.PA_CI_TYPES_B , 

  • 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 , 

  • 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 , 

  • View: PA_CI_IMPACTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CI_IMPACTS_V,  object_name:PA_CI_IMPACTS_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_CI_IMPACTS_V , 

  • View: PA_CI_IMPACTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CI_IMPACTS_V,  object_name:PA_CI_IMPACTS_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_CI_IMPACTS_V , 

  • View: PA_CONTROL_ITEMS_V 12.2.2

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

  • View: PA_RELATED_ITEMS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RELATED_ITEMS_V,  object_name:PA_RELATED_ITEMS_V,  status:VALID,  product: PA - Projects ,  description: This view provides all the control items which can be included. ,  implementation_dba_data: APPS.PA_RELATED_ITEMS_V , 

  • View: PA_RELATED_ITEMS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RELATED_ITEMS_V,  object_name:PA_RELATED_ITEMS_V,  status:VALID,  product: PA - Projects ,  description: This view provides all the control items which can be included. ,  implementation_dba_data: APPS.PA_RELATED_ITEMS_V , 

  • View: PA_CONTROL_ITEMS_V 12.1.1

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

  • View: PA_FP_ELIGIBLE_CI_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_ELIGIBLE_CI_V,  object_name:PA_FP_ELIGIBLE_CI_V,  status:VALID,  product: PA - Projects ,  description: This view shall contain the details of all control orders having a financial impact ,  implementation_dba_data: APPS.PA_FP_ELIGIBLE_CI_V , 

  • View: PA_FP_ELIGIBLE_CI_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_ELIGIBLE_CI_V,  object_name:PA_FP_ELIGIBLE_CI_V,  status:VALID,  product: PA - Projects ,  description: This view shall contain the details of all control orders having a financial impact ,  implementation_dba_data: APPS.PA_FP_ELIGIBLE_CI_V , 

  • Table: PA_BUDGET_VERSIONS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_BUDGET_VERSIONS,  object_name:PA_BUDGET_VERSIONS,  status:VALID,  product: PA - Projects ,  description: Versions of project budgets ,  implementation_dba_data: PA.PA_BUDGET_VERSIONS , 

  • 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 , 

  • Table: PA_BUDGET_VERSIONS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_BUDGET_VERSIONS,  object_name:PA_BUDGET_VERSIONS,  status:VALID,  product: PA - Projects ,  description: Versions of project budgets ,  implementation_dba_data: PA.PA_BUDGET_VERSIONS , 

  • 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_CI_BASIC_CTL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CI_BASIC_CTL_V,  object_name:PA_CI_BASIC_CTL_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_CI_BASIC_CTL_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 , 

  • 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_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_CI_BASIC_CTL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CI_BASIC_CTL_V,  object_name:PA_CI_BASIC_CTL_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_CI_BASIC_CTL_V , 

  • View: PA_CI_CRPRJ_LIST_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CI_CRPRJ_LIST_V,  object_name:PA_CI_CRPRJ_LIST_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_CI_CRPRJ_LIST_V , 

  • View: PA_CI_CRPRJ_LIST_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CI_CRPRJ_LIST_V,  object_name:PA_CI_CRPRJ_LIST_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_CI_CRPRJ_LIST_V , 

  • View: PA_CI_LIST_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CI_LIST_V,  object_name:PA_CI_LIST_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_CI_LIST_V , 

  • View: PA_CI_LIST_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CI_LIST_V,  object_name:PA_CI_LIST_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_CI_LIST_V , 

  • View: PA_LAUNCH_PAGE_OBJECTS_TM_V 12.2.2

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

  • View: PA_LAUNCH_PAGE_OBJECTS_TM_V 12.1.1

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