FA_BOOK_CONTROLS_HISTORY
FA_BOOK_CONTROLS_HISTORY contains information about modifications made to book setup information in the Book Controls form. The table creates an audit history for these changes. Oracle Fusion Assets inserts rows in this table each time you update book level information. The existing record for that book is terminated, so that the DATE_INACTIVE of the old record and the DATE_ACTIVE for the new record are the same. This means that you can easily identify rows that are affected by the same update.
Details
-
Schema: FUSION
-
Object owner: FA
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
FA_BOOK_CONTROLS_HISTORY_PK |
BOOK_TYPE_CODE, DATE_ACTIVE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LEASE_CURR_RATE_GAIN_LOSS_FLAG | VARCHAR2 | 1 | Indicates whether to calculate gain or loss on lease liability for currency exchange rate changes. | ||
| DATE_ACTIVE | DATE | Yes | Date when the row became effective. | ||
| DATE_INACTIVE | DATE | Date when the row became inactive. | |||
| BOOK_TYPE_NAME | VARCHAR2 | 30 | Yes | General description for the asset book. | |
| SET_OF_BOOKS_ID | NUMBER | 18 | Yes | Identifier of the accounting ledger. | |
| AMORTIZE_FLAG | VARCHAR2 | 3 | Yes | Option indicating whether amortized transactions are allowed for the book. | |
| GL_POSTING_ALLOWED_FLAG | VARCHAR2 | 3 | Yes | Option indicating whether the accounting entries can be posted to Oracle Fusion General Ledger. | |
| ALLOW_MASS_CHANGES | VARCHAR2 | 3 | Yes | Option indicating whether mass depreciation changes are allowed for the book. | |
| 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. | |
| DATE_INEFFECTIVE | DATE | Date when the row became inactive. | |||
| COPY_RETIREMENTS_FLAG | VARCHAR2 | 3 | Yes | Option indicating whether retirement transactions to be copied from the corporate book. | |
| COPY_ADJUSTMENTS_FLAG | VARCHAR2 | 3 | Yes | Option indicating whether adjustment transactions to be copied from the corporate book. | |
| ALLOW_COST_CEILING | VARCHAR2 | 3 | Yes | Option indicating whether cost ceilings are allowed for the book. | |
| ALLOW_DEPRN_EXP_CEILING | VARCHAR2 | 3 | Yes | Option indicating whether expense ceilings are allowed for the book. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ALLOW_MASS_COPY | VARCHAR2 | 3 | Yes | Option indicating whether mass copy for the tax book is allowed. | |
| ALLOW_PURGE_FLAG | VARCHAR2 | 3 | Option indicating whether purge is allowed. | ||
| ALLOW_REVAL_FLAG | VARCHAR2 | 3 | Yes | Option indicating whether revaluation is allowed. | |
| AMORTIZE_REVAL_RESERVE_FLAG | VARCHAR2 | 3 | Option indicating whether revaluation reserve amortization is allowed. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| CAPITAL_GAIN_THRESHOLD | NUMBER | Minimum time to hold an asset for Oracle Fusion Assets to report it as a capital gain on the form 4797 reports when you retire it. | |||
| COPY_SALVAGE_VALUE_FLAG | VARCHAR2 | 3 | Yes | Option indicating whether salvage value can be copied by mass copy process. | |
| COST_OF_REMOVAL_CLEARING_ACCT | VARCHAR2 | 25 | Yes | Cost of removal clearing account for retirement transactions. | |
| COST_OF_REMOVAL_GAIN_ACCT | VARCHAR2 | 25 | Cost of removal account for retirement that results in a gain. | ||
| COST_OF_REMOVAL_LOSS_ACCT | VARCHAR2 | 25 | Cost of removal account for retirement that results in a loss. | ||
| DEFAULT_LIFE_EXTENSION_CEILING | NUMBER | Default maximum factor by which the life can be multiplied when backing out depreciation during revaluation. Does not affect the actual asset life. | |||
| DEFAULT_LIFE_EXTENSION_FACTOR | NUMBER | Default factor by which to extend the life when revaluing a fully reserved asset. | |||
| DEFAULT_MAX_FULLY_RSVD_REVALS | NUMBER | 18 | Default maximum number of times an asset can be revalued as fully reserved. | ||
| DEFAULT_REVAL_FULLY_RSVD_FLAG | VARCHAR2 | 3 | Option indicating whether fully reserved assets in this book are revalued or not. This value will be defaulted to the revaluation transactions performed in this book. | ||
| DEFERRED_DEPRN_EXPENSE_ACCT | VARCHAR2 | 25 | Deferred depreciation expense account. | ||
| DEFERRED_DEPRN_RESERVE_ACCT | VARCHAR2 | 25 | Deferred depreciation reserve account. | ||
| DEPRN_ALLOCATION_CODE | VARCHAR2 | 1 | Yes | Method of allocating annual depreciation expense to each period evenly (E) or by the number of days in that period (D). | |
| NBV_AMOUNT_THRESHOLD | NUMBER | Depreciation rounding threshold amount based on currency and precision. | |||
| NBV_FRACTION_THRESHOLD | NUMBER | Depreciation rounding threshold fraction based on currency and precision. | |||
| NBV_RETIRED_GAIN_ACCT | VARCHAR2 | 25 | Net book value retired account for retirement that results in a gain. | ||
| NBV_RETIRED_LOSS_ACCT | VARCHAR2 | 25 | Net book value retired account for retirement that results in a loss. | ||
| PROCEEDS_OF_SALE_CLEARING_ACCT | VARCHAR2 | 25 | Proceeds of sale clearing account for retirement transactions. | ||
| PROCEEDS_OF_SALE_GAIN_ACCT | VARCHAR2 | 25 | Proceeds of sale account for retirement that results in a gain. | ||
| PROCEEDS_OF_SALE_LOSS_ACCT | VARCHAR2 | 25 | Proceeds of sale account for retirement that results in a loss. | ||
| REVAL_DEPRN_RESERVE_FLAG | VARCHAR2 | 3 | Option indicating whether depreciation reserve can be revalued. | ||
| REVAL_RSV_RETIRED_GAIN_ACCT | VARCHAR2 | 25 | Revaluation reserve retired account for retirement that results in a gain. | ||
| REVAL_RSV_RETIRED_LOSS_ACCT | VARCHAR2 | 25 | Revaluation reserve retired account for retirement that results in a loss. | ||
| IMMEDIATE_COPY_FLAG | VARCHAR2 | 3 | Not currently used. | ||
| DEPR_FIRST_YEAR_RET_FLAG | VARCHAR2 | 3 | Yes | Option indicating whether to depreciate assets retired in the first year of life. | |
| FLEXBUILDER_DEFAULTS_CCID | NUMBER | 18 | Identifier of the account code combination used as default value for the accounting segments. | ||
| RETIRE_REVAL_RESERVE_FLAG | VARCHAR2 | 3 | Option indicating whether revaluation reserve can be retired. | ||
| COPY_ADDITIONS_FLAG | VARCHAR2 | 3 | Yes | Option indicating whether the mass copy process can copy the asset additions to tax book. | |
| USE_PERCENT_SALVAGE_VALUE_FLAG | VARCHAR2 | 3 | Not currently used. | ||
| MC_SOURCE_FLAG | VARCHAR2 | 1 | Option indicating whether the book has reporting currency. | ||
| REVAL_YTD_DEPRN_FLAG | VARCHAR2 | 3 | Not currently used. | ||
| ALLOW_CIP_ASSETS_FLAG | VARCHAR2 | 3 | Option indicating whether copying construction-in-process assets from corporate book to tax book is allowed. | ||
| ALLOW_GROUP_DEPRN_FLAG | VARCHAR2 | 1 | Option indicating whether group assets depreciation is allowed. | ||
| ALLOW_CIP_DEP_GROUP_FLAG | VARCHAR2 | 1 | Option indicating whether construction-in-process assets cost can depreciate as part of a group asset. | ||
| ALLOW_INTERCO_GROUP_FLAG | VARCHAR2 | 1 | Option indicating whether intercompany transactions are allowed on group or member assets. | ||
| COPY_GROUP_ASSIGNMENT_FLAG | VARCHAR2 | 1 | Option indicating whether mass copy process can copy the group asset association of an asset. | ||
| COPY_GROUP_ADDITION_FLAG | VARCHAR2 | 1 | Option indicating whether mass copy process can copy group asset additions. | ||
| ALLOW_CIP_MEMBER_FLAG | VARCHAR2 | 1 | Option indicating whether group assets will be automatically defaulted for construction-in-process additions. | ||
| ALLOW_MEMBER_TRACKING_FLAG | VARCHAR2 | 1 | Option indicating whether member asset tracking is allowed. | ||
| ALLOW_BACKDATED_TRANSFERS_FLAG | VARCHAR2 | 1 | Option indicating whether backdated transfers are allowed in tax book. | ||
| ALLOW_COST_SIGN_CHANGE_FLAG | VARCHAR2 | 1 | Option indicating whether adjustments that change the cost of an asset from positive to negative or negative to positive is allowed. | ||
| 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. | |
| ALLOW_BONUS_DEPRN_FLAG | VARCHAR2 | 1 | Option indicating whether bonus depreciation is allowed. | ||
| ALLOW_IMPAIRMENT_FLAG | VARCHAR2 | 1 | Option indicating whether asset impairment is allowed. | ||
| ITC_ALLOWED_FLAG | VARCHAR2 | 3 | Flag indicates whether investment tax credit is allowed. | ||
| SORP_ENABLED_FLAG | VARCHAR2 | 1 | Option indicating whether statement of recommended accounting practice feature is enabled. | ||
| ALLOW_DEPRN_ADJUSTMENTS | VARCHAR2 | 3 | Option indicating whether depreciation adjustments are allowed for the book. | ||
| DEPRN_ADJUSTMENT_ACCT | VARCHAR2 | 25 | Depreciation adjustment account used to account depreciation adjustment transaction. | ||
| 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. | ||
| COPY_GROUP_CHANGE_FLAG | VARCHAR2 | 1 | Option indicating whether mass copy process can copy group asset assignment changes. | ||
| ROUND_ANNUAL_DEPRECIATION | VARCHAR2 | 30 | Annual depreciation rounding option. | ||
| COPY_ALL_COST_ADJUSTMENTS_FLAG | VARCHAR2 | 1 | Option indicating whether mass copy process can copy all adjustments. | ||
| DEFAULT_DPIS_TO_INV_DATE_FLAG | VARCHAR2 | 1 | Option indicating whether payables invoice date can be defaulted to data placed in service. | ||
| USE_NBV_THRESHOLD_FLAG | VARCHAR2 | 1 | Option indicating whether net book value threshold is enabled. | ||
| COPY_AMORT_ADAJ_EXP_FLAG | VARCHAR2 | 1 | Option indicating whether mass copy process can copy amortized adjustment as expensed adjustment. | ||
| PREVENT_PRIOR_PERIOD_TXNS_FLAG | VARCHAR2 | 1 | Option indicating whether amortized transactions backdated to previous periods should be prevented. | ||
| ALLOW_DEPRN_OVERRIDE_FLAG | VARCHAR2 | 1 | Option indicating whether depreciation override is allowed. | ||
| ALLOW_FUND_ACCOUNTING_FLAG | VARCHAR2 | 1 | Enables fund accounting in the book. | ||
| ALLOW_COST_BASED_REVAL_FLAG | VARCHAR2 | 1 | Allows cost-based revaluation on an asset in the book. | ||
| ALLOW_NBV_BASED_REVAL_FLAG | VARCHAR2 | 1 | Allows NBV-based revaluation on an asset in the book. | ||
| DEFAULT_PERIOD_END_REVAL_FLAG | VARCHAR2 | 1 | Includes current period depreciation in revaluation calculations. | ||
| ALLOW_DIRECT_TAX_ADDITION_FLAG | VARCHAR2 | 1 | Indicates whether direct asset addition is allowed for the tax book. | ||
| ALLOW_TAX_DISTRIBUTIONS_FLAG | VARCHAR2 | 1 | Indicates whether the tax book has its own asset distribution or uses the distribution of the associated corporate book. | ||
| BOOK_TYPE_MIGRATION_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| COPY_TRANSFERS_FLAG | VARCHAR2 | 1 | Indicates whether the Mass Copy process can copy the asset transfers to the tax book. | ||
| REQUIRE_LOCATION_FLAG | VARCHAR2 | 1 | Indicates whether location tracking is mandatory for the assets in the book. | ||
| TRACK_SOURCE_LINES_IN_TAX_FLAG | VARCHAR2 | 1 | Indicates whether source lines are allowed for the assets in the tax book. | ||
| CAP_THRESHOLD_TYPE | VARCHAR2 | 30 | Capitalization threshold type for the asset book. It can be either Cost, Unit, or none. | ||
| CAP_THRESHOLD_AMOUNT | NUMBER | The threshold amount used to determine whether to capitalize or expense an asset source line. | |||
| LOW_VALUE_THRESHOLD_AMOUNT | NUMBER | The threshold amount used to determine whether the asset needs to added as a low value capitalized asset. | |||
| ALLOW_TRANS_CONVENTION_FLAG | VARCHAR2 | 1 | Indicates whether the prorate convention is allowed for adjustment and transfer transactions. | ||
| ADVANCED_OPTIONS_ENABLED_FLAG | VARCHAR2 | 1 | Indicates whether advanced features are allowed for this book. | ||
| ALLOW_PHYSICAL_INVENTORY_FLAG | VARCHAR2 | 1 | Indicates whether physical inventory is allowed for the book. | ||
| ALLOW_LEASES_FLAG | VARCHAR2 | 1 | Indicates whether leased assets are allowed for the asset book. | ||
| LEASE_EXPENSE_RUN_FLAG | VARCHAR2 | 1 | Indicates whether periodic lease interest and expense have been generated for the current open period. | ||
| COPY_LEASE_ASSETS_FLAG | VARCHAR2 | 1 | Indicates whether mass copy process can copy lease assets to the tax book. | ||
| COPY_LEASE_SCHEDULES_FLAG | VARCHAR2 | 1 | Indicates whether mass copy process can copy lease schedules while copying lease assets to the tax book. | ||
| USE_FIRST_DATE_AS_TRX_DATE | VARCHAR2 | 1 | Option indicating that the Mass Copy process uses the first date of the current open period as the transaction date. | ||
| ALLOW_UK_GOVERNMENT_REVAL_FLAG | VARCHAR2 | 1 | Specifies whether UK government revaluation is enabled for the book. | ||
| INDEX_REVAL_PERIOD_NUM | NUMBER | 3 | Specifies the period number in which index revaluation will be performed for the book. | ||
| AP_CLEARING_BSV_CHECK_FLAG | VARCHAR2 | 1 | Yes | Indicates whether balancing segment of Payables cost clearing account determines the asset book for invoices. | |
| AP_CLEARING_CC_CHECK_FLAG | VARCHAR2 | 1 | Yes | Indicates whether cost center segment of Payables cost clearing account determines the asset book for invoices. | |
| AP_CLEARING_NA_CHECK_FLAG | VARCHAR2 | 1 | Yes | Indicates whether natural account segment of Payables cost clearing account determines the asset book for invoices. | |
| ADDITIONS_APPROVAL_FLAG | VARCHAR2 | 1 | Indicates whether approval for an addition transaction is allowed for the asset book. | ||
| ADJUSTMENTS_APPROVAL_FLAG | VARCHAR2 | 1 | Indicates whether approval for an adjustment transaction is allowed for the asset book. | ||
| TRANSFERS_APPROVAL_FLAG | VARCHAR2 | 1 | Indicates whether approval for a transfer transaction is allowed for the asset book. | ||
| RETIREMENTS_APPROVAL_FLAG | VARCHAR2 | 1 | Indicates whether approval for a retirement transaction is allowed for the asset book. | ||
| ALLOW_BOOK_TRANSFER_FLAG | VARCHAR2 | 1 | Indicates whether the book allows asset transfer to another book. | ||
| AP_INTERCOMPANY_ACCT | VARCHAR2 | 25 | Intercompany Payables account segment. | ||
| AR_INTERCOMPANY_ACCT | VARCHAR2 | 25 | Intercompany Receivables account segment. | ||
| CAP_THRESHOLD_CURRENCY_CODE | VARCHAR2 | 15 | Currency in which the capitalization threshold is maintained, which may be different than the functional currency of the ledger. | ||
| CAP_THRESHOLD_RATE_TYPE | VARCHAR2 | 30 | Rate type used to convert the capitalization threshold to the functional currency of the associated ledger. | ||
| BOOK_TYPE_CODE | VARCHAR2 | 30 | Yes | Unique book identification name. | |
| ALLOW_ANNUITY_DEPRN_FLAG | VARCHAR2 | 1 | Indicates whether the book allows annuity depreciation calculation. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| FA_BOOK_CONTROLS_HISTORY | fa_book_controls | BOOK_TYPE_CODE |
| FA_BOOK_CONTROLS_HISTORY | gl_ledgers | SET_OF_BOOKS_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FA_BOOK_CONTROLS_HISTORY_U1 | Unique | Default | BOOK_TYPE_CODE, DATE_ACTIVE |