Search Results gl_acct1_fk




Overview
Explore in AI Chat

Overview

FIIBV_PA_REVENUE_F_FCV is a Financial Intelligence (FII) Enterprise Data Warehouse (EDW) base view owned by the APPS schema. In the Oracle EBS 12.1.1 and 12.2.2 environments, this object serves as the Project Revenue fact base view — a staging and integration construct that unifies project revenue records from multiple source systems into a conformed dimensional model. It is not a transactional view used by the Projects (PA) application at runtime; rather, it exists to feed the Financial Intelligence reporting layer, providing a single revenue fact source spanning Expenditure, Billing, and other revenue-generating transaction classes.

The "FCV" suffix identifies it as a Fact Conformed View used by the EDW staging strategy. The view normalizes heterogeneous revenue streams into a single shape with surrogate and natural keys, measures, and foreign keys to conformed dimensions. Revenue is distinguished by the VIEW_TYPE column, and a composite REVENUE_PK is constructed with TO_CHAR concatenation across source identifiers.

Underlying Base Objects

The ETRM metadata documents no explicit base tables, but the embedded view text reveals the underlying sources. The primary FROM clause references FII_PA_REVENUE_EXP_PK (a PK staging table for expenditure-sourced revenue), PA_CUST_R (project customer relationships), and further joins to PA expenditure items (EI), PA distributions/results (RDL, DR), PA projects/instances (I), and GL sets of books (SOB). GL_ACCT1_FK through GL_ACCT10_FK are hard-coded to the literal 'NA_EDW', confirming this fact view does not currently populate GL account dimension keys; instead it exposes CODE_COMBINATION_ID, CHART_OF_ACCOUNTS_ID, and SET_OF_BOOKS_ID for downstream account resolution.

Key Columns

  • REVENUE_PK — Composite primary key for the fact row, built from expenditure item ID, line number, a class tag (e.g. "EXP"), and the instance code.
  • VIEW_TYPE — Revenue classification discriminator; "EXP" indicates expenditure-sourced revenue.
  • REVENUE_B — Base revenue amount sourced from the PA distribution line (RDL.AMOUNT).
  • INSTANCE_FK, SET_OF_BOOKS_FK, PROJECT_FK, CUSTOMER_FK — Conformed dimensional foreign keys, each concatenating a natural identifier with the instance code for multi-instance EDW loads.
  • GL_DATE_FK, PA_DATE_FK, TRANSACTION_DATE_FK — Role-playing date dimensions formatted as DD-MM-YYYY combined with the period set name, period type, and instance code; NULL dates default to "NA_EDW".
  • GL_ACCT1_FK … GL_ACCT10_FK — Reserved GL account dimension keys, all populated with "NA_EDW" in this view. Notably, gl_acct1_fk is the first of these reserved slots and returns no meaningful account segmentation from this object.
  • CODE_COMBINATION_ID, CHART_OF_ACCOUNTS_ID, SET_OF_BOOKS_ID — Native GL identifiers retained for account derivation in the reporting layer.
  • GLOBAL_CURRENCY_RATE — Daily rate derived via EDW_CURRENCY.GET_RATE; returns -1 when no rate is available.
  • LAST_UPDATE_DATE — Sourced from RDL.PROGRAM_UPDATE_DATE for incremental high-water-mark extraction.

Common Use Cases and Queries

This view is typically queried during EDW fact loads, revenue reconciliation between PA and GL, and Financial Intelligence revenue reporting. A baseline extract might read:

SELECT REVENUE_PK, PROJECT_FK, SET_OF_BOOKS_FK, REVENUE_B, CURRENCY_GL_FK, PA_DATE_FK FROM APPS.FIIBV_PA_REVENUE_F_FCV WHERE VIEW_TYPE = 'EXP';

Because GL_ACCT1_FK is hard-coded to 'NA_EDW', searches for a populated gl_acct1_fk will not return meaningful data from this view. Account-level analysis must use CODE_COMBINATION_ID and CHART_OF_ACCOUNTS_ID against GL_CODE_COMBINATIONS, or target the dedicated GL fact views that populate GL_ACCT*_FK. Analysts should also filter on SET_OF_BOOKS_ID or the instance code embedded in the fact keys when extracting across multiple EBS instances.