FA Asset Additions – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Assets · all Assets reports

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

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Ledger, Book, From Period Entered, To Period Entered, From Period Effective, To Period Effective, Category From, Category To, Asset Number, Asset Key

Oracle EBS Tables Used

fbc, fb, fds, fadj, fdd, fa_calendar_periods, fa_deprn_periods, fa_system_controls, fa_lookups, fa_additions, fa_asset_keywords_kfv, fa_asset_history, fa_transaction_headers, fa_category_books, fa_categories_b_kfv, fa_distribution_history, fa_locations_kfv, gl_code_combinations, fnd_currencies, gl_sets_of_books, fa_book_controls_sec, dp

Report Categories

Enginatics

FA Asset Retirements, FA Asset Book Details, FA Fixed Assets Book, FA Asset Upload, FA Asset Inventory 11i, FA Asset Transfers, FA Asset Summary (Germany), FA Asset Reclassification, FA Cost Adjustments

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output FA Asset Additions 30-Aug-2021 051352.xlsx
Blitz Report™ XML Import FA_Asset_Additions.xml
SQL Source FA Asset Additions.sql
Full Report 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.

© Enginatics GmbH