Search Results audit_column_id

Overview

The CSS_DEF_AUDIT_COLUMNS_TL table is a translation table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It is part of the now-obsolete CSS (Support) product module. Its primary role is to store language-specific, translatable descriptions for audit column definitions. This table enables the support application to present audit-related column names and descriptions in the language of the end-user, supporting the multi-language capabilities of the EBS platform. As indicated by the 'TL' suffix, it follows the standard Oracle Applications pattern for translatable entities. Notably, the provided ETRM metadata states this table is "Not implemented in this database," suggesting it may be a legacy or reference object not physically instantiated in all deployments.

Key Information Stored

The table stores user-facing textual data for audit column definitions. The key columns, as defined by its primary key constraint CSS_DEF_AUDIT_COLUMNS_TL_PK, are AUDIT_COLUMN_ID and LANGUAGE. The AUDIT_COLUMN_ID is a foreign key that links to the base definition table, uniquely identifying the audit column being described. The LANGUAGE column holds the ISO code for the translation language (e.g., 'US' for American English). While the specific column list is not fully detailed in the excerpt, a standard TL table structure typically includes columns such as SOURCE_LANG, DESCRIPTION, and LAST_UPDATE_LOGIN. The core translatable content would be held in a column like DESCRIPTION or USER_COLUMN_NAME, providing the human-readable label for the audit column in the specified language.

Common Use Cases and Queries

The primary use case is retrieving localized audit metadata for user interfaces or reports. A common query would join this table to its base table (likely named CSS_DEF_AUDIT_COLUMNS_B) to fetch descriptions in a session's current language. For example, an application might use a query structured as: SELECT tl.description FROM css_def_audit_columns_tl tl WHERE tl.audit_column_id = :1 AND tl.language = userenv('LANG'). In reporting scenarios, analysts might query this table to understand all available translations for audit trail columns. However, given the module's obsolete status and the note that the table is not implemented, direct operational use in active customizations or reports is unlikely in standard deployments.

Related Objects

Based on the primary key and standard EBS design patterns, this table has defined relationships with at least two key objects:

• CSS_DEF_AUDIT_COLUMNS_B: This is the base table. The AUDIT_COLUMN_ID column in CSS_DEF_AUDIT_COLUMNS_TL is a foreign key referencing the primary key (presumably AUDIT_COLUMN_ID) in this base table. The base table holds the non-translatable, operational definition of the audit column.
• FND_LANGUAGES: Although not explicitly listed, the LANGUAGE column typically has an integrity relationship with the FND_LANGUAGES table, which contains the list of installed languages within the EBS instance.

The relationship is strictly defined by the primary key constraint (CSS_DEF_AUDIT_COLUMNS_TL_PK) on the combination of AUDIT_COLUMN_ID and LANGUAGE.