Search Results okl_aging_buckets_uv




Overview
Explore in AI Chat

Overview

OKL_AGING_BUCKETS_UV is an APPS-owned database view within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. It is documented as VALID in ETRM 12.2.2 (and is available in 12.1.1 as well). The view is a filtered access layer over the Receivables aging bucket definitions maintained in the AR_AGING_BUCKETS table. Its purpose is to expose only the active aging bucket configurations that are relevant to lease and finance management processing, reporting, and integration routines. This view is a useful reference object when building custom reports or extensions against lease contracts and associated receivables transactions.

Underlying Base Objects

The view is defined over a single base object: the synonym AR_AGING_BUCKETS, which resolves to the Applications Receivables aging buckets table owned by the AR schema. The view definition is:

SELECT AGING_BUCKET_ID, BUCKET_NAME, STATUS, AGING_TYPE, DESCRIPTION
FROM AR_AGING_BUCKETS
WHERE STATUS = 'A'

The only transformation applied is the filter on STATUS equal to 'A', restricting the result set to active buckets. There is no join, aggregation, or column expression; the view is a projection with a predicate. Because of this simplicity, the view is a thin wrapper, and any change to the underlying AR_AGING_BUCKETS columns is reflected in the view.

Key Columns

  • AGING_BUCKET_ID — Primary identifier of the aging bucket as defined in Receivables. This value is referenced by downstream aging and receivables processes in Lease and Finance Management.
  • BUCKET_NAME — The user-visible name of the aging bucket, such as 0-30 Days, 31-60 Days, etc. It is the label used in aging report output.
  • STATUS — The bucket's enablement status. The view always returns 'A' (Active), so all rows represent currently enabled buckets.
  • AGING_TYPE — Indicates the aging category or method associated with the bucket, distinguishing between aging schemes used by Receivables.
  • DESCRIPTION — Free-text description of the aging bucket as maintained in the Receivables setup.

Common Use Cases and Queries

The view is typically used to obtain the active list of aging buckets for lease-related aging reports, lookup synchronization, and validation logic in custom extensions. A typical query retrieves all active buckets for display in a form or report:

SELECT AGING_BUCKET_ID,
       BUCKET_NAME,
       AGING_TYPE,
       DESCRIPTION
FROM   APPS.OKL_AGING_BUCKETS_UV
ORDER BY AGING_BUCKET_ID;

To resolve a specific bucket name to its identifier for use as a foreign key in a lease aging query:

SELECT AGING_BUCKET_ID, BUCKET_NAME
FROM   APPS.OKL_AGING_BUCKETS_UV
WHERE  BUCKET_NAME = :bucket_name;

Because the view filters out inactive buckets, custom validation can rely on it to confirm that a selected bucket is still valid. Reporting extensions can join this view to lease transaction data on AGING_BUCKET_ID to produce aging summaries grouped by bucket. When building such joins, it should be noted that the view exposes only AR_AGING_BUCKETS columns and no lease-specific attributes; any lease context must be obtained from the OKL tables that reference these bucket identifiers.

Users should also be aware that this is a documentation-only view object; the authoritative aging logic resides in Receivables. Any change to the AR_AGING_BUCKETS definition of active buckets is automatically reflected here, so no separate maintenance is required for the OKL view.