Search Results pa_ci_type_usage




Overview
Explore in AI Chat

Overview

The PA_CI_TYPE_USAGE table is a configuration and validation table within the Oracle E-Business Suite Projects module (PA). Its primary role is to define and enforce the permissible relationships between project types and control item types. Control items are key deliverables, milestones, or events used to manage and monitor project progress. By storing the allowable control item types for each project type, this table acts as a critical setup component, ensuring that only relevant and authorized control item types can be associated with projects of a specific classification. This maintains data integrity and enforces business rules at the application level.

Key Information Stored

The table's core function is to map a project type to its allowed control item types. While the full column list is not detailed in the provided metadata, the documented relationships indicate the presence of essential foreign key columns. The primary identifier is the CI_TYPE_USAGE_ID column, which is the primary key. The most critical data columns are those that establish the relationship: a column for the PROJECT_TYPE (or similar identifier) and the CI_TYPE_ID, which is a foreign key referencing the PA_CI_TYPES_B table. This CI_TYPE_ID column stores the internal identifier for a specific control item type, thereby defining which types are valid for use.

Common Use Cases and Queries

The primary use case is during the project definition and control item creation processes. When a user attempts to create a control item for a project, the application queries this table to validate that the selected control item type is allowed for the project's type. It is also central for setup and administration tasks, where project accountants or implementers define the project templates. A common reporting need is to list all enabled control item types for a given project type or to identify which project types can utilize a specific control item. A typical validation or listing query would join PA_CI_TYPE_USAGE with PA_CI_TYPES_B to get the control item type name and potentially with PA_PROJECT_TYPES to get the project type description.

Related Objects

  • PA_CI_TYPES_B: This is the primary related table, storing the master definition of all control item types. The PA_CI_TYPE_USAGE table references it via the foreign key constraint on the column CI_TYPE_ID. A standard join would be PA_CI_TYPE_USAGE.CI_TYPE_ID = PA_CI_TYPES_B.CI_TYPE_ID.
  • PA_PROJECT_TYPES (Inferred): Although not explicitly listed in the provided foreign key data, this table must be related to PA_CI_TYPE_USAGE to provide the project type context. This relationship is typically established through a column like PROJECT_TYPE in PA_CI_TYPE_USAGE.
  • The table itself is protected by the primary key constraint PA_CI_TYPE_USAGE_PK on the column CI_TYPE_USAGE_ID.