FA Asset Additions – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Imported from BI Publisher Description: Asset Additions Report Application: Assets Source: Asset Additions Report (XML) Short Name: FAS420_XML DB package: FA_FAS420_XMLP_PKG

Report Parameters

Ledger, Book, From Period Entered, To Period Entered, From Period Effective, To Period Effective, Category From, Category To

Oracle EBS Tables Used

fa_calendar_periods, fa_deprn_periods, fa_system_controls, fa_lookups, fa_additions, fa_asset_history, fa_transaction_headers, fa_category_books, fa_categories_b_kfv, fa_distribution_history, gl_code_combinations, &lp_fa_adjustments, &lp_fa_books, &lp_fa_deprn_summary, &lp_fa_deprn_detail, fnd_currencies, &lp_fa_book_controls, gl_sets_of_books, fa_book_controls_sec, &lp_fa_deprn_periods

Report Categories

Enginatics, R12 only

FA Asset Book Details, FA Asset Summary (Germany), FA Asset Upload, FA Asset Reclassification, FA Asset Retirements, FA Cost Adjustments, GL Account Distribution Analysis, GL Account Analysis (Distributions), FA Asset Register

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output FA Asset Additions 30-Aug-2021 051352.xlsx
Blitz Report™ XML Import FA_Asset_Additions.xml
Full SQL on Enginatics www.enginatics.com/reports/fa-asset-additions/

Case Study: Automating Fixed Asset Capitalization Reporting in Oracle EBS

Executive Summary

The FA Asset Additions report is a critical financial control tool designed to validate the capitalization of new assets within Oracle Fixed Assets. By providing a detailed audit trail of asset additions—including source details from Payables and Projects—this report ensures that organizations maintain an accurate asset register, comply with depreciation policies, and support rigorous tax reporting requirements.

Business Challenge

For asset-intensive organizations, the process of capitalizing assets (“Additions”) is a high-risk area for financial reporting. Inaccurate data during this phase can lead to incorrect depreciation calculations for years to come. Common challenges include:

The Solution

The FA Asset Additions report provides a comprehensive view of all assets added within a specific period or range. It bridges the gap between the subsidiary ledgers (AP/PA) and the Fixed Assets module, offering immediate visibility into the “who, what, and when” of asset creation.

Key Features

Technical Architecture

The report is built upon the core Oracle Fixed Assets transaction tables, ensuring data integrity and alignment with the standard FAS420 XML Publisher report but with enhanced accessibility.

Critical Tables

Key Parameters

Functional Analysis

Use Cases

  1. Month-End Close: Accountants run this report to verify that all assets cleared from the CIP (Construction in Process) accounts have been correctly capitalized.
  2. Tax Reporting: Tax teams use the report to identify new additions for the year to calculate tax depreciation schedules.
  3. Internal Audit: Auditors use the source line details to sample asset additions and verify the existence of supporting documentation (invoices).

FAQ

Q: Does this report show assets added via Mass Additions? A: Yes, it includes assets added manually as well as those processed through the Mass Additions interface from Payables or Projects.

Q: Can I see the GL accounts associated with the addition? A: Yes, the report joins to FA_DISTRIBUTION_HISTORY and GL_CODE_COMBINATIONS to show the expense and asset cost accounts.

Q: How does this compare to the standard FAS420 report? A: This SQL-based approach allows for easier export to Excel for pivot table analysis, whereas the standard XML/PDF output is static and harder to manipulate for large datasets.

© 2026 Enginatics