Search Results cancelled_date

Overview

FIIBV_AP_IVTY_INV_LCV is a database view owned by the APPS schema within the Oracle E-Business Suite Financial Intelligence (FII) product family. FII, also marketed as Enterprise Performance Foundation / Financial Intelligence, provides the extract, transformation, and staging layer used by Oracle's analytical and data warehousing applications. Views in this family conform to the Enterprise Data Warehouse (EDW) integration model, presenting source application data in a structure intended for downstream consumption by reporting, analytics, and external extract processes.

In ETRM 12.1.1 and 12.2.2, the object is documented as an internal table with no user-facing description, and it carries a VALID status in the APPS schema. Its name follows the FIIBV_AP_IVTY_INV_LCV convention: FIIBV denoting a Financial Intelligence base view, AP indicating the Payables source, INVITY denoting the invoice activity/AP invoices extract, INV the entity, and LCV likely denoting the "latest changed version" or change-aware flavor used to drive incremental EDW loads. The view functions as a flattening layer over Payables invoice data, exposing the columns required by the EDW mapping definitions.

Underlying Base Objects

The view is defined over AP_INVOICES_ALL, aliased AI in the view text. AP_INVOICES_ALL is the Payables invoice entity table that stores invoice headers, including invoice number, type, source, cancellation date, and audit columns. The view references no other base table; all exposed columns derive from AP_INVOICES_ALL or from functions and literals in the SELECT list.

Notably, the ETRM metadata documents no additional referenced base objects, even though the SELECT list calls the EDW_INSTANCE.GET_CODE function. That function supplies the EDW instance code, which is concatenated into the surrogate primary key and also exposed in truncated form as the INSTANCE column. The view does not join to invoice lines, distributions, or suppliers; it is intentionally restricted to the invoice header grain to serve as a single-entity extract.

Key Columns

• INV_PK — Surrogate primary key constructed by concatenating TO_CHAR(INVOICE_ID), ORG_ID, and the first 40 bytes of EDW_INSTANCE.GET_CODE. This composite ensures global uniqueness across multi-org and multi-instance EDW deployments.
• INV_TYPE_FK — Maps to INVOICE_TYPE_LOOKUP_CODE, the Payables lookup identifying invoice type such as Standard, Credit, Prepayment, or Debit Memo.
• INV_ID — Character form of INVOICE_ID, the internal identifier of the invoice header.
• NAME / INV_NAME — Both populated from INVOICE_NUM, providing the user-visible invoice number for reporting and display.
• INSTANCE — The truncated EDW instance code returned by EDW_INSTANCE.GET_CODE, identifying the warehouse instance sourcing the row.
• INV_SOURCE — The invoice source indicator from AP_INVOICES_ALL, distinguishing originating subsystems.
• CANCELLED_DATE — Date the invoice was cancelled, if applicable; supports exclusion of voided documents.
• LAST_UPDATE_DATE / CREATION_DATE — Standard audit timestamps used by the EDW for incremental change detection.
• DELETION_DATE / INV_DP — Both NULL, reserving placeholder semantics for soft-delete and dimensional-property handling in the EDW model.
• _DF:SQLAP:AP_INVOICES:AI, _DF:SQLAP:AP_GOV_DETAIL_INVOICES:AI, _DF:JG:JG_AP_INVOICES:AI — Literal data-source descriptors, plus _DF:INV:_EDW, _DF:GOV:_EDW, and _DF:JGI:_EDW, used by EDW loaders to trace lineage and target mappings.

Common Use Cases and Queries

This view is primarily consumed by FII/EDW extraction programs rather than by end users or custom reports. It supports incremental invoice extracts, multi-org consolidation, and change tracking driven by CREATION_DATE and LAST_UPDATE_DATE. Analysts occasionally query it to enumerate the most recent invoice activity in a compact key structure.

Example query to list recent invoice extracts for an instance:

• SELECT INV_PK, INV_ID, INV_NAME, INV_TYPE_FK, INV_SOURCE, CREATION_DATE FROM APPS.FIIBV_AP_IVTY_INV_LCV WHERE CREATION_DATE >= TRUNC(SYSDATE) - 30 ORDER BY CREATION_DATE DESC;
• SELECT INV_TYPE_FK, COUNT(*) FROM APPS.FIIBV_AP_IVTY_INV_LCV WHERE CANCELLED_DATE IS NULL GROUP BY INV_TYPE_FK;

Because the view performs no joins and returns invoice-header rows only, its performance profile closely matches a filtered AP_INVOICES_ALL scan, and it should be accessed with predicates on the audit columns to keep extract windows bounded.