15Oracle Fusion Assets Reports

This chapter contains the following:

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions.

The Assets reports run from the Scheduled Processes work area found on the Navigator.

The following tables list the predefined reports by type.

Transaction Reports

Display Name Description

Asset Additions Report

  • Lists all the assets added or capitalized during the specified periods.

  • Sorted by and groups totals for each balancing segment, asset type, asset account, cost center, and reserve account.

Additions by Source Report

  • Lists all the assets added or capitalized during the specified periods.

  • Shows the details of associated invoice lines.

  • Sorts and totals by source, balancing segment, asset type, asset account, cost center and asset number.

Asset Retirements Report

  • Lists all the asset retirements performed during the specified periods.

  • Sorted by and groups totals for each balancing segment, asset type, asset account, and cost center.

Asset Transaction History Report

  • Lists all transactions performed on selected assets.

  • Sorted by asset number.

Asset Transfers Report

  • Lists all asset transfers performed during the specified period.

  • Sorted by asset number.

CIP Capitalization Report

  • Lists all the CIP assets capitalized during the specified periods.

  • Sorted by and groups totals for each balancing segment, CIP cost account, cost center, and asset cost account.

Cost Adjustment Report

  • Lists all the asset cost adjustments made during the specified periods.

  • Sorted by and groups totals for each balancing segment, asset type, asset cost account, and cost center.

Cost Adjustments by Source Report

  • Lists all the asset cost adjustments made during the specified periods.

  • Shows the details of associated invoice lines.

  • Sorts and totals by source, balancing segment, asset type, asset account, cost center, and asset number.

Asset Category Change Report

  • Lists all the assets for which the asset category is changed during the specified period.

  • Sorted by and groups totals for each balancing segment, asset account, and asset number.

Asset Impairment Report

  • Lists the impact of impairment transactions.

  • Displays cost, new net book value, net selling price, value in use, and impairment loss amount for all the impaired assets in the given book and depreciation period.

  • Sorted by asset number.

Asset Additions by Responsibility Report

  • Lists assets added or capitalized during the specified periods.

  • Displays the owner and location for each unit.

  • Sorts and totals by balancing segment, asset type, asset account, cost center, and reserve account.

Mass Additions Reports

Display Name Description

Create Mass Additions Report

  • Lists all invoice and discount lines processed by the last run of the Create Mass Additions process.

  • Sorted by and groups totals for each foreign currency, balancing segment, asset clearing account, and cost center.

  • Generated every time the Create Mass Additions process is run.

Delete Mass Additions Report

Lists all the mass addition lines in the Delete queue that are ready to be processed by the Delete Mass Additions process.

Post Mass Additions Report

  • Lists all the asset additions and cost adjustments processed by the Post Mass Additions process.

  • Sorted by transaction type.

  • Generated every time the Post Mass Additions process is run.

Reconciliation Reports

Display Name Description

Cost Clearing Reconciliation Report

  • Lists all asset additions and cost adjustments performed during the specified period for which accounting entries are created for cost clearing accounts.

  • Sorted by and groups totals for each transaction type, balancing segment, and clearing account.

Cost Detail Report

  • Lists asset level asset cost account balances for the specified periods.

  • Sorted by and groups totals for each balancing segment, asset cost account, and cost center.

Cost Summary Report

  • Lists asset cost account summary balances for the specified periods.

  • Sorted by and groups totals for each balancing segment and asset cost account.

Journal Entry Reserve Ledger

  • Lists asset depreciation amounts for the specified period.

  • Sorted by and groups totals for each balancing segment, expense account, reserve account, and cost center.

CIP Detail Report

  • Lists asset level CIP cost account balances for the specified periods.

  • Sorted by and groups totals for each balancing segment, CIP cost account, and cost center.

CIP Summary Report

  • Lists CIP cost account summary balances for the specified periods.

  • Sorted by and groups totals for each balancing segment and CIP cost account.

Reserve Detail Report

  • Lists asset level asset reserve account balances for the specified periods.

  • Sorted by and groups totals for each balancing segment, reserve account, and cost center.

Reserve Summary Report

  • Lists reserve account summary balances for the specified periods.

  • Sorted by and groups totals for each balancing segment and reserve account.

Revaluation Reserve Detail Report

  • Lists asset revaluation reserve account balances for a specified period for an asset level.

  • Sorted by and groups totals for each balancing segment, asset cost account, and cost center.

