Skip Headers

Oracle Financials for Europe User Guide
Release 12.1
Part Number E13421-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Oracle Assets

Regional and Country Reports

Fixed Assets Register Report

Use the Fixed Assets Register report to report your fixed asset ledger status to your tax authorities. The report helps you reconcile your Fixed Asset books with your General Ledger account balances and to review asset details such as depreciation method, prorate convention, tag number, and statistical information.

The Fixed Assets Register report is an RXi report, divided into two sections. For the first section, Asset Details, the default attribute set displays detailed information for active assets within a particular period range. Active assets are assets that are not fully retired during previous fiscal years. This detail section includes account information as well as descriptive information about each asset. Financial information, such as initial values, increases, decreases, and final values, about asset cost, revaluations, ordinary depreciation, bonus depreciation reserve, and net book value is also printed. Information about asset transactions during the relevant fiscal year follows and is printed in chronological order. Possible transactions include:

For the second section, Retirement, the default attribute set displays information about assets that were retired during the same period, including the retirement date, asset cost at the time of retirement, retired depreciation reserve amounts, and retired net book value.

You can copy the default attribute set and customize the layout to suit your reporting needs. Additional headings that you can add to your default attribute set are also available.

The report does not include expensed assets or CIP (construction in process) assets.

Choose the RXi: Fixed Assets Register Report in the Standard Request Submission windows to submit the Fixed Assets Register Report.

Report Parameters

Output Format

Select the format for the report output. You can select the default format or any that you may have built by creating a new attribute set.

Retirement Section Format

Enter the format that you want for the retirement section. You can choose the default format or any that you may have built by creating a new attribute set.

Book

Enter the depreciation book that you want to run the report for. All active assets in the book are reported on.

From Period

Enter the earliest accounting period that you want to report from.

To Period

Enter the latest accounting period that you want to report to. You can enter periods that the depreciation process was run for.

Major Category

Enter the major category segment value that you want to report on. If you leave this parameter blank, all major categories are reported on.

Minor Category

Enter the minor category segment value that you want to report on. You can enter a minor category even if you do not enter a major category. If you leave this parameter blank, all minor categories are reported on.

Column Headings

Asset Details Section

This table shows the column headings.

In this column... Oracle Assets prints...
Major Category The value and description of the major category segment for assets listed on the current page.
Minor Category The value and description of the minor category segment for assets listed on the current page.
Starting Depr Year The fiscal year that the assets listed on the current page were first depreciated.
Invoice Numbers The invoice numbers associated with the original purchase of the asset.
Original Cost The original cost of the asset, including any cost adjustments or additional invoices applied before the first depreciation process.
Supplier Names The supplier names associated with the original purchase of the asset.
Date Placed in Service The date placed in service. The Fixed Assets Register report does not print this column by default; you can choose to print this column through RXi.
Cost Account The asset cost account.
Depr Account The depreciation expense account.
Reserve Account The accumulated depreciation account.
Bonus Depr Account The bonus depreciation expense account.
Bonus Reserve Account The bonus accumulated depreciation account.
Initial Cost The cost of the asset at the beginning of the period that you selected in the From Period parameter.
Cost Increase The sum of any increases to the asset cost during the period range from any of these transactions:
  • Additions

  • Mass additions

  • Positive manual cost adjustments

  • Positive revaluations

  • Reinstatements

Cost Decrease The sum of any reductions to the asset cost during the period range from any of these transactions:
  • Credit memos

  • Negative manual cost adjustments

  • Negative revaluations

  • Retirements


The sum is printed as a positive number.
Final Cost The cost of the asset at the end of the period that you selected in the To Period parameter.
Initial Revaluation The total revaluation amount from the beginning of the asset life to the end of the previous period that you entered in the From Period parameter.
Revaluation Increase The sum of changes to the asset cost due to any positive revaluations during the period range.
Revaluation Decrease The sum of changes to the asset cost due to any negative revaluations during the period range. Retirements are not included.
Final Revaluation The total revaluation amount from the beginning of the asset life to the end of the period that you entered in the To Period parameter.
Initial Depr Reserve The life-to-date ordinary depreciation, excluding any bonus depreciation, at the beginning of the period that you entered in the From Period parameter.
Depr Reserve Increase The sum of increases to ordinary accumulated depreciation during the period range due to any of these transactions:
  • Ordinary depreciation expense

  • Reinstatements

  • Positive financial adjustments

  • Positive tax reserve adjustments in the tax book

