OFA Tables (203)

OFA - Assets — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

Table	Columns	Description
FA_ACE_BOOKS	15	Financial information for updating ACE book
FA_ADDITIONS_B	80	Descriptive information about assets (base MLS table)
FA_ADDITIONS_TL	9	Descriptive information about assets (translated MLS table)
FA_ADDITION_REP_ITF	55	Interface table for Report eXchange reports
FA_ADD_WARRANTIES	9	Warranty information
FA_ADJUSTMENTS	45	Information used by the posting program to generate journal entry lines in the general ledger
FA_ADJUSTMENTS_T	90	FA_ADJUSTMENTS_T is a temporary table used during processing of impairment transaction and Extended Depreciation.
FA_ADJUST_REP_ITF	34	Interface table for Report eXchange reports
FA_AMORT_SCHEDULES	12	Amortization schedules
FA_ARCHIVE_HISTORY	12	Archive, purge, and restore request information
FA_ASSET_HIERARCHY	31	Defines hierarchy nodes and the relationship between them.
FA_ASSET_HIERARCHY_PURPOSE	14	Contains Purpose information. This contains rules regarding how the Inheritance Rule Set will be used and whether the relationship between
FA_ASSET_HIERARCHY_VALUES	13	Stores attribute values associated with a hierarchy node that may be inherited by other nodes.
FA_ASSET_HISTORY	11	Historical information about asset reclassifications and unit adjustments
FA_ASSET_INVOICES	61	Accounts payable and purchasing information for each asset
FA_ASSET_KEYWORDS	18	Asset key flexfield segment combinations
FA_ASSET_LISTING_REP_ITF	45	Interface table for Report eXchange reports
FA_BALANCES_REPORT	9	Temporary storage area for the balance reports
FA_BALANCES_REPORTS	10
FA_BALANCES_REP_ITF	42	Interface table for Report eXchange reports
FA_BONUS_RATES	28	Bonus rate information used by the Depreciation program
FA_BONUS_RULES	24	Bonus rule information used by the Depreciation program
FA_BOOKS	132	Financial information of each asset
FA_BOOKS_GROUPS	55	Contains financial (cost) information for a group asset within a particular book. This is also a history table.
FA_BOOKS_SUMMARY	103	This table stores group assets' periodical financial information
FA_BOOKS_SUMMARY_T	100	FA_BOOKS_SUMMARY_T is a temporary table used during processing of impairment transaction.
FA_BOOK_CONTROLS	153	Control information that affects all assets in a depreciation book
FA_BOOK_CONTROLS_HISTORY	132	Tracks changes to book setup information in Oracle Assets
FA_BUDGET_DISTRIBUTION	23	Capital budget information entered manually or uploaded from the FA_BUDGET_INTERFACE table
FA_BUDGET_INTERFACE	50	Capital budget information to be uploaded into Oracle Assets
FA_CALENDAR_PERIODS	10	Detailed calendar information
FA_CALENDAR_TYPES	26	General calendar information
FA_CAPITAL_BUDGET	24	Budget assets used to run depreciation projections and reports
FA_CAP_REP_ITF	23	Interface table for Report eXchange reports
FA_CASH_GEN_UNITS	10	FA_CASH_GEN_UNITS table stores the definition of cash generating units per asset book.
FA_CATEGORIES_B	62	Default financial information for asset categories (base MLS table)
FA_CATEGORIES_TL	9	Default financial information for asset categories (base MLS table)Default financial information for asset categories (translated MLS table)
FA_CATEGORY_ACCOUNTS_GT	3
FA_CATEGORY_BOOKS	84	Default financial information for an asset category and depreciation book combination
FA_CATEGORY_BOOK_DEFAULTS	64	Default depreciation rules for asset category and book combination for a particular date placed in service range
FA_CEILINGS	26	Seeded and user-defined ceilings for depreciation expense, investment tax credit cost basis, and depreciation cost basis
FA_CEILING_TYPES	25	General ceiling information
FA_CONVENTIONS	9	Detailed prorate convention information
FA_CONVENTION_TYPES	25	Names and descriptions for prorate conventions
FA_COSTCLEAR_REP_ITF	22	Interface table for Report eXchange reports
FA_DEFERRED_DEPRN	14	Deferred depreciation calculated for each distribution line
FA_DEFERRED_DEPRN_EVENTS	11	Information about deferred depreciation accounting events.
FA_DELETED_MASS_ADDITIONS	20	Invoice information of mass additions you deleted from the FA_MASS_ADDITIONS table using the Delete Mass Additions form
FA_DEPRN_BASIS_RULES	14	Depreciable Basis Rules
FA_DEPRN_DETAIL	40	Depreciation amounts charged to the depreciation expense account in each distribution line
FA_DEPRN_DETAIL_H	29	Stores the depreciation information originally stored in FA_DEPRN_DETAIL for audit purposes.
FA_DEPRN_EVENTS	13	Information about depreciation accounting events.
FA_DEPRN_OVERRIDE	20	Table for Depreciation Override Feature.
FA_DEPRN_PERIODS	27	Information about each depreciation period
FA_DEPRN_REP_ITF	52	Interface table for Report eXchange reports
FA_DEPRN_RULE_DETAILS	17	This table is to define the detail information of depreciable basis rule
FA_DEPRN_SUMMARY	36	Depreciation information at the asset level
FA_DEPRN_SUMMARY_H	38	Stores the depreciation information originally stored in FA_DEPRN_SUMMARY for audit purposes.
FA_DEPRN_TAX_AUTHORITIES	35	FA_DEPRN_TAX_AUTHORITIES table is used to store tax-authority-level information required by Japanese Depreciable Assets Tax Reports.
FA_DEPRN_TAX_ENTITIES	23	FA_DEPRN_TAX_ENTITIES table is used to store company-level information required by Japanese Depreciable Assets Tax Reports.
FA_DEPRN_TAX_REP_ITF	47	Depreciable Assets Tax Reports interim table
FA_DEPRN_TAX_REP_NBVS	18	Table used for the Japanese Depreciable Asset Tax Report.
FA_DISTRIBUTION_ACCOUNTS	35	Table to store account ccids for all distributions for a book
FA_DISTRIBUTION_DEFAULTS	11	Distribution set information
FA_DISTRIBUTION_HISTORY	18	Employee, location, and Accounting Flexfield values assigned to each asset
FA_DISTRIBUTION_SETS	11	Header information for distribution sets
FA_EXCLUDE_HIERARCHY_LEVELS	9	Which hierarchy levels should be excluded from an inheritance rule.
FA_EXT_INV_RETIREMENTS	4	External invoice retirements. Identifies the source line(s) to be retired by a mass external retirement.
FA_FISCAL_YEAR	26	Range of dates for all fiscal years
FA_FLAT_RATES	26	Annual depreciation rates for all flat-rate methods
FA_FORMULAS	13	Depreciation rates for formula-based methods
FA_GROUP_ASSETS	20	Contains group asset definitions - flexfield and general descriptive information.
FA_GROUP_ASSET_DEFAULT	52	Defines accounts to be used for a group asset within a particular book. e.g. Expense account, reserve account etc.
FA_GROUP_ASSET_RULES	36	Defines the depreciation rules to be followed when depreciating a group asset within a particular book. This is also a history table.
FA_GROUP_DEPRN_DETAIL	21	Redundant - mirrors FA_DEPRN_DETAIL and exists purely to store information returned by the depreciation process. Would usually store deprec
FA_GROUP_DEPRN_RATES	26	Contains the depreciation rates to be used when calculating the reserve amount to be transferred with an asset which is being moved out of a
FA_GROUP_DEPRN_SUMMARY	20	Stores information about depreciation taken on a group asset, in a particular book in a particular period. This is a history table.
FA_GROUP_REP_ITF	78
FA_HIERARCHY_CONTROLS	14	For a hierarchy purpose (root node) defines the rules that apply to the hierarchy. e.g. Maximum allowed number of levels, mandatory attribu
FA_HIERARCHY_DISTRIBUTIONS	12	Stores distribution sets (expense account, location and employee) associated with a hierarchy node that may be inherited by other nodes.
FA_HIERARCHY_RULE_DETAILS	18	Specific rules for a rule set, detailing how attributes are derived and where they are derived from.
FA_HIERARCHY_RULE_SET	25	Header information for a rule set that defines how attributes are inherited in the hierarchy.
FA_HR_RETIREMENT_DETAILS	21	Individual retirements made as a result of a mass retirement on an asset hierarchy.
FA_HR_RETIREMENT_HEADERS	57	Header information for mass retirement of assets in a hierarchy. Contains the retirement selection parameters defined by the user.
FA_IMPAIRMENTS	39	FA_IMPAIRMENTS table stores the Impairment Transaction information.
FA_INS_LINES	34	Stores policy line information
FA_INS_MST_POLS	10	Master policy table for insurance
FA_INS_POLICIES	43	Contains asset insurance policy information
FA_INS_VALUES	20	Stores insurance indexation details
FA_INVENTORY	9	Physical Inventory entry
FA_INVMISS_REP_ITF	18	Interface table for Report eXchange reports
FA_INVOICE_TRANSACTIONS	4	Information about transactions made to invoice lines within Oracle Assets
FA_INV_COMPARE_REP_ITF	20	Interface table for Report eXchange reports
FA_INV_INTERFACE	25	Open Interface table to Physical Inventory
FA_ITC_RATES	26	Investment tax credit (ITC) rate information
FA_ITC_RECAPTURE_RATES	26	Percentage of Investment Tax Credit (ITC) to recapture for early retirements
FA_ITF_IMPAIRMENTS	99	FA_ITF_IMPAIRMENTS table gets populated for any candidate assets to be impaired per the impairment transaction stored in FA_IMPAIRMENTS tabl
FA_JOURNAL_ENTRIES	41	Journal Entry Information
FA_LEASES	39	Lease information for leased assets
FA_LEASE_PAYMENTS	13	Payment schedule detail information
FA_LEASE_PAYMENT_ITEMS	17	This table stores all the payment items of leases in Oracle Assets
FA_LEASE_SCHEDULES	12	Payment schedule information
FA_LIFE_DERIVATION_INFO	5	This table stores how Life was derived on on Asset from the Inheritance Rules. Stores the Type and tName of the Entity from where the life w
FA_LOCATIONS	31	Location flexfield segment value combinations
FA_LOOKUPS_B	27	Seeded and user-defined values for QuickCodes (base MLS table)
FA_LOOKUPS_TL	12	Seeded and user-defined values for QuickCodes (translated MLS table)
FA_LOOKUP_TYPES_B	8	Information about QuickCodes (base MLS table)
FA_LOOKUP_TYPES_TL	11	Information about QuickCodes (translated MLS table)
FA_MAINT_EVENTS	33	Stores scheduled events
FA_MAINT_REP_ITF	31	Interface table for Report eXchange reports
FA_MAINT_SCHEDULE_DTL	33	Stores detail information for scheduling
FA_MAINT_SCHEDULE_HDR	19	Stores information about maintenance scheduling requests
FA_MASSADD_DISTRIBUTIONS	11	Distribution information for each mass addition line
FA_MASSADD_REP_ITF	67	Interface table for Report eXchange reports
FA_MASS_ADDITIONS	205	Information about assets that you want to automatically add to Oracle Assets from another system
FA_MASS_ADDITIONS_GT	173
FA_MASS_CHANGES	71	Mass change request information
FA_MASS_CHANGES_ITF	41	Interface table for Report eXchange reports
FA_MASS_EXTERNAL_TRANSFERS	81	Interface Table for Mass External Transfers
FA_MASS_EXT_RETIREMENTS	68	Mass external retirements interface table.
FA_MASS_EXT_RET_EXCEPTS	10	Mass external retirements interface - exceptions.
FA_MASS_RECLASS	104	Mass reclass request information
FA_MASS_RECLASS_ITF	29	Interface table for Report eXchange reports
FA_MASS_RETIREMENTS	116	FA_MASS_RETIREMENT contains information about your mass retirement and mass reinstatement processes.
FA_MASS_RET_EXCEPTS	8	Information about assets that could not be retired as part of a mass retirement transaction
FA_MASS_REVALUATIONS	54	Mass revaluation request status information
FA_MASS_REVALUATION_RULES	36	Mass revaluation request rule information
FA_MASS_REVAL_REP_ITF	32	Interface table for Mass Revaluation reports
FA_MASS_TAX_ADJUSTMENTS	29	Mass depreciation adjustment request information
FA_MASS_TAX_ADJ_REP_T	17	Interface table for Mass Tax Reserve Adjustment Review reports
FA_MASS_TRANSFERS	119	Mass transfer request information
FA_MASS_UPDATE_BATCH_DETAILS	20	The individual asset changes made as a result of a mass update.
FA_MASS_UPDATE_BATCH_HEADERS	37	Contains header information for a mass update. Describes the parameters and selection criteria for the update.
FA_MC_ADJUSTMENTS	47	Stores information to create adjustment journal entries in the reporting currency
FA_MC_ASSET_INVOICES	63	Accounts payable and purchasing information for each asset, in the reporting currency
FA_MC_BOOKS	125	Financial information for each asset in the reporting currency
FA_MC_BOOKS_GROUPS	57
FA_MC_BOOKS_RATES	13	Exchange rate information
FA_MC_BOOKS_SUMMARY	104	This table stores financial and depreciation information at the asset level.
FA_MC_BOOK_CONTROLS	24	Control information that affects all assets in a reporting depreciation book
FA_MC_CONVERSION_HISTORY	11	Table to store the conversion history of primary to reporting books
FA_MC_CONVERSION_RATES	9	Table to store the exchange rate information to convert assets from primary to reporting book
FA_MC_DEFERRED_DEPRN	15	Deferred depreciation calculated for each distribution line in the reporting currency
FA_MC_DEPRN_DETAIL	51	Depreciation amounts in the reporting currency, charged to the depreciation expense account in each distribution line
FA_MC_DEPRN_DETAIL_H	36	Stores the depreciation information originally stored in FA_MC_DEPRN_DETAIL for audit purposes.
FA_MC_DEPRN_PERIODS	26	Information about each depreciation period
FA_MC_DEPRN_SUMMARY	38	Depreciation information at the asset level
FA_MC_DEPRN_SUMMARY_H	39	Stores the depreciation information originally stored in FA_MC_DEPRN_SUMMARY for audit purposes.
FA_MC_GROUP_DEPRN_DETAIL	32
FA_MC_GROUP_DEPRN_SUMMARY	22
FA_MC_IMPAIRMENTS	40	FA_MC_IMPAIRMENTS is the MRC version of FA_IMPAIRMENTS.
FA_MC_ITF_IMPAIRMENTS	99	FA_MC_ITF_IMPAIRMENTS is the MRC version of FA_ITF_IMPAIRMENTS.
FA_MC_MASS_RATES	10	Exchange rate information for mass additions process
FA_MC_RETIREMENTS	60	Currency and financial information about retirements in each reporting book
FA_METHODS	37	Depreciation method information
FA_PARALLEL_WORKERS	19	Used to control concurrent execution of post mass additions program.
FA_PERIODIC_PRODUCTION	27	Production information for units of production assets entered manually or uploaded from FA_PRODUCTION_INTERFACE
FA_PERIOD_MAPS	10	Static information about period mapping; used by the Budget-To-Actual Report
FA_PLSQL_DEBUG	8	For debugging purposes in plsql.
FA_PRICE_INDEXES	23	General price index information
FA_PRICE_INDEX_VALUES	20	Price index values of each price index
FA_PRODUCTION_INTERFACE	4	Production information to be uploaded into Oracle Assets
FA_PROJECT_REP_ITF	19	Interface table for Report eXchange reports
FA_PROPTAX_REP_ITF	31	Interface table for Report eXchange reports
FA_RATES	10	Annual depreciation rates for life-based depreciation methods
FA_RECLASS_REP_ITF	25	Interface table for Report eXchange reports
FA_RESERVE_LEDGER	18	Temporary storage area for the reserve ledger reports
FA_RESERVE_LEDGER_GT	22
FA_RETIREMENTS	58	Information about asset retirements and reinstatements
FA_RETIRE_REP_ITF	48	Interface table for Report eXchange reports
FA_REVAL_LINK_IMP_ASSET	13	Stores all the impairmets that are eligible for reversal during a given mass revaluation.
FA_REVAL_LINK_IMP_CAT	10	Stores impairment classification type that can be selected for linking during a mass revaluation at the category level
FA_RX_ATTRSETS_B	24	Stores attribute set information for RX reports (base MLS table)
FA_RX_ATTRSETS_TL	12	Stores Attribute Set information for RX reports (translated MLS table)
FA_RX_DYNAMIC_COLUMNS	13	Stores information about dynamic columns for RX reports
FA_RX_LOV	11	Stores information about creating the LOV's for RX reports.
FA_RX_MULTIFORMAT_REPS	12	Stores information about Multiple format reports for use with RXi
FA_RX_REPORTS	17	Stores Report eXchange report definitions
FA_RX_REP_COLUMNS_B	22	Stores attribute definitions for Report eXchange report attributes (base MLS table)
FA_RX_REP_COLUMNS_TL	12	Stores attribute definitions for Report eXchange report attributes (translated MLS table)
FA_RX_REP_PARAMETERS	15	Stores parameter definitions for Report eXchange reports
FA_RX_SECURITY	9	Stores security assignments for Report eXchange Attribute sets
FA_RX_SUMMARY_TL	17	Stores summary definitions for Report eXchange report attributes (base MLS table)
FA_SHORT_TAX_RESERVES	9	Stores accumulated depreciation amounts for assets added in short tax years in their tax books
FA_SORP_LINK_REVAL_ITF	27	This interface tables is reserved for processing Revaluations and the related Impairments.
FA_SUPER_GROUPS	21	Contains super group definitions - flexfield and general descriptive information.
FA_SUPER_GROUP_RULES	33	Defines the depreciation rules to be followed when depreciating asset groups that are members of the super group.
FA_SYSTEM_CONTROLS	35	System-wide controls that affect all assets
FA_TAX_INTERFACE	88	Tax Book Interface table
FA_TAX_REPORT	12	FA_TAX_REPORT is temporary storage table for TAX PREFERENCE REPORT.
FA_TRACK_MEMBERS	32
FA_TRANSACTION_HEADERS	37	Information about all transactions performed within Oracle Assets
FA_TRANSACTION_INTERFACE	16	Interface table for uploading transactions to Assets
FA_TRANSFER_DETAILS	3	Information that defines the historic relationship between active FA_BOOKS and FA_DISTRIBUTION_HISTORY rows
FA_TRANSFER_REP_ITF	35	Interface table for Report eXchange reports
FA_TRX_REFERENCES	25	Information about inter-asset transactions performed within Oracle Assets
FA_WARRANTIES	46	Warranty information
FA_WHATIF_ITF	37	Interface table for What-If Depreciation Analysis Report
FA_WORKER_JOBS	5	This table is used for internal processesing only
FA_XLA_EXT_HEADERS_B_GT	62
FA_XLA_EXT_LINES_B_GT	320
FA_XLA_EXT_LINES_STG_GT	308
FA_XLA_EXT_LINES_TL_GT	11