Revaluation Reserve Summary Report

  • Lists asset level revaluation reserve account balances for the specified periods.

  • Sorted by and groups totals for each balancing segment, reserve account, and cost center.

Asset Register Report

  • Lists initial costs, current reserve, year-to-date amounts, depreciation rules, and retirements for a range of assets for the specified corporate book and for each associated tax book.

  • Sorts the data by asset number.

Asset Leases Expense Report

  • Lists asset lease interest and expense amounts for the specified period.

  • Sorted by and groups totals for each balancing segment, expense account, and cost center.

Asset Leases Liability Report

  • Lists asset lease liability for the specified period.

  • Sorts by and groups totals for each balancing segment, liability account, and cost center.

Asset Cost and Reserve Report

  • Lists the asset cost and depreciation reserve balances at the asset or cost center level.

  • Sorts and totals by category, asset type, asset cost account, and cost center.

  • You can run the report only for closed periods.

Group Reports

Display Name Description

Group Asset Detail Report

  • Lists the group and its member asset balances for the specified fiscal year and is used to comply with Indian income tax requirements.

  • Sorted by and groups totals for each fiscal year and asset category.

Group Asset Listing

  • Lists the group asset balances for the specified fiscal year and is used to comply with Canadian capital cost allowance requirements.

  • Sorted by and groups totals for each fiscal year and asset category.

Group Asset Summary Report

  • Lists the group asset balances for the specified fiscal year and is used to comply with Indian income tax requirements.

  • Sorted by and prints totals for each fiscal year and asset category.

Reports for the United States

Display Name Description

Form 4562 - Depreciation and Amortization Report

  • Lists asset depreciation amounts for the specified fiscal year.

  • Used for US tax reporting. Sorted by balancing segment, fiscal year added, depreciation method, asset category, and asset number.

  • Lists totals for each category, method, fiscal year added, and balancing segment.

Form 4626 - AMT Summary Report

  • Lists the difference in year-to-date depreciation between any tax book and an alternative minimum tax book through the period you select in detail.

  • Sorted by balancing segment, depreciation method, asset account, category, and asset number.

  • Lists totals for each category, asset account, method, and balancing segment.

Form 4626 - AMT Detail Report

  • Lists the difference in year-to-date depreciation between any tax book and an alternative minimum tax (AMT) book through the period you select in detail.

  • Sorted by balancing segment, depreciation method, asset account, category, and asset number.

  • Lists totals for each category, asset account, method, and balancing segment.

Form 4797 - Gain From Disposition of 1245 Property Report

  • Lists gain or loss amounts from sales of 1245 property held longer than the capital gain threshold.

  • Used for US tax reporting.

  • Shows only assets that were sold.

  • Sorts by balancing segment into gains and losses by asset account and by asset number.

  • Lists totals for gains or losses, and for each distinct asset account and balancing segment.

Form 4797 - Gain From Disposition of 1250 Property Report

  • Lists gain or loss amounts from sales of 1250 property held longer than the capital gain threshold.

  • Sorted by balancing segment into gains and losses, property class, asset account, and asset number.

  • Lists totals for gains or losses, and for each asset account, property class, and balancing segment.

Form 4797 - Sales or Exchanges of Property Report

  • Lists amounts held longer than the capital gain threshold.

  • Sorted by balancing segment into gains and losses, property class, asset account, and asset number.

  • Lists totals for gains or losses, and for each asset account, property class, and balancing segment.

Reports for Japan

Display Name Description

Japanese Addition or All Asset Detail by Asset Type Report 132 Characters

Lists depreciable assets for Japan in detail by asset type in a 132 character-wide format.

Japanese Addition or All Asset Detail by Asset Type Report 180 Characters

Lists depreciable assets for Japan in detail by asset type in a 180 character-wide format.

Japanese Corporate Tax Reports Schedule 16 (1) Report

Lists the summary of depreciable assets for Japan in accordance with Corporate Tax Reports Schedule 16 for Japan.

Japanese Corporate Tax Reports Schedule 16 (2) Report

Lists the summary of depreciable assets for Japan in accordance with Corporate Tax Reports Schedule 16 for Japan.

Japanese Corporate Tax Reports Schedule 16 (4) Report

