Skip to content

README.md

Latest commit

 

History

History
91 lines (67 loc) · 6.66 KB

README.md

File metadata and controls

91 lines (67 loc) · 6.66 KB
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/

FA Depreciation Reserve – Oracle EBS SQL Report

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

Overview

Depreciation Reserve Summary/Detail Report

Equivalent to Oracle Standard Reports: Reserve Summary Report Reserve Detail Report

DB package: XXEN_FA_FAS_XMLP

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_balances_report_q, fa_additions, gl_code_combinations

Report Categories

Enginatics, R12 only

Related Reports

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

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 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/

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

© 2026 Enginatics