Depr Reserve Decrease The sum of decreases to ordinary accumulated depreciation during the period range due to any of these transactions:
  • Retirements

  • Negative financial adjustments

  • Negative tax reserve adjustments in the tax book

Final Depr Reserve The life-to-date ordinary depreciation, excluding any bonus depreciation, at the end of the period that you entered in the To Period parameter.
Initial Bonus Reserve The life-to-date bonus depreciation at the beginning of the period that you entered in the From Period parameter.
Bonus Reserve Increase The sum of increases to bonus depreciation reserve during the period range due to any of these transactions:
  • Bonus depreciation expense

  • Reinstatements

  • Positive financial adjustments

Bonus Reserve Decrease The sum of decreases to bonus depreciation reserve during the period range due to any of these transactions:
  • Retirements

  • Negative financial adjustments

Final Bonus Reserve The life-to-date bonus depreciation at the end of the period that you entered in the To Period parameter.
Initial Net Book Value The initial net book value at the beginning of the period that you entered in the From Period parameter.
Net Book Value Increase The increase to net book value during the period range, calculated as:
Net Book Value Increase = Cost Increase + Depr Reserve Decrease + Bonus Reserve Decrease
Net Book Value Decrease The decrease to net book value during the period range, calculated as:
Net Book Value Decrease = Cost Decrease + Depr Reserve Increase + Bonus Reserve Increase
Final Net Book Value The final net book value at the end of the period that you entered in the To Period parameter, calculated as:
Final Net Book Value = Final Cost - Final Depr Reserve - Final Bonus Reserve
Transaction Date The transaction date depending on the type of asset transaction:
  • Addition - Date placed in service

  • Adjustment - Transaction date, effective the last day of the accounting period

  • Reinstatement - Reinstatement date

  • Retirement - Retirement date

  • Revaluation - Revaluation date

Transaction Number The transaction reference number for all four types of asset transactions.
Transaction Code The transaction code depending on the type of asset transaction:
  • Addition - Transaction code for additions

  • Adjustment - Transaction code for adjustments

  • Reinstatement - Transaction code for reinstatements

  • Retirement - Transaction code for partial or full retirements

  • Revaluation - Transaction code for revaluations

Transaction Amount The transaction amount depending on the type of asset transaction:
  • Addition - Transaction amount

  • Adjustment - Transaction amount

  • Reinstatement - Reinstatement amount

  • Retirement - Retired cost

  • Revaluation - Revaluation amount

Additional Column Headings

This table shows the column headings that are also available for use in your user-defined attribute set.

In this column... Oracle Assets prints...
Asset Key Flexfield The concatenated segments of the asset key flexfield value that is assigned to the asset
Depreciation Method The depreciation method code that is associated with this asset in the chosen book
Life in Months The useful life of the asset, expressed in month, in the chosen book
Life in Years The useful life of the asset, expressed in years, in the chosen book
Prorate Convention The prorate convention code associated with this asset in the chosen book

Retirement Section

This table shows the column headings.

In this column... Oracle Assets prints...
Major Category The value and description of the major category segment for assets listed on the current page.
Minor Category The value and description of the minor category segment for assets listed on the current page.
Retirement Date The retirement date.
Sales Invoice The sales invoice number associated with the retirement.
Sales Amount The proceeds of sale.
Parent Asset Number The parent asset number.
Asset Cost The cost of the asset when at the time of retirement. If the asset was partially retired, the proportional retired cost is displayed.
Depr Reserve The proportional amount of ordinary accumulated depreciation that was retired.
Bonus Reserve The proportional amount of bonus depreciation reserve that was retired.
Net Book Value The net book value that was retired.
Gain/Loss The amount of realized gain or loss, including any reductions for removal cost. The gain/loss does not always equal the proceeds of sale minus retired net book value because removal cost is not shown in this report.

