FA Revaluation 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
Revaluation Reserve Summary/Detail Report
Equivalent to Oracle Standard Reports: Revaluation Reserve Summary Report Revaluation 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
Book, Set of Books Currency, From Period, To Period
Oracle EBS Tables Used
msc_form_query, fa_system_controls, gl_ledgers, fnd_currencies, fa_additions, gl_code_combinations
Report Categories
Related Reports
FA CIP Cost, FA Asset Cost, FA Depreciation Reserve, FA Tax Reserve Ledger, FA Cost Adjustments, FA Asset Summary (Germany), FA Asset Additions, 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 Revaluation Reserve 30-Aug-2021 080055.xlsx |
| Blitz Report™ XML Import | FA_Revaluation_Reserve.xml |
| SQL Source | FA Revaluation Reserve.sql |
| Full Report 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
- 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