Results for “pa_action_set_lines”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_ACTION_SET_LINES is a Projects (PA) module table in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It stores the individual action lines that belong to either an action set or an action set template. Action sets and templates provide a mechanism for grouping reusable project-related actions that can be launched together, and this table captures the ordered, attribute-bearing detail of each line within such a set.

From a Data Vault modeling perspective, the mined foreign key structure classifies this table as satellite-leaning. This is a heuristic suggestion only: the table describes characteristics of a parent entity (the action set) rather than acting as an independent hub, since it carries descriptive attributes and a foreign key to PA_ACTION_SETS. It is best modeled as a satellite attached to an action set hub, with its own surrogate key for row identity.

Key Information Stored

The table exposes 24 documented columns. The most significant are:

• ACTION_SET_LINE_ID — the surrogate primary key, uniquely identifying each action set line.
• ACTION_SET_ID — foreign key to PA_ACTION_SETS, tying the line to its owning action set or action set template. This is the primary relationship column.
• ACTION_SET_LINE_NUMBER — the sequence number that orders lines within the set.
• ACTION_CODE — identifies the specific action performed by the line.
• STATUS_CODE — the processing or lifecycle status of the line.
• DESCRIPTION — free-text explanation of the line.
• LINE_DELETED_FLAG — soft-delete indicator for the line.
• RECORD_VERSION_NUMBER — optimistic-locking/version column.
• ACTION_ATTRIBUTE1 through ACTION_ATTRIBUTE10 — a ten-column descriptive flexfield-style attribute block holding action-specific parameters.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.
• ZD_EDITION_NAME — editioning column supporting online patching and multi-edition access.

The unique index PA_ACTION_SET_LINES_U1 (ACTION_SET_LINE_ID, ZD_EDITION_NAME) is the business-key candidate surfaced by the metadata, combining the surrogate key with the edition discriminator.

Common Use Cases and Queries

Typical scenarios include reconstructing the full configuration of an action set, auditing which actions are attached to a given set or template, and validating ordering and status of lines.

Retrieve all lines for one action set:

SELECT action_set_line_id, action_set_line_number, action_code,
       status_code, description
FROM   pa_action_set_lines
WHERE  action_set_id = :p_action_set_id
ORDER  BY action_set_line_number;

Filter active, non-deleted lines by action code:

SELECT l.action_set_line_id, l.action_code, l.action_attribute1
FROM   pa_action_set_lines l
WHERE  l.line_deleted_flag = 'N'
AND    l.action_code = :p_action_code;

Reporting frequently joins lines back to PA_ACTION_SETS to present set names alongside line detail, and aggregates line counts per set.

Related Objects

• PA_ACTION_SETS — the parent table referenced by PA_ACTION_SET_LINES.ACTION_SET_ID → PA_ACTION_SETS.ACTION_SET_ID. This is the principal join for any line query.
• Action set and template inquiry/administration forms and the underlying action-set management APIs that populate these lines through the FK to PA_ACTION_SETS.
• Project action processing and launch utilities that consume the lines defined here during execution of an action set.

Because the metadata documents only the single foreign key above, related objects beyond PA_ACTION_SETS are inferred from standard EBS action-set functionality rather than enumerated in the ETRM record.