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 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:
Duty Roles
The following duty roles secure access to this subject area:
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.