Search Results ar_aging_bucket_lines_b




Overview
Explore in AI Chat

Overview

The AR_AGING_BUCKET_LINES_B table is a core configuration object within the Oracle Receivables (AR) module of Oracle E-Business Suite, available in both release 12.1.1 and 12.2.2. It stores the individual aging bucket periods that comprise an aging bucket set. Each row represents one discrete bucket — for example, "Current," "1–30 Days," or "31–60 Days" — that Oracle Receivables uses to classify open receivables balances by age when generating aging reports, collection dashboards, and customer account summaries. Because the table is prefixed with _B, it belongs to the standard EBS "_B/_TL" convention: _B holds base, non-translated configuration rows, with any associated translations stored separately. The object resides in the AR schema and is flagged VALID in the ETRM repository.

The metadata's heuristic Data Vault classification describes this table as satellite-leaning. In practice this reflects that it hangs off a parent configuration entity (AR_AGING_BUCKETS) via a foreign key, carrying descriptive attributes about each bucket line — a pattern analogous to a satellite attached to a hub or parent link.

Key Information Stored

The table contains 28 documented columns. The most operationally significant include:

The business-key candidate is captured by the unique index AR_AGING_BUCKET_LINES_B_U1 on (AGING_BUCKET_ID, BUCKET_SEQUENCE_NUM, ZD_EDITION_NAME), ensuring that within a given bucket set (and edition) no two lines share the same sequence number.

Common Use Cases and Queries

Typical scenarios include reviewing bucket definitions during Collections configuration, validating aging report output, and migrating bucket sets between instances. A representative query joins the line table to its parent set:

SELECT l.aging_bucket_line_id, l.aging_bucket_id, l.bucket_sequence_num, l.days_start, l.days_to, l.type FROM ar.ar_aging_bucket_lines_b l WHERE l.aging_bucket_id = :bucket_id ORDER BY l.bucket_sequence_num;

Developers frequently extract the ordered day ranges to reproduce or reconcile the aging logic used by Oracle Receivables reports. Because the DFF attributes are present, custom reporting may reference ATTRIBUTE_CATEGORY and the ATTRIBUTE1..15 columns. In 12.2 environments, queries should account for ZD_EDITION_NAME to avoid returning rows from multiple editions.

Related Objects

  • AR_AGING_BUCKETS — parent table referenced via AR_AGING_BUCKET_LINES_B.AGING_BUCKET_ID.
  • AR_AGING_BUCKETS_TL — translated names for the parent bucket set (where applicable).
  • AR_AGING_BUCKET_LINES_B unique index AR_AGING_BUCKET_LINES_B_U1 and primary key AR_AGING_BUCKET_LINES_B_PK — enforce integrity on the line definitions.
  • AR_AGING_BUCKET_SETS — higher-level grouping that associates bucket sets with collections/aging configurations.

These relationships let administrators and developers trace a single aging bucket line back through its parent set to the aging configuration that drives Receivables reporting behavior.