1. Tables and Views for Financials
  2. FA_BOOKS

FA_BOOKS

FA_BOOKS contains the information needed for calculating depreciation. When you initially add an asset, Oracle Fusion Assets inserts one row into the table and that becomes the active row for the asset. Whenever you change the asset's depreciation information, or if you retire or reinstate it, Oracle Fusion Assets inserts another row into the table, which then becomes the new active row, and marks the previous row as obsolete. At any point in time, there is only one active row in the table for an asset in any given depreciation book. Generally, Oracle Fusion Assets uses the active row, but if you run a report for a prior accounting period, Oracle Fusion Assets selects the row that was active during that period. When you retire an asset, Oracle Fusion Assets inserts a new row to reduce the COST by the amount retired. When you reinstate an asset, Oracle Fusion Assets inserts a new row to increase the COST by the COST_RETIRED in the corresponding row in FA_RETIREMENTS.

Details

  • Schema: FUSION

  • Object owner: FA

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

FA_BOOKS_PK

TRANSACTION_HEADER_ID_IN

Columns

Name Datatype Length Precision Not-null Comments
ASSET_ID NUMBER 18 Yes Identifier of the asset number.
DATE_PLACED_IN_SERVICE DATE Yes Date on which the asset was placed in service.
DATE_EFFECTIVE DATE Yes Date when the row became effective.
DEPRN_START_DATE DATE Yes Date the asset started to depreciate.
RATE_ADJUSTMENT_FACTOR NUMBER Yes Internal factor used to adjust depreciation rates to depreciate the net book value over the remaining life.
ADJUSTED_COST NUMBER Yes Depreciable basis of the asset, calculated as recoverable cost for cost basis depreciation methods, and recoverable cost less the accumulated depreciation for net book value basis methods.
COST NUMBER Yes Total recorded cost of the asset.
ORIGINAL_COST NUMBER Yes Original cost of the asset at the time of its addition.
SALVAGE_VALUE NUMBER Yes Salvage value amount for the asset.
PRORATE_DATE DATE Yes Date used to calculate the annual depreciation for assets.
CAPITALIZE_FLAG VARCHAR2 3 Yes Option indicating whether the asset is a capitalized or construction-in-process asset.
DEPRECIATE_FLAG VARCHAR2 3 Yes Option indicating whether the asset is depreciating or not.
DATE_INEFFECTIVE DATE Date when the row became inactive.
TRANSACTION_HEADER_ID_IN NUMBER 18 Yes Identifier of the transaction that created the row.
TRANSACTION_HEADER_ID_OUT NUMBER 18 Identifier of the transaction that terminated the row.
RETIREMENT_ID NUMBER 18 Identifier of the asset retirement transaction.
RECOVERABLE_COST NUMBER Yes Cost minus salvage value, or depreciation ceiling, whichever is lower.
ADJUSTED_CAPACITY NUMBER Remaining production capacity used to depreciate assets that use units of production method.
FULLY_RSVD_REVALS_COUNTER NUMBER 5 Number of times the asset has been revalued as fully reserved.
PERIOD_COUNTER_CAPITALIZED NUMBER 18 Identifier of the depreciation period in which asset is capitalized.
PERIOD_COUNTER_FULLY_RESERVED NUMBER 18 Identifier of the depreciation period in which the asset was fully reserved.
PERIOD_COUNTER_FULLY_RETIRED NUMBER 18 Identifier of the depreciation period in which the asset was fully retired.
PERIOD_COUNTER_FULLY_XFRD NUMBER 18 Period identifier in which the asset was fully transferred to another book.
PRODUCTION_CAPACITY NUMBER Production capacity for assets that use units of production method.
REVAL_AMORTIZATION_BASIS NUMBER Revaluation reserve used in calculating amortization of revaluation reserve. This changes only when the asset is revalued or an amortized adjustment is performed.
REVAL_CEILING NUMBER Upper limit for revaluing asset cost.
UNIT_OF_MEASURE VARCHAR2 25 Unit of measure used for assets depreciation under units of production method.
UNREVALUED_COST NUMBER Yes Cost without regard to any revaluations.
ANNUAL_DEPRN_ROUNDING_FLAG VARCHAR2 5 Option indicating whether Oracle Fusion Assets should subtract year-to-date depreciation from the annual depreciation amount to get the depreciation amount for the last period of the fiscal year.
PERCENT_SALVAGE_VALUE NUMBER Salvage value percentage for the asset.
ALLOWED_DEPRN_LIMIT NUMBER Depreciation limit percentage for the asset.
ALLOWED_DEPRN_LIMIT_AMOUNT NUMBER Depreciation limit amount for the asset.
PERIOD_COUNTER_LIFE_COMPLETE NUMBER 18 Identifier of the asset book period in which the life of the asset was completed.
ADJUSTED_RECOVERABLE_COST NUMBER Adjusted recoverable cost with special depreciation limits taken into account.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
EOFY_ADJ_COST NUMBER Adjusted cost at the end of the previous fiscal year.
SHORT_FISCAL_YEAR_FLAG VARCHAR2 3 Option indicating whether the asset is added in short tax year.
REMAINING_LIFE1 NUMBER 4 Remaining life of the asset calculated as on the conversion date, prorate date or fiscal year start date.
REMAINING_LIFE2 NUMBER 4 Remaining life of the asset calculated as on the fiscal year start date.
CONVERSION_DATE DATE Date when short tax year asset was added to the acquiring company.
ORIGINAL_DEPRN_START_DATE DATE Date short tax year asset begin depreciating in the books of the acquired company.
OLD_ADJUSTED_COST NUMBER Cost before adjustment transaction for the asset depreciation under formula net book value based depreciation method.
FORMULA_FACTOR NUMBER Factor used to adjust the depreciation rate for formula-NBV method assets.
EOFY_FORMULA_FACTOR NUMBER Formula factor at the end of the previous fiscal year.
GROUP_ASSET_ID NUMBER 18 Identification number of the group asset.
SALVAGE_TYPE VARCHAR2 30 Yes Salvage type assigned to the asset. It can be either amount, percentage, or sum of member assets.
DEPRN_LIMIT_TYPE VARCHAR2 30 Yes Depreciation limit type assigned to the asset. It can be either amount, percentage, sum of member assets, or none.
REDUCTION_RATE NUMBER Depreciation reduction percentage for the group and its member assets.
REDUCE_ADDITION_FLAG VARCHAR2 1 Option indicating whether depreciation reduction to be considered for addition transaction.
REDUCE_ADJUSTMENT_FLAG VARCHAR2 1 Option indicating whether depreciation reduction to be considered for adjustment transaction.
REDUCE_RETIREMENT_FLAG VARCHAR2 1 Option indicating whether depreciation reduction is to be considered for retirement transaction.
RECOGNIZE_GAIN_LOSS VARCHAR2 30 Option indicating whether gain or loss to be recognized for member asset retirement.
RECAPTURE_RESERVE_FLAG VARCHAR2 1 Option indicating whether reserve for the group asset can exceed its recoverable cost.
LIMIT_PROCEEDS_FLAG VARCHAR2 1 Option indicating whether the member asset proceed of sale to be limited to its recoverable cost.
TERMINAL_GAIN_LOSS VARCHAR2 30 Option indicating how terminal gain or loss to be recognized for member asset retirement.
TRACKING_METHOD VARCHAR2 30 Option indicating the group asset tracking method that is used to calculate group and its member asset depreciation.
EXCLUDE_FULLY_RSV_FLAG VARCHAR2 1 Option indicating whether fully reserved assets depreciable basis should be excluded from the depreciable basis of the group assets.
EXCESS_ALLOCATION_OPTION VARCHAR2 30 Option indicating whether excess depreciation of the group asset is to be allocated to its member assets or reduced from the group asset depreciation.
DEPRECIATION_OPTION VARCHAR2 30 Option indicating whether the member asset's depreciation expense is calculated using its group asset depreciation rules or the member asset depreciation rules.
MEMBER_ROLLUP_FLAG VARCHAR2 1 Option indicating whether group asset depreciation is sum of member asset depreciation or calculated separately.
ALLOCATE_TO_FULLY_RSV_FLAG VARCHAR2 1 Option indicating whether group asset depreciation amount should be allocated to fully retired assets.
ALLOCATE_TO_FULLY_RET_FLAG VARCHAR2 1 Option indicating whether group asset depreciation amount should be allocated to fully retired assets.
TERMINAL_GAIN_LOSS_AMOUNT NUMBER Accumulated depreciation remaining for the group asset after the last member asset of the group asset is retired.
CIP_COST NUMBER Construction-in-Process cost of the asset.
YTD_PROCEEDS NUMBER Year-to-date proceeds of sale for an asset.
LTD_PROCEEDS NUMBER Life-to-date proceeds of sale amount for the asset.
LTD_COST_OF_REMOVAL NUMBER Life-to-date cost of removal amount for the asset.
EOFY_RESERVE NUMBER Depreciation reserve at the end of the previous fiscal year.
PRIOR_EOFY_RESERVE NUMBER Previous accumulated depreciation at the end of the previous fiscal year.
EOP_ADJ_COST NUMBER Adjusted cost at the end of the previous period.
EOP_FORMULA_FACTOR NUMBER Formula factor at the end of the previous period.
EXCLUDE_PROCEEDS_FROM_BASIS VARCHAR2 1 Group asset retirement rule which indicates whether proceeds of sale should be excluded when calculating the depreciable basis for group assets.
RETIREMENT_DEPRN_OPTION VARCHAR2 30 Option indicating whether group asset should depreciate till the last member asset is retired or end of the fiscal year.
TERMINAL_GAIN_LOSS_FLAG VARCHAR2 1 Option indicating whether terminal gain or loss amount needs to be processed by the Calculate Gains and Losses program, when it is running for the last period of the fiscal year.
OVER_DEPRECIATE_OPTION VARCHAR2 30 Option indicating whether over depreciation is allowed for the group asset depreciation or not.
DISABLED_FLAG VARCHAR2 1 Option indicating whether the group asset is enabled or disabled.
OLD_ADJUSTED_CAPACITY NUMBER Remaining production capacity before the last depreciation process run for assets that that use units of production method.
METHOD_ID NUMBER 18 Identifier of the depreciation method.
FLAT_RATE_ID NUMBER 18 Identifier of the rates for the flat rate depreciation method.
CONVENTION_TYPE_ID NUMBER 18 Identifier of the prorate convention.
BONUS_RULE_ID NUMBER 18 Identifier of the depreciation bonus rule.
CEILING_TYPE_ID NUMBER 18 Identifier of the depreciation ceiling.
CASH_GENERATING_UNIT_ID NUMBER 18 Identifier of the cash generating unit.
CONTRACT_ID NUMBER 18 Identifier of the lease contract of the asset.
DRY_HOLE_FLAG VARCHAR2 1 Option indicating whether energy asset is classified as dry hole or not.
EXTENDED_DEPRECIATION_PERIOD NUMBER 18 No longer used.
EXTENDED_DEPRN_FLAG VARCHAR2 1 Option indicating whether the asset depreciation is extended.
ITC_AMOUNT NUMBER Investment tax credit amount of the asset.
ITC_AMOUNT_ID NUMBER 18 Identifier of the investment tax credit.
ITC_BASIS NUMBER Investment tax credit calculation basis.
NBV_AT_SWITCH NUMBER Net book value of the asset as of the date at which the original rate was switched to the revised rate.
PERIOD_COUNTER_FULLY_EXTENDED NUMBER 18 Identifier of the depreciation period in which the asset life was extended.
PRIOR_DEPRN_LIMIT NUMBER Depreciation limit as a percentage of cost for the asset immediately before it began extended depreciation.
PRIOR_DEPRN_LIMIT_AMOUNT NUMBER Depreciation limit amount for the asset immediately before it began extended depreciation.
PRIOR_DEPRN_LIMIT_TYPE VARCHAR2 30 Depreciation limit type for the asset immediately before it began extended depreciation.
RATE_IN_USE NUMBER Depreciation rates used to depreciate the net book value over the remaining life.
PRIOR_METHOD_ID NUMBER 18 Identifier of the depreciation method for the asset immediately before it began extended depreciation.
PRIOR_FLAT_RATE_ID NUMBER 18 Identifier of the flat rate for the depreciation method of the asset immediately before it began extended depreciation.
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 30 Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
FAIR_MARKET_VALUE NUMBER Stores the fair value of an asset.
LAST_PRICE_INDEX_VALUE NUMBER Stores the value of the price index used during index-based revaluation for future revaluation.
PERIOD_COUNTER_EXTENDED NUMBER 18 Extended depreciation start period identifier.
LOW_VALUE_ASSET_FLAG VARCHAR2 1 Indicates whether this line is a low value asset.
USE_BOOKS_SUMMARY_FLAG VARCHAR2 1 Indicates whether the FA_BOOKS_SUMMARY table for the asset was populated.
ACCELERATED_BONUS_RULE_ID NUMBER 18 Bonus rule used to take a higher depreciation amount than the amount calculated by the depreciation method.
ACCELERATED_ADJUSTED_COST NUMBER The base amount on which the accelerated depreciation is calculated.
BONUS_ADJUSTED_COST NUMBER The base amount on which the bonus depreciation is calculated.
GLOBAL_ATTRIBUTE_NUMBER6 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER7 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER8 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER9 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER10 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
LEASE_SCHEDULE_ID NUMBER 18 Unique lease payment schedule identification number.
LEASE_ID NUMBER 18 Unique lease identification number.
LEASE_EXPENSE_BASIS NUMBER Basis used for calculating the periodic lease expense of the asset.
LEASE_ADJUSTMENT_FACTOR NUMBER Internal factor used to amortize the lease basis over the remaining lease term of the asset.
DEPRN_ADJUSTMENT_FACTOR NUMBER Controls the speed of depreciation of an asset by multiplying this factor by the annual depreciation rate.
FULLY_RESERVE_ON_ADD_FLAG VARCHAR2 1 Indicates whether to fully depreciate an asset when the asset is added.
REVALUED_COST NUMBER Increase or decrease in cost due to revaluation of the asset. Can be a positive or negative amount.
EOFY_REVAL_RESERVE NUMBER Revaluation reserve at the end of previous fiscal year.
PRIOR_EOFY_REVAL_RESERVE NUMBER Stores the value of revaluation reserve at the end of fiscal year before the transaction. This is used to rollback the depreciation for the last period of fiscal year.
IB_ASSET_LINK_FLAG VARCHAR2 1 Indicates whether to synchronize the transaction between a fixed asset and its associated installed base asset.
BOOK_TYPE_CODE VARCHAR2 30 Yes Unique book identification name.
ANNUITY_INTEREST_RATE NUMBER Annual interest rate used to calculate annual interest expense.

