Search Results fii_ap_inv_b

Overview

The FII_AP_INV_B table is a core data repository within the Oracle E-Business Suite (EBS) Financial Intelligence (FII) module. It functions as a summary table specifically designed to hold aggregated Accounts Payable (AP) information. Its primary role is to serve as a high-performance data source for the analytical portlets and dashboards within the AP and Procure-to-Pay Analysis (POA) areas of the FII application. By pre-aggregating transactional data, it enables efficient reporting and real-time business intelligence on key AP metrics, supporting strategic financial analysis and operational oversight without directly querying the underlying transactional tables.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the table's description and foreign key relationships indicate it stores summarized AP invoice and related data. Key fields logically include aggregated amounts (e.g., invoice amount, amount paid, discount taken), invoice counts, and date-based summaries (by due date, invoice date). Crucially, the documented foreign keys reveal it stores identifiers linking to source transactional entities. The column EXP_REPORT_HEADER_ID links to expense reports via AP_EXPENSE_REPORT_HEADERS_ALL, and PO_RELEASE_ID links to purchase order releases via PO_RELEASES_ALL. This suggests the summary encompasses both standard invoices and expense reports, and is integrated with procurement data.

Common Use Cases and Queries

This table is primarily accessed for predefined FII portlets and for building custom analytical reports. Common use cases include analyzing outstanding AP liabilities, tracking invoice payment performance, and monitoring expense report volumes. A typical analytical query would join this summary table to dimension tables (like time, supplier, and ledger) from the FII schema to produce reports. A sample pattern for summarizing aged payables might be:

• SELECT time_fiscal_year, supplier_name, SUM(invoice_amount) total_liability
• FROM fii_ap_inv_b inv, fii_suppliers sup, fii_time_day time
• WHERE inv.supplier_id = sup.supplier_id
• AND inv.invoice_date = time.report_date
• AND inv.amount_remaining > 0
• GROUP BY time_fiscal_year, supplier_name;

Direct operational reporting or data modification on this table is discouraged, as it is a derived summary maintained by the FII data collection and refresh processes.

Related Objects

The FII_AP_INV_B table is integral to the FII data model. As per the metadata, it has direct foreign key relationships to two core EBS transactional tables: AP_EXPENSE_REPORT_HEADERS_ALL and PO_RELEASES_ALL. It is also a central fact table that is almost certainly joined to various FII dimension tables (e.g., FII_TIME_DAY, FII_SUPPLIERS, FII_LEADERS) to provide contextual analysis. The table supports specific AP and POA portlets, implying dependencies from those application components. Its data is populated and refreshed via dedicated FII data collection programs that extract and transform data from the underlying AP, PO, and GL source modules.