Search Results fa_asset_keywords




Overview
Explore in AI Chat

Overview

The FA_ASSET_KEYWORDS table is a core data structure within the Oracle E-Business Suite Fixed Assets (OFA) module. It serves as the repository for all valid asset key flexfield segment combinations. The asset key flexfield is a configurable field that allows organizations to categorize and track assets according to their unique business requirements, such as by department, location, or asset type. This table stores the unique code combination identifier (CCID) for each valid combination of flexfield segment values, acting as the central reference point for asset key information across the Fixed Assets application. Its primary role is to enforce data integrity by ensuring that only predefined and validated key combinations are assigned to assets.

Key Information Stored

The central piece of data stored in this table is the CODE_COMBINATION_ID, which is the primary key column (FA_ASSET_KEYWORDS_PK). This numeric identifier uniquely represents a specific, validated combination of asset key flexfield segment values. While the detailed segment values (like 'HQ-BUILDING-COMPUTER') are stored in the associated flexfields tables, this ID acts as a compact foreign key reference throughout the Fixed Assets schema. The table's structure is intentionally lean, as its main purpose is to provide a validated list of IDs; the descriptive flexfield metadata is managed separately within the Oracle Applications flexfield architecture.

Common Use Cases and Queries

The primary use case for the FA_ASSET_KEYWORDS table is to support the assignment and validation of asset keys during asset creation, mass addition, and reclassification. Reporting and inquiry processes also heavily rely on joining to this table to translate the stored CCID into meaningful business descriptions. A common SQL pattern involves joining this table to asset transaction tables to retrieve the asset key for reporting.

  • Finding the Asset Key for a Specific Asset: SELECT ak.CODE_COMBINATION_ID FROM FA_ADDITIONS_B a, FA_ASSET_KEYWORDS ak WHERE a.ASSET_KEY_CCID = ak.CODE_COMBINATION_ID AND a.ASSET_ID = :p_asset_id;
  • Listing All Valid Asset Key Combinations with Descriptions: This requires joining to the flexfield view FA_ASSET_KEYWORDS# (or using the FND_FLEX_EXT APIs) to decode the segment values stored against the CODE_COMBINATION_ID.

Related Objects

As indicated by the foreign key relationships in the provided metadata, the FA_ASSET_KEYWORDS table is directly referenced by several key transaction tables in the Fixed Assets module. The CODE_COMBINATION_ID links to:

  • FA_ADDITIONS_B: The core asset master table, via the ASSET_KEY_CCID column. This stores the asset key for each capital asset.
  • FA_MASS_ADDITIONS: The table holding data imported from Payables or other sources, via the ASSET_KEY_CCID column, to assign a key before creating an asset.
  • FA_MASS_RECLASS: The table used for mass reclassification transactions, via the ASSET_KEY_ID column, to specify a new asset key for a group of assets.

Effectively, any process that assigns or updates an asset's categorical key interacts with this table to validate the chosen combination.