Results for “exp_report_header_id”

7 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FII_AP_INV_STG is a staging table owned by the FII (Financial Intelligence) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It serves as the intermediate landing area for Accounts Payable summary information, capturing invoice distribution-level detail before it is consumed by downstream Financial Intelligence extraction, transformation, and reporting processes. In a typical EBS implementation, data is populated into FII_AP_INV_STG from Payables transactional tables and subsequently moved into the FII data warehouse star schemas, where it feeds AP aging, spend analysis, supplier performance, and subledger reconciliation reporting.

Based on the foreign key structure mined from the ETRM metadata, this object can be modeled heuristically as a link table in a Data Vault sense. It records associative relationships among invoices, distributions, purchase orders, projects, employees, companies, and accounting flexfield combinations rather than acting as a standalone hub or a descriptive satellite. The 52 documented columns reflect this bridging role, carrying keys and measures that tie AP activity to multiple dimensions.

Key Information Stored

FII_AP_INV_STG spans 52 columns. The most significant include:

No surrogate primary key or unique index is documented in the supplied metadata; the table functions primarily as a key-and-measure container whose uniqueness is defined by the combination of invoice distribution, ledger, and org identifiers. Business-key candidates include INVOICE_ID plus INVOICE_DISTRIBUTION_ID and DISTRIBUTION_LINE_NUMBER.

Common Use Cases and Queries

Typical scenarios include AP spend reporting by supplier, cost center, or project; reconciliation between Payables and the General Ledger; and validating PO-matched versus non-PO invoices. A representative query pattern joins the staging table to supplier and accounting dimensions:

  • Aggregating SUM(AMOUNT_B) grouped by SUPPLIER_ID, ORG_ID, and ACCOUNT_DATE for period spend analysis.
  • Filtering on PO_MATCHED_FLAG to separate matched and unmatched invoices.
  • Joining DIST_CCID to the accounting flexfield to report by natural account or cost center.
  • Using POSTED_FLAG to isolate unposted distributions awaiting accounting.
  • Project cost queries filtering on PROJECT_ID and TASK_ID.

Related Objects

The documented foreign keys identify the principal dependencies of FII_AP_INV_STG:

These relationships confirm the table's role as a consolidation point linking Payables, Purchasing, Projects, and Financials dimensions within the FII reporting architecture.