Fixed Asset tables in oracle fusion

Fixed Asset tables in oracle fusion

We will be discussing about the fixed asset tables in oracle fusion. Fixed asset tables help to store the different part of Assets information’s in oracle fusion. These fixed asset tables are very useful if we are writing the sql queries or developing the fixed asset reports through Oracle Fusion BIP tool. There are many fixed asset tables available in oracle fusion but some of the tables are quite important which do store the most relevant fixed asset information’s in oracle fusion. Here below I will be share some of these important fixed asset tables in oracle fusion.

12 Most Important Fixed assets tables in oracle fusion

1.       FA_ADDITIONS_B

2.       FA_ADJUSTMENTS

3.       FA_ASSET_HISTORY

4.       FA_ASSET_INVOICES

5.       FA_BOOKS

6.       FA_CALENDAR_PERIODS

7.       FA_CATEGORY_BOOKS

8.       FA_DEPRN_DETAIL

9.       FA_DEPRN_SUMMARY

10.   FA_INVOICE_TRANSACTIONS

11.   FA_MASS_ADDITIONS

12.   FA_MC_RETIREMENTS

Detail Explanation of fixed asset tables in oracle fusion

FA_ADDITIONS_B :- In this table we will get the asset descriptive information’s in oracle fusion.

FA_ADJUSTMENTS :- In this table , we do get the Asset Adjustment information’s if happened for the asset in oracle fusion.This information used by the posting program to generate journal entry lines in general ledger

FA_ASSET_HISTORY :- In this Table , We will get the old Asset Information’s before adjustment like Historical information about asset reclassification and unit adjustments

FA_ASSET_INVOICES :- This table to find out the AP Invoice and PO against which the asset got created in system. Accounts payable and purchasing information for each asset

FA_BOOKS :- This table help to find out the  Financial information of each asset

FA_CALENDAR_PERIODS:- This table help to find out the Detailed calendar information

FA_CATEGORY_BOOKS: -  Default financial information for an asset category and depreciation book combination

FA_DEPRN_DETAIL:- We will get the Asset depreciation information like Depreciation amounts charged to the depreciation expense account in each distribution line.

FA_DEPRN_SUMMARY :- Depreciation information at the asset level

Important SQL Query Using Fixed Asset tables in oracle fusion

SELECT fa.asset_number,

       fai.fixed_assets_cost,

       fai.invoice_transaction_id_in,

       fai.invoice_line_number,

       fai.invoice_id,

       aia.invoice_id,

       fai.invoice_number,

       fai.ap_distribution_line_number,

       aila.line_number,

       aida.invoice_distribution_id

  FROM        ap_invoices_all              aia,

       ap_invoice_lines_all         aila,

       ap_invoice_distributions_all aida,

fa_additions                 fa,

       fa_asset_invoices            fai

WHERE fai.invoice_id = aia.invoice_id

   AND aia.invoice_id = aila.invoice_id

   AND aia.invoice_id = aida.invoice_id

   AND aila.line_number = aida.invoice_line_number

   AND fai.invoice_line_number = aila.line_number

   AND fai.invoice_distribution_id = aida.invoice_distribution_id

   AND fai.asset_id = fa.asset_id

   AND fa.asset_number = :P_ASSET_NO