Search Results all_fk




Overview
Explore in AI Chat

Overview

FIIBV_AP_IVSR_INV_SOURCE_LCV is a base view within the Oracle Financial Intelligence (FII) product family, designated in Oracle EBS documentation as an obsolete component. Its purpose is to materialize the Invoice Source level of the Invoice Source dimension used by Financial Intelligence analytics and extract-transform-load processes. In releases 12.1.1 and 12.2.2, FII was progressively superseded by Oracle Business Intelligence Applications and the Enterprise Data Warehouse (EDW) model, so this view is encountered primarily in legacy installations, historical ETRM references, or migration audits rather than in active production schemas. The ETRM metadata explicitly notes that the object is not implemented in the reference database, meaning the definition is preserved for documentation and lineage purposes but the physical view may not exist in a given environment.

The view consolidates two distinct populations of invoice source values: the seeded or user-defined lookup codes held in FND lookups, and the distinct source values actually assigned to invoices in the payables tables. This union-based design ensures the dimension remains complete even when an invoice carries a source value that was never formally defined as a lookup code.

Underlying Base Objects

According to the documented view text, FIIBV_AP_IVSR_INV_SOURCE_LCV is defined over three principal base objects:

  • AP_LOOKUP_CODES — filtered with the predicate LOOKUP_TYPE = 'SOURCE' to retrieve the canonical invoice source lookup values from the Oracle Application Object Library lookup model.
  • AP_INVOICES_ALL — queried for distinct SOURCE values not already present in the lookup codes, ensuring completeness of the dimension.
  • EDW_INSTANCE — an Enterprise Data Warehouse package used to stamp each row with the instance identifier via EDW_INSTANCE.GET_CODE, truncated to 40 bytes.

The ETRM record lists no formally documented referenced base objects, reflecting the object's obsolete status, but the embedded SQL clearly establishes these dependencies. The view is the Invoice Source level of a larger dimension hierarchy, and is typically joined to fact views through the INSTANCE and ALL_FK columns.

Key Columns

  • INV_SOURCE_PK — the natural primary key for the dimension level, sourced from LOOKUP_CODE or the distinct AI.SOURCE value.
  • ALL_FK — a literal 'ALL' constant, used as the foreign key to the "All" level of the dimension hierarchy for aggregate roll-ups.
  • INSTANCE — the EDW instance code, identifying the source EBS instance in multi-instance warehouse deployments.
  • NAME and INV_SOURCE — the descriptive label for the invoice source, both populated from DISPLAYED_FIELD or AI.SOURCE.
  • LAST_UPDATE_DATE and CREATION_DATE — derived from START_DATE_ACTIVE or TRUNC(SYSDATE)-1, providing a stable temporal stamp.
  • DELETION_DATE and INV_SOURCE_DP — placeholders returned as NULL.
  • _DF columns — data lineage descriptors mapping the source to FND, AP_INVOICES, AP_GOV_DETAIL_INVOICES, and JG_AP_INVOICES, which support EDW traceability.

Common Use Cases and Queries

Because the view is obsolete and may not exist physically, the most practical uses are lineage analysis, ETL reconciliation, and migration mapping. A representative query to enumerate dimension members is:

SELECT INV_SOURCE_PK, NAME, INV_SOURCE, INSTANCE FROM FIIBV_AP_IVSR_INV_SOURCE_LCV ORDER BY NAME;

To reconcile sources present on invoices but absent from the lookup table, the union's second branch can be replicated directly against AP_INVOICES_ALL. The ALL_FK column supports aggregate reporting, for example joining fact data on ALL_FK = 'ALL' to obtain totals across every invoice source. The all_fk term referenced in the originating search reflects this constant column, which is characteristic of FII dimension base views and is not a physical foreign key constraint.