Results for “hrfv_workforce_budgets”

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

Overview

HRFV_WORKFORCE_BUDGETS is an APPS-owned business view (status VALID) within the PER – Human Resources product family in Oracle EBS 12.1.1 and 12.2.2. Per the ETRM metadata, it is described as a "Business view template from which the flexfield view is generated," meaning it serves as a flattened, reporting-oriented projection of the underlying Oracle Human Resources workforce budgeting tables rather than as a transactional entry object. The view consolidates budget definitions, budget versions, budget details, and budget periods into a single denormalized result set suitable for BI Publisher, Oracle Discoverer, and custom SQL reporting.

Functionally, the view answers the question of what a workforce budget contains at the intersection of organization, job, position, grade, and time period. It exposes budgeted values alongside actual values computed through the HR_DISCOVERER.GET_ACTUAL_BUDGET_VALUES and HR_DISC_CALCULATIONS.GET_FF_ACTUAL_VALUE_PQH packaged functions, making it useful for variance and comparison reporting without requiring the caller to re-implement budget arithmetic.

Underlying Base Objects

The view is defined over a union of PQH budgeting tables and PER/HR reference tables, joined through key identifiers such as BUDGET_ID, BUSINESS_GROUP_ID, BUDGET_PERIOD_ID, ORGANIZATION_ID, JOB_ID, POSITION_ID, and GRADE_ID. The documented base objects include:

• PQH_BUDGETS (synonym) — the parent budget record supplying BUDGET_NAME, PERIOD_SET_NAME, BUDGET_START_DATE, BUDGET_END_DATE, BUDGET_STYLE_CD, and BUDGETED_ENTITY_CD.
• PQH_BUDGET_VERSIONS (synonym) — supplies BUDGET_VERSION_NUMBER and version date range (DATE_FROM/DATE_TO).
• PQH_BUDGET_DETAILS (synonym) — supplies the line-level BUDGET_UNIT1_VALUE and position linkage.
• PQH_BUDGET_PERIODS (synonym) — supplies the period-level BUDGET_UNIT1_VALUE and budget period identifiers.
• PQH_BUDGETS_V (view) — a supporting budget view.
• PER_TIME_PERIODS (synonym) and PAY_CALENDARS (synonym) — supply BUDGET_PERIOD_START_DATE, BUDGET_PERIOD_END_DATE, and the calendar frequency/period type.
• PER_ORGANIZATION_STRUCTURES, PER_ORG_STRUCTURE_VERSIONS, HR_ALL_ORGANIZATION_UNITS_TL, HR_ALL_POSITIONS_F_TL, PER_JOBS_TL, PER_GRADES_TL, and PER_SHARED_TYPES_VL — provide hierarchy, organization, position, job, grade, and shared-type descriptive attributes.
• Packages HR_BIS, HR_DISCOVERER, HR_DISC_CALCULATIONS, HR_GENERAL, and PQH_UTILITY — provide lookup decoding, organization decoding, and actual-value computation.

Key Columns

• BUSINESS_GROUP_NAME, BUDGET_NAME, BUDGET_CALENDAR_NAME, BUDGET_CALENDAR_FREQUENCY — identify the budget and its calendar context.
• BUDGET_START_DATE, BUDGET_END_DATE — the overall budget validity window.
• BUDGETED_ENTITY, BUDGET_STYLE, BUDGET_MEASUREMENT_TYPE, BUDGET_UNIT_AGGREGATE_DESC — decoded lookups describing how the budget is measured and aggregated.
• BUDGET_VERSION_NUMBER, BUDGET_VERSION_START_DATE, BUDGET_VERSION_END_DATE — version-level context for the returned rows.
• ORGANIZATION_NAME, JOB_NAME, POSITION_NAME, GRADE_NAME — the workforce dimensions against which budget values are set.
• BUDGET_PERIOD_NAME, BUDGET_PERIOD_START_DATE, BUDGET_PERIOD_END_DATE — the period identifiers most often filtered on. A search for budget_period_end_date targets the last of these, which corresponds to PTPE.END_DATE from PER_TIME_PERIODS.
• BUDGET_DETAIL_BUDGETED_VALUE, BUDGET_PERIOD_BUDGETED_VALUE, BUDGET_PERIOD_ACTUAL_VALUE — the budgeted and calculated actual amounts used for comparison reporting.

Common Use Cases and Queries

The view is typically queried to report workforce budgets by period and organization, to reconcile budgeted versus actual workforce costs, and to extract period boundaries. The following example filters on the searched column:

SELECT business_group_name, budget_name, organization_name, position_name, budget_period_name, budget_period_start_date, budget_period_end_date, budget_period_budgeted_value FROM apps.hrfv_workforce_budgets WHERE budget_period_end_date BETWEEN :p_start AND :p_end ORDER BY budget_period_end_date;

A second common pattern aggregates budgeted and actual values by period for variance analysis:

SELECT budget_name, budget_period_name, SUM(budget_period_budgeted_value) budgeted, SUM(budget_period_actual_value) actual FROM apps.hrfv_workforce_budgets WHERE budget_name = :p_budget GROUP BY budget_name, budget_period_name;

Because it is a view template, bind variables should be used liberally and joins to the base PQH tables avoided where the view already exposes required attributes, to preserve consistency with the flexfield-generated reporting view.