All Fixed Asset Tables

Here is the list of all the Fixed Asset Tables along with the descriptions

Table Name	Description

OKL_LINES_INTERFACE	Contract Open Interface Lines Table
OKL_SIF_LINES	Holds the asset line details used for external pricing.
JL_CO_FA_PURGE	Information about the Colombian archive, purge and restore requests
IGI_IAC_TRANSACTION_HEADERS	Holds the details of the transactions performed against all assets
CSI_I_ASSETS_H	Instance Asset association History.
CSI_I_ASSET_INTERFACE	Instance Asset Interface
FA_ASSET_INVOICES	Accounts payable and purchasing information for each asset
FA_ARCHIVE_HISTORY	Archive, purge, and restore request information
FA_MC_ASSET_INVOICES	Accounts payable and purchasing information for each asset, in the reporting currency
IGI_MHC_LEDGER	This table is an intermediate table. Records are transferred from this table into the GL_INTERFACE and FA_ADJUSTMENT tables after each logical process ie Revaluation , Depreciation. The Extended Revaluation program copies the information af
FA_MC_BOOKS_SUMMARY	This table stores financial and depreciation information at the asset level.
CSI_FA_HEADERS	This table stores the Fixed Asset Header Information
EDW_TIME_CAL_DAY_LSTG	Interface table for calendar day level
JAI_FA_EXEMPTIONS	Stores the Exemptions corresponding to the FA Asset Blocks
FA_MC_DEPRN_PERIODS	Information about each depreciation period
EAM_WORK_ORDER_BILLS	Work Order Billing Information.
IGI_IAC_ASSET_BAL_INTERFACE	Interface table for Inflation Accounting
PA_PROJECT_ASSETS_ALL	Assets defined for capital projects
FA_BOOKS_SUMMARY_T	FA_BOOKS_SUMMARY_T is a temporary table used during processing of impairment transaction.
FA_BOOKS_SUMMARY	This table stores group assets' periodical financial information
EDW_TIME_CAL_DAY_LTC	Calendar day level table
FA_DEPRN_PERIODS	Information about each depreciation period
IGF_AP_RECORD_MATCH_ALL	Holds the person attributes which are to be used for matching new ISIR or Profile record with the existing person
CSI_INSTALL_PARAMETERS	Install Base Application Installation Parameters.
IGF_AP_FA_BASE_H_ALL	This table is obsolete now.
IGF_SL_PE_CITI_MAP	Table storing the OSS and FA data mapping for Citizenship Code
XDP_WI_FA_MAPPING	XDP_WI_FA_MAPPING defines the list of fulfillment actions to be excuted in order to fulfill a work item
IGI_MHC_DEPRN_DETAIL	This table contains the depreciation amounts detailing the backlog components at the distribution line level. Where Modified Historic Cost Accounting is installed, information in this table is used to create depreciation expense journal en
XDP_FMC_AUD_TRAIL_DETS	This table contains the history of the service parameter value change for a faulty order.
IGF_AP_HOUSING_MAP	Housing status mapping between OSS and FA
PA_PROJECT_ASSET_LINES_ALL	Summarized project CIP costs
EGO_MTL_SY_ITEMS_CHG_B	This table is used to store Pending Changes information for the Items
IGF_SE_PAYMENT_INT	This entity is an Interface table that stores the payment details. The external HRMS system will upload data in this table. Later FA process will pick data from this table and upload it into IGF_SE_PAYMENT table.
XDP_FA_DETAILS	XDP_FA_DETAILS contains the runtime FA parameter values.
JG_ZZ_FA_REG_ITF	JG_ZZ_FA_REG_ITF holds data needed for Fixed Assets Register Report
FA_DEPRN_TAX_ENTITIES	FA_DEPRN_TAX_ENTITIES table is used to store company-level information required by Japanese Depreciable Assets Tax Reports.
FA_BOOKS_SUMMARY_T	FA_BOOKS_SUMMARY_T is a temporary table used during processing of impairment transaction.
FA_IMPAIRMENTS	FA_IMPAIRMENTS table stores the Impairment Transaction information.
FA_ADJUSTMENTS_T	FA_ADJUSTMENTS_T is a temporary table used during processing of impairment transaction and Extended Depreciation.
OKL_ASSET_DEPRN_METHODS_UV	User interface view for FA depreciation methods
FA_EXTENDED_DEPRN_V	FA_EXTENDED_DEPRN_V view is used for extended depreciation.
FA_IMPAIRMENTS_MRC_V	FA_IMPAIRMENTS_MRC_V is the MRC view on top of FA_MC_IMPAIRMENTS.
FII_ASSET_CAT_MAJOR_V	This view is based on table FII_FA_CAT_DIMENSIONS. It will contain information about the major category segment of an asset category.
IGI_MHC_TRANSACTION_HEADERS	This table holds additional information required to check if the Modified Historic Cost Accounting processes have been run on each transaction.
CSI_I_ASSETS	Instance Asset Association.
FA_DEPRN_DETAIL_H	Stores the depreciation information originally stored in FA_DEPRN_DETAIL for audit purposes.
FA_DEPRN_SUMMARY_H	Stores the depreciation information originally stored in FA_DEPRN_SUMMARY for audit purposes.
IGF_AP_HOUSING_MAP	Housing status mapping between OSS and FA
JAI_FA_EXEMPTIONS	Stores the Exemptions corresponding to the FA Asset Blocks
FA_GROUP_DEPRN_DETAIL	Redundant - mirrors FA_DEPRN_DETAIL and exists purely to store information returned by the depreciation process. Would usually store depreciation charged to expense accounts identified in the distribution list of an asset - since group ass
FA_MC_ITF_IMPAIRMENTS	FA_MC_ITF_IMPAIRMENTS is the MRC version of FA_ITF_IMPAIRMENTS.
FA_MC_IMPAIRMENTS	FA_MC_IMPAIRMENTS is the MRC version of FA_IMPAIRMENTS.
FA_MASS_RETIREMENTS	FA_MASS_RETIREMENT contains information about your mass retirement and mass reinstatement processes.
XDP_WI_FA_MAPPING_VL	The view XDP_WI_FA_MAPPING_VL defines the list of Fulfillment Actions to be excuted in order to fulfill a given workitem.
AS_IMPORT_INTERFACE	staging table to hold data to be imported
FA_DEPRN_TAX_AUTHORITIES	FA_DEPRN_TAX_AUTHORITIES table is used to store tax-authority-level information required by Japanese Depreciable Assets Tax Reports.
FA_BUDGET_DISTRIBUTION	Capital budget information entered manually or uploaded from the FA_BUDGET_INTERFACE table
FII_GL_BOOK_FA_BOOK_LCV	FII_GL_BOOK_FA_BOOK_LCV is the collection view for FA Book level of GL Book dimension
MTL_SYSTEM_ITEMS_B	Inventory item definitions
FA_LIFE_DERIVATION_INFO	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 was derived. This table is populated through a trigger on FA_TRANSACTION_HEADER table
IGF_AP_IMPORT_SETUP_ALL	Maintains batch import parameters
IGF_SL_PE_CITI_MAP	Table storing the OSS and FA data mapping for Citizenship Code
MTL_SYSTEM_ITEMS_INTERFACE	Inventory Items Open Interface table
MTL_SERIAL_NUMBERS	Serial number definitions
FA_MC_DEPRN_SUMMARY_H	Stores the depreciation information originally stored in FA_MC_DEPRN_SUMMARY for audit purposes.
FA_LIFE_DERIVATION_INFO	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 was derived. This table is populated through a trigger on FA_TRANSACTION_HEADER table
FA_ITF_IMPAIRMENTS	FA_ITF_IMPAIRMENTS table gets populated for any candidate assets to be impaired per the impairment transaction stored in FA_IMPAIRMENTS table.
IGF_SL_PE_CITI_MAP_V	View for the OSS and FA data mapping for Citizenship Code
OKL_ASSET_LINES_ALL_V	View based on fixed asset line in Oracle Contracts for Lease 'LEASE' contracts. Fixed asset line in OKL points to a fixed asset(asset_id) in Oracle FA.Also this view shows asset for loan type of contracts.
XDP_ADAPTER_JOB_QUEUE_V	This view is used as an internal queue table. When the Fulfillment Action(FA) workflow tries to execute a fulfillment procedure(FP) for fulfillment on a fulfillment element(FE), the workflow has to first allocate a free adapter for the t
FA_ITF_IMPAIRMENTS_MRC_V	FA_ITF_IMPAIRMENTS_MRC_V is the MRC view on top of FA_MC_ITF_IMPAIRMENTS.
FII_ASSET_CAT_MINOR_V	This view is based on table FII_FA_CAT_DIMENSIONS. It will contain information about the minor category segment of an asset category.
IGF_SP_STDNT_REL_V	FORM VIEW formed by joining IGF_SP_STDNT_REL MO view, IGF_AW_FUND_MAST view and IGF_AP_FA_BASE_REC. The view holds sponsor student relation details
FII_FA_EXP_F	This is the fact table for the Asset Expense Base Summary extraction program
IGI_MHC_DEPRN_SUMMARY	This table holds additional depreciation information like the Backlog Depreciation figures for an asset.
PA_PROJECT_TYPES_ALL	Implementation-defined project classifications that supply default information and drive some project processing
FA_MC_DEPRN_DETAIL_H	Stores the depreciation information originally stored in FA_MC_DEPRN_DETAIL for audit purposes.
XDP_WI_FA_MAPPING_TL	XDP_WI_FA_MAPPING_TL is the MLS (Multi-Language Support) table for the XDP_WI_FA_MAPPING table
FA_TRANSFER_DETAILS	Information that defines the historic relationship between active FA_BOOKS and FA_DISTRIBUTION_HISTORY rows
FA_DELETED_MASS_ADDITIONS	Invoice information of mass additions you deleted from the FA_MASS_ADDITIONS table using the Delete Mass Additions form
IGI_MHC_LEDGER	This table is an intermediate table. Records are transferred from this table into the GL_INTERFACE and FA_ADJUSTMENT tables after each logical process ie Revaluation , Depreciation. The Extended Revaluation program copies the information af
FA_DEPRN_GROUPS_V1	Adds unplanned depreciation adjustments to fa_deprn_groups_v
HZ_LOCATIONS	Physical addresses
FII_FA_EXP_T	This is the staging table for the Asset Expense Base Summary extraction program
FA_HR_RETIREMENT_DETAILS	Individual retirements made as a result of a mass retirement on an asset hierarchy.
IGI_IAC_DET_BALANCES	Holds distribution level balance information whcih is made up due to Reval Reserve , Operating Account, Backlog.
JA_CN_FA_CATEGORY_GT	The 'JA_CN_FA_CATEGORY_GP' table stores fixed asset category code and fixed asset category name to filter the same asset category.
FA_TAX_REPORT	FA_TAX_REPORT is temporary storage table for TAX PREFERENCE REPORT.
FA_PERIODIC_PRODUCTION	Production information for units of production assets entered manually or uploaded from FA_PRODUCTION_INTERFACE
FA_CASH_GEN_UNITS	FA_CASH_GEN_UNITS table stores the definition of cash generating units per asset book.
OKL_CS_ASSET_LINES_V	View based on fixed asset line in Oracle Contracts for Lease 'LEASE' contracts. Fixed asset line in OKL points to a fixed asset(asset_id) in Oracle FA.Also this view shows asset for loan type of contracts.
CUN_LOCATIONS_V	CUN_LOCATIONS_V is created based on CUN_LOCATIONS table, HR_LOCATIONS view and FA_LOCATIONS_KFV view.
XDP_WI_FA_MAPPING_DISP_V	The view XDP_WI_FA_MAPPING_DISP_V defines the list of Fulfillment Actions to be excuted in order to fulfill a given workitem.
FIIBV_GL_BOOK_FA_BOOK_LCV	FIIBV_GL_BOOK_FA_BOOK_LCV is the base view for FA Book level of GL Book dimension