Related Topics

Working with Attribute Sets, Oracle Financials RXi Reports Administration Tool User Guide

Using the RXi Reports Concurrent Program, Oracle Financials RXi Reports Administration Tool User Guide

Running Reports and Programs, Oracle Applications User Guide

Finnish Deferred Depreciation Expense Report

Use the Finnish Deferred Depreciation Expense report to analyze the differences between corporate and tax book depreciation. You can print information for assets for a selected period. At the end of each fiscal year, run the report on the capitalized assets.

In Finland, tax book depreciation is calculated at the category level. This affects the tax depreciation calculation of assets sold during the year because Oracle Assets generates loss/gain amounts based on individual assets, not on the whole category. Because calculation on individual assets is illegal in Finland, Oracle Assets sets up each category with a new sales asset. It creates new sales assets for the categories at the end of each financial year.

The value of this sales asset in the corporate book is zero. The value of the sales asset in the tax book depends on whether you copy the retirements from the corporate book to the tax book or not. If you copy retirements to the tax book, the value of the sales asset equals the total gain/loss retirement value in the tax book. If you do not copy retirements, the value of the sales asset equals the sum of all proceeds received from the sale of retirements in the category.

You can choose to report assets by detail asset category either individually (detail report), or in a summary format (summary report). Both the detail and summary reports contain separate pages for each asset category. Both reports contain information for category. The reports are ordered by cost account and category. The detail report contains the financial information of every individual asset in the category. Report totals are printed for category, cost account, and report levels.

Note that asset category selection is restricted to the detail category, and you can use different accounting calendars for the tax and corporate book.

Use the Standard Request Submission windows to submit the Finnish Deferred Depreciation Expense report.

Prerequisites

Before submitting the Finnish Deferred Depreciation Expense report, you must:

Report Parameters

Tax Book

Select any depreciation book with a type of Tax.

Period

Select the period that you want to report on for the tax book that you entered. Only closed periods appear in the list of values.

Report Type

Select Detail or Summary.

Category From

Enter the first asset category that you want to report on. Leave this parameter blank to specify all categories.

Category To

Enter the last asset category that you want to report on. Leave this parameter blank to specify all categories.

Asset Number From

Enter the first asset number that you want to report on. Leave this parameter blank to specify all assets.

Asset Number To

Enter the last asset number that you want to report on. Leave this parameter blank to specify all assets.

Report Headings

In this heading... Oracle Assets prints...
Tax Book The tax book that you selected
Corporate Book The corporate book associated with the tax book
Period Name The period that you selected
Cost Account The cost account related to the asset categories
Description The description of the cost account
Category The detail category that the assets are assigned to

Detail Column Headings

In this column... Oracle Assets prints...
Tax Initial NBV The initial net book value of the asset in the tax book at the start of the fiscal year.
Additions (Tax) The value of any additions or cost adjustments made to the asset in the tax book from the start of the fiscal year to the period that you selected.
Tax Retired NBV The net book value of any retirements, partial or full, made to the asset in the tax book from the start of the fiscal year to the period that you selected.
Depreciation - Corporate The amount of YTD depreciation in the corporate book for the asset from the start of the fiscal year to the period that you selected.
Depreciation - Deferred The amount of YTD deferred depreciation for the asset from the start of the fiscal year to the period that you selected. Deferred depreciation is calculated as the difference between the YTD tax book depreciation and the YTD corporate book depreciation.
Tax Closing NBV The value of the tax book NBV at the end of the period that you selected. It is calculated as follows: Tax Initial NBV + Tax Additions - Tax Retired NBV - Corporate YTD Depreciation - Deferred Depreciation.
Sales Proceeds The value of any sales proceeds as a result of a partial or full retirement made on the asset in the tax book from the start of the fiscal year to the period that you selected.

Detail Row Headings

In this row… Oracle Assets prints…
Category Sum The sum of the asset columns described above for each detail category.
Account Total The sum of the asset categories belonging to the cost account.
Report Total The sum of the asset account totals.

