Results for “pa_alloc_target_lines”

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

Overview

PA_ALLOC_TARGET_LINES is a Projects (PA) module table that stores the target lines associated with each allocation rule in Oracle EBS 12.1.1 and 12.2.2. An allocation rule defines how amounts are distributed from a source to one or more targets; this table holds the recipient (target) side of that definition. Each row represents a single target line belonging to a rule, identified by the composite primary key PA_ALLOC_TARGET_PK, comprising RULE_ID and LINE_NUM. The table is owned by the PA schema and is classified as VALID in the ETRM metadata.

Under the heuristic Data Vault classification mined from the foreign key structure, PA_ALLOC_TARGET_LINES is satellite-leaning. This suggests it is best modeled as a satellite attached to a parent allocation rule hub (PA_ALLOC_RULES_ALL), carrying descriptive and qualifying attributes for each target line rather than acting as an independent hub or a pure link.

Key Information Stored

The table contains 18 documented columns. The most significant are:

• RULE_ID — Foreign key to PA_ALLOC_RULES_ALL, identifying the parent allocation rule. Part of the composite primary key.
• LINE_NUM — The sequence number of the target line within a rule. Together with RULE_ID, forms the unique business-key candidate PA_ALLOC_TARGET_LINES_U1.
• PROJECT_ID — Foreign key to PA_PROJECTS_ALL, specifying the target project.
• TASK_ID — Foreign key to PA_TASKS, specifying the target task, where applicable.
• EXCLUDE_FLAG — Indicates whether the line is excluded from the allocation.
• LINE_PERCENT — The percentage share of the allocation assigned to the target line.
• BILLABLE_ONLY_FLAG — Restricts the target to billable transactions or amounts.
• PROJECT_TYPE, CLASS_CATEGORY, CLASS_CODE — Qualifying attributes describing the target project classification.
• SERVICE_TYPE — Identifies the service type associated with the target.
• PROJECT_ORG_ID, TASK_ORG_ID — Organizational identifiers for the target project and task.
• CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns.

The surrogate primary key is PA_ALLOC_TARGET_PK (RULE_ID, LINE_NUM); the unique index PA_ALLOC_TARGET_LINES_U1 covers the same columns as the business-key candidate.

Common Use Cases and Queries

Typical use cases include reviewing allocation rule definitions, validating that target percentages sum correctly, and reporting which projects and tasks receive allocated amounts. A common query joins target lines back to their parent rule:

• List all target lines for a given rule: SELECT line_num, project_id, task_id, line_percent FROM pa.pa_alloc_target_lines WHERE rule_id = :rule_id ORDER BY line_num;
• Validate percentage totals per rule: SELECT rule_id, SUM(line_percent) FROM pa.pa_alloc_target_lines GROUP BY rule_id HAVING SUM(line_percent) <> 100;
• Resolve target project names: join PROJECT_ID to PA_PROJECTS_ALL and TASK_ID to PA_TASKS.

Reporting scenarios include auditing allocation setup, reconciling allocations to the general ledger, and tracing run-time targets to their defining lines.

Related Objects

The following objects are most significant to this table, based on documented relationships:

• PA_ALLOC_RULES_ALL — Parent table; joined via RULE_ID. Defines the allocation rule owning each target line.
• PA_ALLOC_RUN_TARGETS — References this table via (RULE_ID, LINE_NUM); holds the run-time executed targets derived from these definitions.
• PA_PROJECTS_ALL — Referenced via PROJECT_ID, providing the target project.
• PA_TASKS — Referenced via TASK_ID, providing the target task.
• PA_ALLOC_RUN_SOURCES / PA_ALLOC_RUNS — Related run-time allocation objects that consume rule definitions built from these target lines.