Search Results oks_billing_profiles_tl




Overview
Explore in AI Chat

Overview

OKS_BILLING_PROFILES_TL is the translation (language) table for the base Service Contracts entity OKS_BILLING_PROFILES in Oracle E-Business Suite 12.1.1 and 12.2.2. Billing profiles in the OKS (Service Contracts) module define how a service contract or subscription is priced, invoiced, and renewed — including billing frequency, invoice text, and instructions shown to users. Because these descriptive elements are user-facing, Oracle stores them in a multilanguage-enabled design: the base table OKS_BILLING_PROFILES holds language-independent attributes, while this _TL table holds the translatable text, one row per profile per installed language.

From a Data Vault modeling perspective, the metadata classifies this object heuristically as standalone. In Data Vault terms it is best viewed as a satellite attached to the billing-profile hub, holding descriptive, language-dependent attributes. Its composite primary key (ID, LANGUAGE) reinforces this role: ID identifies the parent profile, and LANGUAGE qualifies the specific translation row.

Key Information Stored

The table contains 13 documented columns. The most important are:

  • ID — Surrogate identifier of the parent billing profile in OKS_BILLING_PROFILES. Part of the composite primary key and the primary join column back to the base table.
  • LANGUAGE — The language code for the translation row. Together with ID it forms the unique business key OKS_BILLING_PROFILES_TL_U1 and part of the primary key OKS_BILLING_PROFILES_TL_PK.
  • SOURCE_LANG — The language in which the source record was originally created; used by Oracle's translation framework.
  • SFWT_FLAG — The "seed/flexfield" style flag used by the multilanguage translation infrastructure to indicate translation status.
  • DESCRIPTION — The translated name/description of the billing profile presented to users.
  • INSTRUCTIONS — Translated instructional text associated with the billing profile.
  • MESSAGE — Translated message text displayed in the context of the billing profile.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle "who columns" auditing the creation and modification of each translation row.
  • SECURITY_GROUP_ID — Multi-org/security grouping attribute, with a documented foreign key to FND_SECURITY_GROUPS.

The surrogate-level identity is ID; the business-key candidate is the combination (ID, LANGUAGE), enforced by the unique index OKS_BILLING_PROFILES_TL_U1.

Common Use Cases and Queries

Typical usage centers on reporting and joining translated text to the base profile. A common pattern joins ID back to OKS_BILLING_PROFILES and filters to the session or target language:

  • Retrieving the localized description for a profile: SELECT t.description FROM oks_billing_profiles_tl t WHERE t.id = :profile_id AND t.language = USERENV('LANG');
  • Building multilingual lookup reports using FND_LANGUAGES to map LANGUAGE to the installed language name.
  • Detecting missing translations by comparing profile IDs in the base table against existing rows for a given LANGUAGE.
  • Auditing translation hygiene via LAST_UPDATED_BY and LAST_UPDATE_DATE, or checking SFWT_FLAG to confirm translation seeding status.
  • Reporting supported by SECURITY_GROUP_ID joins to FND_SECURITY_GROUPS for secured reporting scenarios.

Because the _TL pattern is standard across EBS, the queries resemble those used for other translation tables, always keying on ID plus LANGUAGE.

Related Objects

  • OKS_BILLING_PROFILES — The base table. Join via ID = ID (translation table ID references the base profile).
  • FND_SECURITY_GROUPS — Referenced by the SECURITY_GROUP_ID foreign key for security grouping.
  • FND_LANGUAGES — Provides the installed and enabled language list corresponding to LANGUAGE values.
  • OKS_BILLING_PROFILES_TL_U1 / OKS_BILLING_PROFILES_TL_PK — The unique index and primary key enforcing (ID, LANGUAGE) integrity.
  • Service Contracts billing and invoicing APIs — OKS billing routines consume profile text when generating invoices and renewal documentation.

In summary, OKS_BILLING_PROFILES_TL functions as a language satellite to the billing-profile hub, holding translatable DESCRIPTION, INSTRUCTIONS, and MESSAGE text keyed by (ID, LANGUAGE), with standard EBS audit and security columns.