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.

FA Revaluation Reserve | Oracle EBS SQL Report

Revaluation Reserve Summary/Detail Report Equivalent to Oracle Standard Reports: Revaluation Reserve Summary Report Revaluation Reserve Detail Report DB…