Search Results pa_control_items

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:

• PA_CI_ACTIONS (CI_ID): Stores actions or tasks associated with a control item.
• PA_CI_COMMENTS (CI_ID): Holds discussion threads and notes.
• PA_CI_IMPACTS (CI_ID): Records impact assessments on project elements.
• PA_CI_SUPPLIER_DETAILS (CI_ID): Manages supplier-related information for items.
• PA_BUDGET_VERSIONS (CI_ID): Links budget changes to specific control items.

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.