Search Results fa_asset_invoices




Overview
Explore in AI Chat

Overview

The FA_ASSET_INVOICES table is a core transactional table within the Oracle E-Business Suite Fixed Assets module (OFA). It serves as the central repository for linking capital asset records to their originating source documents from the Procure-to-Pay cycle. Its primary role is to store detailed accounts payable and purchasing information for each asset, creating an auditable trail from the asset's financial addition in Fixed Assets back to the invoice in Payables (AP) and, often, the original purchase order (PO) in Purchasing. This integration is fundamental for accurate asset costing, reconciliation with subledgers, and project accounting tie-ins.

Key Information Stored

The table's columns can be categorized by their link to related EBS modules. Key foreign key columns establish these critical relationships. The ASSET_ID links to the FA_ADDITIONS_B table, the master asset record. The INVOICE_ID and AP_DISTRIBUTION_LINE_NUMBER pair connects to the AP_INVOICE_DISTRIBUTIONS_ALL table, tying the asset cost to a specific invoice line. For purchased assets, PO_DISTRIBUTION_ID links to Purchasing. Project-related columns like PROJECT_ID, TASK_ID, and PROJECT_ASSET_LINE_ID facilitate Project Accounting (PA) integration. The table also manages the lifecycle of assets sourced from the Mass Additions interface through links to FA_MASS_ADDITIONS via columns such as PARENT_MASS_ADDITION_ID, SPLIT_PARENT_MASS_ADDITIONS_ID, and MERGE_PARENT_MASS_ADDITIONS_ID.

Common Use Cases and Queries

This table is essential for reconciliation reports and troubleshooting asset cost discrepancies. A common query traces an asset's invoice source by joining to AP and Purchasing tables. For example:

  • SELECT fa.asset_number, ai.invoice_id, ap.invoice_num, po.segment1 po_number FROM fa_additions fa, fa_asset_invoices ai, ap_invoices_all ap, po_headers_all po WHERE fa.asset_id = ai.asset_id AND ai.invoice_id = ap.invoice_id AND ai.po_number = po.po_header_id(+);

It is also critical for identifying assets created from a specific Mass Addition batch or for validating that all project-related assets have correct task assignments. Support and implementation teams frequently query this table to diagnose issues where an asset's cost does not match the associated invoice distribution amount or to find assets linked to a specific vendor via the PO_VENDOR_ID.

Related Objects

As indicated by its extensive foreign keys, FA_ASSET_INVOICES is a central hub integrating multiple modules. Its primary relationships are: