| layout | default |
|---|---|
| title | FA Depreciation Reserve | Oracle EBS SQL Report |
| description | Depreciation Reserve Summary/Detail Report Equivalent to Oracle Standard Reports: Reserve Summary Report Reserve Detail Report DB package: XXENFAFASXMLP |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, R12 only, Depreciation, Reserve, msc_form_query, fa_system_controls, gl_ledgers |
| permalink | /FA%20Depreciation%20Reserve/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Depreciation Reserve Summary/Detail Report
Equivalent to Oracle Standard Reports: Reserve Summary Report Reserve Detail Report
DB package: XXEN_FA_FAS_XMLP
Set of Books, Book, From Period, To Period, Show Impairments
msc_form_query, fa_system_controls, gl_ledgers, fnd_currencies, fa_balances_report_q, fa_additions, gl_code_combinations
MSC Horizontal Plan, FA Asset Cost, CAC Shipping Network (Inter-Org) Accounts Setup, CAC Shipping Networks Missing Interco OU Relationships, CAC Inventory Lot and Locator OPM Value (Period-End), CAC Interface Error Summary, CAC ICP PII Inventory and Intransit Value (Period-End), CAC Inventory and Intransit Value (Period-End), CAC Inventory Pending Cost Adjustment - No Currencies
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.
| Resource | Link |
|---|---|
| Excel Example Output | FA Depreciation Reserve 30-Aug-2021 073636.xlsx |
| Blitz Report™ XML Import | FA_Depreciation_Reserve.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fa-depreciation-reserve/ |
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.
- 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.
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.
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.
- Book: The depreciation book.
- Period: The "as-of" period for the report.
- Show Impairments: Toggle to display impairment columns.
- 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.
- 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.
- 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
© 2026 Enginatics