Foreign Keys

Table Foreign Table Foreign Key Column
FA_BOOKS fa_book_controls BOOK_TYPE_CODE
FA_BOOKS fa_deprn_periods BOOK_TYPE_CODE, PERIOD_COUNTER_FULLY_RESERVED
FA_BOOKS fa_deprn_periods BOOK_TYPE_CODE, PERIOD_COUNTER_FULLY_RETIRED
FA_BOOKS fa_deprn_periods BOOK_TYPE_CODE, PERIOD_COUNTER_CAPITALIZED
FA_BOOKS fa_cash_gen_units CASH_GENERATING_UNIT_ID
FA_BOOKS fa_bonus_rules ACCELERATED_BONUS_RULE_ID
FA_BOOKS fa_ceiling_types CEILING_TYPE_ID
FA_BOOKS fa_deprn_periods BOOK_TYPE_CODE, PERIOD_COUNTER_LIFE_COMPLETE
FA_BOOKS fa_bonus_rules BONUS_RULE_ID
FA_BOOKS fa_itc_rates ITC_AMOUNT_ID
FA_BOOKS fa_additions_b ASSET_ID
FA_BOOKS fa_transaction_headers TRANSACTION_HEADER_ID_IN, BOOK_TYPE_CODE
FA_BOOKS fa_transaction_headers TRANSACTION_HEADER_ID_OUT, BOOK_TYPE_CODE
FA_BOOKS fa_methods METHOD_ID
FA_BOOKS fa_convention_types CONVENTION_TYPE_ID
FA_BOOKS fa_retirements RETIREMENT_ID
FA_BOOKS fa_flat_rates METHOD_ID, FLAT_RATE_ID
FA_BOOKS fa_additions_b GROUP_ASSET_ID

Indexes

Index Uniqueness Tablespace Columns
FA_BOOKS_N1 Non Unique Default ASSET_ID, BOOK_TYPE_CODE
FA_BOOKS_N3 Non Unique Default RETIREMENT_ID
FA_BOOKS_N4 Non Unique Default GROUP_ASSET_ID
FA_BOOKS_N5 Non Unique FUSION_TS_TX_DATA LEASE_ID, BOOK_TYPE_CODE
FA_BOOKS_U1 Unique Default TRANSACTION_HEADER_ID_IN
FA_BOOKS_U2 Unique Default BOOK_TYPE_CODE, TRANSACTION_HEADER_ID_OUT, ASSET_ID