Results for “claim_type_id”

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

Overview

OZF_CLAIM_TYPES_ALL_TL is the translation (language) table for Claim Types within the Oracle Trade Management (OZF) module of Oracle E-Business Suite. In Oracle EBS, tables suffixed with _TL store the translatable, user-facing text attributes — typically the NAME and DESCRIPTION columns — for each language installed in the application, while the corresponding _B table (OZF_CLAIM_TYPES_ALL_B) holds the language-independent base rows. Claim Types define the categories of trade promotion claims (for example, accruals, deductions, or billbacks) that customers and internal users can raise against trade activities.

From a dimensional modeling perspective, the ETRM metadata classifies this object heuristically as satellite-leaning. This suggests modeling OZF_CLAIM_TYPES_ALL_TL as a satellite table attached to the OZF_CLAIM_TYPES_ALL_B hub, keyed by CLAIM_TYPE_ID and qualified by ORG_ID, LANGUAGE, and the edition context (ZD_EDITION_NAME). It is not a transaction or relationship table; it enriches the base entity with descriptive, locale-specific text.

Key Information Stored

The table comprises 13 documented columns. The most significant are:

• CLAIM_TYPE_ID — The surrogate primary key (OZF_CLAIM_TYPES_ALL_TL_PK) and foreign key to OZF_CLAIM_TYPES_ALL_B. It uniquely identifies the claim type whose translation is stored.
• NAME — The translated, display-facing name of the claim type in the row's language.
• DESCRIPTION — The translated descriptive text elaborating on the claim type's purpose.
• LANGUAGE — The language code identifying which translated text this row contains. It forms part of the unique business key.
• SOURCE_LANG — The language in which the source (typically base) text was originally authored.
• ORG_ID — The operating unit or organization context; part of the unique business-key candidate and used for multi-org data security.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, controlling which security group may access the row.
• ZD_EDITION_NAME — The edition identifier supporting Oracle's edition-based redefinition (EBR), also part of the unique key.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard Oracle who-columns auditing row creation and modification.

The unique index OZF_CLAIM_TYPES_ALL_TL_U1 on (CLAIM_TYPE_ID, ORG_ID, LANGUAGE, ZD_EDITION_NAME) represents the true business key candidate, distinct from the surrogate primary key of CLAIM_TYPE_ID alone. Note that CLAIM_TYPE_ID alone repeats across languages, so queries must always constrain LANGUAGE.

Common Use Cases and Queries

Typical scenarios include resolving a claim type's display name into a user's session language, populating LOVs (list of values) in claim-entry forms, and generating multilingual claims reports. A common join pattern resolves the current-language description:

SELECT b.claim_type_id, t.name, t.description
FROM   ozf_claim_types_all_b b,
       ozf_claim_types_all_tl t
WHERE  b.claim_type_id = t.claim_type_id
AND    t.language = USERENV('LANG')
AND    b.org_id = :p_org_id;

For reporting, analysts frequently filter by a specific language and ORG_ID to render consistent terminology. Multi-language reconciliation queries (grouping by CLAIM_TYPE_ID and counting distinct LANGUAGE) help identify untranslated claim types. Combining with FND_SECURITY_GROUPS supports enforcing security-group visibility. Note that CLAIM_TYPE_ID alone repeats across languages, so queries must always constrain LANGUAGE.

Related Objects

• OZF_CLAIM_TYPES_ALL_B — The base (non-translated) table; joined on CLAIM_TYPE_ID. Every _TL row's parent.
• FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID; governs row-level access.
• OZF_CLAIM_TYPES_ALL_TL itself — Where claim types are consumed in claim headers/claims, referenced via CLAIM_TYPE_ID.
• FND_LANGUAGES — Provides valid values for LANGUAGE and SOURCE_LANG.
• OZF_CLAIM_TYPES_VL — The common EBS translation view that joins _B and _TL for developer convenience.

These relationships confirm OZF_CLAIM_TYPES_ALL_TL functions as a locale-aware descriptive satellite supporting Trade Management claims processing.