Search Results user_fk1




Overview
Explore in AI Chat

Overview

FII_PA_BUDGET_F_FCV is a Financial Intelligence (FII) view that serves as the Extract, Transform, and Load (ETL) source for the Project Budget fact table within the Enterprise Data Warehouse (EDW). In Oracle EBS 12.1.1 and 12.2.2, FII is designated as an obsolete product, but legacy installations and historical data models may still reference this object. The view presents project budget data at the budget line level, consolidating cost, burden, quantity, and revenue measures alongside a full set of surrogate foreign keys. Its design follows the star-schema convention typical of FII fact source views, where descriptive dimensions are represented by foreign key references rather than denormalized text.

The view includes a GLOBAL_CURRENCY_RATE column, which is the reason it surfaces in searches for "global_currency_rate." This column exposes the exchange rate applied to convert the document currency amount into the global (reporting) currency. It is central to multi-currency project budget reporting, allowing the EDW to store both entered and converted amounts consistently.

Underlying Base Objects

Per the ETRM metadata, FII_PA_BUDGET_F_FCV is defined over a single underlying object: FIIBV_PA_BUDGET_F_FCV. The view text is a direct column projection from that base view, with no joins or filters applied at this layer. The prefix "FIIBV" indicates a Financial Intelligence Base View, which in turn would resolve to Project Accounting (PA) base tables such as PA_BUDGET_LINES, PA_BUDGET_VERSIONS, and related dimension sources. The metadata notes that the view is "Not implemented in this database," and no referenced base objects are documented, so the physical lineage beyond FIIBV_PA_BUDGET_F_FCV is not enumerated in the available ETRM record. In practice, the chain is FII_PA_BUDGET_F_FCV → FIIBV_PA_BUDGET_F_FCV → PA budget and dimension tables.

Key Columns

Common Use Cases and Queries

This view is typically consumed by FII ETL processes loading the Project Budget fact into the EDW, but it can also be queried directly for reconciliation and analysis. A representative query retrieving budget measures with the global currency rate is:

  • Currency conversion audit: SELECT PROJECT_FK, BUDGET_LINE_PK, RAW_COST_B, RAW_COST_G, GLOBAL_CURRENCY_RATE FROM FII_PA_BUDGET_F_FCV WHERE GLOBAL_CURRENCY_RATE <> 1;
  • Periodic budget extraction: SELECT * FROM FII_PA_BUDGET_F_FCV WHERE LAST_UPDATE_DATE >= :last_run_date;
  • Dimension join for reporting: Join CURRENCY_GL_FK and SET_OF_BOOKS_FK to FII currency and ledger dimension views to resolve descriptive currency and ledger names.

Because FII is obsolete in 12.1.1 and 12.2.2, new implementations should treat this view as read-only and avoid extending it. Any new global currency rate derivation logic should be sourced from standard PA and GL currency conversion APIs rather than relying on this legacy object.