Search Results create_batch_date




Overview
Explore in AI Chat

Overview

FA_ASSET_INVOICES_MRC_V is a multi-reporting-currency (MRC) view owned by the APPS schema in Oracle E-Business Suite, belonging to the Oracle Assets (OFA) product. It exposes asset invoice and payables-sourced cost information for a single reporting set of books, filtered dynamically at runtime through the session context. The "_MRC_V" suffix indicates that the underlying data originates from a multi-currency accounting table, FA_MC_ASSET_INVOICES, which stores asset invoice details for each reporting book associated with a primary ledger. Because Oracle Assets can maintain multiple reporting sets of books, this view allows consumers to query invoice-level asset cost data as it applies to the currently selected reporting book rather than the primary set of books.

The view is documented as "Retrofitted," meaning its definition was regenerated or re-applied during an upgrade or patch cycle. In practice, the view plays a supporting role in payables-to-assets reconciliation, mass additions processing, and reporting on capitalizable invoice lines. The metadata confirms status VALID and identifies the object as a VIEW rather than a synonym or table, so it carries no independent storage.

Underlying Base Objects

The view is defined over a single documented base object: FA_MC_ASSET_INVOICES, referenced through APPS in the ETRM metadata as a SYNONYM. The view's SELECT statement qualifies the source table with the alias FAMAI and returns its columns without joins, aggregation, or transformation, apart from the governing WHERE clause. That clause restricts rows by SET_OF_BOOKS_ID, using the following predicate:

The CLIENT_INFO session parameter is populated by Oracle Assets when a user selects a reporting book, and the substring at offset 45 (length 10) contains the active set of books identifier. If no value is present, the NVL fallback of -1 returns no rows, preventing cross-book data leakage. Because the view simply re-projects the base table's columns with this filter applied, its behavior is entirely dependent on FA_MC_ASSET_INVOICES retaining currency-specific asset invoice rows.

Key Columns

The view exposes the full column list of FA_MC_ASSET_INVOICES. The most operationally significant columns include:

Common Use Cases and Queries

This view is typically queried during payables-to-assets reconciliation, when accountants need to confirm which invoice distributions posted to which assets for a reporting book, and during investigation of mass addition or batch posting issues. Because POST_BATCH_ID is exposed, users can trace a source invoice directly to the posting batch that capitalized it. A representative query is:

  • SELECT asset_invoice_id, asset_id, invoice_number, po_number, payables_cost, fixed_assets_cost, post_batch_id, create_batch_id FROM fa_asset_invoices_mrc_v WHERE post_batch_id = :batch_id;
  • SELECT invoice_number, SUM(payables_cost), SUM(fixed_assets_cost) FROM fa_asset_invoices_mrc_v WHERE asset_id = :asset_id GROUP BY invoice_number;

External reports and integrations that rely on multi-currency asset invoice detail should always supply the correct book context, since the view returns no rows if the CLIENT_INFO substring is empty. Direct queries against the view from tools outside the EBS form session may therefore require explicit initialization of the client context or a join back to FA_MC_ASSET_INVOICES with a literal SET_OF_BOOKS_ID filter.