Results for “per_budget_values_efc”

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

Overview

PER_BUDGET_VALUES_EFC is a table owned by the HR schema within the Oracle E-Business Suite Human Resources (PER) product family. It is a structural copy of the PER_BUDGET_VALUES table, created and populated exclusively by the EFC (Euro as Functional Currency) process. The EFC initiative was introduced to support organizations transitioning their functional currency to the Euro, and tables bearing the _EFC suffix serve as the converted-currency counterparts of their base tables. As a result, PER_BUDGET_VALUES_EFC holds budget value records expressed in the Euro functional currency context, maintained alongside the original PER_BUDGET_VALUES rows rather than replacing them.

From a Data Vault modeling perspective, the mined heuristic classifies this table as satellite-leaning. This reflects its design: it carries descriptive and measurable attributes (currency amounts and currency codes) attached to a parent budget entity, plus a dependent link to the EFC batch that produced the row. It does not behave as an independent hub of business entities, and its primary key is a composite of an inherited identifier and a process identifier, which is characteristic of satellite or link-satellite constructs.

Key Information Stored

The documented physical schema consists of five columns. The most significant are the following.

• BUDGET_VALUE_ID — Identifier inherited from the corresponding PER_BUDGET_VALUES record. It ties each converted row back to its source budget value and forms the first component of the composite primary key.
• EFC_ACTION_ID — Identifies the specific EFC conversion run that generated the row. It is the second component of the primary key and the sole foreign key column, referencing HR_EFC_ACTIONS.
• VALUE — The budgeted monetary or numeric amount as converted under the Euro functional currency process.
• BUDGET_CURRENCY — The currency associated with the original budget value, retained for traceability to the source record.
• EFC_BG_CURRENCY — The currency code applied within the EFC budget group context, reflecting the converted or reporting currency used by the EFC process.

The surrogate primary key is documented as PER_BUDGET_VALUES_EFC_PK, defined over (BUDGET_VALUE_ID, EFC_ACTION_ID). This composite key is also the only documented unique index and therefore the sole business-key candidate; there is no separate single-column surrogate. Because EFC_ACTION_ID participates in the key, the table can legitimately retain multiple converted versions of the same BUDGET_VALUE_ID across different EFC runs, which supports audit and re-conversion scenarios.

Common Use Cases and Queries

Typical usage centers on reporting and reconciliation between base and converted budget values.

• Comparing original and Euro-converted amounts for the same budget value:

SELECT e.BUDGET_VALUE_ID, e.EFC_ACTION_ID,
       e.VALUE AS EFC_VALUE, e.BUDGET_CURRENCY, e.EFC_BG_CURRENCY
FROM   HR.PER_BUDGET_VALUES_EFC e
WHERE  e.BUDGET_VALUE_ID = :p_budget_value_id;

• Isolating all values produced by a single EFC run by joining to HR_EFC_ACTIONS:

SELECT e.BUDGET_VALUE_ID, e.VALUE, a.EFC_ACTION_ID
FROM   HR.PER_BUDGET_VALUES_EFC e,
       HR.HR_EFC_ACTIONS a
WHERE  e.EFC_ACTION_ID = a.EFC_ACTION_ID
AND    a.EFC_ACTION_ID = :p_action_id;

• Auditing currency coverage by grouping on BUDGET_CURRENCY and EFC_BG_CURRENCY to confirm that every source currency has been mapped appropriately.
• Validating key integrity by detecting orphaned EFC_ACTION_ID values, which indicates rows left behind by a failed or partially rolled-back conversion run.

Related Objects

• PER_BUDGET_VALUES — The base table from which this object is copied; the natural parent of BUDGET_VALUE_ID.
• HR_EFC_ACTIONS — Referenced by the PER_BUDGET_VALUES_EFC.EFC_ACTION_ID foreign key; the conversion-run header.
• PER_BUDGET_VALUES_EFC_PK — The composite unique index enforcing (BUDGET_VALUE_ID, EFC_ACTION_ID).
• Other PER_BUDGET_* base tables and the EFC conversion concurrent programs — Additional EFC-suffixed copies and the processes that populate them.
• PER_BUDGET_* budget element and budget group objects — Define the budget context to which converted values logically attach.