Search Results ap_invoices_u1

Overview

FIIBV_AP_INV_LINES_FCV is a base view belonging to the Financial Intelligence (FII) product family within Oracle E-Business Suite. It functions exclusively as the source view for the FII_AP_INV_LINES_F fact table, part of the Financial Intelligence data warehouse schema. FII was Oracle's early-generation financial analytics offering, predating the later Enterprise Performance Foundation and Financial Services data models, and it is classified as obsolete in Oracle EBS 12.1.1 and 12.2.2.

The view is not a transactional or operational object. Its purpose is to flatten and enrich Accounts Payable invoice distribution data with descriptive attributes and surrogate foreign-key strings suitable for dimensional loading. Each row represents one invoice distribution line combined with context from the associated invoice, supplier, purchase order, accounting period, and inventory item definitions. Because FII is retired, the view is documented for reference and historical understanding rather than for active development.

The metadata states plainly that FIIBV_AP_INV_LINES_FCV is "not implemented in this database," confirming that the object does not exist in the current EBS instance and cannot be queried or compiled there.

Underlying Base Objects

The view text reveals a heavily joined definition. Although the ETRM metadata documents no referenced base objects, the embedded SELECT statement lists the operative tables and, importantly for the user's search, exposes the exact indexes relied upon for the join strategy. The tables include AP_INVOICE_DISTRIBUTIONS, AP_INVOICES, PO_VENDORS, PO_DISTRIBUTIONS, PO_LINE_LOCATIONS, PO_HEADERS, MTL_UNITS_OF_MEASURE_TL, FND_USER, GL_CODE_COMBINATIONS, GL_SETS_OF_BOOKS, FII_LOOKUPS (aliased LI), and the FII transaction/parameter tables (AID, AI, GCC, GSOB, PV, PD, PL, PLL, PH, MTL, FU, FSP, LI, LS).

The hint block directs the optimizer to use nested-loop joins in a fixed order and to access each driving table through a named unique or primary index. Notably, the alias PLL is accessed via INDEX(PLL PO_LINE_LOCATIONS_U1) — the exact index the user searched for. PO_LINE_LOCATIONS_U1 is the unique primary key index on PO_LINE_LOCATIONS, and the view uses it to resolve purchase-order line-location detail for each invoice distribution.

Key Columns

The view projects foreign-key surrogate strings rather than plain numeric identifiers, a design characteristic of FII fact-loading views. Key columns include:

• Approval status and sequence — AI.APPROVAL_STATUS and FTP.SEQ_ID convey invoice workflow state and load sequencing.
• INV_LINE_PK — a concatenated key of invoice distribution line number, invoice line number, and org, built from AP_INVOICE_DISTRIBUTIONS.
• UOM_G_FK / UOM_T_FK — unit-of-measure keys resolved through EDW_UTIL.GET_EDW_BASE_UOM and GET_EDW_UOM using MTL units of measure.
• ACCOUNTING_DATE_FK — composite of accounting date, period set name, and accounted period type from GL_SETS_OF_BOOKS.
• EMPLOYEE_FK — derived from FND_USER employee identifiers, with 'NA_EDW' substitution when null.
• SUPPLIER_FK / GEOGRAPHY_FK — vendor-site-based keys qualified by org and instance code.
• INV_FK, INV_CURRENCY_FK, ORG_FK, PAYMENT_TERM_FK, INSTANCE_FK — dimensional keys linking to invoice, currency, operating unit, payment terms, and EBS instance dimensions.

Null handling is standardized: DECODE and NVL expressions convert missing values to the literal 'NA_EDW' so that fact loads never encounter a null foreign key.

Common Use Cases and Queries

Because the view is obsolete and not implemented, practical use is limited to reference and migration analysis. In an FII-enabled historical environment, a typical extraction would resemble:

• Dimensional staging: SELECT INV_LINE_PK, SUPPLIER_FK, ORG_FK, ACCOUNTING_DATE_FK FROM FIIBV_AP_INV_LINES_FCV WHERE APPROVAL_STATUS = 'APPROVED'; used to populate FII_AP_INV_LINES_F.
• Join-path investigation: querying ALL_IND_COLUMNS for PO_LINE_LOCATIONS_U1 to confirm the unique key used by the PLL alias.
• Lineage documentation: mapping FII fact columns back to AP_INVOICE_DISTRIBUTIONS and PO_LINE_LOCATIONS for modernization to contemporary analytics.

For current releases, equivalent AP invoice distribution reporting should be sourced directly from AP_INVOICE_DISTRIBUTIONS joined to PO_DISTRIBUTIONS and PO_LINE_LOCATIONS, since neither the FII view nor its fact table is supported in EBS 12.1.1 or 12.2.2.