Oracle Assets Predefined Reports

Oracle 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 Balances 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 Register Report	Lists the cost-related details, current activity, and retirements for every asset within the selected asset category. Lists all transactions that impact asset cost during the chosen period.
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 Assets.

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

Click the Schedule New Process button.
Search on the Process Name.
Enter the appropriate parameters.
Enter the appropriate process options and schedule.
Click Submit.