Search Results ar_aging_buckets_u1




Overview
Explore in AI Chat

Overview

AR.AR_AGING_BUCKETS is a Receivables (AR) module table in Oracle E-Business Suite that stores the definitions of aging buckets used to group and report on open receivables transactions. Each row in the table represents a single aging bucket, such as a user-defined bucket like "Old Past Due Items" that groups invoices 180 to 270 days past due. Oracle Receivables relies on AR_AGING_BUCKETS in combination with AR_AGING_BUCKET_LINES_B to drive aging reports and related receivables analytics. The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and the object is documented as VALID in the AR schema in both 12.1.1 and 12.2.2.

From a dimensional modeling perspective, the mined foreign-key relationships show AR_AGING_BUCKETS referenced by multiple dependent tables (AR_AGING_BUCKET_LINES_B, AR_CHARGE_SCHEDULE_HDRS, AR_CHARGE_SCHEDULE_LINES, OZF_AGING_SUMMARY_ALL, AR_CMGT_SETUP_OPTIONS, and OZF_AGING_BUCKET_DATES). This pattern supports a heuristic classification as a hub-leaning entity: the aging bucket is a relatively stable reference concept around which transactional and reporting rows cluster, making it a natural candidate for a hub in a Data Vault model with the dependent tables modeled as links or satellites.

Key Information Stored

The primary key of AR_AGING_BUCKETS is AGING_BUCKET_ID, a mandatory NUMBER(15) surrogate identifier. The unique index AR_AGING_BUCKETS_U1 is defined across (AGING_BUCKET_ID, ZD_EDITION_NAME) and resides in APPS_TS_TX_IDX; this composite key reflects the editioning mechanism introduced in the 12.2 online patching architecture. The most significant business columns include:

  • AGING_BUCKET_ID — Surrogate primary key identifying each aging bucket row.
  • BUCKET_NAME — VARCHAR2(20) name of the aging bucket, the primary user-facing identifier.
  • STATUS — VARCHAR2(30) indicating whether the bucket is Active or Inactive.
  • AGING_TYPE — VARCHAR2(30) lookup code referencing the aging bucket type in AR_LOOKUPS.
  • DESCRIPTION — VARCHAR2(240) free-text description of the bucket.
  • ATTRIBUTE_CATEGORY — VARCHAR2(30) descriptive flexfield structure name.
  • ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield segments available for customer-defined reporting attributes.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard WHO audit columns tracking row creation and modification.
  • ZD_EDITION_NAME — Editioning column supporting the 12.2 online patching edition model.

Common Use Cases and Queries

The primary use case is reporting on open receivables by aging period. A typical configuration query retrieves all active aging buckets and their names:

  • SELECT AGING_BUCKET_ID, BUCKET_NAME, AGING_TYPE, STATUS FROM AR.AR_AGING_BUCKETS WHERE STATUS = 'A';
  • SELECT b.AGING_BUCKET_ID, b.BUCKET_NAME, l.START_DAYS, l.END_DAYS FROM AR.AR_AGING_BUCKETS b, AR.AR_AGING_BUCKET_LINES_B l WHERE b.AGING_BUCKET_ID = l.AGING_BUCKET_ID; — joins the header to its lines to enumerate bucket ranges.
  • Subqueries against AR_AGING_BUCKETS are commonly embedded in custom aging report logic in Oracle Reports or BI Publisher, filtering by AGING_TYPE to select the appropriate bucket set for a given business process.

Because aging buckets are referenced by charge schedules and collections management setup, administrators also query this table to audit which buckets are assigned to specific agreements or collection strategies.

Related Objects

AR_AGING_BUCKETS participates in several documented foreign-key relationships:

  • AR_AGING_BUCKET_LINES_B — Joins on AGING_BUCKET_ID; holds the individual aging lines (date ranges) that make up each bucket.
  • AR_CHARGE_SCHEDULE_HDRS — Joins on AGING_BUCKET_ID; charge schedule headers may reference a bucket.
  • AR_CHARGE_SCHEDULE_LINES — Joins on AGING_BUCKET_ID; charge schedule lines may reference a bucket.
  • AR_CMGT_SETUP_OPTIONS — Joins on AGING_BUCKET_ID; collections management setup options reference a default aging bucket.
  • OZF_AGING_SUMMARY_ALL — Joins on AGING_BUCKET_ID; trade management aging summary records reference the bucket.
  • OZF_AGING_BUCKET_DATES — Joins on AGING_BUCKET_ID; stores date-related aging bucket configuration.
  • AR_LOOKUPS — Logical (non-FK) reference for the AGING_TYPE lookup code.

These dependencies confirm that AR_AGING_BUCKETS is a foundational reference table within the Receivables aging and collections configuration domain.