Search Results action_set_name




Overview
Explore in AI Chat

Overview

PA_ACTION_SETS is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores action set templates together with action sets that belong to specific objects, such as projects and requirements. An action set is a reusable grouping of executable steps that the Projects application invokes against a target object; PA_ACTION_SETS defines the header-level identity, classification, and validity of that grouping, while its constituent steps are held in the associated line table PA_ACTION_SET_LINES. The table therefore serves as the control point for configuring, versioning, and tracking automated processing within Oracle Projects.

From a dimensional-modeling perspective, the documented foreign-key structure suggests a hub-leaning classification for PA_ACTION_SETS. Its surrogate primary key, ACTION_SET_ID, is referenced by six dependent tables without the table itself functioning as a transactional link, which is consistent with a durable business-key hub. This classification is offered as a modeling suggestion derived from the FK topology rather than as a mandatory physical design.

Key Information Stored

The documented unique index PA_ACTION_SETS_U1 covers (ACTION_SET_ID, ZD_EDITION_NAME), confirming the surrogate-plus-edition combination as the enforced business-key candidate in the 12.2.2 schema.

Common Use Cases and Queries

Typical reporting scenarios include listing all active templates, resolving the steps behind a given action set, and tracing action sets instantiated for a specific project. The following pattern returns template headers with their line counts:

  • SELECT a.ACTION_SET_ID, a.ACTION_SET_NAME, a.OBJECT_TYPE, a.STATUS_CODE, COUNT(l.ACTION_SET_LINE_ID) FROM PA_ACTION_SETS a LEFT JOIN PA_ACTION_SET_LINES l ON l.ACTION_SET_ID = a.ACTION_SET_ID WHERE a.ACTION_SET_TEMPLATE_FLAG = 'Y' GROUP BY a.ACTION_SET_ID, a.ACTION_SET_NAME, a.OBJECT_TYPE, a.STATUS_CODE;
  • To find object-specific action sets: SELECT ACTION_SET_ID, ACTION_SET_NAME FROM PA_ACTION_SETS WHERE OBJECT_TYPE = :object_type AND OBJECT_ID = :object_id AND STATUS_CODE = 'ACTIVE';
  • To trace provenance of a copied set: SELECT ACTION_SET_ID, SOURCE_ACTION_SET_ID, MOD_SOURCE_ACTION_SET_FLAG FROM PA_ACTION_SETS WHERE SOURCE_ACTION_SET_ID IS NOT NULL;

Because ATTRIBUTE columns are flexfield-enabled, reporting queries frequently join the appropriate descriptive flexfield view to expose client-defined attributes alongside the standard columns.

Related Objects

  • PA_ACTION_SET_LINES — Joins on ACTION_SET_ID; holds the ordered steps of each action set.
  • PA_ACTION_SETS_AR — Audit/archive companion keyed on ACTION_SET_ID.
  • PA_ACTION_SET_LINES_AR — Audit/archive companion for lines, joined via ACTION_SET_ID.
  • ALR_ACTION_SET_MEMBERS — Alert/action-set membership, joined on ACTION_SET_ID.
  • ALR_ACTION_SET_CHECKS — Alert condition checks associated with the action set, joined on ACTION_SET_ID.
  • ALR_ACTION_HISTORY — Execution history referencing ACTION_SET_ID for audit and troubleshooting.

Together these tables form the complete action-set framework: PA_ACTION_SETS supplies the header, PA_ACTION_SET_LINES supplies the steps, the _AR tables provide audit retention, and the ALR tables integrate action sets with the alerting subsystem.