Results for “disposition_h_id”

20 results




Overview
Explore in AI Chat

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

Overview

In Oracle E-Business Suite 12.1.1 and 12.2.2, the table AHL.AHL_PRD_DISPOSITIONS_TL_H belongs to the AHL product family, Oracle Complex Maintenance, Repair and Overhaul (CMRO). It is the translation layer of the disposition history model, storing the language-dependent, translatable columns of past disposition records — chiefly descriptive free text such as comments. Oracle's ETRM description states its purpose succinctly: it "stores disposition history's translatable columns."

The suffix conventions are important: _TL denotes a translated table, one row per language, while the _H suffix indicates a history (audit/version) table. The object therefore retains multilingual text for historical disposition versions, allowing older records to display in each installed language for which translated content exists. A heuristic Data Vault classification mined from the foreign-key structure suggests this object behaves as a link table, connecting a disposition history version to its language-specific descriptive content. This is a modeling suggestion rather than a documented Oracle designation.

Key Information Stored

The table is composed of 11 documented columns. The most significant are:

  • DISPOSITION_H_ID — Identifier of the disposition history version being described. It is part of the composite primary key (AHL_PRD_DISPOSITIONS_TL_H_PK) and the foreign key to AHL_PRD_DISPOSITIONS_B_H.
  • LANGUAGE — The language code for the translated row; the second component of the composite primary key and of the source-language pair.
  • SOURCE_LANG — The language in which the text was originally entered, used by the translation framework to determine whether a translation is current.
  • COMMENTS — The translatable descriptive text. This is the primary payload column of the table; in a _TL table it is typically the only user-entered, translatable attribute.
  • DISPOSITION_ID — Foreign key to AHL_PRD_DISPOSITIONS_B, linking the translated row back to the base (non-history) disposition entity.
  • SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting multi-organization/security-group data segregation in the schema.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who last changed the row and when.
  • CREATION_DATE, CREATED_BY — Standard EBS audit columns recording initial row insertion.

The surrogate/business key is the composite (DISPOSITION_H_ID, LANGUAGE). No separate unique business key is documented beyond this primary key. DISPOSITION_H_ID serves as the identifying link to the history record; LANGUAGE qualifies the row.

Common Use Cases and Queries

Typical uses include reporting on disposition history in a user's session language, translation gap analysis, and audit reconstruction of what comments were recorded against a historic disposition version. Because it joins to the history base table and its translation counterpart, standard query patterns are:

  • Retrieve comments for a specific disposition history version: join on DISPOSITION_H_ID and LANGUAGE.
  • Detect missing translations: compare _B_H rows against _TL_H rows by LANGUAGE.
  • Feed descriptive text into CMRO disposition history inquiry or reporting extracts.

A representative pattern: SELECT t.COMMENTS FROM ahl_prd_dispositions_tl_h t WHERE t.disposition_h_id = :p_id AND t.language = USERENV('LANG'); Note that USERENV('LANG') should be mapped to the EBS language code stored in this table.

Related Objects

  • AHL_PRD_DISPOSITIONS_B_H — base history table; joined via DISPOSITION_H_ID.
  • AHL_PRD_DISPOSITIONS_B — base (non-history) disposition entity; joined via DISPOSITION_ID.
  • AHL_PRD_DISPOSITIONS_TL — current (non-history) translation counterpart, the logical sibling of the _H table.
  • FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID for data segregation.
  • FND_LANGUAGES — implicit reference for LANGUAGE/SOURCE_LANG validation.
  • AHL disposition history inquiry/reporting views and CMRO APIs — consume these rows to present disposition history in the user's language.