Search Results inv_dp




Overview
Explore in AI Chat

Overview

FII_AP_IVTY_INV_LCV is a collection view owned by the APPS schema within the FII (Financial Intelligence) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It serves as the invoice-level collection view for the Invoice Type dimension, presenting a denormalized, reporting-oriented projection of accounts payable invoice activity that is consumed by the Financial Intelligence data model. In practice, the view acts as a staging interface between the transactional AP invoice tables and the analytical structures used for spend analysis, supplier performance reporting, and invoice lifecycle tracking. Because it is a collection view rather than a transactional entity, it is read-only by design and is intended for extraction, extraction-transform-load, and ad-hoc reporting workloads rather than for online transaction processing.

Underlying Base Objects

The view text documented in ETRM 12.2.2 shows that FII_AP_IVTY_INV_LCV is defined entirely over a single underlying object, FIIBV_AP_IVTY_INV_LCV, with no additional joins, unions, or aggregations at this layer. The row set is a direct projection: the first thirteen columns (INV_PK through INV_DP) map one-to-one to the base object, followed by five positional placeholders that alias the USER_ATTRIBUTE1 through USER_ATTRIBUTE5 columns. No referenced base tables are separately documented in the metadata, which indicates that the physical AP tables are encapsulated within the FIIBV layer beneath this collection view. This two-tier naming convention (FIIBV_ prefix for the internal build view, FII_ prefix for the published collection view) is standard within Financial Intelligence and allows Oracle to revise the underlying build logic without changing the public contract exposed to customer extracts.

Key Columns

  • INV_PK — The surrogate primary key of the invoice record used by FII. This is the column most relevant to the user's search for "inv_pk", as it is the canonical join key linking this view to other FII collection views and fact tables at invoice grain.
  • INV_TYPE_FK — Foreign key to the Invoice Type dimension, identifying the classification of the invoice within the FII dimension model.
  • INV_ID — The operational AP invoice identifier (AP_INVOICES_ALL.INVOICE_ID) from which the FII record is derived.
  • NAME / INV_NAME — Descriptive identifiers for the invoice or invoice type entry in the dimension.
  • INSTANCE / INV_SOURCE — Attributes identifying the source EBS instance and the originating invoice source.
  • CANCELLED_DATE, CREATION_DATE, LAST_UPDATE_DATE, DELETION_DATE — Lifecycle timestamps used for slowly changing dimension logic and point-in-time reporting.
  • INV_DP — A data-processing or partition indicator supporting incremental load strategies.
  • USER_ATTRIBUTE1 through USER_ATTRIBUTE5 — Flexible descriptive columns exposed as positional NULLs at this layer, carrying no values from the collection view itself but available for downstream extension.

Common Use Cases and Queries

Typical usage centers on joining invoice-level FII records to dimension views via INV_PK or INV_TYPE_FK. For example:

SELECT inv_pk, inv_id, inv_name, inv_type_fk, inv_source
FROM   apps.fii_ap_ivty_inv_lcv
WHERE  cancelled_date IS NULL
AND    creation_date >= SYSDATE - 90;

A second common pattern correlates this view to type-dimension lookups:

SELECT i.inv_pk, i.inv_id, i.inv_name, t.type_name
FROM   apps.fii_ap_ivty_inv_lcv i,
       apps.fii_ap_ivty_type_dim t
WHERE  i.inv_type_fk = t.type_pk
AND    i.deletion_date IS NULL;

Analysts also use the view to validate extract completeness by counting records per instance and source, and to reconcile FII invoice grain against AP_INVOICES_ALL before loading a warehouse.