Search Results inv_source




Overview
Explore in AI Chat

Overview

FII_AP_IVSR_INV_SOURCE_LCV is a collection view within the Oracle Financial Intelligence (FII) product family, belonging to the Payables (AP) subject area. It exposes data at the Invoice Source level of the Invoice Source dimension, which is one of the standard dimensional hierarchies used by Financial Intelligence (also marketed as Daily Business Intelligence) reporting. In EBS 12.1.1 and 12.2.2, FII views of this type supply the extract layer consumed by the DBI/FII collection programs, which stage dimensional and fact data into summary tables used for dashboards and analytics on Payables activity.

The _LCV suffix denotes a "collection view" — an internal, ETL-facing object rather than an end-user reporting view. Its role is to present a flattened, denormalized projection of a single dimension level so that collection programs can load dimension members consistently. Importantly, the FII product line is documented as Obsolete, and this view is not implemented in the reference database. Organizations on 12.1.1/12.2.2 should treat any remaining FII objects as legacy artifacts, superseded by Oracle Business Intelligence Applications (OBIA) and later analytical offerings.

Underlying Base Objects

The view text reveals that it is defined over a single underlying collection view, FIIBV_AP_IVSR_INV_SOURCE_LCV:

  • FII_AP_IVSR_INV_SOURCE_LCV — the collection view (the object documented here).
  • FIIBV_AP_IVSR_INV_SOURCE_LCV — the "BV" (base view) that performs the actual dimensional derivation and column population.

The ETRM metadata records no separately documented base tables ("Referenced base objects: none documented"), which is typical for FII collection views: the physical source tables are resolved inside the BV layer, ultimately tracing to Payables tables such as invoice headers, lookup values, and source definitions. Because the object is not implemented in this database, the definitive join path to base AP tables cannot be confirmed from the provided metadata.

Key Columns

The view projects the following columns (with the last five positionally NULL):

  • INV_SOURCE_PK — surrogate primary key for the Invoice Source dimension member.
  • ALL_FK — the "all" foreign key, linking this level to the top of the dimension hierarchy.
  • INSTANCE — identifies the source instance/organization context.
  • NAME — display name of the invoice source member.
  • INV_SOURCE — the invoice source value (the dimensional attribute itself).
  • LAST_UPDATE_DATE, CREATION_DATE, DELETION_DATE — standard EBS audit and slowly-changing-dimension effective-dating columns.
  • INV_SOURCE_DP — the descriptive flexfield (DP) column for the invoice source.
  • USER_ATTRIBUTE1–5 — declared in the signature but selected as NULL literals, reserved for extensibility.

Common Use Cases and Queries

Typical use is dimensional validation and collection troubleshooting rather than ad hoc reporting, since the view is not deployed. A representative query:

  • Listing invoice source members: SELECT INV_SOURCE_PK, NAME, INV_SOURCE, INSTANCE FROM FII_AP_IVSR_INV_SOURCE_LCV ORDER BY NAME;
  • Checking active members by effective dates: SELECT INV_SOURCE_PK, NAME FROM FII_AP_IVSR_INV_SOURCE_LCV WHERE DELETION_DATE IS NULL AND CREATION_DATE <= SYSDATE;
  • Joining to the parent level via ALL_FK to reconstruct the Invoice Source hierarchy for drill-down.

Given its obsolete status, these patterns are most relevant to migration review or auditing historical FII collections.