Lists the summary of depreciable assets for Japan in accordance with Corporate Tax Reports Schedule 16 for Japan.

Japanese Corporate Tax Reports Schedule 16 (6) Report

Lists the summary of depreciable assets for Japan in accordance with Corporate Tax Reports Schedule 16 for Japan.

Japanese Corporate Tax Reports Schedule 16 (8) Report

Lists the summary of depreciable assets for Japan in accordance with Corporate Tax Reports Schedule 16 for Japan.

Japanese Depreciable Assets Tax Summary Report

Lists a summary of depreciable assets for Japan by location as of January 1 for the selected fiscal year.

Japanese Detail by Asset Type (Decrease Assets) Report

Lists depreciable assets for Japan in detail by the asset type Decrease Assets, between January 2 of the prior year and January 1 of the selected fiscal year.

Other Reports

Display Name Description

Property Tax Report

  • Lists the assets at a particular location as of the specified cutoff date.

  • Used for property tax forms.

  • Sorted by and groups totals for each balancing segment, location, asset account, and year acquired.

What-If Depreciation Analysis Report

  • Lists depreciation projections for the selected assets based on the specified depreciation parameters.

  • Generated when you submit what-if depreciation analysis for existing assets.

Hypothetical Depreciation Analysis Report

  • Lists depreciation projections for hypothetical assets based on the specified depreciation parameters.

  • Generated when you submit what-if depreciation analysis for hypothetical assets.

Assets by Cash Generating Unit Report

  • Lists all assets by cash generating unit.

  • Extracts the details of all the asset impairment transactions such as asset number, cash generating unit, cost, net book value, accumulated impairment reserve, and year-to-date impairments from Oracle Fusion Assets.

To run Assets reports, perform the following steps in the Scheduled Processes work area in the Navigator menu.

  1. Click the Schedule New Process button.

  2. Search on the Process Name.

  3. Enter the appropriate parameters.

  4. Enter the appropriate process options and schedule.

  5. Click Submit.

Assets Transaction Reports

This topic includes details about the Assets transaction reports.

Overview

The Assets transaction reports list transactions performed during the life of the asset, such as additions, adjustments, transfers, and retirements.

Assets transaction reports include:

Report Name Description

Asset Additions Report

Lists all of the assets added or capitalized during the specified periods. The report is sorted by and groups totals for each balancing segment, asset type, asset account, cost center, and reserve account.

Additions by Source Report

Lists all the assets added or capitalized during the specified periods. The report shows the details of associated invoice lines. The report sorts and totals by source, balancing segment, asset type, asset account, cost center, and asset number

Asset Retirements Report

Lists all of the asset retirements performed during the specified periods. The report is sorted by and groups totals for each balancing segment, asset type, asset account, and cost center.

Asset Transaction History Report

Lists all transactions performed on selected assets. The report is sorted by asset number.

Asset Transfers Report

Lists all asset transfers performed during the specified period. The report is sorted by asset number.

CIP Capitalization Report

Lists all of the construction-in-process (CIP) assets capitalized during the specified periods. The report is sorted by and groups totals for each balancing segment, CIP cost account, cost center, and asset cost account.

Cost Adjustment Report

Lists all of the asset cost adjustments made during the specified periods. The report is sorted by and groups totals for each balancing segment, asset type, asset cost account, and cost center.

Cost Adjustments by Source Report

Lists all the asset cost adjustments made during the specified periods. The report shows the details of associated invoice lines. The report sorts and totals by source, balancing segment, asset type, asset account, cost center, and asset number.

Asset Category Change Report

Lists all of the assets for which the asset category is changed during the specified period. The report is sorted by and groups totals for each balancing segment, asset account, and asset number.

Asset Impairment Report

Lists the impact of impairment transactions. Displays the cost, new net book value, net selling price, value in use, and impairment loss amount for all of the impaired assets in the given book and depreciation period. The report is sorted by the asset number. The report shows totals for the current net book value, net selling price, values in use, impairment loss, and new net book value.

Asset Additions by Responsibility Report

Lists assets that were added or capitalized during the specified periods. The report displays the owner and location for each unit. The report sorts and totals by balancing segment, asset type, asset account, cost center, and reserve account.

The following table describes selected report parameters:

Name Description

Book

Use this parameter to specify the book to be included for reports.

Currency

