Fixed Assets - Asset Transactions Real Time

Description

Real time information on the transactions associated with an asset such as additions, transfers, adjustment, reinstatement, retirement. Includes accounting details, asset book, asset category, type of asset, location, and cost center. Offers supporting financial information at the same granularity and source line level detail for source line driven transactions.

Business Questions

This subject area can answer the following business questions:

• What assets have been transferred from one location or cost center to another during a given period?

• What invoices have I received for a given asset during the current year?

• What is the financial history for a given asset?

• What are all the transactions performed on selected assets?

• What are the assets reinstated during a specified period?

• What assets are currently operational in a particular department and what is their current cost, net book value, and accumulated depreciation reserve?

• Which assets have a remaining life that is less than one year from today?

• What is the cost of removal of a retired asset?

• What vendor invoices were charged to a cost center for an asset?

• What assets have been retired this past month with sale proceeds above a specified dollar amount?

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 Asset Transaction Analysis Duty

Primary Navigation

Home > Fixed Assets > Asset Inquiry > Transactions tab

Time Reporting

This subject area supports fixed assets transactions history.

Time dimension is linked to Asset Transaction Period Name.

Transactional Grain

This subject area returns data at the grain of asset transaction distribution line (FA_TRX_EXTRACT). To enhance the query performance, asset transaction data has been denormalized and extracted into the extract table FA_TRX_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.