Search Results cn_credit_types_all_tl




Overview
Explore in AI Chat

Overview

CN_CREDIT_TYPES_ALL_TL is a translation (TL) table in the CN (Incentive Compensation) product of Oracle E-Business Suite, holding the language-dependent, user-facing text for credit type definitions. Credit types classify the transactions and revenue that feed incentive compensation calculations, determining how credit is attributed to sales representatives and how quota and commission plans are satisfied. Because credit type names and descriptions must be presented in multiple installed languages, the base definition rows are stored in a companion _B table while all translated attributes reside in this _TL table, linked by CREDIT_TYPE_ID, ORG_ID, and LANGUAGE.

The ETRM metadata classifies this object as standalone under a heuristic Data Vault analysis. From a modeling perspective, this would suggest treating CN_CREDIT_TYPES_ALL_TL as a hub-like entity keyed on the credit type identity, with language-specific descriptive attributes behaving as satellite content. Practically, it is a standard EBS multilingual lookup table and should be queried in conjunction with its _B counterpart or through the _VL view when a single-language presentation is required.

Key Information Stored

The table is physically owned by the CN schema and documented with 12 columns. The most significant are:

  • CREDIT_TYPE_ID — surrogate identifier for the credit type; part of the primary key.
  • ORG_ID — operating unit / organization context; part of the primary key and unique indexes, enforcing multi-org separation.
  • LANGUAGE — the language code for the translated row; part of the primary key.
  • NAME — the translated name of the credit type; a business-key candidate via unique index CN_CREDIT_TYPES_ALL_TL_U2.
  • SOURCE_LANG — the source language from which the translation was derived.
  • SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, governing row-level access.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS WHO columns for audit and concurrency tracking.
  • ZD_EDITION_NAME — editioning column supporting online patching (notably in 12.2.x).

The documented primary key is CN_CREDIT_TYPES_ALL_TL_UK (CREDIT_TYPE_ID, ORG_ID, LANGUAGE). Two unique indexes act as business-key candidates: U1 (CREDIT_TYPE_ID, ORG_ID, LANGUAGE, ZD_EDITION_NAME) and U2 (NAME, ORG_ID, LANGUAGE, ZD_EDITION_NAME). The combination of NAME, ORG_ID, and LANGUAGE in U2 indicates credit type names are unique within an organization and language.

Common Use Cases and Queries

Typical uses include LOV lookups, incentive plan setup validation, multilingual reporting, and reconciliation of translated credit type names against the base table.

  • Retrieve translated credit types for a specific language and org: 
    SELECT credit_type_id, name
FROM   cn_credit_types_all_tl
WHERE  org_id = :p_org_id
AND    language = USERENV('LANG');
  • Detect missing translations by outer-joining base rows to _TL rows and filtering where NAME IS NULL.
  • Confirm uniqueness of credit type names per organization and language using CN_CREDIT_TYPES_ALL_TL_U2.
  • Join to incentive transaction and credit allocation data on CREDIT_TYPE_ID to label analytical reports.
  • Audit recent translation changes through LAST_UPDATED_BY and LAST_UPDATE_DATE.

Related Objects

  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID; restricts visibility of credit type rows.
  • CN_CREDIT_TYPES_ALL_B — base table supplying language-independent definition rows; join on CREDIT_TYPE_ID, ORG_ID.
  • CN_CREDIT_TYPES_ALL_VL — the translated view exposing a single-language row for application queries.
  • CN_CREDIT_TYPES_ALL — synonym or consolidated access object in the CN schema.
  • Credit allocation / transaction tables in CN that carry CREDIT_TYPE_ID to classify creditable events.
  • FND_LANGUAGES — provides valid values for the LANGUAGE column.