Use this parameter to specify the currency to be included for reports.

From Period

Use this parameter to specify the starting period for a range of the reports.

To Period

Use this parameter to specify the ending period for a range of the reports.

Frequently Asked Questions

The following table lists frequently asked questions about the Assets transaction reports:

FAQ Answer

How do I find these reports?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

When do I use these reports?

Use these reports to:

  • Ensure that your asset transactions are being accurately posted.

  • Keep track of your assets, and to reconcile Oracle Fusion Assets to your general ledger.

How do I change the default report format?

To change from Oracle Business Intelligence Publisher (BI Publisher), edit the fixed asset catalog and choose the output format from the layout table in the view list.

Assets Mass Additions Reports

This topic includes details about the Assets mass additions reports.

Overview

The Assets mass additions reports help to track mass additions transactions from the time you bring them into Oracle Fusion Assets from a source system such as Oracle Fusion Payables or Oracle Fusion Projects to the time you post them to Assets.

Mass additions reports include:

Report Name Description

Create Mass Additions Report

Lists all invoice and discount lines processed by the Create Mass Additions process. The report is sorted by and groups totals for each foreign currency, balancing segment, asset clearing account, and cost center.

This report is usually run from Payables.

Delete Mass Additions Report

Lists all the mass addition lines in the Delete queue that are ready to be processed by the Delete Mass Additions process.

Post Mass Additions Report

Lists all the asset additions and cost adjustments processed by the Post Mass Additions process. The report is sorted by transaction type.

The following table describes selected report parameters:

Name Description

Request Number

The request number of the Create Mass Additions process.

Book

Use this parameter to specify the book to be used for reporting.

Frequently Asked Questions

The following table lists frequently asked questions about the Assets mass additions reports:

FAQ Answer

How do I find these reports?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

When do I use these reports?

Use these reports to keep track of all invoice and discount lines interfaced from Payables to Assets.

What happens after I run the Create Mass Additions process?

The Payables invoice and discount addition lines appear with the asset category you specified for the item.

How many times can you run the Create Mass Additions process?

You can run the Create Mass Additions process as many times as you like. Each time it sends potential asset invoice line distributions and any associated discount lines to Assets. Payables ensures that it does not bring over the same line twice.

How do I change the default report format?

To change from Oracle Business Intelligence Publisher (BI Publisher), edit the fixed asset catalog and choose the output format from the layout table in the view list.

Assets Reconciliation Reports

This topic includes details about the Assets reconciliation reports.

Overview

The Assets Reconciliation reports are designed to reconcile journal entries to your general ledger accounts.

Assets reconciliation reports include:

Report Name Description

Cost Clearing Reconciliation Report

Lists all asset additions and cost adjustments performed during the specified period for which accounting entries are created for cost clearing accounts. The report is sorted by and groups totals for each transaction type, balancing segment, and clearing account.

Cost Detail Report

Lists asset-level asset cost account balances for the specified periods. The report is sorted by and groups totals for each balancing segment, asset cost account, and cost center.

Cost Summary Report

Lists asset cost account summary balances for the specified periods. The report is sorted by and groups totals for each balancing segment and asset cost account.

Journal Entry Reserve Ledger

Lists asset depreciation amounts for the specified period. The report is sorted by and groups totals for each balancing segment, expense account, reserve account, and cost center.

CIP Detail Report

Lists asset-level construction-in-process (CIP) cost account balances for the specified periods. The report is sorted by and groups totals for each balancing segment, CIP cost account, and cost center.

CIP Summary Report

Lists CIP cost account summary balances for the specified periods. The report is sorted by and groups totals for each balancing segment and CIP cost account.

Reserve Detail Report

Lists asset level asset reserve account balances for the specified periods. The report is sorted by and groups totals for each balancing segment, reserve account, and cost center.

Reserve Summary Report

Lists reserve account summary balances for the specified periods. The report is sorted by and groups totals for each balancing segment and reserve account.

Revaluation Reserve Detail Report

Lists asset revaluation reserve account balances for a specified period for an asset level. The report is sorted by and groups totals for each balancing segment, asset cost account, and cost center.

Revaluation Reserve Summary Report

Lists asset level revaluation reserve account balances for the specified periods. The report is sorted by and groups totals for each balancing segment, reserve account, and cost center.

Asset Register Report

