FA Asset Book Details – 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

FA asset books with asset depreciation summary and financial transaction values. Using parameters ‘Show Calendar’, ‘Show Alternative Ledgers’, ‘Show Accounting Rules’, ‘Show Natural Accounts’ shows the setup details of book controls.

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, As of Period, Show Calendar, Show Alternative Ledgers, Show Accounting Rules, Show Natural Accounts, Show Asset Details, Show Depreciation Summary, Show Assignments, Show Fin Transactions, Show Source Invoices, Exclude Retired Assets, Organization

Oracle EBS Tables Used

fa_mc_book_controls, gl_ledgers, fnd_id_flex_structures_vl, fa_additions_tl, fa_asset_keywords_kfv, fa_additions_b, ap_suppliers, fa_deprn_periods, fa_books, fa_leases, fa_book_controls, fa_system_controls, fa_category_books, fa_deprn_summary, fa_calendar_types, fa_distribution_history, gl_code_combinations_kfv, per_all_people_f, fa_lookups, fa_transaction_headers, fa_trx_references, fa_calendar_periods, fa_invoice_details_v, fnd_id_flex_structures_tl, hr_all_organization_units_vl

Report Categories

Enginatics

FA Cost Adjustments, FA Asset Upload, FA Asset Register, FA Fixed Assets Book, FA Asset Retirements, GL Account Distribution Analysis, FA Asset Impairments, FA Additions By Source, FA Asset Summary (Germany)

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 Book Details 19-Jan-2018 003659.xlsx
Blitz Report™ XML Import FA_Asset_Book_Details.xml
SQL Source FA Asset Book Details.sql
Full Report on Enginatics www.enginatics.com/reports/fa-asset-book-details/

Case Study & Technical Analysis: FA Asset Book Details

Executive Summary

The FA Asset Book Details report is a fundamental tool for Fixed Asset Accountants and System Administrators. It provides a deep dive into the configuration and status of Asset Books within Oracle Assets. From verifying depreciation rules to reconciling financial transaction values, this report ensures that the asset register is aligned with corporate accounting policies and the General Ledger.

Business Challenge

Fixed Asset management involves complex calculations and strict regulatory compliance. Organizations often struggle with:

The Solution

This report solves these challenges by providing a transparent “Operational View” of the Asset Book controls and contents.

Technical Architecture (High Level)

The report queries the core Oracle Assets configuration and transaction tables.

Parameters & Filtering

Performance & Optimization

FAQ

Q: How can I verify if my Tax Book is set up to copy changes from the Corporate Book? A: Run the report for the Tax Book and check the “Mass Copy” flags in the output (often part of the detailed book controls).

Q: Why do I see different costs for the same asset in different books? A: This is normal. Run the report for both the Corporate and Tax books. The FA_BOOKS table stores cost and depreciation rules separately for each book, allowing for different valuations (e.g., GAAP vs. Tax).

Q: Can this report show me the GL accounts mapped to the book? A: Yes, if you enable “Show Natural Accounts” or look at the distribution details, you can see the account code combinations associated with the asset categories in this book.

© Enginatics GmbH