Oracle Fusion · Data dictionary
FA_BOOK_CONTROLS
Fixed AssetsUsed in 13 subject areas29 reporting columns
Fixed Assets (FA).
Primary key: BOOK_TYPE_CODE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ALLOW_CIP_ASSETS_FLAG | ● | Indicator (Y/N) for the allow cip assets. | |
| ALLOW_MASS_CHANGES | ● | Allow mass changes. | |
| AMORTIZE_FLAG | ● | Indicator (Y/N) for the amortize. | |
| BOOK_CLASS | ● | Book class. | |
| BOOK_TYPE_CODE | PK | ● | Code identifying the book type. |
| BOOK_TYPE_NAME | ● | Name of the book type. | |
| COST_OF_REMOVAL_CLEARING_ACCT | ● | Cost of removal clearing account. | |
| COST_OF_REMOVAL_GAIN_ACCT | ● | Cost of removal gain account. | |
| COST_OF_REMOVAL_LOSS_ACCT | ● | Cost of removal loss account. | |
| CURRENT_FISCAL_YEAR | ● | Current fiscal year. | |
| DATE_INEFFECTIVE | ● | Date ineffective. | |
| DEFERRED_DEPRN_EXPENSE_ACCT | ● | Deferred deprn expense account. | |
| DEFERRED_DEPRN_RESERVE_ACCT | ● | Deferred deprn reserve account. | |
| DEPRN_ADJUSTMENT_ACCT | ● | Deprn adjustment account. | |
| DEPRN_ALLOCATION_CODE | ● | Code identifying the deprn allocation. | |
| DEPRN_CALENDAR | ● | Deprn calendar. | |
| DEPRN_STATUS | ● | Status of the deprn. | |
| DISTRIBUTION_SOURCE_BOOK | ● | Distribution source book. | |
| FISCAL_YEAR_NAME | ● | Name of the fiscal year. | |
| GL_POSTING_ALLOWED_FLAG | ● | Indicator (Y/N) for the general ledger posting allowed. | |
| LAST_DEPRN_RUN_DATE | ● | Last deprn run date. | |
| LAST_PERIOD_COUNTER | ● | Last period counter. | |
| NBV_AMOUNT_THRESHOLD | ● | Nbv amount threshold. | |
| NBV_FRACTION_THRESHOLD | ● | Nbv fraction threshold. | |
| NBV_RETIRED_GAIN_ACCT | ● | Nbv retired gain account. | |
| NBV_RETIRED_LOSS_ACCT | ● | Nbv retired loss account. | |
| PROCEEDS_OF_SALE_CLEARING_ACCT | ● | Proceeds of sale clearing account. | |
| PROCEEDS_OF_SALE_GAIN_ACCT | ● | Proceeds of sale gain account. | |
| PROCEEDS_OF_SALE_LOSS_ACCT | ● | Proceeds of sale loss account. |
6 reports read from this table
Change a column here and these are the reports that move with it — the blast radius for any change to FA_BOOK_CONTROLS.
- Asset Book Controls Report
- Asset Accounting and Location Report
- Asset Addition and Cost Adjustment Report
- Asset Audit History Detail Report
- Asset Category Exceptions Report
- FA to GL Reconciliation Report
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.
- Fiscal Document Capture Transactions Real Time
- Fixed Assets - Asset Assignments Real Time
- Fixed Assets - Asset Balances Real Time
- Fixed Assets - Asset Depreciation Real Time
- Fixed Assets - Asset Financial Information Real Time
- Fixed Assets - Asset Retirements and Reinstatements Real Time
- Fixed Assets - Asset Transactions Real Time
- Fixed Assets - Asset Transfer Real Time
- Payables Invoices - Holds Real Time
- Payables Invoices - Prepayment Applications Real Time
- Payables Invoices - Transactions Real Time
- Procurement - Spend Real Time
- Subledger Accounting - Journals Real Time
Need the extract + dbt staging for FA_BOOK_CONTROLS?
We ship parameterized SQL, BICC config, and dbt models you own.