Summary Row Headings

In this row… Oracle Assets prints…
Asset Cost (From) The sum of the corporate initial cost values for all assets in the category at the start of the fiscal year.
Additions The sum of the corporate additions/adjustments for all assets in the category made from the start of the fiscal year to the period that you selected.
Retirements The sum of the corporate retirements for all assets in the category made from the start of the fiscal year to the period in the period name.
Asset Cost (To) The sum of the corporate end cost values for all assets in the category. This value is calculated as: Asset Cost (From) + Additions - Retirements.
Corporate Book - Depreciation Reserve (From) The sum of the corporate book depreciation reserve values for all assets in the category at the start of the fiscal year.
Corporate Book - YTD Depreciation The sum of the corporate book YTD depreciation values for all assets in the category.
Corporate Book - Retirements The sum of the corporate book reserve retired values for all assets in the category.
Corporate Book - Depreciation Reserve The sum of the corporate book depreciation reserve values at the end of the period.
Corporate Book - Net Book Value (Initial) The sum of the corporate book net book values for the assets in the category at the start of the fiscal year.
Corporate Book - Net Book Value (End) The sum of the corporate book net book values for the assets in the category at the end of the period in the period that you selected.
Tax and Corporate Book Difference - Deferred Depreciation Reserve (Initial) The difference between the sum of the corporate and tax depreciation reserve at the start of the fiscal year for all assets in the category.
Tax and Corporate Book Difference - Deferred Depreciation YTD The difference between the sum of the corporate and tax YTD depreciation values for all assets in the category.
Tax and Corporate Book Difference - Retirements The difference between the sum of the corporate and tax retirements for all assets in the category.
Tax and Corporate Book Difference - Deferred Depreciation Reserve (End) The difference between the sum of the corporate and tax depreciation reserve for all assets in the category at the end of the period that you selected.
Tax Book Net Book Value (Initial) The sum of the tax book initial NBV values for all assets in the category at the start of the fiscal year.
Tax Book Net Book Value (End) The sum of the tax book end NBV values for all assets in the category at the end of the period that you selected.

Related Topics

Running Reports and Programs, Oracle Applications User Guide

Hungarian Asset Movement Schedule: Gross Changes Report

Use the Hungarian Asset Movement Schedule: Gross Changes report to review a summary of changes to asset category costs due to additions, adjustments, revaluations, and reclassifications. The Hungarian Asset Movement Schedule: Gross Changes report prints the asset category cost account and totals for property type and company. Run the Hungarian Asset Movement Schedule: Gross Changes report as needed.

Use the Standard Request Submission windows to submit the Hungarian Asset Movement Schedule: Gross Changes report.

Prerequisites

Before running the Hungarian Asset Movement Schedule: Gross Changes report, you must:

Report Parameters

Book

Enter the depreciation book that you want to report on.

From Period

Enter the earliest period for the information that you want to include in the report. The periods displayed for selection in this period are in the same fiscal year as those in the To period. You can choose an open period.

To Period

Enter the latest period for the information that you want to include in the report. The periods displayed for selection in this period are in the same fiscal year as those in the From period. You can choose an open period.

Company

Enter the balancing segment value that you want to report on.

Report Headings

In this heading… Oracle Assets prints…
Book The depreciation book that the report is run for
Company The balancing segment that you selected
<Report Title> Hungarian Asset Movement Schedule: Gross Changes
Period The period range that you selected
<Ending Period> The ending period status, Open or Closed

Column Headings

In this column… Oracle Assets prints...
Asset Account The natural account value of the asset cost account assigned to the asset category for the asset book selected.
Category The asset category description for all asset categories included in the report.
Beginning Balance The current cost total at the beginning of the period range selected for each asset category. The sum of this column matches the Beginning Balance column of the Cost Summary report.
Additions The change to the asset category cost that results from asset additions made during the period range you requested. The sum of this column matches the Cost column in the Asset Additions report for the balancing segment value that you requested.
Adjustments The net change to the asset category cost that results from cost adjustments made during the period range you requested. The sum of this column matches the Net Change column of the Cost Adjustments report for the balancing segment value that you requested.
Retirements The net change to the asset category cost that results from asset retirements made during the period range you requested. The sum of this column matches the Cost Retired column in the Asset Retirements report for the balancing segment value that you requested.
Revaluation The net change to the asset category cost that results from asset revaluations made during the period range that you requested.
Reclasses The reclassification amounts.

