Fixed Assets - Asset Depreciation Real Time

Description

Real time information on depreciation value and balance of an asset for each asset book such as the cost center, ledger and sub-ledger account, asset depreciation account, asset book, asset category, and asset depreciation. Offers supporting financial information at the same granularity.

Business Questions

This subject area can answer the following business questions:

• What assets have a book value within a specified dollar value range?

• What is the total record cost and depreciated value of an asset during a specified time period?

• What is the depreciation expense amount for all the assets with a specified asset category that have been depreciated in a particular cost center?

• What are the year-to-date depreciation amounts for all assets in an asset book?

• What is the total depreciation since the beginning of the asset's life?

Job Roles

The following job roles secure access to this subject area:

• Asset Accountant

• Asset Accounting Manager

Duty Roles

The following duty roles secure access to this subject area:

• Fixed Depreciation Transaction Analysis Duty

Primary Navigation

Home > Fixed Assets > Asset Inquiry > Assets tab

Time Reporting

This subject area supports fixed assets depreciation value and balance history.

Time dimension is linked to Asset Depreciation Period Name.

Transactional Grain

This subject area returns data at the grain of asset depreciation distribution (FA_DEPRN_EXTRACT). To enhance the query performance, depreciation data has been denormalized and extracted into the extract table FA_DEPRN_EXTRACT. Customer needs to run the ESS job Extract Asset Reporting Data to populate this extract table before using OTBI reports.

Note that Fusion Financials data security may further restrict the data being returned in OTBI as OTBI uses the same data security as Oracle Fusion Financials.

Special Considerations

None.