Oracle Apps Fixed Assets Table

Below are some important tables frequently used in query's in Oracle Apps for Fixed Assets module.

 

FA_ADDITIONS_B           Descriptive information about assets 

 

FA_ADDITIONS_TL          Translated Descriptive information about assets

 

FA_ADJUSTMENTS           Adjustment information on assets user by 

                         General Ledger to create journal entry lines 

                         in the general ledger  

 

FA_ASSET_HISTORY         Historical information about asset  

                         reclassification and unit adjustments 

 

FA_ASSET_INVOICES        Accounts payable and purchasing information 

                         for each asset  

 

FA_BOOKS                  Financial information of each asset  

 

FA_BOOK_CONTROLS          Control information that affects all assets 

                          in a depreciation book  

 

FA_CALENDAR_PERIODS       Detailed calendar information  

 

FA_CATEGORIES_B           Default financial information for asset 

                          categories 

 

FA_CATEGORY_BOOKS         Default financial information for an asset 

                          category and depreciation book combination 

 

 

FA_DEPRN_DETAIL           Depreciation amounts charged to the 

                          depreciation expense account in each 

                          distribution line


FA_DEPRN_PERIODS          Information about each depreciation period

FA_DISTRIBUTION_ACCOUNTS  Table to store account ccids for all 

                          distributions for a book


FA_DISTRIBUTION_HISTORY   Employee, location, and Accounting Flexfield 

                          values assigned to each asset

FA_RETIREMENTS            Information about asset retirements and 

                          reinstatements

Create Mass Additions from Invoice Distributions in Payables

11i/R12 process to Add Asset through PO/Invoice to FA

1. Make sure that the Asset item that you want to procure is having the expense account  as the Asset
   Clearing account of the Asset category that you want to assign in Fixed Assets.

2. Raise a PO for this Asset item you want to procure, so that the PO Distribution account is the Asset
   Clearing item.

3. Receive the Asset item in the Expense Location.

4. Make new Invoice and match it with Inventory Receipt.

5. The Invoice Distributions will automatically be defaulted due to matching with receipt. "Track As Asset
    Flag" will be set to Yes in Invoice distribution

7. Validate the Invoice and Create Online Accounting for this Invoice.

8. Run the Mass Addition Creation request from Payables module. The Invoice distribution will be imported
    into the Mass Addition Tables in FA.

10. Prepare and Post the Mass Addition line to create the Asset.

Conditions for Invoice distribution Line to be picked up by Create Mass additions Program following
are the important points
1. Invoice Distribution account is a Asset Account.
2. The account is set up for an existing asset category as either the
    asset clearing account or the CIP clearing account
3. Track As Asset check box is checked.
4. Invoice line distribution is posted to GL.

Conditions for Expensed Invoice Line Distributions To Be Imported
The create mass additions process imports an expensed line only if:
1. Invoice line distribution is an Expense account
2. Track as Asset is checked
4. Invoice line distribution is posted to GL.
5. The general ledger


R12 Features:
1. Enhanced Asset Tracking:
   Asset information typically entered on a purchase order, such as manufacturer, serial number, and model
   number, can now flow seamlessly into Payables and Assets. R12 provides the ability to track attributes such as Manufacturer, Model, Serial Number, Warranty Number from Purchasing through Accounts Payable to Fixed Assets.This increases processing efficiency and eliminates manual updates in FA that may have been required in the past.

2. Addition of  Asset Book at Invoice Line level:
   The Create Mass Additions process can now be submitted to select only those invoice distributions with a   specific Asset Book, reducing the possibility of errors that need to be manually corrected. Addition   of this field to the Lines and Distributions model will enable controlled transfer of Asset Distributions per Asset Book over to Oracle Assets via the Create Mass Additions process.  In 11i, the Asset Book is defaulted from the parameter given to the Mass Additions process; the user has not control in terms of selecting appropriate distributions to transfer to the given Asset Book since the distributions don’t have Asset Book information.  With the addition of this field to the Lines and Distributions model, the Payables user will be able to select the appropriate Asset Book for a line, have that default to the distribution and in turn have the Create Mass Additions process transfer distributions having Asset Book matching the parameter for the run.

3. Addition of  Asset Category at Invoice Distribution level:
With the addition of this field to the Lines model, the Payable user will be able to populate the Asset Category via the Invoice Entry mechanisms.  One caveat of this solution is that the field will not be mandatory and thus, distributions may still be transferred with null Asset Category.  Furthermore, since Oracle Payable will not support validation of the Asset Category against the Asset Clearing Account, distributions may be transferred with mismatched Asset Category.

4. Invoice Lines:
   Oracle Payables incorporates Invoice Lines into the invoice model. Adding Invoice Lines is a key 
   architectural change, which enables Oracle Payables to better model the paper or electronic business
   document yet maintain key features that exist at the invoice distributions level.Furthermore, it facilitates
  the capture and transfer of additional, pertinent information to and from Oracle Projects and Oracle Assets.