Row Headings

In this row… Oracle Assets prints...
<Property Type Name> The Property Type name for each group of asset categories (Intangible Assets, Tangible Assets) assigned to it
<Property Type> Totals The sum of all amount columns listed for each asset category
Company Totals The sum of all amount columns for all assets assigned to the balancing segment value selected

Related Topics

Running Reports and Programs, Oracle Applications User Guide

Entering QuickCodes, Oracle Assets User Guide

Hungarian Accumulated Depreciation Movement Schedule Report

Use the Hungarian Accumulated Depreciation Movement Schedule report to see a summary of all of your asset depreciation transactions by property type and by asset category. Run the Hungarian Accumulated Depreciation Movement Schedule report as needed.

The Hungarian Accumulated Depreciation Movement Schedule report shows the summary of changes to asset category accumulated depreciation values due to additions, adjustments, revaluations, and reclassifications. The report prints the asset category reserve account and totals for property type and company.

Use the Standard Request Submission windows to submit the Hungarian Accumulated Depreciation Movement Schedule report.

Prerequisites

Before running the Hungarian Accumulated Depreciation Movement Schedule report, you must:

Report Parameters

Book

Enter the depreciation book that you want to report on.

From Period

Enter the earliest period for the information that you want to include in the report. The periods displayed for selection in this period are in the same fiscal year as those in the To period. You can choose an open period.

To Period

Enter the latest period for the information that you want to include in the report. The periods displayed for selection in this period are in the same fiscal year as those in the From period. You can choose an open period.

Company

Enter the balancing segment value that you want to report on.

Report Headings

In this heading… Oracle Assets prints…
Book The depreciation book that the report is run for
Operative Unit The balancing segment that you selected
<Report Title> Hungarian Accumulated Depreciation Movement Schedule
Period The period range that you selected

Column Headings

In this column… Oracle Assets prints...
Reserve Account The natural account value of the asset reserve account assigned to the asset category for the asset book that you selected.
Category The asset category description for all asset categories included in the report.
Beginning Balance The depreciation reserve account at the beginning of the period range that you selected for each asset category. The sum of this column matches the Beginning Balance column in the Reserve Summary report for the balancing segment value that you requested.
Additions The change to the asset category depreciation reserve account that results from asset additions and the unplanned depreciations made during the period range that you requested. The sum of this column matches the Additions column in the Reserve Summary report for the balancing segment value that you requested.
Depreciation The change to the depreciation reserve account that results from depreciation expense calculated during the period range that you requested. The sum of this column matches the Depreciation Expense column in the Reserve Summary report for the balancing segment value that you requested.
Adjustments The change to the asset category depreciation reserve account that results from tax reserve adjustments or revaluations performed during the period range that you requested. The sum of this column matches the Adjustments column in the Reserve Summary report for the balancing segment value that you requested.
Retirements The change to the asset category depreciation reserve account that results from asset retirements made during the period range that you requested. The sum of this column matches the Retirements column in the Reserve Summary report for the balancing segment value that you requested.
Reclasses The change to the asset category depreciation reserve account that results from asset reclassifications made during the period range that you requested. The sum in this column matches the Reclassifications column in the Reserve Summary report for the balancing segment value that you requested.
Ending Balance The total actual asset category depreciation reserve account balance at the end of the period range that you requested. The sum of this column matches the Ending Balance column in the Reserve Summary report for the balancing segment value that you requested.

Row Headings

In this row… Oracle Assets prints...
<Property Type Name> The property type name for each group of asset categories (Intangible Assets, Tangible Assets) assigned to it
<Property Type> Totals The sum of all amount columns listed for each asset category
Company Totals The sum of all amount columns for all assets assigned to the balancing segment value selected

Related Topics

Running Reports and Programs, Oracle Applications User Guide

