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?
-
Which assets have a remaining life that is less than one year from today?
-
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:
Duty Roles
The following duty roles secure access to this subject area:
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.