Results for “per_default_budget_values”

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

Overview

PER_DEFAULT_BUDGET_VALUES is a view owned by the APPS schema in Oracle E-Business Suite, classified under the PER (Human Resources) product family. It is documented as VALID in ETRM for both 12.1.1 and 12.2.2. The view exposes the default budget values that are configured against a business group organization, allowing those defaults to be consumed by forms, concurrent processes, and external integrations without requiring direct joins against the HR organization tables.

The view is derived entirely from organization data. Organization units classified as business groups ('HR_BG') carry descriptive flexfield information stored in HR_ORGANIZATION_INFORMATION. One of those information contexts, 'BUDGET VALUE DEFAULTS', holds the actual default budget amount, while the 'CLASS' context identifies the organization as a business group. PER_DEFAULT_BUDGET_VALUES reconciles these two context rows by organization_id and returns the business group together with its budget unit and numeric default value. This makes the view the canonical access point for budget defaults in HR budgeting and position management reporting.

Underlying Base Objects

Per the documented ETRM metadata, the view resolves to three underlying objects:

• HR_ORGANIZATION_UNITS (synonym to HR_ALL_ORGANIZATION_UNITS) — supplies the organization identifiers and business group linkage. Aliased as O in the view text.
• HR_ORGANIZATION_INFORMATION — referenced twice. Aliased O2, it provides the 'BUDGET VALUE DEFAULTS' context rows. Aliased O3, it provides the 'CLASS' context rows used to filter for business groups.
• FND_NUMBER (package) — invoked through FND_NUMBER.CANONICAL_TO_NUMBER to convert the stored character representation of the budget value into a numeric type.

The join conditions are standard self-joins on organization_id: O.ORGANIZATION_ID = O2.ORGANIZATION_ID and O.ORGANIZATION_ID = O3.ORGANIZATION_ID. The restrictive predicates require O2.ORG_INFORMATION_CONTEXT = 'BUDGET VALUE DEFAULTS', O3.ORG_INFORMATION_CONTEXT = 'CLASS', O3.ORG_INFORMATION1 = 'HR_BG', and O3.ORG_INFORMATION2 = 'Y'. Because the 'CLASS' context flag is checked as 'Y', only organizations explicitly flagged as business groups are returned.

Key Columns

The view exposes three columns, as documented:

• BUSINESS_GROUP_ID — the organization identifier of the business group (O.BUSINESS_GROUP_ID). This is the primary grouping key and the value normally passed as a parameter by HR budgeting and position control functionality.
• UNIT — the budget unit, sourced from O2.ORG_INFORMATION1. This is the descriptive flexfield segment that specifies the unit or qualifier associated with the default budget value.
• VALUE — the default budget value itself, sourced from O2.ORG_INFORMATION2 and converted from canonical character form to a number via FND_NUMBER.CANONICAL_TO_NUMBER. The conversion is important because organization information is stored as text; the view shields callers from the required numeric cast.

There is no ORGANIZATION_ID column in the projection, so callers joining back to HR tables should join on BUSINESS_GROUP_ID.

Common Use Cases and Queries

Typical usage includes verifying configured budget defaults for a business group, feeding default values into budgeting or position management logic, and auditing which business groups have non-null defaults defined.

Retrieve all defaults:

• SELECT business_group_id, unit, value FROM apps.per_default_budget_values;

Filter for a specific business group:

• SELECT business_group_id, unit, value FROM apps.per_default_budget_values WHERE business_group_id = :p_business_group_id;

Join to the organization definition to display the business group name:

• SELECT b.business_group_id, o.name, b.unit, b.value FROM apps.per_default_budget_values b, apps.hr_all_organization_units o WHERE b.business_group_id = o.organization_id;

Because the view collapses the two context rows into a single row per business group, it is the recommended access path for budget defaults. Direct queries against HR_ORGANIZATION_INFORMATION risk returning character data and duplicate context rows, whereas this view returns the converted numeric value already scoped to valid, active business groups.