Lists initial costs, current reserve, year-to-date amounts, depreciation rules, and retirements for a range of assets for the specified corporate book and for each associated tax book. The report sorts the data by asset number.

Asset Leases Expense Report

Lists asset lease interest and expense amounts for the specified period. The report sorts by and groups totals for each balancing segment, expense account, and cost center.

Asset Leases Liability Report

Lists asset lease liability for the specified period. The report sorts by and groups totals for each balancing segment, liability account, and cost center.

Asset Cost and Reserve Report

The Asset Cost and Reserve Report lists the asset cost and depreciation reserve balances at the asset or cost center level. The report sorts and totals by category, asset type, asset cost account, and cost center. You can run the report only for closed periods.

The following table describes selected report parameters:

Name Description

Book

Use this parameter to specify the book to be included for reports.

Currency

Use this parameter to specify the currency to be included for reports.

From Asset Number and To Asset Number

Use these parameters to enter the asset number range for which you want to run the report.

Period

Use this parameter to specify the period to be included for reports.

Frequently Asked Questions

The following table lists frequently asked questions about the Asset reconciliation reports:

FAQ Answer

How do I find these reports?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

When do I use these reports?

Use these reports to:

  • Review your asset transactions to make sure they're being accurately posted.

  • Keep track of your assets, and to reconcile Oracle Fusion Assets to your general ledger.

How do I reconcile journal entries to Oracle Fusion General Ledger accounts?

Use the Unposted Journals Report in Oracle General Ledger to match General Ledger batch totals with the asset batch totals found in the Subledger Accounting Account Analysis report.

How do I change the default report format?

To change from Oracle Business Intelligence Publisher (BI Publisher), edit the fixed asset catalog and choose the output format from the layout table in the view list.

Assets Group Reports

This topic includes details about the Assets group reports.

Overview

The Assets group reports are designed to assist with the regulatory reporting requirements when you use group depreciation.

Assets group reports include:

Report Name Description

Group Asset Detail Report

Lists the group and its member asset balances for the specified fiscal year and is used to comply with Indian income tax requirements. The report is sorted by and groups totals for each fiscal year and asset category.

Group Asset Listing

Lists the group asset balances for the specified fiscal year and is used to comply with Canadian capital cost allowance requirements. The report is sorted by and groups totals for each fiscal year and asset category.

Group Asset Summary Report

Lists the group asset balances for the specified fiscal year and is used to comply with Indian income tax requirements. The report is sorted by and prints totals for each fiscal year and asset category.

The following table describes selected report parameters:

Name Description

Book

Use this parameter to specify the asset book to be included for reports.

Currency

Use this parameter to specify the currency to be included for reports.

From Fiscal Year

Use this parameter to specify the starting fiscal year for the reports.

To Fiscal Year

Use this parameter to specify the ending fiscal year for the reports.

From Asset Number and To Asset Number

Use these parameters to specify the asset number range you want to use for the report.

Frequently Asked Questions

The following table lists frequently asked questions about the Assets Group reports.

FAQ Answer

How do I find these reports?

Schedule and run these reports from the Scheduled Processes work area on the Navigator menu.

When do I use these reports?

Use these reports if you use group depreciation as per regulatory reporting requirements of Canada and India.

What are the group reports I can print?

  • Canadian 50% Rule

    Use this report to comply with the Canadian capital cost allowance (CCA) Schedule 8 guidelines.

  • Group Summary: Summary for Half Year Rule

    Use this report to review group asset amounts. It is designed to meet reporting on the Indian 50% rule and the Indian Income Tax Authorities regulatory requirement of summary depreciation reporting.

  • Group Detail: Detail for Half Year Rule

    Use this report to review group and member asset detail amounts. The report is based on the Indian 50% rule and is intended for management use.

How do I change the default report format?

To change from Oracle Business Intelligence Publisher (BI Publisher), edit the fixed asset catalog and choose the output format from the layout table in the view list.

Reports for the United States

This topic includes details about the reports for the United States.

Overview

These reports are designed to review the depreciation taken for the specified fiscal year. The reports also show calculated gain or loss amounts for sales of 1245 or 1250 property held longer than the capital gain threshold.

Reports for the United States include:

Report Name Description

Form 4562 - Depreciation and Amortization Report

