Skip to content

FA Revaluation Reserve

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

FA Revaluation Reserve

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
DESCRIPTION.md
DESCRIPTION.md
 
 
FA Revaluation Reserve.sql
FA Revaluation Reserve.sql
 
 
README.md
README.md
 
 

README.md

layout default
title FA Revaluation Reserve | Oracle EBS SQL Report
description Revaluation Reserve Summary/Detail Report Equivalent to Oracle Standard Reports: Revaluation Reserve Summary Report Revaluation Reserve Detail Report DB…
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, R12 only, Revaluation, Reserve, fa_system_controls, gl_ledgers, fnd_currencies
permalink /FA%20Revaluation%20Reserve/

FA Revaluation Reserve – Oracle EBS SQL Report

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

Overview

Revaluation Reserve Summary/Detail Report

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

DB package: XXEN_FA_FAS_XMLP

Report Parameters

Book, Set of Books Currency, From Period, To Period

Oracle EBS Tables Used

fa_system_controls, gl_ledgers, fnd_currencies, fa_balances_report_gt, fa_additions, gl_code_combinations

Report Categories

Enginatics, R12 only

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 Revaluation Reserve 30-Aug-2021 080055.xlsx
Blitz Report™ XML Import FA_Revaluation_Reserve.xml
Full SQL on Enginatics www.enginatics.com/reports/fa-revaluation-reserve/

Executive Summary

The FA Revaluation Reserve report tracks the revaluation reserve account, which holds the unrealized gains or losses from asset revaluations. This is critical for companies that use the revaluation model for fixed assets (common in IFRS and public sector).

Business Challenge

  • Revaluation Tracking: Monitoring the surplus created when an asset is revalued upwards.
  • Equity Reporting: The revaluation reserve is often part of Shareholder's Equity; accuracy is paramount.
  • Amortization: Tracking the amortization of the revaluation reserve over the asset's life.

The Solution

This Blitz Report provides a clear view of the revaluation reserve activity:

  • Movement Analysis: Shows the beginning balance, revaluation impact, amortization, and ending balance.
  • Asset Detail: Links the reserve balance to specific assets.
  • Compliance: Supports reporting requirements for jurisdictions allowing asset revaluation.

Technical Architecture

Equivalent to the standard Revaluation Reserve reports, it uses FA_BALANCES_REPORT_GT to calculate the buckets for the revaluation reserve. It tracks the REVAL_RESERVE column in the FA books.

Parameters & Filtering

  • Book: The asset book (must be a book where revaluation is enabled).
  • Period: The reporting period.

Performance & Optimization

  • Revaluation Only: This report is only relevant for books where revaluation has occurred. If you don't revalue assets, this report will be empty.
  • Summary Mode: Use summary mode for high-level equity reporting.

FAQ

  • Q: What triggers a change in this reserve?
    • A: Running the "Mass Revaluation" program or manually revaluing an asset.
  • Q: Can the reserve be negative?
    • A: Typically, a revaluation reserve represents a gain (credit balance). A loss usually goes to the P&L unless it reverses a previous gain.

Useful Links

© 2026 Enginatics