Search Results ar_aging_bucket_lines_tl




Overview
Explore in AI Chat

Overview

AR_AGING_BUCKET_LINES_TL is the translation (multi-lingual support, MLS) table for aging bucket periods in Oracle Receivables. In Oracle EBS 12.1.1 and 12.2.2, MLS allows applications to store and print user-defined descriptive data in multiple languages, so that the same functional record can present translated text to users operating under different language settings. This table stores the translated report headings associated with each aging bucket line, while the language-independent attributes of the bucket line reside in the base table AR_AGING_BUCKET_LINES_B. The _TL suffix confirms this is the translated counterpart, and the presence of both LANGUAGE and SOURCE_LANG is characteristic of Oracle's MLS implementation pattern.

From a data modeling perspective, the ETRM metadata classifies this object heuristically as standalone within its Data Vault classification. This reflects that the translation rows are keyed by the combination of the parent bucket line identifier and language rather than forming an independent hub or link. In practical modeling terms, the object behaves most like a satellite attached to the aging bucket line hub, carrying descriptive and audit attributes partitioned by language.

Key Information Stored

The table's primary key is AR_AGING_BUCKET_LINES_TL_PK, defined on (AGING_BUCKET_LINE_ID, LANGUAGE). A second unique index, AR_AGING_BUCKET_LINES_TL_U1, is defined on (AGING_BUCKET_LINE_ID, LANGUAGE, ZD_EDITION_NAME). The documented schema contains eleven columns.

  • AGING_BUCKET_LINE_ID — surrogate foreign key referencing the base aging bucket line; part of the composite primary key.
  • LANGUAGE — the language code for the translated row; part of the composite primary key and the discriminator for MLS.
  • SOURCE_LANG — indicates the source language of the translation, used by the MLS framework when deriving translated rows.
  • REPORT_HEADING1 — first translated report heading text displayed for the aging bucket.
  • REPORT_HEADING2 — second translated report heading text for the aging bucket.
  • ZD_EDITION_NAME — editioning column used in 12.2 online patching; participates in the U1 unique index.
  • CREATED_BY, CREATION_DATE — standard WHO audit columns recording row creation.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns capturing the most recent modification context.

The business-key candidate (U1) is effectively the parent identifier combined with language and edition, while the surrogate primary key remains the (line, language) pair.

Common Use Cases and Queries

Typical usage centers on reporting and multilingual display of aging bucket headings. Joining the translation table to the base table yields language-specific bucket descriptions:

  • Retrieve translated headings for a given language: SELECT aging_bucket_line_id, report_heading1, report_heading2 FROM ar_aging_bucket_lines_tl WHERE language = USERENV('LANG');
  • Join to the base table to combine language-independent attributes with translated text on AGING_BUCKET_LINE_ID and LANGUAGE.
  • Validate translation coverage using SOURCE_LANG to detect rows lacking translations.
  • Audit changes via LAST_UPDATED_BY and LAST_UPDATE_DATE for compliance reporting.

Related Objects

The most significant related objects include:

  • AR_AGING_BUCKET_LINES_B — base table holding language-independent bucket line data; join on AGING_BUCKET_LINE_ID.
  • AR_AGING_BUCKETS — parent aging bucket definition table.
  • AR_AGING_BUCKETS_TL — translated headers for the bucket definitions.
  • FND_LANGUAGES — reference for valid LANGUAGE and SOURCE_LANG values.
  • FND_TERRITORIES — language and territory context for display.
  • Receivables aging reports and concurrent programs that render bucket headings using MLS.
  • Standard WHO audit views and the AR schema MLS views exposing translated headings.