Fixed Assets Tables

FA_ACE_BOOKS Financial information for updating ACE book


FA_ADDITIONS_B Descriptive information about assets (base MLS table)

FA_ADDITIONS_TL Descriptive information about assets (translated MLS table) 

FA_ADD_WARRANTIES Warranty information

FA_ADJUSTMENTS Information used by the posting program to generate journal entry lines in general ledger

FA_AMORT_SCHEDULES Amortization schedules

FA_ARCHIVE_HISTORY Archive, purge, and restore request information

FA_ASSET_HISTORY Historical information about asset reclassifications and unit adjustments

FA_ASSET_INVOICES Accounts payable and purchasing information for each asset

FA_ASSET_KEYWORDS Asset key flexfield segment combinations

FA_BALANCES_REPORT Temporary storage area for the balance reports

FA_BALANCES_REP_ITF Interface table for Report eXchange reports

FA_BONUS_RATES Bonus rate information used by the Depreciation program

FA_BOOKS Financial information of each asset

FA_BOOK_CONTROLS Control information that affects all assets in a depreciation book

FA_BUDGET_DISTRIBUTION Capital budget information entered manually or uploaded from the FA_BUDGET_INTERFACE table

FA_BUDGET_INTERFACE Capital budget information to be uploaded into Oracle Assets

FA_CALENDAR_PERIODS Detailed calendar information

FA_CALENDAR_TYPES General calendar information

FA_CAPITAL_BUDGET Budget assets used to run depreciation projections and reports

FA_CATEGORIES_B Default financial information for asset categories (base MLS table)

FA_CATEGORIES_TL Default financial information for asset categories (base MLS table)Default financial information for asset categories (translated MLS table)

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

FA_CATEGORY_BOOK_DEFAULTS Default depreciation rules for asset category and book combination for a particular date placed in service range

FA_CEILINGS Seeded and user–defined ceilings for depreciation expense, investment tax credit cost basis, and depreciation cost basis

FA_CEILING_TYPES General ceiling information

FA_CONVENTIONS Detailed prorate convention information

FA_CONVENTION_TYPES Names and descriptions for prorate conventions

FA_DEFERRED_DEPRN Deferred depreciation calculated for each distribution line

FA_DELETED_MASS_ADDITIONS Invoice information of mass additions you deleted from the

FA_MASS_ADDITIONS table using the Delete Mass Additions form

FA_DEPRN_DETAIL Depreciation amounts charged to the depreciation expense account in each distribution line

FA_DEPRN_PERIODS Information about each depreciation period

FA_DEPRN_SUMMARY Depreciation information at the asset level

FA_DISTRIBUTION_ACCOUNTS Table to store account ccids for all distributions for a book

FA_DISTRIBUTION_DEFAULTS Distribution set information

FA_DISTRIBUTION_HISTORY Employee, location, and Accounting Flexfield values assigned to each asset

FA_DISTRIBUTION_SETS Header information for distribution sets

FA_FISCAL_YEAR Range of dates for all fiscal years

FA_FLAT_RATES Annual depreciation rates for all flat–rate methods

FA_FORMULAS Depreciation rates for formula–based methods

FA_INS_LINES Stores policy line information

FA_INS_MST_POLS Master policy table for insurance

FA_INS_POLICIES Contains asset insurance policy information

FA_INS_VALUES Stores insurance indexation details

FA_INVENTORY Physical Inventory entry

FA_INVOICE_TRANSACTIONS Information about transactions made to invoice lines within Oracle Assets

FA_INV_INTERFACE Open Interface table to Physical Inventory

FA_ITC_RATES Investment tax credit (ITC) rate information

FA_ITC_RECAPTURE_RATES Percentage of Investment Tax Credit (ITC) to recapture for early retirements

FA_LEASES Lease information for leased assets

FA_LEASE_PAYMENTS Payment schedule detail information

FA_LEASE_SCHEDULES Payment schedule information

FA_LOCATIONS Location flexfield segment value combinations

FA_LOOKUPS_B Seeded and user–defined values for QuickCodes (base MLS table)

FA_LOOKUPS_TL Seeded and user–defined values for QuickCodes (translated MLS table)

FA_LOOKUP_TYPES_B Information about QuickCodes (base MLS table)

FA_LOOKUP_TYPES_TL Information about QuickCodes (translated MLS table)

FA_MAINT_EVENTS Stores scheduled events

FA_MAINT_REP_ITF Interface table for Report eXchange reports

