Search Results apps_ts_tx_idx




Overview
Explore in AI Chat

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.

  • TABLE: FA.FA_ASSET_KEYWORDS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ASSET_KEYWORDS,  object_name:FA_ASSET_KEYWORDS,  status:VALID, 

  • TABLE: IGS.IGS_AD_RECRUITMENTS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AD_RECRUITMENTS,  object_name:IGS_AD_RECRUITMENTS,  status:VALID, 

  • TABLE: AP.AP_INVOICE_DISTS_ARCH 12.2.2

    owner:AP,  object_type:TABLE,  object_name:AP_INVOICE_DISTS_ARCH,  status:VALID, 

  • TABLE: AP.AP_INVOICE_DISTS_ARCH 12.1.1

    owner:AP,  object_type:TABLE,  object_name:AP_INVOICE_DISTS_ARCH,  status:VALID, 

  • TABLE: FA.FA_DISTRIBUTION_HISTORY 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_DISTRIBUTION_HISTORY,  object_name:FA_DISTRIBUTION_HISTORY,  status:VALID, 

  • TABLE: FA.FA_ASSET_KEYWORDS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ASSET_KEYWORDS,  object_name:FA_ASSET_KEYWORDS,  status:VALID, 

  • TABLE: AMW.AMW_FIN_ITEM_ACC_RISK 12.1.1

    owner:AMW,  object_type:TABLE,  fnd_design_data:AMW.AMW_FIN_ITEM_ACC_RISK,  object_name:AMW_FIN_ITEM_ACC_RISK,  status:VALID, 

  • TABLE: ENG.ENG_ENGINEERING_CHANGES 12.2.2

    owner:ENG,  object_type:TABLE,  fnd_design_data:ENG.ENG_ENGINEERING_CHANGES,  object_name:ENG_ENGINEERING_CHANGES,  status:VALID, 

  • TABLE: WSH.WSH_EXCEPTIONS 12.2.2

    owner:WSH,  object_type:TABLE,  fnd_design_data:WSH.WSH_EXCEPTIONS,  object_name:WSH_EXCEPTIONS,  status:VALID, 

  • TABLE: ENG.ENG_ENGINEERING_CHANGES 12.1.1

    owner:ENG,  object_type:TABLE,  fnd_design_data:ENG.ENG_ENGINEERING_CHANGES,  object_name:ENG_ENGINEERING_CHANGES,  status:VALID, 

  • TABLE: HR.PER_ALL_ASSIGNMENTS_F 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.PER_ALL_ASSIGNMENTS_F,  object_name:PER_ALL_ASSIGNMENTS_F,  status:VALID, 

  • TABLE: FA.FA_TRANSACTION_HEADERS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_TRANSACTION_HEADERS,  object_name:FA_TRANSACTION_HEADERS,  status:VALID, 

  • TABLE: APPLSYS.WF_DIG_SIGS 12.2.2

    owner:APPLSYS,  object_type:TABLE,  fnd_design_data:FND.WF_DIG_SIGS,  object_name:WF_DIG_SIGS,  status:VALID, 

  • TABLE: OZF.OZF_FUNDS_UTILIZED_ALL_B 12.1.1

    owner:OZF,  object_type:TABLE,  fnd_design_data:OZF.OZF_FUNDS_UTILIZED_ALL_B,  object_name:OZF_FUNDS_UTILIZED_ALL_B,  status:VALID, 

  • TABLE: APPLSYS.WF_DIG_SIGS 12.1.1

    owner:APPLSYS,  object_type:TABLE,  fnd_design_data:FND.WF_DIG_SIGS,  object_name:WF_DIG_SIGS,  status:VALID, 

  • TABLE: QA.QA_SL_SP_RCV_CRITERIA 12.2.2

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_SL_SP_RCV_CRITERIA,  object_name:QA_SL_SP_RCV_CRITERIA,  status:VALID, 

  • TABLE: PSB.PSB_SET_RELATIONS 12.1.1

    owner:PSB,  object_type:TABLE,  fnd_design_data:PSB.PSB_SET_RELATIONS,  object_name:PSB_SET_RELATIONS,  status:VALID, 

  • TABLE: PO.RCV_SUPPLY 12.2.2

    owner:PO,  object_type:TABLE,  fnd_design_data:PO.RCV_SUPPLY,  object_name:RCV_SUPPLY,  status:VALID, 

  • TABLE: AMW.AMW_FIN_ITEM_ACC_CTRL 12.1.1

    owner:AMW,  object_type:TABLE,  fnd_design_data:AMW.AMW_FIN_ITEM_ACC_CTRL,  object_name:AMW_FIN_ITEM_ACC_CTRL,  status:VALID, 

  • TABLE: PA.PA_DRAFT_REVENUES_ALL 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_DRAFT_REVENUES_ALL,  object_name:PA_DRAFT_REVENUES_ALL,  status:VALID, 

  • TABLE: HR.PER_BUDGET_ELEMENTS 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.PER_BUDGET_ELEMENTS,  object_name:PER_BUDGET_ELEMENTS,  status:VALID, 

  • TABLE: HR.PER_BUDGET_ELEMENTS 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.PER_BUDGET_ELEMENTS,  object_name:PER_BUDGET_ELEMENTS,  status:VALID, 

  • TABLE: OTA.OTA_EVENT_ASSOCIATIONS 12.2.2

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_EVENT_ASSOCIATIONS,  object_name:OTA_EVENT_ASSOCIATIONS,  status:VALID, 

  • TABLE: AP.AP_SUPPLIER_CONTACTS 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_SUPPLIER_CONTACTS,  object_name:AP_SUPPLIER_CONTACTS,  status:VALID, 

  • TABLE: AP.AP_SUPPLIER_CONTACTS 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_SUPPLIER_CONTACTS,  object_name:AP_SUPPLIER_CONTACTS,  status:VALID, 

  • TABLE: FA.FA_LOCATIONS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_LOCATIONS,  object_name:FA_LOCATIONS,  status:VALID, 

  • TABLE: WSH.WSH_EXCEPTIONS 12.1.1

    owner:WSH,  object_type:TABLE,  fnd_design_data:WSH.WSH_EXCEPTIONS,  object_name:WSH_EXCEPTIONS,  status:VALID, 

  • TABLE: JTF.JTF_TERR_VALUES_ALL 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_TERR_VALUES_ALL,  object_name:JTF_TERR_VALUES_ALL,  status:VALID, 

  • TABLE: JTF.JTF_TERR_VALUES_ALL 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_TERR_VALUES_ALL,  object_name:JTF_TERR_VALUES_ALL,  status:VALID, 

  • TABLE: HR.PER_ALL_ASSIGNMENTS_F 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PER.PER_ALL_ASSIGNMENTS_F,  object_name:PER_ALL_ASSIGNMENTS_F,  status:VALID, 

  • TABLE: POS.POS_ACCT_ADDR_REL 12.2.2

    owner:POS,  object_type:TABLE,  fnd_design_data:POS.POS_ACCT_ADDR_REL,  object_name:POS_ACCT_ADDR_REL,  status:VALID, 

  • TABLE: POS.POS_ACCT_ADDR_REL 12.1.1

    owner:POS,  object_type:TABLE,  object_name:POS_ACCT_ADDR_REL,  status:VALID, 

  • TABLE: OKL.OKL_TRX_ACCT_OPTS_ALL 12.2.2

    owner:OKL,  object_type:TABLE,  fnd_design_data:OKL.OKL_TRX_ACCT_OPTS_ALL,  object_name:OKL_TRX_ACCT_OPTS_ALL,  status:VALID, 

  • TABLE: PA.PA_BILL_RATES_ALL 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_BILL_RATES_ALL,  object_name:PA_BILL_RATES_ALL,  status:VALID, 

  • TABLE: ENG.ENG_CHANGE_LINES_EXT 12.1.1

    owner:ENG,  object_type:TABLE,  fnd_design_data:ENG.ENG_CHANGE_LINES_EXT,  object_name:ENG_CHANGE_LINES_EXT,  status:VALID, 

  • TABLE: ENG.ENG_CHANGES_EXT 12.2.2

    owner:ENG,  object_type:TABLE,  fnd_design_data:ENG.ENG_CHANGES_EXT,  object_name:ENG_CHANGES_EXT,  status:VALID, 

  • TABLE: ONT.OE_DROP_SHIP_SOURCES 12.1.1

    owner:ONT,  object_type:TABLE,  fnd_design_data:ONT.OE_DROP_SHIP_SOURCES,  object_name:OE_DROP_SHIP_SOURCES,  status:VALID, 

  • TABLE: IGS.IGS_AD_CAL_CONF 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AD_CAL_CONF,  object_name:IGS_AD_CAL_CONF,  status:VALID, 

  • TABLE: OKL.OKL_TRX_ACCT_OPTS_ALL 12.1.1

    owner:OKL,  object_type:TABLE,  fnd_design_data:OKL.OKL_TRX_ACCT_OPTS_ALL,  object_name:OKL_TRX_ACCT_OPTS_ALL,  status:VALID, 

  • TABLE: QA.QA_SL_SP_RCV_CRITERIA 12.1.1

    owner:QA,  object_type:TABLE,  fnd_design_data:QA.QA_SL_SP_RCV_CRITERIA,  object_name:QA_SL_SP_RCV_CRITERIA,  status:VALID, 

  • TABLE: OSM.AS_SALES_CREDITS_DENORM 12.1.1

    owner:OSM,  object_type:TABLE,  fnd_design_data:AS.AS_SALES_CREDITS_DENORM,  object_name:AS_SALES_CREDITS_DENORM,  status:VALID, 

  • TABLE: OZF.OZF_FUNDS_UTILIZED_ALL_B 12.2.2

    owner:OZF,  object_type:TABLE,  fnd_design_data:OZF.OZF_FUNDS_UTILIZED_ALL_B,  object_name:OZF_FUNDS_UTILIZED_ALL_B,  status:VALID, 

  • TABLE: ASO.ASO_QUOTE_HEADERS_ALL 12.2.2

    owner:ASO,  object_type:TABLE,  fnd_design_data:ASO.ASO_QUOTE_HEADERS_ALL,  object_name:ASO_QUOTE_HEADERS_ALL,  status:VALID, 

  • TABLE: AP.AP_POL_LOCATIONS_B 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_POL_LOCATIONS_B,  object_name:AP_POL_LOCATIONS_B,  status:VALID, 

  • TABLE: JA.JAI_AP_TDS_F16_HDRS_ALL 12.2.2

    owner:JA,  object_type:TABLE,  fnd_design_data:JA.JAI_AP_TDS_F16_HDRS_ALL,  object_name:JAI_AP_TDS_F16_HDRS_ALL,  status:VALID, 

  • TABLE: PSP.PSP_ENC_LINES_HISTORY 12.1.1

    owner:PSP,  object_type:TABLE,  fnd_design_data:PSP.PSP_ENC_LINES_HISTORY,  object_name:PSP_ENC_LINES_HISTORY,  status:VALID, 

  • TABLE: PO.RCV_SUPPLY 12.1.1

    owner:PO,  object_type:TABLE,  fnd_design_data:PO.RCV_SUPPLY,  object_name:RCV_SUPPLY,  status:VALID, 

  • TABLE: OTA.OTA_EVENT_ASSOCIATIONS 12.1.1

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_EVENT_ASSOCIATIONS,  object_name:OTA_EVENT_ASSOCIATIONS,  status:VALID, 

  • TABLE: JTF.JTF_TTY_NAMED_ACCTS 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_TTY_NAMED_ACCTS,  object_name:JTF_TTY_NAMED_ACCTS,  status:VALID, 

  • TABLE: BEN.BEN_ELIG_PER_ELCTBL_CHC 12.2.2

    owner:BEN,  object_type:TABLE,  fnd_design_data:BEN.BEN_ELIG_PER_ELCTBL_CHC,  object_name:BEN_ELIG_PER_ELCTBL_CHC,  status:VALID,