Search Results fa_mc_asset_invoices




Overview
Explore in AI Chat

Overview

The FA_MC_ASSET_INVOICES table is a core data object within the Oracle E-Business Suite Fixed Assets (OFA) module, specifically for versions 12.1.1 and 12.2.2. It serves as the repository for accounts payable and purchasing information associated with capital assets, but with a critical distinction: it stores this information in the reporting currency. This table is essential for organizations operating in a multi-currency environment, as it maintains the converted invoice and distribution details that feed into asset cost reporting and reconciliation across different ledgers. Its primary role is to support the accurate reflection of asset acquisition costs in the corporate or other designated reporting currency, separate from the transaction currency stored in its base table counterpart, FA_ASSET_INVOICES.

Key Information Stored

The table's columns capture the financial and transactional lineage of an asset's invoice. Key fields include identifiers linking to the source asset (ASSET_ID), the originating invoice in Payables (INVOICE_ID, AP_DISTRIBUTION_LINE_NUMBER), and the related purchase order distribution (PO_DISTRIBUTION_ID). Crucially, it holds the reporting currency amounts for the invoice line. The table also maintains relationships to Projects (PROJECT_ID, TASK_ID, PROJECT_ASSET_LINE_ID) for project-related asset capitalization. Batch processing identifiers (CREATE_BATCH_ID, POST_BATCH_ID) track the mass addition and posting processes. The PAYABLES_CODE_COMBINATION_ID stores the reporting currency accounting flexfield for the liability, and the INVOICE_TRANSACTION_ID_IN and INVOICE_TRANSACTION_ID_OUT columns manage the relationship to the FA_INVOICE_TRANSACTIONS table for transfers and adjustments.

Common Use Cases and Queries

This table is central to reporting and reconciling asset costs in the reporting currency. Common use cases include generating reports that compare asset book costs in the corporate currency against original invoice values, auditing the multi-currency conversion history for asset additions, and troubleshooting discrepancies between Assets and Payables subledgers in the reporting ledger. A typical query might join to FA_ADDITIONS_B and GL_CODE_COMBINATIONS to list assets with their invoice details in the reporting currency.

SELECT fai.asset_id,
       fa.asset_number,
       fai.invoice_number,
       fai.invoice_id,
       fai.po_number,
       fai.invoice_amount -- This is in reporting currency
  FROM fa_mc_asset_invoices fai,
       fa_additions_b fa
 WHERE fai.asset_id = fa.asset_id
   AND fa.asset_number = '&Asset_Number';

Another critical scenario involves reconciling the FA_MC_ASSET_INVOICES data back to its source in AP_INVOICE_DISTRIBUTIONS_ALL for a specific reporting currency, ensuring the converted cost posted to the asset matches the underlying payable distribution.

Related Objects

As indicated by its extensive foreign keys, FA_MC_ASSET_INVOICES is a central hub integrating Fixed Assets with other EBS modules. Its primary relationships are:

  • FA_ADDITIONS_B: Links to the master asset record.
  • FA_INVOICE_TRANSACTIONS: Manages the invoice transaction lifecycle for transfers and adjustments.
  • AP_INVOICES_ALL & AP_INVOICE_DISTRIBUTIONS_ALL: The source invoice and distribution details from Payables.
  • PO_HEADERS_ALL & PO_DISTRIBUTIONS_ALL: The originating purchase order information.
  • PA_PROJECTS_ALL & PA_TASKS: For assets capitalized to projects.
  • GL_CODE_COMBINATIONS: The reporting currency liability account code.
  • Base Table: It is directly related to FA_ASSET_INVOICES, which holds the transaction currency data.