FA_MAINT_SCHEDULE_DTL Stores detail information for scheduling

FA_MAINT_SCHEDULE_HDR Stores information about maintenance scheduling requests

FA_MASSADD_DISTRIBUTIONS Distribution information for each mass addition line

FA_MASS_ADDITIONS Information about assets that you want to automatically add to Oracle Assets from another system

FA_MASS_CHANGES Mass change request information

FA_MASS_RECLASS Mass reclass request information

FA_MASS_RECLASS_ITF Interface table for Report eXchange reports

FA_MASS_RETIREMENTS contains information about your mass retirement and mass reinstatement processes.

FA_MASS_RET_EXCEPTS Information about assets that could not be retired as part of a mass retirement transaction

FA_MASS_REVALUATIONS Mass revaluation request status information

FA_MASS_REVALUATION_RULES Mass revaluation request rule information

FA_MASS_TAX_ADJUSTMENTS Mass depreciation adjustment request information

FA_MASS_TRANSFERS Mass transfer request information

FA_MC_ADJUSTMENTS Stores information to create adjustment journal entries in the reporting currency

FA_MC_ASSET_INVOICES Accounts payable and purchasing information for each asset, in the reporting currency

FA_MC_BOOKS Financial information for each asset in the reporting currency

FA_MC_BOOKS_RATES Exchange rate inormation

FA_MC_BOOK_CONTROLS Control information that affects all assets in a reporting depreciation book

FA_MC_CONVERSION_HISTORY Table to store the conversion history of primary to reporting books

FA_MC_CONVERSION_RATES Table to store the exchange rate information to convert assets from primary to reporting book

FA_MC_DEFERRED_DEPRN Deferred depreciation calculated for each distribution line in the reporting currency

FA_MC_DEPRN_DETAIL Depreciation amounts in the reporting currency, charged to the depreciation expense account in each distribution line

FA_MC_DEPRN_PERIODS Information about each depreciation period

FA_MC_DEPRN_SUMMARY Depreciation information at the asset level

FA_MC_MASS_RATES Exchange rate information for mass additions process

FA_MC_RETIREMENTS Currency and financial information about retirements in each reporting book

FA_METHODS Depreciation method information

FA_PERIODIC_PRODUCTION Production information for units of production assets entered manually or uploaded from

FA_PRODUCTION_INTERFACE

FA_PERIOD_MAPS Static information about period mapping; used by the Budget–To–Actual Report

FA_PRICE_INDEXES General price index information

FA_PRICE_INDEX_VALUES Price index values of each price index 

FA_PRODUCTION_INTERFACE Production information to be uploaded into Oracle Assets

FA_PROJ_INTERIM Stores depreciation projections

FA_RATES Annual depreciation rates for life–based depreciation methods

FA_RESERVE_LEDGER Temporary storage area for the reserve ledger reports

FA_RETIREMENTS Information about asset retirements and reinstatements 

FA_RX_ATTRSETS_B Stores attribute set information for RX reports (base MLS table)

FA_RX_ATTRSETS_TL Stores Attribute Set information for RX reports (translated MLS table)

FA_RX_DYNAMIC_COLUMNS Stores information about dynamic columns for RX reports

FA_RX_LOV

FA_RX_MULTIFORMAT_REPS Stores information about Multiple format reports for use with RXi

FA_RX_REPORTS Stores Report eXchange report definitions

FA_RX_REP_COLUMNS_B Stores attribute definitions for Report eXchange report attributes (base MLS table)

FA_RX_REP_COLUMNS_TL Stores attribute definitions for Report eXchange report attributes (translated MLS table)

FA_RX_REP_PARAMETERS Stores parameter definitions for Report eXchange reports

FA_RX_SECURITY Stores security assignments for Report eXchange Attribute sets

FA_RX_SUMMARY_TL Stores summary definitions for Report eXchange report attributes (base MLS table) 

FA_SHORT_TAX_RESERVES Stores accumulated depreciation amounts for assets added in short tax years in their tax books

FA_SYSTEM_CONTROLS System–wide controls that affect all assets

FA_TRANSACTION_HEADERS Information about all transactions performed within Oracle Assets

FA_TRANSFER_DETAILS Information that defines the historic relationship between active FA_BOOKS and FA_DISTRIBUTION_HISTORY rows

FA_WARRANTIES Warranty information

FA_WHATIF_ITF Interface table for What–If Depreciation Analysis Report