Search Results fnd_user_u1

Overview

The view APPS.FIIBV_AP_INV_LINES_FCV is a Business Intelligence (BI) facing database object that belongs to the Oracle E-Business Suite Financial Intelligence (FII) family of extracted data sets, commonly referred to as "FCV" (Financial Corporate View) or first-class views used by OBIA/ETRM reporting. Its primary function is to present Oracle Payables invoice distribution line information in a flattened, denormalized form suitable for extraction, data warehousing, and analytical reporting. The view consolidates detail from the Payables sub-ledger together with purchasing, suppliers, general ledger, units of measure, and FND user data, producing surrogate-style foreign key columns (suffixed with _FK) that are designed to map into the ETRM/BI star schema. Because it joins across so many foundational tables and computes composite keys, it is intended for read-oriented extraction rather than transactional online use.

Underlying Base Objects

The view text documents its internal joins and hints explicitly. The driving, interrelated set of base tables includes AP_INVOICE_DISTRIBUTIONS (aliased AID), AP_INVOICES (AI), and what appears as FND_USER (FU). Purchasing base objects include PO_VENDORS (PV), PO_DISTRIBUTIONS (PD), PO_HEADERS (PH), PO_LINE_LOCATIONS (PLL), and a PO line table (PL). General ledger context is supplied by GL_CODE_COMBINATIONS (GCC) and GL_SETS_OF_BOOKS (GSOB). Unit-of-measure translation is resolved via MTL_UNITS_OF_MEASURE_TL (MTL). Utility functions EDW_UTIL.GET_EDW_BASE_UOM and EDW_UTIL.GET_EDW_UOM are invoked to derive canonical UOM representations, and instance/source context is carried through LI (LI.instance_code). Critically, the view is written with an ORDERED USE_NL hint and explicit single-table index hints, including the index PO_HEADERS_U1 — the exact object referenced in the user's search term — confirming that PO_HEADERS is one of the principal dimension sources behind this view.

Key Columns

• APPROVAL_STATUS — approval state of the parent invoice.
• INV_LINE_PK — concatenated surrogate key combining invoice/distribution/line/org identifiers.
• UOM_G_FK / UOM_T_FK — base and translated unit-of-measure foreign keys.
• ACCOUNTING_DATE_FK — composite accounting-period key; defaults to 'NA_EDW' when null.
• EMPLOYEE_FK, SUPPLIER_FK, GEOGRAPHY_FK, ORG_FK — dimension keys for employee, supplier, site geography, and operating unit.
• INV_FK, INV_CURRENCY_FK, INV_SOURCE_FK — invoice identity, currency, and source system keys.
• PAYMENT_TERM_FK, SOB_FK, SIC_CODE_FK — payment terms, set of books, and industry classification.
• INSTANCE_FK — identifies the source EBS instance.
• DUNS_FK, UNSPSC_FK — reserved placeholders fixed to 'NA_EDW'.

Common Use Cases and Queries

This view is typically consumed by ETRM/OBIA extraction mappings rather than ad hoc operational queries. Analysts use it to reconcile Payables invoice distributions against purchase order receipts, to analyze spend by supplier and organization, and to populate AP invoice-line fact tables. A representative query joins the flattened keys back to BI dimension tables:

SELECT INV_LINE_PK, SUPPLIER_FK, ORG_FK, ACCOUNTING_DATE_FK, UOM_G_FK
FROM   APPS.FIIBV_AP_INV_LINES_FCV
WHERE  APPROVAL_STATUS = 'APPROVED';

The presence of the PO_HEADERS_U1 index hint indicates the optimizer is steered to access PO_HEADERS efficiently when resolving PO-referenced invoice lines, making the view suitable for high-volume extraction jobs that trace Payables distributions back to their originating purchase orders.