Entering QuickCodes, Oracle Assets User Guide

Hungarian Depreciation Analysis Report

Use the Hungarian Depreciation Analysis report to see a summary analysis of all of your asset depreciation expense transactions by property type and by asset category for the period range that you requested. Run the Hungarian Depreciation Analysis report as needed.

The Hungarian Depreciation Analysis report shows the summary of depreciation expense for different depreciation methods for each asset category. The Hungarian Depreciation Analysis report also shows totals for property type and company.

Use the Standard Request Submission windows to submit the Hungarian Depreciation Analysis report.

Prerequisites

Before running the Hungarian Depreciation Analysis report, you must:

Report Parameters

Book

Enter the Depreciation Book that you want to report on.

From Period

Enter the earliest period for the information that you want to include in the report. The periods displayed for selection in this period are in the same fiscal year as those in the To period. You can choose an open period.

To Period

Enter the latest period for the information that you want to include in the report. The periods displayed for selection in this period are in the same fiscal year as those in the From period. You can choose an open period.

Company

Enter the balancing segment value that you want to report on.

Report Headings

In this heading… Oracle Assets prints…
Book The depreciation book that the report is run for
Company The balancing segment that you selected
<Report Title> Hungarian Accumulated Depreciation Movement Schedule
Period The period range that you selected
<Ending Period> The ending period status, Open or Closed

Column Headings

In this column… Oracle Assets prints...
Reserve Account The natural account value of the asset reserve account assigned to the asset category for the asset book that you selected.
Category The asset category description for all asset categories included in the report.
Life Based The total depreciation expense for the period range that you requested for all assets that have life based depreciation methods, less the amount shown in the Expensed column and the amount shown in the Incidental column which refer to this depreciation method.
Expensed The total depreciation expense for the period range that you requested for all assets that have been depreciated in full in the first period of depreciation calculation and have a life based depreciation method.
Diminishing The total depreciation expense for the period range requested for all assets that have a flat rate depreciation method, less the amount shown in the Incidental column which refers to this depreciation method.
Units of Production The total depreciation expense for the period range that you requested for all assets that have a units of production depreciation method, less the amount shown in the Incidental column which refers to this depreciation method.
Total Regular Depreciation The total depreciation expense for the life based, expensed, diminishing, and units of production columns. The sum of this column matches the amount in the Depreciation column of the Hungarian Accumulated Depreciation Movement Schedule report.
Incidental The total unplanned depreciation expense for the period range that you requested. The straight line, flat-rate, or unit of production depreciation method can be used for unplanned depreciation.
Total Depreciation The total of all depreciation expense for the period range requested.

Row Headings

In this row… Oracle Assets prints...
Property Type Name The property type name for each group of asset categories (Intangible Assets, Tangible Assets) assigned to it
Property Type Totals The sum of all amount columns listed for each asset category
Company Totals The sum of all amount columns for all assets assigned to the balancing segment value selected

Related Topics

Running Reports and Programs, Oracle Applications User Guide

Entering QuickCodes, Oracle Assets User Guide

Statutory Reports

Statutory Asset Ledger Report

Use the Statutory Asset Ledger report to see summary asset information. The report provides summarized asset cost, accumulated depreciation, and net book value information for each asset, and optionally reports on all parent accounts.

Use the Standard Request Submission windows to submit the Statutory Asset Ledger report.

Report Parameters

Official Run

Enter Yes to print the report on Official Statutory Report headed paper. Enter No to use normal report headings.

Book

Enter the Asset book that you want to use for this report.

Balancing Segment

Enter the balancing segment that you want to use for this report.

Period

Enter the period that you want to use for this report.

Parent Totals

Enter Yes to show parent account totals. Otherwise enter No.

Precision

If you entered Yes in the Parent Totals field, enter Class, Class and Sub-class, or Class, Sub-class, and Group to indicate the summary level to use for this report.

The Precision indicates the summary level that balances are reported on:

Precision Width

If you entered Yes in the Parent Totals field, enter the precision width that you want to report on the summary level you entered.

