Results for “actual_work_quantity”

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

Overview

PA_TASK_ASSIGNMENTS_AMG_V is a valid APPS-schema view within the Oracle E-Business Suite Projects (PA) module. Its documented description states that it provides progress data for task assignments. In practice the view consolidates progress rollup and earned value information at the granularity of an individual task assignment, joining progress data held at the project element version level to the assignment definition maintained by the task assignment view.

Within Oracle EBS 12.1.1 and 12.2.2 the _AMG suffix identifies views typically consumed by Oracle's Application Management and reporting layers, and this view serves as a reporting and integration surface for progress and performance measurement. Rather than storing data, it exposes derived values: variances between actual and scheduled assignment dates, actual cost and effort to date, baseline cost and effort, estimated-at-completion cost, earned value, and countdown metrics such as days until progress is due or days until an assignment starts. These are the same style of metrics surfaced in Progress Workbench and related earned value reporting, making the view suitable for extracting consistent progress snapshots without reimplementing PA_PROGRESS_UTILS logic.

Underlying Base Objects

The view text is defined over PA_PROGRESS_ROLLUP (aliased PPR), PA_TASK_ASSIGNMENTS_V (PTAV, a view), and PA_PROJ_PROGRESS_ATTR (PPA), and it invokes several public utility packages. The documented referenced base objects are:

• Packages: PA_PROGRESS_UTILS, PA_PLANNING_RESOURCE_UTILS, PA_PLANNING_ELEMENT_UTILS, PA_TASK_ASSIGNMENT_UTILS, PA_EXPENDITURES_UTILS, PA_FIN_PLAN_UTILS, PA_PROJ_ELEMENTS_UTILS, PA_RELATIONSHIP_UTILS, PA_ROLE_JOB_BG_UTILS.
• Views and synonyms: PA_TASK_ASSIGNMENTS_V, PA_PROJECTS_ALL, PA_PROJ_ELEMENTS, PA_PROJ_ELEMENT_VERSIONS, PA_PROJ_ELEM_VER_SCHEDULE, PA_PROJ_ELEM_VER_STRUCTURE, PA_PROJ_PROGRESS_ATTR, PA_PROJ_STRUCTURE_TYPES, PA_PROJECT_STATUSES, PA_PERCENT_COMPLETES, PA_LOOKUPS, PA_TASK_TYPES.

Key correlations include PROJECT_ID, OBJECT_ID, OBJECT_VERSION_ID, PROJ_ELEMENT_ID and AS_OF_DATE. Assignment-level baseline and schedule attributes come from PA_TASK_ASSIGNMENTS_V, while period-to-date progress, cost, effort and earned value come from PA_PROGRESS_ROLLUP. Scalar functions such as PA_PROGRESS_UTILS.GET_ACT_COST_THIS_PERIOD, GET_ACT_EFFORT_THIS_PERIOD, GET_NEXT_PROGRESS_CYCLE and SUM_ETC_VALUES compute period amounts and estimated-at-completion totals. Because this is a view, results reflect the queries made through these base objects at run time.

Key Columns

• ACTUAL_COST and ACTUAL_EFFORT — actual cost and effort to date, computed by resource class (PEOPLE, EQUIPMENT, other) minus the current-period amounts returned by PA_PROGRESS_UTILS functions.
• ACTUAL_START_DATE and ACTUAL_FINISH_DATE — actual assignment dates from progress rollup.
• ACT_SCH_START_VAR and ACT_SCH_FINISH_VAR — schedule variance expressed as actual date minus the assignment baseline start or end date.
• BASELINE_COST, BASELINED_EFFORT, BASELINED_ASGMT_START_DATE, BASELINED_ASGMT_END_DATE — baselined cost, planned quantity and baseline assignment dates.
• EST_AT_COMPLETION_COST — sum of actual costs plus estimated-to-complete cost derived through PA_PROGRESS_UTILS.SUM_ETC_VALUES.
• EARNED_VALUE and ACTUAL_WORK_QUANTITY — earned value and cumulative work quantity at the as-of date.
• DAYS_UNTIL_PROGRESS_DUE, DAYS_UNTIL_START, and the truncated end-date minus SYSDATE expression — timing metrics for progress cycles and assignment start/finish.
• AS_OF_DATE — the reference date for the progress snapshot.

Common Use Cases and Queries

Typical uses include progress and earned value reporting by project or assignment, monitoring assignments approaching their start or progress-due dates, and extracting actual versus baseline cost and effort for performance analysis. Always supply an AS_OF_DATE filter and restrict to the relevant project to keep volume manageable.

SELECT project_id, proj_element_id, actual_cost, actual_effort,
       earned_value, est_at_completion_cost, days_until_progress_due
FROM   apps.pa_task_assignments_amg_v
WHERE  as_of_date = TRUNC(SYSDATE)
AND    days_until_progress_due BETWEEN 0 AND 7;

SELECT proj_element_id, baseline_cost, actual_cost,
       est_at_completion_cost, actual_start_date, actual_finish_date
FROM   apps.pa_task_assignments_amg_v
WHERE  as_of_date = TRUNC(SYSDATE)
AND    project_id = :project_id;

Because the view embeds utility-package calls, queries can be resource-intensive; filter by PROJECT_ID and AS_OF_DATE, and grant SELECT to reporting users through the APPS schema rather than querying base tables directly.