Search Results fiibv_pa_budget_f_fcv




Overview
Explore in AI Chat

Overview

FIIBV_PA_BUDGET_F_FCV is an Oracle EBS 12.1.1 / 12.2.2 view owned by the APPS schema and classified under the FII (Financial Intelligence) product family. Within the ETRM metadata it is described as the "EDW Project Budget fact base view" — that is, a base-level (staging) fact view that feeds the Enterprise Data Warehouse layer for Project Budgeting analytics. It is marked with the _FCV suffix typical of Financial Intelligence base fact views, and STATUS is VALID in the reported environment.

The view presents one row per project budget line, keyed by a composite business key that concatenates the resource assignment identifier, the budget line start date, and the FII instance code. Its primary role is to expose Project Accounting budget data — raw cost, burdened cost, quantity, and revenue — in a denormalised, warehouse-ready form, with all surrogate keys (PROJECT_FK, BUDGET_FK, EXPENDITURE_TYPE_FK, GL_PERIOD_FK, PA_PERIOD_FK, UNIT_OF_MEASURE_FK, etc.) pre-computed so that downstream ETL and star-schema population processes can join directly to conformed dimensions. It sits in the integration layer between the EBS PA transactional tables and the FII reporting/BI repository.

Underlying Base Objects

The documented ETRM metadata for 12.2.2 does not enumerate referenced base objects, but the view text itself is authoritative. The FROM clause references the FII Project Accounting package view FII_PA_BUDGET_PK (aliased FIIPK), which is the principal driving object and supplies budget line values, the PA budget version, task, resource, and period attributes, and the CONVERSION_DATE used as the reporting transaction date. It is joined to GL sets of books data (aliased SOB and BV) to supply SET_OF_BOOKS_ID, CURRENCY_CODE, and PERIOD_SET_NAME. The aliases referenced in the SELECT list — BL, LI, RA, R, RT, PRJ, T, BEM, BV, SOB — indicate further joins to Project Accounting budget lines, resources, resource types, tasks, projects, budget entry methods, and budget versions, plus the FII instance table supplying INSTANCE_CODE. Because the joins are executed inside FII_PA_BUDGET_PK and the GL objects, the effective lineage of this view is the PA budget schema (PA_BUDGET_VERSIONS, PA_BUDGET_LINES, PA_RESOURCES, PA_TASKS, PA_PROJECTS) plus GL_SETS_OF_BOOKS, resolved through the FII package layer.

Key Columns

Common Use Cases and Queries

Typical use is period-end extraction of project budget facts for the EDW, variance reporting of budget versus actuals, and multi-currency normalisation of budget amounts. A representative query aggregates budgeted cost by project and budget version for a given instance:

SELECT PROJECT_FK,
       BUDGET_FK,
       SUM(RAW_COST_B)      RAW_COST,
       SUM(BURDENED_COST_B) BURDENED_COST,
       SUM(QUANTITY)        QUANTITY
FROM   APPS.FIIBV_PA_BUDGET_F_FCV
WHERE  INSTANCE_FK = :instance_code
  AND  RANGE_FROM_DATE >= :from_date
  AND  RANGE_TO_DATE   <= :to_date
GROUP  BY PROJECT_FK, BUDGET_FK;

Because the view carries no WHERE clause of its own, filtering by INSTANCE_FK and the RANGE_FROM_DATE / RANGE_TO_DATE pair is essential to bound the result set to the desired extract window. A second common pattern joins GL_PERIOD_FK to the FII period dimension to produce budget by accounting period, while SET_OF_BOOKS_FK and CURRENCY_GL_FK support consolidation. Consumers should note that measures are presented only in ledger currency (_B columns), with GLOBAL_CURRENCY_RATE available for translation and the original-currency columns reserved for the target fact layer.