OFA — Assets
203 documented tables · 148 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
FA_BOOK_CONTROLS |
Control information that affects all assets in a depreciation book | hub-leaning |
FA_ADDITIONS_B |
Descriptive information about assets (base MLS table) | hub |
FA_CATEGORIES_B |
Default financial information for asset categories (base MLS table) | hub-leaning |
FA_DEPRN_PERIODS |
Information about each depreciation period | hub |
FA_LEASES |
Lease information for leased assets | satellite-leaning |
FA_ASSET_KEYWORDS |
Asset key flexfield segment combinations | hub-leaning |
FA_RX_REPORTS |
Stores Report eXchange report definitions | satellite-leaning |
FA_METHODS |
Depreciation method information | hub |
FA_TRANSACTION_HEADERS |
Information about all transactions performed within Oracle Assets | hub-leaning |
FA_LOCATIONS |
Location flexfield segment value combinations | hub-leaning |
FA_RX_ATTRSETS_B |
Stores attribute set information for RX reports (base MLS table) | hub-leaning |
FA_CALENDAR_TYPES |
General calendar information | hub-leaning |
FA_FISCAL_YEAR |
Range of dates for all fiscal years | hub-leaning |
FA_DISTRIBUTION_HISTORY |
Employee, location, and Accounting Flexfield values assigned to each asset | hub-leaning |
FA_CONVENTION_TYPES |
Names and descriptions for prorate conventions | hub-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.