Search Results pa_alloc_run_resource_det




Overview
Explore in AI Chat

Overview

PA_ALLOC_RUN_RESOURCE_DET is a transaction table in the Oracle Projects (PA) schema that stores details about resource list members participating in an allocation run. It functions as a child table to the allocation run process, capturing the specific resource list members, their member types, and their percentage allocations that were evaluated during a given allocation run. The table is owned by the PA schema and holds a status of VALID in Oracle EBS 12.1.1 and 12.2.2.

From a modeling perspective, the heuristic Data Vault classification for this object is satellite-leaning. This suggests it is best understood as a descriptive detail table that hangs off a central business entity — in this case, an allocation run and its associated resource list members — rather than as a hub of core business keys or a pure link resolving many-to-many relationships. Its granularity is one row per (run, member type, resource list member) combination, as evidenced by its unique index.

Key Information Stored

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

  • RULED_ID / RULE_ID — Identifier of the allocation rule that governed the run; ties resource detail back to allocation rule definition.
  • RUN_ID — Surrogate/business identifier of the allocation run; the primary driver of this detail set and part of the business-key unique index.
  • MEMBER_TYPE — Classifies the resource list member (for example, by type of resource or assignment); part of the unique business key.
  • RESOURCE_LIST_MEMBER_ID — Foreign key to PA_RESOURCE_LIST_MEMBERS; identifies the specific member included in the run and forms part of the unique business key.
  • RESOURCE_PERCENT — The percentage value assigned to the resource member for allocation purposes.
  • AUDIT COLUMNS — LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN capture standard Oracle EBS who/when audit information.

The unique index PA_ALLOC_RUN_RESOURCE_DET_U1 on (RUN_ID, MEMBER_TYPE, RESOURCE_LIST_MEMBER_ID) is the strongest documented business-key candidate, uniquely identifying each resource detail line within a run. No separate surrogate primary key column is documented in the excerpt beyond these business-key columns; the unique index effectively acts as the row identifier.

Common Use Cases and Queries

Typical usage centers on auditing and reporting allocation runs. Common queries include retrieving all resource details for a specific run, joining to resource list members to obtain names and attributes, and analyzing percentage distributions across member types.

  • Detail extraction: SELECT * FROM PA.PA_ALLOC_RUN_RESOURCE_DET WHERE RUN_ID = :run_id;
  • Join to member master: SELECT d.RUN_ID, d.MEMBER_TYPE, m.NAME, d.RESOURCE_PERCENT FROM PA.PA_ALLOC_RUN_RESOURCE_DET d, PA.PA_RESOURCE_LIST_MEMBERS m WHERE d.RESOURCE_LIST_MEMBER_ID = m.RESOURCE_LIST_MEMBER_ID;
  • Percentage validation: aggregate RESOURCE_PERCENT by RUN_ID and MEMBER_TYPE to confirm total allocation percentages.
  • Audit trail: filter by CREATION_DATE and LAST_UPDATE_DATE to identify recent allocation runs and changes.

Reporting use cases include reconciliation of allocation results, troubleshooting unexpected percentage splits, and feeding downstream cost distribution reports.

Related Objects

The most significant related object is the parent resource list member master. Because this table is satellite-leaning, joins flow primarily outward from RUN_ID and RESOURCE_LIST_MEMBER_ID.

  • PA_RESOURCE_LIST_MEMBERS — Referenced via RESOURCE_LIST_MEMBER_ID; provides the descriptive attributes of each resource member.
  • PA_ALLOC_RUNS (allocation run header) — Joins on RUN_ID; supplies run-level context such as run date and status.
  • PA_ALLOC_RULES / PA_ALLOC_RULE_DETAILS — Joins via RULE_ID; defines the allocation rule logic applied.
  • PA_RESOURCE_LISTS — Parent of resource list members; useful for grouping details by list.
  • Allocation run reports and concurrent programs in Oracle Projects that consume PA_ALLOC_RUN_RESOURCE_DET output for distribution and audit reporting.

These relationships make PA_ALLOC_RUN_RESOURCE_DET a focused detail table best queried in conjunction with its run, rule, and resource list member parents.