Search Results css_def_audit_history_tl

Overview

The CSS_DEF_AUDIT_HISTORY_TL table is a translation table within the obsolete Oracle E-Business Suite CSS (Support) module. Its primary function is to store language-specific, translatable text for audit history records, enabling multilingual support for audit trail descriptions or comments. As a Translation (TL) table, it works in conjunction with a base table, typically named CSS_DEF_AUDIT_HISTORY_B, where the non-translatable columns are stored. The ETRM metadata explicitly states this table is "Not implemented in this database," indicating it was defined in the application data model but is not present in a standard installation of Oracle EBS 12.1.1 or 12.2.2. Its role, had it been implemented, would have been to support the internationalization of audit history data within the now-obsolete Support module.

Key Information Stored

The table's structure is designed to hold translated text linked to a specific audit record and language. Based on the provided primary key definition, the two critical columns are AUDIT_HISTORY_ID and LANGUAGE. The AUDIT_HISTORY_ID is a foreign key that links each row to its corresponding master audit record in the base table. The LANGUAGE column stores the language code (e.g., 'US' for American English) for the translation. While the specific translatable columns are not listed in the excerpt, typical TL tables include columns such as DESCRIPTION, COMMENTS, or REASON_TEXT to hold the user-facing text that varies by language. Each unique combination of AUDIT_HISTORY_ID and LANGUAGE constitutes a single translated record, as enforced by the primary key constraint CSS_DEF_AUDIT_HISTORY_TL_PK.

Common Use Cases and Queries

Given its unimplemented status, direct operational use cases are non-existent in standard EBS deployments. However, from a design pattern perspective, queries would typically involve joining this table to its base table to retrieve audit history information in a user's session language. A standard query pattern would be:

• Retrieving translated descriptions for a specific audit history ID in the current session language: SELECT t.translated_description FROM css_def_audit_history_b b, css_def_audit_history_tl t WHERE b.audit_history_id = t.audit_history_id AND t.language = USERENV('LANG') AND b.audit_history_id = :id;
• Reporting on all available translations for a set of audit records.

Any attempt to query this table in a standard instance will result in an "object does not exist" error, confirming the ETRM notation.

Related Objects

The primary related object is the base table CSS_DEF_AUDIT_HISTORY_B, to which this TL table holds a foreign key relationship via the AUDIT_HISTORY_ID column. This is a standard EBS architecture pattern where the '_B' suffix denotes the base table and '_TL' denotes its translation. The primary key constraint, CSS_DEF_AUDIT_HISTORY_TL_PK, explicitly defines the relationship and ensures data integrity between these entities. Other objects, such as views or application programming interfaces (APIs) for the Support module, would likely have referenced this translation table to serve multilingual content, though they are also presumably unimplemented. No other foreign key relationships are documented in the provided metadata.