The precision width indicates the number of account value digits to include at each summary or precision level. The number of digits reported is a combination of the values that you enter in the Precision and Precision Width parameters, and operates as a multiplier from the lowest precision width of 1. For a precision width of 2, the number of digits reported for each precision is twice that of precision width of 1; for precision width of 3, the number of digits reported is three times that of precision width 1. The maximum precision width is 8, because the accounting flexfield column width is 25 characters.

This table shows the digits reported for each precision width.

Precision Width Class Sub-Class Group
1 1 2 3
2 2 4 6
3 3 6 9
8 8 16 24

Country

Enter your country code.

If your country uses global attributes for asset reporting, these two parameters contain a list of values for the country that you entered in the Country parameter. You enter global attributes for asset reporting in the global descriptive flexfield in the Asset Details window or the Quick Addition window.

1st Global Attribute

Enter the first global attribute that you want to include in the report.

2nd Global Attribute

Enter the second global attribute that you want to include in the report.

Report Headings

In this heading… Oracle Assets prints…
Book Depreciation book
Period Periods included in this report
Ledger Ledger associated with the depreciation book
Balancing Segment Balancing segment

Column Headings

In this column… Oracle Assets prints…
Asset Account Natural account segment of the asset cost account associated with the asset category and book
Current Cost Asset cost as of the end of the specified period
Accumulated Depreciation Accumulated depreciation as of the end of the specified period
Net Book Value Asset net book value as of the end of the specified period
<Global Attribute Name> First asset key segment parameter value
<Global Attribute Name> Second asset key segment parameter value

Related Topics

Running Reports and Programs, Oracle Applications User Guide

Statutory Asset Cost Detail Report

Use the Statutory Asset Cost Detail report to see period changes in fixed asset costs. The report provides additions, revaluations, retirements, reclassifications, cost adjustments, and ending balances on all fixed assets.

Use the Standard Request Submission windows to submit the Statutory Asset Cost Detail report.

Report Parameters

Report Type

Enter Statutory Asset Cost Detail Report to run the Statutory Asset Cost Detail report.

Official Run

Enter Yes to print the report on Official Statutory Report headed paper. Enter No to use normal report headings.

Book

Enter the Asset book that you want to use for this report.

Balancing Segment

Enter the balancing segment that you want to use for this report.

From Period

Enter the first period range that you want to include in the report.

To Period

Enter the last period range that you want to include in the report.

Parent Totals

Enter Yes to show parent account totals. Otherwise enter No.

Precision

If you entered Yes in the Parent Totals field, enter Class, Class and Sub-class, or Class, Sub-class, and Group to indicate the summary level to use for this report.

The Precision indicates the summary level that balances are reported on:

Precision Width

If you entered Yes in the Parent Totals field, enter the precision width to use to report on the summary level that you entered.

The precision width indicates the number of account value digits to include at each summary or precision level. The number of digits reported is a combination of the values that you enter in the Precision and Precision Width parameters, and operates as a multiplier from the lowest precision width of 1. For a precision width of 2, the number of digits reported for each precision is twice that of precision width of 1; for precision width of 3, the number of digits reported is three times that of precision width 1. The maximum precision width is 8, because the accounting flexfield column width is 25 characters.

This table shows the digits reported for each precision width.

Precision Width Class Sub-Class Group
1 1 2 3
2 2 4 6
3 3 6 9
8 8 16 24

Asset Information

Select Short to show one line per asset, or Long to show two lines per asset.

Note: The report only prints the column headings Supplier Name, Invoice Number, Location, and Retirement Reason if you select Long.

Report Headings

In this heading… Oracle Assets prints…
Book Depreciation book
Period Range Periods included in this report
Ledger Ledger associated with the depreciation book
Balancing Segment Balancing segment

Column Headings

Note: The Statutory Asset Cost Detail report only prints the column headings Supplier Name, Invoice Number, Location, and Retirement Reason if you entered Long in the Asset Info parameter.

