Search Results fa_asset_keywords_u1

Overview

The FA_ASSET_KEYWORDS table is a core reference table within the Oracle E-Business Suite Fixed Assets (FA) module, versions 12.1.1 and 12.2.2. It functions as a cross-reference or mapping table between asset-specific natural account segments and their corresponding General Ledger (GL) code combination IDs. Its primary role is to enable the system to correctly identify and post depreciation expense, accumulated depreciation, and asset cost accounts based on the descriptive keywords (segments) assigned to an asset. This table is essential for ensuring accurate and automated accounting entries for fixed asset transactions, linking asset characteristics to the chart of accounts.

Key Information Stored

The table's structure is defined by two distinct column groups. The first group consists of the SEGMENT1 through SEGMENT10 columns, which store the natural account segment values (keywords) used to describe an asset's accounting classification. The second, and most critical, column is CODE_COMBINATION_ID, which stores the unique identifier for the fully qualified accounting flexfield combination in GL. This ID directly links the asset keywords to a specific GL account. Control columns such as ENABLED_FLAG, START_DATE_ACTIVE, and END_DATE_ACTIVE manage the validity and effective dating of these mappings. Standard WHO columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) track audit information. As per the provided metadata, all indexes for this table reside in the APPS_TS_TX_IDX tablespace, including a unique index on CODE_COMBINATION_ID (FA_ASSET_KEYWORDS_U1) and non-unique indexes on each individual segment column to optimize query performance.

Common Use Cases and Queries

The primary use case is the system's internal resolution of an asset's accounting flexfield during journal generation. When depreciation is calculated, the Fixed Assets engine uses the asset's assigned keyword segments to look up the correct CODE_COMBINATION_ID from this table. Common queries involve validating mappings and troubleshooting posting issues. A fundamental query retrieves the full mapping for analysis:

SELECT CODE_COMBINATION_ID, SEGMENT1, SEGMENT2, SEGMENT3 FROM FA.FA_ASSET_KEYWORDS WHERE ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE);

Another typical pattern is finding the GL account for a specific set of keywords, or conversely, identifying which keyword combination is linked to a known code combination ID. Reporting use cases often involve joining this table to FA_ASSET_KEYWORDS_DENORM or directly to transaction tables to verify the accounting paths used for asset postings.

Related Objects

As indicated in the dependency metadata, the FA_ASSET_KEYWORDS table is a referenced object with a key relationship to the APPS.FA_ASSET_KEY synonym. This synonym is the primary access point for the underlying table within the EBS application code. The table's central purpose is to support the Fixed Assets accounting engine; therefore, it is intrinsically linked to core FA transaction tables and the GL_INTERFACE table where journal lines are staged. Its design, featuring segment columns, aligns it with the descriptive flexfield and keyword functionality used throughout the FA module to define asset categories and their corresponding accounting rules.