Search Results ar_cons_bill_cycles_tl




Overview
Explore in AI Chat

Overview

AR_CONS_BILL_CYCLES_TL is the multilingual support (MLS) table for billing cycles defined in Oracle Receivables. Every billing cycle maintained in the base table AR_CONS_BILL_CYCLES has one or more corresponding translation rows in this table, one per installed language. The "_TL" suffix follows the standard Oracle EBS MLS convention: translatable descriptive attributes—here CYCLE_NAME and DESCRIPTION—are stored in the translation table rather than the base table, allowing the same billing cycle definition to be presented in the language of each user's session. The object is owned by the AR schema, holds VALID status, and is available in both EBS 12.1.1 and 12.2.2, with the 12.2.2 edition adding the ZD_EDITION_NAME column used for edition-based redefinition support.

The ETRM metadata classifies this object heuristically as standalone within a Data Vault model, meaning it is not treated as a hub, link, or satellite by the mined foreign-key structure. As a modeling suggestion, however, the composite key of BILLING_CYCLE_ID plus LANGUAGE and the presence of descriptive, language-dependent attributes make it behave naturally as a satellite attached to the billing cycle hub, with LANGUAGE acting as a descriptive discriminator.

Key Information Stored

The table contains 12 documented columns. The most significant are:

  • BILLING_CYCLE_ID — Surrogate identifier of the parent billing cycle; part of the composite primary key and the join back to AR_CONS_BILL_CYCLES.
  • LANGUAGE — The installed language code for the translation row; the second component of the primary key.
  • CYCLE_NAME — The translated, user-facing name of the billing cycle.
  • DESCRIPTION — The translated description of the billing cycle.
  • SOURCE_LANG — The language in which the row was originally entered, used by MLS tooling to track translation origin.
  • OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Forms/ADF framework during concurrent updates.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS who-columns providing audit history for each translation row.
  • ZD_EDITION_NAME — Editioning column introduced for 12.2 online patching, present in the documented 12.2.2 physical schema.

The primary key is AR_CONS_BILL_CYCLES_TL_PK on (BILLING_CYCLE_ID, LANGUAGE). A unique index, AR_CONS_BILL_CYCLES_TL_U1 on (BILLING_CYCLE_ID, LANGUAGE, ZD_EDITION_NAME), serves as the business-key candidate aligned to the 12.2 editioning model.

Common Use Cases and Queries

Typical usage is to resolve the display name and description of a billing cycle in the user's session language. A common pattern joins the translation table to the base table and filters by language:

  • Lookup by cycle name — SELECT billing_cycle_id, cycle_name FROM ar_cons_bill_cycles_tl WHERE cycle_name = :name AND language = USERENV('LANG').
  • Fallback translation — query all languages for a given BILLING_CYCLE_ID to find an available translation when the session language row is missing.
  • Reporting — join AR_CONS_BILL_CYCLES to AR_CONS_BILL_CYCLES_TL on BILLING_CYCLE_ID and LANGUAGE to print cycle names on consolidated billing output.
  • Data validation — use AR_CONS_BILL_CYCLES_TL_U1 to detect duplicate or missing translations across languages.

When writing queries, restrict LANGUAGE explicitly to avoid returning multiple rows per cycle, and account for SOURCE_LANG to understand original-entry language.

Related Objects

  • AR_CONS_BILL_CYCLES — Base table; join on BILLING_CYCLE_ID. Holds non-translated attributes.
  • AR_CONS_BILL_CYCLES_VL — MLS view exposing translated and base columns for the current language.
  • AR_CONS_BILL_CYCLES_B / AR_CONS_BILL_CYCLES_TL — The standard _B/_TL pair underpinning the VL view.
  • AR_CONS_BILL_CYCLES_TL_PK / AR_CONS_BILL_CYCLES_TL_U1 — Primary key and unique index governing row identity.
  • FND_LANGUAGES — Reference for the LANGUAGE column values.
  • AR_BILLING_CYCLES API / Receivables forms — PL/SQL and Forms components that insert and maintain translation rows.