Lists asset depreciation amounts for the specified fiscal year. This report is sorted by balancing segment, fiscal year added, depreciation method, asset category, and asset number. It shows totals for each category, depreciation method, fiscal year added, and balancing segment.

Form 4626 - AMT Detail Report

Lists the difference in year-to-date depreciation between any tax book and an alternative minimum tax (AMT) book through the period you select in detail. The report is sorted by balancing segment, depreciation method, asset account, category, and asset number. The report totals for each category, asset account, method, and balancing segment.

Form 4626 - AMT Summary Report

Lists the difference in year-to-date depreciation between any tax book and an alternative minimum tax book through the period you select in detail. The report is sorted by balancing segment, depreciation method, asset account, category, and asset number. The report lists totals for each category, asset account, method, and balancing segment.

Form 4797 - Gain From Disposition of 1245 Property Report

Lists gain or loss amounts from sales of 1245 property held longer than the capital gain threshold you entered for the book on the Create Book page. This report only shows assets that were sold, so assets without proceeds of sale do not appear. The report is sorted by balancing segment into gains and losses, by asset account, and by asset number. The report shows totals for gains or losses, and for each asset account and balancing segment.

Form 4797 - Gain From Disposition of 1250 Property Report

Lists gain or loss amounts from sales of 1250 property held longer than the capital gain threshold. The report is sorted by balancing segment into gains and losses, property class, asset account, and asset number. The report lists totals for gains or losses, and for each asset account, property class, and balancing segment.

Form 4797 - Sales or Exchanges of Property Report

Lists amounts held longer than the capital gain threshold. The report is sorted by balancing segment into gains and losses, property class, asset account, and asset number. The report lists totals for gains or losses, and for each asset account, property class, and balancing segment.

The following table describes selected report parameters:

Name Description

Book

Use this parameter to specify the book to be included for the reports.

Currency

Use this parameter to specify the currency to be included for the reports.

Fiscal Year

Use this parameter to specify the fiscal year for the reports.

From Period

Use this parameter to specify the starting period for a range of the reports.

To Period

Use this parameter to specify the ending period for a range of the reports.

Frequently Asked Questions

The following table lists frequently asked questions about the reports for the United States:

FAQ Answer

How do I find these reports?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

When do I use these reports?

Use these reports as per the regulatory reporting requirements of the United States tax law.

What information does the Gain From Disposition of 1245/1250 Property Reports print?

These reports calculate gain or loss amounts for sales of 1245 or 1250 property held longer than the capital gain threshold you entered for the book on the Create Book page. Personal property is section 1245 or 1250 business property under United States tax law.

To use the 1245 or 1250 report, complete Part III of the United States federal tax form 4797 - Sales of Business Property and enter a capital gain threshold of one year. If you need different capital gains thresholds for different dates placed in service, such as the six month threshold for assets placed in service before January 1, 1988 in the United States, set up your asset category for the different date placed in service ranges with different thresholds.

The reports only show assets that were sold, so assets without proceeds of sale do not appear. For items that were lost or stolen, run the Form 4684 - Casualties and Thefts Report.

How do I change the default report format?

To change from Oracle Business Intelligence Publisher (BI Publisher), edit the fixed asset catalog and choose the output format from the layout table in the view list.

This topic includes details about the what-if analysis reports, property tax reports, and cash generating unit reports.

Overview

The other Assets reports include:

Report Name Description

Property Tax Report

Lists the assets at a particular location as of the specified cutoff date. This information is used for property tax forms. The report is sorted by and groups totals for each balancing segment, location, asset account, and year acquired.

What-If Depreciation Analysis Report

Lists depreciation projections for the selected assets based on the specified depreciation parameters.

Hypothetical Depreciation Analysis Report

Lists depreciation projections for hypothetical assets based on the specified depreciation parameters.

Assets by Cash Generating Unit Report

Lists all assets by cash generating unit. The report extracts the details of all of the asset impairment transactions, such as asset number, cash generating unit, cost, net book value, accumulated impairment reserve, and year-to-date impairments from Oracle Fusion Assets.

Japanese Addition or All Asset Detail by Asset Type Report 132 Characters

Lists depreciable assets for Japan in detail by asset type in a 132 character-wide format.

Japanese Addition or All Asset Detail by Asset Type Report 180 Characters

Lists depreciable assets for Japan in detail by asset type in a 180 character-wide format.

