FA Depreciation Reserve – 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
Depreciation Reserve Summary/Detail Report
Equivalent to Oracle Standard Reports: Reserve Summary Report Reserve Detail Report
DB package: XXEN_FA_FAS_XMLP
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
Set of Books, Book, From Period, To Period, Show Impairments
Oracle EBS Tables Used
msc_form_query, fa_system_controls, gl_ledgers, fnd_currencies, fa_additions, fa_asset_keywords_kfv, gl_code_combinations
Report Categories
Related Reports
FA CIP Cost, FA Asset Cost, FA Revaluation Reserve, FA Cost Adjustments, FA Tax Reserve Ledger, FA Asset Additions, FA Asset Summary (Germany), FA Fixed Assets Book, FA Asset Book Details
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 Depreciation Reserve 30-Aug-2021 073636.xlsx |
| Blitz Report™ XML Import | FA_Depreciation_Reserve.xml |
| SQL Source | FA Depreciation Reserve.sql |
| Full Report on Enginatics | www.enginatics.com/reports/fa-depreciation-reserve/ |
Executive Summary
The FA Depreciation Reserve report provides a snapshot of the accumulated depreciation for assets as of a specific period. It is a key report for reconciling the Accumulated Depreciation account in the General Ledger.
Business Challenge
- GL Reconciliation: Verifying that the subledger’s accumulated depreciation matches the GL balance.
- Net Book Value Analysis: Understanding the remaining life and value of the asset portfolio.
- Impairment Tracking: Seeing the impact of impairments on the reserve.
The Solution
This Blitz Report offers a robust view of the reserve account:
- Roll-Forward Logic: Shows the beginning balance, additions (depreciation expense), adjustments, and ending balance.
- Impairment Visibility: Optionally includes impairment amounts which reduce the Net Book Value.
- Drill-Down: Can be run at a summary level for reconciliation or detail level for asset analysis.
Technical Architecture
Equivalent to the standard Reserve Summary/Detail reports, it uses FA_BALANCES_REPORT_GT to calculate the movement of the reserve account. It aggregates depreciation expense, retirements, and adjustments to derive the ending reserve.
Parameters & Filtering
- Book: The depreciation book.
- Period: The “as-of” period for the report.
- Show Impairments: Toggle to display impairment columns.
Performance & Optimization
- Summary vs. Detail: Use the Summary version for high-level GL checks. Use Detail only when investigating discrepancies.
- Currency: Ensure the correct currency is selected for multi-currency books.
FAQ
- Q: How does this differ from the Account Analysis?
- A: This report focuses specifically on the Reserve (Accumulated Depreciation) account and its roll-forward, whereas Account Analysis covers all asset accounts.
- Q: Does it show YTD depreciation?
- A: Yes, it typically shows the depreciation expense for the period and the Year-To-Date accumulation.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© Enginatics GmbH