Search Results inv_date

Overview

The FII_AP_INV_LINES_FCV view is a legacy Financial Intelligence (FII) extraction object belonging to the FII – Financial Intelligence module, designated as obsolete in Oracle EBS 12.1.1 and 12.2.2. FII was Oracle's early financial data warehousing and analytics product, positioned as a precursor to later Oracle Business Intelligence Applications (OBIA) and Daily Business Intelligence (DBI) offerings. This view serves as a flattened, denormalized staging surface purpose-built for extracting Oracle Payables invoice line detail into an external warehouse environment.

Its principal role is to consolidate invoice-line-level transaction facts — amounts, quantities, prices, variances, matching status, tax, withholding, and accounting attributes — into a single row-per-invoice-line projection suitable for ETL loading. As documented in ETRM, the view is not implemented in the current database and its referenced base objects are not catalogued, confirming it exists only as a legacy migration artifact for installations that have retained FII-era warehouse objects. In modern 12.x environments it is effectively dormant.

Underlying Base Objects

The ETRM metadata records no documented referenced base objects, and the view is marked "Not implemented in this database." Where the view is present, its column inventory (foreign-key surrogates such as INV_LINE_PK, INV_FK, SUPPLIER_FK, SOB_FK, ITEM_FK, PROJECT_ID, TASK_ID) indicates it is derived principally from the Payables invoice line and distribution tables — AP_INVOICE_LINES_ALL, AP_INVOICES_ALL, and AP_INVOICE_DISTRIBUTIONS_ALL — joined to a star-schema conformed dimension layer (supplier, geography, employee, item, currency, set of books). The _FK suffix columns are warehouse surrogate keys rather than EBS primary keys, distinguishing FII facts from transactional tables. Several duplicated LAST_UPDATE_DATE1..4 columns reflect the multiple source tables fused into the projection.

Key Columns

• AWT_FLAG / AWT_GROUP_ID — Withholding tax indicator and withholding group identifier; the columns driving the "awt_flag" search. AWT_FLAG denotes whether withholding applies; AWT_GROUP_ID links to the tax group definition.
• INV_LINE_PK / INV_FK / SEQ_ID — Invoice line surrogate key, parent invoice key, and line sequence.
• MATCH_STATUS_FLAG / MATCH_LINE_COUNT / UNMATCH_LINE_COUNT — PO-matching state and matched versus unmatched line counts.
• INV_LINE_AMT_T/B/G, MATCH_LINE_AMT_T/B/G, TOTAL_VAR_AMT_T/B/G — Tracked, base, and global currency amounts for invoice lines, matched amounts, and total variance.
• INV_PRICE_VAR_AMT, QTY_VAR_AMT, PO_UNIT_PRICE, INV_UNIT_PRICE — Price and quantity variance facts with PO versus invoice pricing.
• ACCRUAL_POSTED_FLAG, CASH_POSTED_FLAG, POSTED_FLAG, ENCUMBERED_FLAG, ASSETS_TRACKING_FLAG, AMT_INCLUDES_TAX_FLAG — Posting and processing status flags.
• GL_ACCT1_FK and related DECODE expressions — GL account segment parsing, including the special NA_EDW mapping.
• EXCHANGE_RATE, EXCHANGE_RATE_TYPE, EXCHANGE_DATE, GLOBAL_CURRENCY_RATE — Currency conversion context.

Common Use Cases and Queries

Typical usage is confined to legacy FII warehouse extraction and reconciliation reporting, particularly for withholding tax analysis, variance analysis, and matched/unmatched line aging.

Identify withholding-tax-applicable invoice lines:

SELECT INV_NUM, INV_LINE_PK, SEQ_ID, AWT_FLAG, AWT_GROUP_ID,
       INV_LINE_AMT_T, POSTED_AMT_T
FROM   FII_AP_INV_LINES_FCV
WHERE  AWT_FLAG = 'Y'
AND    ACCOUNTING_DATE BETWEEN :p_start AND :p_end;

Summarize price and quantity variance by supplier and set of books, and reconcile matched versus unmatched amount buckets using SUM(TOTAL_VAR_AMT_B) grouped by SUPPLIER_FK, SOB_FK, and MATCH_STATUS_FLAG. Because FII is obsolete, Oracle recommends migrating equivalent logic to OBIA/DBI or direct sourcing from AP_INVOICE_LINES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL in current 12.2.2 architectures.