In this column… Oracle Assets prints…
Asset Account Natural account segment of the asset cost account
Retired Retirement reason for the asset, if the asset was retired during the reported period
Supplier Name Supplier for the asset associated with the Payables invoice
Invoice Number Payables invoice numbers (if any) for the asset
Location Active locations for the asset
Cost Beginning Balance Asset cost at the start of the reported period
Additions Addition cost of the asset
Revaluations Changes in cost of the asset due to revaluations
Retirements Total change in cost of the asset due to any full retirements, partial retirements, or reinstatements
Reclass. Changes in cost of the asset due to reclassifications
Adjustments Changes in cost of the asset due to adjustments
Cost Ending Balance Asset cost at the end of the reported period

Related Topics

Statutory Asset Reserve Detail Report

Running Reports and Programs, Oracle Applications User Guide

Running Standard Reports and Listings, Oracle Assets User Guide

Statutory Asset Reserve Detail Report

Use the Statutory Asset Reserve Detail report to see period changes in fixed asset accumulated depreciation between two periods. The report provides depreciation expenses, revaluations, retirements, reclassifications, reserve adjustments, and ending balances on all fixed assets.

Use the Standard Request Submission windows to submit the Statutory Asset Reserve Detail report.

Report Parameters

Report Type

Enter Statutory Asset Reserve Detail Report to run the Statutory Asset Reserve Detail report.

Official Run

Enter Yes to print the report on Official Statutory Report headed paper. Enter No to use normal report headings.

Book

Enter the Asset book that you want to use for this report.

Balancing Segment

Enter the balancing segment that you want to use for this report.

From Period

Enter the first period range that you want to include in the report.

To Period

Enter the last period range that you want to include in the report.

Parent Totals

Enter Yes to show parent account totals. Otherwise enter No.

Precision

If you entered Yes in the Parent Totals field, enter Class, Class and Sub-class, or Class, Sub-class, and Group to indicate the summary level to use for this report.

The Precision indicates the summary level that balances are reported on:

Precision Width

If you entered Yes in the Parent Totals field, enter the precision width to use to report on the summary level that you entered.

The precision width indicates the number of account value digits to include at each summary or precision level. The number of digits reported is a combination of the values that you enter in the Precision and Precision Width parameters, and operates as a multiplier from the lowest precision width of 1. For a precision width of 2, the number of digits reported for each precision is twice that of precision width of 1; for precision width of 3, the number of digits reported is three times that of precision width 1. The maximum precision width is 8, because the accounting flexfield column width is 25 characters.

This table shows the digits reported for each precision width.

Precision Width Class Sub-Class Group
1 1 2 3
2 2 4 6
3 3 6 9
8 8 16 24

Asset Information

Enter Short to show one line per asset, or Long to show two lines per asset.

Note: The report only prints the column headings Supplier Name, Invoice Number, Location, and Retirement Reason if you select Long.

Report Headings

In this heading… Oracle Assets prints…
Book Depreciation book
Period Range Periods included in this report
Ledger Ledger associated with the depreciation book
Balancing Segment Balancing segment

Column Headings

Note: The Statutory Asset Reserve Detail report only prints the column headings Supplier Name, Invoice Number, Location, and Retirement Reason if you entered Long in the Asset Info parameter.

In this column… Oracle Assets prints…
Asset Account Natural account segment of the asset cost account
Reserve Account Natural account segment of the reserve account
Retired Retirement reason for the asset, if the asset was retired during the reported period
Supplier Name Supplier for the asset associated with the Payables invoice
Invoice Number Payables invoice numbers (if any) for the asset
Location Active locations for the asset
Cost Beginning Balance Original cost of the asset
Depr Rsv Beginning Balance Asset depreciation reserve at the start of the reported period
Depreciation Depreciation Expense of the asset
Revaluations Changes in depreciation reserve of the asset due to revaluations
Retirements Total change in depreciation reserve of the asset due to any full retirements, partial retirements, or reinstatements
Reclass. Changes in depreciation reserve of the asset due to reclassifications
Adjustments Changes in depreciation reserve of the asset due to adjustments
Depr Rsv Ending Balance Asset depreciation reserve at the end of the reported period

Related Topics

Running Reports and Programs, Oracle Applications User Guide

Running Standard Reports and Listings, Oracle Assets User Guide