Search Results cn_interval_types_all_tl_uk

Overview

CN_INTERVAL_TYPES_ALL_TL is the translation-enabled (TL) definition table for Accumulation Calendar Interval Types within the Oracle Incentive Compensation (CN) module. Interval types define the recurring time buckets — such as weekly, monthly, or quarterly periods — against which plan element accumulations are calculated. Because accumulation calendars govern how credits, quota attainments, and commission earnings are aggregated over time, the rows in this table determine the granularity at which compensation formulas accumulate transactional data. The table serves as the multilingual companion to CN_INTERVAL_TYPES_ALL_B, storing the language-specific display name for each interval type definition.

From a Data Vault modeling perspective, the metadata classifies this object heuristically as standalone. This suggests the table functions as a reference or classification hub rather than a transactional link or satellite. In practice, the base (B) table anchors the interval type entity, while this TL table acts as a descriptive attribute satellite carrying the translated NAME values keyed by language, organization, and interval type.

Key Information Stored

The table stores 12 documented columns. The most operationally significant are listed below, distinguishing the surrogate key from business-key candidates.

• INTERVAL_TYPE_ID — Surrogate identifier for the interval type. Combined with ORG_ID and LANGUAGE, it forms the unique business key defined by index CN_INTERVAL_TYPES_ALL_TL_UK and also appears in the U1 index alongside ZD_EDITION_NAME.
• ORG_ID — Multi-org operating unit discriminator; interval types are partitioned by organization for security and reporting isolation.
• NAME — The translated display name of the interval type (for example, "Monthly" or "Weekly"). This is the primary business-facing attribute and is included in the U2 unique index (INTERVAL_TYPE_ID, NAME, ORG_ID, LANGUAGE, ZD_EDITION_NAME).
• LANGUAGE — Language code identifying the translation locale of the NAME value; central to the TL pattern.
• SOURCE_LANG — The language of the source/base record from which this translation derives, supporting the standard EBS MLS translation workflow.
• SECURITY_GROUP_ID — References FND_SECURITY_GROUPS, enforcing row-level access control consistent with the CN module's security model.
• ZD_EDITION_NAME — Editioning artifact used by the EBS online patching (adop) infrastructure in 12.2.x, isolating editioned data during patch cycles.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide the standard WHO-column audit trail for change tracking.

Common Use Cases and Queries

Typical scenarios include joining the TL table to its base table to retrieve the correctly translated interval type name for a given user's session language, and auditing which interval types are configured per operating unit.

A standard translation lookup joins on the shared key columns and filters by the runtime language:

• SELECT b.interval_type_id, t.name, t.language FROM cn_interval_types_all_b b, cn_interval_types_all_tl t WHERE b.interval_type_id = t.interval_type_id AND b.org_id = t.org_id AND t.language = USERENV('LANG') AND t.org_id = :p_org_id;
• Multi-org reporting lists all interval types for an organization ordered by name, returned from the TL table filtered on a single language to avoid duplicate rows.
• Configuration validation queries check that every base interval type has at least one matching TL row per installed language, detecting translation gaps before plan element assignment.
• Security-driven extraction joins SECURITY_GROUP_ID to FND_SECURITY_GROUPS to restrict visibility by responsibility.

Related Objects

The most significant related objects, derived from the documented relationships, include:

• CN_INTERVAL_TYPES_ALL_B — The base table holding language-independent definitions; joined on INTERVAL_TYPE_ID and ORG_ID.
• CN_INTERVAL_TYPES_ALL_TL — The translation table itself, keyed on INTERVAL_TYPE_ID, ORG_ID, and LANGUAGE.
• FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID for access control.
• CN_PLAN_ELEMENTS / CN_PLAN_COMPONENTS — Consume interval types when assigning accumulation calendars to plan elements.
• CN_ACCUMULATION_CALENDARS — Dependent calendar definitions that reference the interval type to define accumulation periods.
• FND_LANGUAGES — Provides valid values for the LANGUAGE and SOURCE_LANG columns.