Japanese Corporate Tax Reports Schedule 16 (1) Report

Lists the summary of depreciable assets for Japan in accordance with Corporate Tax Reports Schedule 16 for Japan.

Japanese Corporate Tax Reports Schedule 16 (2) Report

Lists the summary of depreciable assets for Japan in accordance with Corporate Tax Reports Schedule 16 for Japan.

Japanese Corporate Tax Reports Schedule 16 (4) Report

Lists the summary of depreciable assets for Japan in accordance with Corporate Tax Reports Schedule 16 for Japan.

Japanese Corporate Tax Reports Schedule 16 (6) Report

Lists the summary of depreciable assets for Japan in accordance with Corporate Tax Reports Schedule 16 for Japan.

Japanese Corporate Tax Reports Schedule 16 (8) Report

Lists the summary of depreciable assets for Japan in accordance with Corporate Tax Reports Schedule 16 for Japan.

Japanese Depreciable Assets Tax Summary Report

Lists a summary of depreciable assets for Japan by location as of January 1 for the selected fiscal year.

The following table describes selected report parameters:

Name Description

Book

Use this parameter to specify the book to be included for reports.

Currency

Use this parameter to specify the currency to be included for reports.

From Asset Number and To Asset Number

Use these parameters to enter the asset number range for which you want to run the report.

Frequently Asked Questions

The following table lists frequently asked questions about the other reports.

FAQ Answer

How do I find these reports?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

When do I use these reports?

Use these reports to:

  • Review and analyze depreciation projections.

  • Review data based on depreciation parameters for hypothetical assets.

  • Review information for property tax forms.

  • Review and analyze depreciation projection for your current depreciation parameters.

  • Review and analyze the details of your asset impairment transactions.

What are the parameters required for the Hypothetical Depreciation Analysis Report?

You must enter a category, date in service, and cost when you submit this report.

Can I optionally enter an accumulated depreciation amount for the Hypothetical Depreciation Analysis Report?

Yes.

How do I submit the Hypothetical Depreciation Analysis Report?

You must submit this report using the What-If Analysis window.

How do I change the default report format?

To change from Oracle Business Intelligence Publisher (BI Publisher), edit the fixed asset catalog and choose the output format from the layout table in the view list.

Asset Register Report

This topic includes details about the Asset Register Report.

Overview

Use the Asset Register Report to provide cost-related details, current activity, and retirements for every asset within the selected asset category. The report lists all transactions that impact asset cost during the selected period.

The following figure is an example of the report.

This figure shows an example of the Asset Register report.

Key Insights

The Asset Register Report generates two layouts:

  • Asset Register: Displays detailed information about active assets within a particular period range. Active assets are assets that aren't fully retired during previous fiscal years.

    Asset Register includes:

    • Account details and description of each asset.

    • Financial data, such as initial values, increases, decreases, and final values. It includes asset cost information, revaluation, depreciation, depreciation reserve, and net book value.

    • Transaction information about asset transactions during the relevant fiscal year, ordered by the transaction number.

  • Asset Register - Retirements: Displays the assets that are retired during a given period. It includes retirement date, asset cost at the time of retirement, retired depreciation reserve amounts, and retired net book value. This is an optional layout.

The report doesn't include expensed assets or construction in process (CIP) assets.

Report Parameters

The following table lists selected parameters of the report:

Parameter Description

Major Category

Enter the major category segment value on which you want to report. Leave this parameter blank to include all major categories.

Minor Category

Enter a minor category only if you enter a major category. Leave this parameter blank to include all minor categories.

Asset Cost Account

Enter the assigned asset account. Select this parameter to list all the asset categories that are associated with a particular cost account segment.

Legal Entity

Specify the legal entity to print the statutory heading on the report.

Frequently Asked Questions

The following table lists frequently asked questions about the Asset Register Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Assets Manager

  • Tax Manager

  • Tax Accountant

When do I use this report?

Use the Asset Register Report to:

  • Report fixed asset ledger status to your tax authorities.

  • Reconcile your fixed asset books with your ledger accounts balances.

  • Review asset details, such as depreciation method, prorate convention, tag number, and statistical information.

  • Review asset transactions, like additions and retirements, during the relevant fiscal year as of the reporting period.

What type of reports are these?

Oracle Business Intelligence Publisher