Search Results fa_massadd_rep_itf




Overview
Explore in AI Chat

Overview

FA_MASSADD_REP_ITF is an Oracle Assets (OFA) interface table owned by the FA schema. Its documented description is "Interface table for Report eXchange reports," indicating that it serves as a staging structure populated by the Mass Additions Report eXchange process and related concurrent programs. In Oracle EBS 12.1.1 and 12.2.2, the table holds the intermediate, report-facing representation of mass addition lines before, during, and after the posting of payables-sourced and manually entered asset additions into the FA_ADDITIONS_B base table.

The object is classified as VALID in the ETRM repository and contains 67 documented columns in the 12.2.2 schema. From a Data Vault modeling perspective, the mined foreign-key structure suggests this table behaves as a link entity: it associates a mass addition group asset (via GROUP_ASSET_NUMBER) with a purchasing distribution (via PO_DISTRIBUTION_ID), while carrying extensive descriptive and financial attributes that would typically be modeled as satellite data. This classification is heuristic and intended as a modeling suggestion rather than a statement of Oracle's physical design.

Key Information Stored

The table's most significant columns fall into identification, financial, and asset-attribute categories:

The surrogate primary key is not explicitly documented in the excerpt; the practical business-key candidates are GROUP_ASSET_NUMBER combined with MASS_ADDITION_ID or PO_DISTRIBUTION_ID, which together uniquely identify a staged addition line.

Common Use Cases and Queries

Typical usage centers on reconciliation of the Mass Additions Report eXchange output against posted assets. A common query joins the interface to the asset base table to confirm that staged rows have been converted:

  • Report reconciliation: SELECT r.group_asset_number, r.payables_cost, r.fixed_assets_cost FROM fa_massadd_rep_itf r WHERE r.request_id = :request_id.
  • Posting status monitoring: filter on POSTING_STATUS = 'POSTED' or STATUS to detect unposted or error rows.
  • Variance analysis between PAYABLES_COST and FIXED_ASSETS_COST to identify exchange-rate or allocation differences before capitalization.
  • Traceability from PO_DISTRIBUTION_ID back to the purchasing distribution for audit of capitalized versus expensed amounts.

Programs such as the Mass Additions Create and Post Mass Additions concurrent processes populate and consume this table, so REQUEST_ID-scoped queries are the standard reporting idiom.

Related Objects

The following objects are most significant to FA_MASSADD_REP_ITF based on the documented relationships:

  • FA_ADDITIONS_B — joined on GROUP_ASSET_NUMBER; the authoritative asset definition table.
  • PO_DISTRIBUTIONS_ALL — joined on PO_DISTRIBUTION_ID; the purchasing distribution source.
  • FA_MASS_ADDITIONS — the primary mass additions staging table with which this interface coexists.
  • FA_BOOK_CONTROLS — provides the BOOK_TYPE_CODE context and period status.
  • FA_CATEGORIES_B — resolves ASSET_CATEGORY_ID to category defaults.
  • AP_INVOICES_ALL / AP_INVOICE_DISTRIBUTIONS_ALL — referenced through invoice and distribution identifiers.
  • FA_ADDITIONS — the reporting view over the asset base table for end-user queries.

These relationships make FA_MASSADD_REP_ITF a bridge between the Payables and Assets subledgers within the Oracle EBS financials architecture.