FA Journal Entry Reserve Ledger – 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
Imported Oracle standard journal entry reserve ledger report. The Asset Account column and the template ‘Pivot: Account Reconciliation Reserve Ledger’ cover the Account Reconciliation Reserve Ledger Report (FAS403), which shows the same reserve ledger grouped by asset account instead of depreciation expense account. Source: Journal Entry Reserve Ledger Report (XML) Short Name: FAS400_XML 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, Period
Oracle EBS Tables Used
fds, fa_system_controls, gl_ledgers, fa_reserve_ledger_gt, fa_additions, fa_asset_keywords_kfv, gl_code_combinations
Report Categories
Related Reports
FA Asset Book Details, FA CIP Cost, FA Tax Reserve Ledger, FA Asset Cost, FA Fixed Assets Book, FA Revaluation Reserve, FA Depreciation Reserve, FA Asset Upload, FA Asset Additions
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 Journal Entry Reserve Ledger 30-Aug-2021 053316.xlsx |
| Blitz Report™ XML Import | FA_Journal_Entry_Reserve_Ledger.xml |
| SQL Source | FA Journal Entry Reserve Ledger.sql |
| Full Report on Enginatics | www.enginatics.com/reports/fa-journal-entry-reserve-ledger/ |
Executive Summary
The FA Journal Entry Reserve Ledger is a specialized report used to reconcile depreciation expense and the depreciation reserve with the General Ledger. It lists the journal entries created by the depreciation run.
Business Challenge
- Journal Verification: Ensuring that the depreciation run created the correct journal entries.
- Account Balance Proof: Proving the balance of the Accumulated Depreciation account at the journal line level.
- Audit Compliance: Providing a detailed list of all system-generated depreciation journals.
The Solution
This Blitz Report replicates the standard FAS400_XML report, providing:
- Journal Details: Listing the specific accounts and amounts credited/debited during depreciation.
- Asset-Level Granularity: Showing which assets contributed to each journal line.
- Tying to GL: Serving as the bridge between the FA subledger and GL journal batches.
Technical Architecture
The report queries FA_RESERVE_LEDGER_GT, which is populated during the reporting process to show the breakdown of depreciation by account. It links back to FA_ADDITIONS for asset details.
Parameters & Filtering
- Book: The asset book.
- Period: The period for which depreciation was run.
Performance & Optimization
- Period Specific: This report is strictly period-based. It is designed to be run after the depreciation close for that period.
- Data Volume: Can be large if there are many assets and complex account distributions.
FAQ
- Q: Why doesn’t this match my GL?
- A: Check if the depreciation journals have been posted to GL. Also, check for manual journals in GL that wouldn’t be in this report.
- Q: Is this the same as the “Journal Entry Reserve Ledger” PDF?
- A: Yes, it is the Excel version of that standard Oracle report.
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