Search Results fii_ap_inv_lines_fstg

Overview

FII_AP_INV_LINES_FSTG is a staging (interface) table owned by the FII schema within the Oracle EBS Financial Intelligence product family. It serves as the inbound landing zone for Accounts Payable invoice line facts before they are validated, transformed, and loaded into the Financial Intelligence data warehouse. In EBS 12.1.1 and 12.2.2, Financial Intelligence extracts transactional AP data from the operational schemas (primarily AP and PO) and consolidates it into fact and dimension structures used for analytical reporting. This table holds the line-level grain of that pipeline, capturing invoiced quantities, matched and unmatched amounts, price and quantity variances, distribution references, and the surrounding accounting context. Its documented physical schema in ETRM 12.1.1 spans 182 columns.

From a Data Vault modeling perspective, the metadata classifies this object heuristically as standalone. This suggests it functions less as a pure hub or link and more as a wide satellite-style staging container that aggregates descriptive attributes and measures around the invoice line business key, rather than defining foreign-key-driven relationships to other hubs.

Key Information Stored

The table carries both surrogate keys and natural business identifiers, alongside a broad set of monetary measures expressed in transaction, entered, and base currencies.

• INV_LINE_PK — the natural business key for the invoice line; the primary candidate for uniquely identifying a staging record.
• ROW_ID — surrogate-style identifier and the only documented foreign key, referencing CS_SYSTEMS_ALL_B_TEMP.
• INV_NUM / VOUCHER_NUMBER — invoice number and voucher identifier linking back to the AP invoice header.
• PO_NUMBER — purchase order reference for matched invoices.
• SUPPLIER_FK / SUPPLIER_SITE_ID — supplier and supplier site identifiers for payee analysis.
• INV_LINE_AMT_T / _G / _B — invoiced line amount in transaction, entered, and base currencies.
• INV_LINE_COUNT — aggregate line count measure.
• MATCH_LINE_AMT_T / _G / _B and UNMATCH_LINE_AMT_T / _G / _B — matched versus unmatched line amounts.
• QTY_VAR_AMT_T / _G / _B and INV_PRICE_VAR_AMT_T / _G / _B — quantity and price variance amounts.
• QUANTITY_INVOICED_T / _G — invoiced quantity measures.
• ACCOUNTING_DATE / INV_DATE / EXCHANGE_DATE — key date dimensions for period reporting.
• CCID and the GL_ACCT1_FK through GL_ACCT10_FK keys — account and chart-of-accounts decomposition.
• ORG_FK / SOB_FK — operating unit and set-of-books keys for organizational rollups.
• INV_TYPE / APPROVAL_STATUS / MATCH_STATUS_FLAG / POSTED_FLAG — status attributes useful for filtering and reconciliation.

Common Use Cases and Queries

Because this is a staging interface, the dominant use cases involve validation, reconciliation, and downstream fact loading. Typical queries profile staged amounts and variances prior to transformation, or reconcile staged records against posted AP transactions.

• Summing invoiced and variance amounts by operating unit and accounting period: aggregate INV_LINE_AMT_B, MATCH_LINE_AMT_B, and QTY_VAR_AMT_B grouped by ORG_FK and ACCOUNTING_DATE.
• Isolating unmatched or unapproved lines: filter where MATCH_STATUS_FLAG or APPROVAL_STATUS indicate exceptions.
• Verifying load completeness by comparing INV_LINE_COUNT against upstream AP invoice line counts.
• Analyzing price and quantity variance trends by supplier (SUPPLIER_FK) or category (CATEGORY_ID).
• Auditing multi-currency exposure through the transaction-versus-base currency amount columns.

Related Objects

The documented relationship footprint of this table is narrow, reflecting its staging role:

• CS_SYSTEMS_ALL_B_TEMP — referenced via FII_AP_INV_LINES_FSTG.ROW_ID, providing the system/source registration context for the staged row.
• The upstream AP_INVOICE_LINES_ALL and AP_INVOICES_ALL operational tables, which supply source invoice and line data (joined on invoice and line identifiers).
• PO_DISTRIBUTIONS_ALL — referenced through PO_DISTRIBUTION_ID for matched purchase-order distributions.
• PO_HEADERS_ALL — the source of PO_NUMBER.
• GL_CODE_COMBINATIONS — resolved through CCID and the GL account FK keys.
• Downstream FII fact and dimension tables loaded from this staging interface.