FA Asset Register – Oracle EBS SQL Report

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

Overview

Application: Assets Source: Asset Register Report (XML) Short Name: FAS600_XML DB package: FA_FAS600_XMLP_PKG

Report Parameters

Book, From Period, To Period, From Asset Number, To Asset Number, Asset Key, Show Deprn Book Details, Show Distribution Details, Show Invoice Details, DFF Display

Oracle EBS Tables Used

fa_asset_keywords_kfv, fa_transaction_headers, fa_asset_history, fa_books, fa_categories, fa_lookups, fa_additions_tl, fa_additions_b, fa_book_controls, fa_deprn_periods, fa_ceiling_types, fa_deprn_summary, fa_methods, fa_itc_rates, fa_convention_types, fa_calendar_periods, fa_calendar_types, fa_locations, gl_code_combinations, per_all_people_f, fa_distribution_history, fa_employees, ap_invoices_all, fa_asset_invoices, po_vendors, q_assets, q_books

Report Categories

Enginatics

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 Register 06-Sep-2023 081714.xlsx
Blitz Report™ XML Import	FA_Asset_Register.xml
Full SQL on Enginatics	www.enginatics.com/reports/fa-asset-register/

Executive Summary

The FA Asset Register is a fundamental report for fixed asset management, providing a comprehensive listing of all assets in a book. It serves as the primary source of truth for asset details, including cost, depreciation, location, and invoice information.

Business Challenge

Asset Visibility: Difficulty in getting a complete picture of an asset’s financial and physical attributes in one place.
Reconciliation: Needing a detailed subledger report to reconcile with General Ledger balances.
Data Integrity: Verifying that all capitalized assets have the correct depreciation method and life assigned.

The Solution

This Blitz Report enhances the standard Asset Register by:

Comprehensive Data: Combining asset header, book, distribution, and invoice data into a single view.
Flexible Detail Levels: Allowing users to toggle details for depreciation, distributions, and invoices.
Excel Analysis: Enabling pivot tables to summarize cost by category, location, or cost center.

Technical Architecture

The report mimics the FAS600_XML standard report. It joins FA_ADDITIONS (header), FA_BOOKS (financials), FA_DISTRIBUTION_HISTORY (assignments), and FA_ASSET_INVOICES (source). It handles the complexity of showing current vs. historical data based on the selected period.

Parameters & Filtering

Book: The depreciation book (Required).
Asset Number Range: To run for specific assets.
Show Details: Flags to include/exclude Depreciation, Distribution, and Invoice details.

Performance & Optimization

Detail Flags: Turn off “Show Invoice Details” or “Show Distribution Details” if you only need high-level financial data to speed up execution.
Asset Range: Use for targeted analysis of specific assets rather than running the full book.

FAQ

Q: Why is the report output so wide?
- A: It includes detailed sections for distributions and invoices, which adds many columns. You can hide unused columns in Blitz Report.
Q: Does this show fully retired assets?
- A: It typically shows assets active during the requested period or fiscal year.

FA Asset Register | Oracle EBS SQL Report

Application: Assets Source: Asset Register Report (XML) Short Name: FAS600XML DB package: FAFAS600XMLPPKG