Results for “incident_audit_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CS.CS_INCIDENTS_AUDIT_TL is a translation table in the Oracle E-Business Suite Service (CS) module. It stores language-specific audit information associated with service requests (incidents). In Oracle EBS, translation tables (suffixed _TL) hold the user-facing, multilingual text that complements the base transactional records. For CS_INCIDENTS_AUDIT_TL, this means the human-readable audit narrative — such as change descriptions describing what was altered on a service request — is maintained for each supported language.

The table is registered as VALID in the CS schema under the 12.1.1 and 12.2.2 releases, with 11 documented columns in the ETRM 12.2.2 physical schema. Its primary key, CS_INCIDENTS_AUDIT_TL_PK, is composite over (INCIDENT_AUDIT_ID, LANGUAGE), reflecting the standard EBS translation pattern where a single base audit record carries one row per installed language. The metadata classifies the object heuristically as standalone in Data Vault terms. From a modeling standpoint, the table is best treated as a satellite, holding descriptive, language-dependent attributes attached to the parent audit event, rather than functioning as a hub or link.

Key Information Stored

The most significant columns capture both the link back to the base audit record and the translated text itself:

• INCIDENT_AUDIT_ID — Surrogate key component linking to the base audit record; part of both the primary key and unique index.
• LANGUAGE — The language code of the translated row; the second half of the composite primary key.
• SOURCE_LANG — Indicates the language from which the translation originated, supporting EBS multilingual resolution.
• CHANGE_DESCRIPTION — The translated narrative text describing the audit event, the principal business payload of this table.
• INCIDENT_ID — Reference to the service request (incident) to which the audit entry belongs.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS WHO-column audit metadata identifying when and by whom the row was created or modified.
• SECURITY_GROUP_ID — Multi-tenant/security grouping discriminator, referencing FND_SECURITY_GROUPS.

The unique index CS_INCIDENTS_AUDIT_TL_U1 (INCIDENT_AUDIT_ID, LANGUAGE) confirms the business key: one translated row per audit record per language. Note that the primary key and the unique index are defined on the same two columns, so there is no separate surrogate beyond the composite key.

Common Use Cases and Queries

Typical usage centers on resolving audit narratives into the user’s session language and on audit reporting. A common pattern joins the translation table to the base audit record filtered by language:

• Audit trail reporting — listing all change descriptions for a given service request: SELECT a.incident_audit_id, t.change_description FROM cs_incidents_audit a, cs_incidents_audit_tl t WHERE a.incident_audit_id = t.incident_audit_id AND a.incident_id = :incident_id AND t.language = USERENV('LANG');
• Multilingual comparison — retrieving the same audit event across languages using the composite key qualifiers.
• Data migration/quality checks — detecting missing translations by comparing base audit counts against translation counts grouped by language.

Because SOURCE_LANG records provenance, reports can fall back to the base language when a translated row is unavailable.

Related Objects

The object participates in a compact relationship set:

• CS_INCIDENTS_AUDIT (base table) — joined on INCIDENT_AUDIT_ID; supplies the untranslated audit record.
• CS_INCIDENTS — the parent service request referenced via INCIDENT_ID.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID.
• CS_INCIDENTS_AUDIT_TL_PK / _U1 — the primary key and unique index enforcing key integrity.
• FND_LANGUAGES — provides the valid values for LANGUAGE and SOURCE_LANG.

Together these objects support Service request audit tracking and multilingual reporting across Oracle EBS releases 12.1.1 and 12.2.2.