Results for “per_budgets_v”
37 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PER_BUDGETS_V is a valid, APPS-owned database view in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 that belongs to the PER (Human Resources) product family. According to the ETRM documentation metadata, the view is designated as "Used to support user interface," indicating that it exists primarily as an OA Framework or Forms presentation-layer construct rather than as a standalone reporting entity. It presents budget records defined in the Human Resources module, enriching them with calendar and lookup information so that the user interface can render meaningful descriptive values in place of raw coded identifiers.
Because the view is a UI-support object, Oracle does not document it as a supported public API or a formal integration interface. Nevertheless, its underlying structure makes it useful for custom reporting and for developers who need to understand how HR budget data is exposed to the EBS front end. The view is defined with a simple join across three source objects, projecting a wide set of columns that mirror the base table plus a small number of derived columns.
Underlying Base Objects
The documented base objects referenced by the view are HR_API (PACKAGE), HR_LOOKUPS (VIEW), PAY_CALENDARS (SYNONYM), and PER_BUDGETS (SYNONYM). The view text itself confirms three of these directly:
- PER_BUDGETS (aliased BUD) — the primary driving table, supplying the budget identifier, business group, unit, comments, period set name, budget type code, the standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN), the concurrent manager request columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE), and the 20 descriptive flexfield columns (ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20).
- PAY_CALENDARS (aliased CAL) — joined on PERIOD_SET_NAME to retrieve ACTUAL_PERIOD_TYPE, which classifies the accounting period set.
- HR_LOOKUPS (aliased LK) — outer-joined on LOOKUP_CODE equal to BUD.UNIT, restricted to LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE', to translate the unit code into its MEANING as UNIT_MEANING.
HR_API is listed as a referenced package in the 12.2.2 metadata, although the visible view text does not call it directly; it is commonly associated with the PER_BUDGETS domain for budget validation logic.
Key Columns
The view exposes the full PER_BUDGETS column set plus derived columns. Notable columns include:
- ROW_ID — the ROWID of the underlying PER_BUDGETS row, useful for direct row addressing.
- BUDGET_ID — the primary identifier of the budget record.
- BUSINESS_GROUP_ID — the HR business group that owns the budget; note the view text applies "+ 0" to force numeric handling.
- NAME — the user-defined budget name.
- UNIT and UNIT_MEANING — the budget measurement unit code and its decoded lookup meaning.
- BUDGET_TYPE_CODE — classification of the budget.
- PERIOD_SET_NAME and ACTUAL_PERIOD_TYPE — the accounting calendar and its period type.
- ATTRIBUTE1–ATTRIBUTE20, ATTRIBUTE_CATEGORY — descriptive flexfield segments.
- Audit and concurrent columns — WHO columns and the request/program columns used for concurrent program traceability.
Common Use Cases and Queries
Typical scenarios include reporting on HR budget definitions with decoded units and calendar types, and investigating how the UI resolves budget descriptions. A representative query is:
SELECT budget_id, name, unit_meaning, budget_type_code, period_set_name, actual_period_type FROM per_budgets_v WHERE business_group_id = :p_bg_id;- Joining to PER_BUDGETS or PER_BUDGET_TYPES on BUDGET_ID or BUDGET_TYPE_CODE for extended analysis.
- Filtering by NAME for ad hoc operational reporting.
Because this is a UI-support view, treat its columns as subject to change across patches and avoid building permanent integrations upon it without confirming support status.
-
View: PER_BUDGETS_V 12.2.2
Used to support user interface
APPS.PER_BUDGETS_V·↳ HR_API·↳ HR_LOOKUPS·↳ PAY_CALENDARS·Explore PER module →
-
View: PER_BUDGETS_V 12.1.1
Used to support user interface
APPS.PER_BUDGETS_V·↳ FND_GLOBAL·↳ HR_API·↳ HR_LOOKUPS·Explore PER module →
-
VIEW: APPS.PER_BUDGETS_V 12.1.1
-
VIEW: APPS.PER_BUDGETS_V 12.2.2
-
SYNONYM: APPS.PAY_CALENDARS 12.2.2
-
SYNONYM: APPS.PAY_CALENDARS 12.1.1
-
SYNONYM: APPS.PER_BUDGETS 12.2.2
-
SYNONYM: APPS.PER_BUDGETS 12.1.1
-
PACKAGE: APPS.HR_BIS_ALERTS 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
VIEW: APPS.HR_LOOKUPS 12.1.1
-
VIEW: APPS.HR_LOOKUPS 12.2.2
-
12.2.2 DBA Data 12.2.2
-
eTRM - PER Tables and Views 12.2.2
Table to store NQF Training info for a person
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person
-
12.1.1 DBA Data 12.1.1
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person
-
eTRM - PER Tables and Views 12.2.2
Table to store NQF Training info for a person