Search Results inv_source_pk




Overview
Explore in AI Chat

Overview

APPS.FIIBV_AP_IVSR_INV_SOURCE_LCV is an Oracle E-Business Suite 12.1.1 / 12.2.2 view that presents a consolidated, reporting-friendly list of invoice source values used within Oracle Payables. The suffix "LCV" denotes a "lookup code value" style construct, and "FIIBV" indicates that the object belongs to the Oracle Financials Intelligence / EBS data warehouse integration layer, specifically the AP Invoice Source reference set. The view is intended to serve as a conformed dimension source for downstream analytics and ETL processes that require a stable, enumerated list of invoice sources without depending directly on the transactional AP_INVOICES_ALL table or the FND/AP lookup infrastructure.

Functionally, the view answers the question "what invoice sources exist in this instance?" by combining the standard Oracle Payables SOURCE lookup codes with any ad-hoc source values that have been entered on actual invoices but not registered as lookup codes. This union guarantees that the reference list is complete even when users have typed free-form source values, which is common in legacy or custom integrations.

Underlying Base Objects

The ETRM metadata for this object documents no explicit base objects, but the view text itself references two sources:

  • AP_LOOKUP_CODES — filtered by LOOKUP_TYPE = 'SOURCE'. This is the Oracle Payables lookup table that stores the seeded or user-defined invoice source codes and their displayed field values.
  • AP_INVOICES_ALL — the transactional invoice table. The view selects DISTINCT ai.source for any source value not already present in AP_LOOKUP_CODES.

The view also references the function EDW_INSTANCE.GET_CODE, which returns the instance identifier used by the EBS data warehouse to distinguish multiple EBS environments feeding a single reporting database. Several _df: tag columns are included as data-lineage markers pointing back to FND_COMMON_LOOKUPS, AP_INVOICES, AP_GOV_DETAIL_INVOICES, and JG_AP_INVOICES.

Key Columns

  • INV_SOURCE_PK — the primary key / lookup code value for the invoice source (e.g., a seeded code such as INVOICE, or a free-form value found on AP_INVOICES_ALL).
  • ALL_FK — a constant 'ALL' used as a degenerate foreign key for "all instances" reporting.
  • INSTANCE — the EBS instance code from EDW_INSTANCE.GET_CODE, truncated to 40 bytes.
  • NAME and INV_SOURCE — the human-readable description. For lookup codes this is DISPLAYED_FIELD; for ad-hoc sources it is the raw AI.SOURCE value.
  • LAST_UPDATE_DATE / CREATION_DATE — derived from START_DATE_ACTIVE for lookups, or TRUNC(SYSDATE)-1 for ad-hoc values.
  • DELETION_DATE and INV_SOURCE_DP — consistently NULL, reserved for slowly changing dimension processing.

Common Use Cases and Queries

Typical uses include populating an invoice source dimension in an AP spend dashboard, validating source values prior to loading an invoice interface, and reconciling invoice counts by source.

Example — list all invoice sources for the current instance:

  • SELECT INV_SOURCE_PK, NAME, INV_SOURCE FROM APPS.FIIBV_AP_IVSR_INV_SOURCE_LCV ORDER BY INV_SOURCE_PK;

Example — find ad-hoc sources not seeded as lookups:

  • SELECT INV_SOURCE_PK FROM APPS.FIIBV_AP_IVSR_INV_SOURCE_LCV WHERE INV_SOURCE_PK NOT IN (SELECT LOOKUP_CODE FROM AP_LOOKUP_CODES WHERE LOOKUP_TYPE='SOURCE');

Example — join to AP invoices to summarize amounts by source for ETL staging:

  • SELECT s.INV_SOURCE, COUNT(*) FROM AP_INVOICES_ALL ai JOIN APPS.FIIBV_AP_IVSR_INV_SOURCE_LCV s ON ai.source = s.INV_SOURCE_PK GROUP BY s.INV_SOURCE;