Results for “bucket_sequence_num”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OZF_AGING_BUCKET_DATES is a Trade Management (OZF) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the date values associated with aging bucket day ranges, calculated relative to the system date. Aging buckets are the classifications used in receivables and trade management reporting to group outstanding balances or promotional accruals by how long they have been open (for example, 0–30, 31–60, 61–90 days). This table persists the concrete date boundaries that correspond to each defined bucket range, allowing reports and concurrent programs to resolve a bucket line into an actual start or end date.

The table is owned by the OZF schema and is documented as VALID with seven columns. Its heuristic Data Vault classification is standalone, meaning it is not modeled as a hub, link, or satellite within a dimensional or Data Vault construct. From a modeling perspective, it is best treated as a reference or configuration table that resolves bucket definitions into dated ranges, rather than as a transactional fact or a master entity.

Key Information Stored

• AGING_BUCKET_ID — Foreign key to AR_AGING_BUCKETS. Identifies the aging bucket definition (the parent bucket set) to which the dated line belongs.
• AGING_BUCKET_LINE_ID — Foreign key to AR_AGING_BUCKET_LINES_B. Identifies the specific bucket line (range) within the bucket set.
• BUCKET_DATE — The actual date value computed and stored for the bucket line, derived from the system date and the bucket's day range.
• BUCKET_SEQUENCE_NUM — Ordinal position of the bucket line, used to order the buckets in reports and displays.
• BUCKET_TYPE — Classifies the bucket or its date semantics, distinguishing how the bucket date is interpreted.
• CONDITION_TYPE — Indicates the condition or comparison operator applied to the bucket boundary (for example, less-than, between, or greater-than semantics).
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting Oracle's multi-org / security group access model.

No dedicated surrogate primary key column is enumerated in the documented column list; the effective unique key is the combination of AGING_BUCKET_ID and AGING_BUCKET_LINE_ID. The business-key candidates are therefore AGING_BUCKET_ID, AGING_BUCKET_LINE_ID, and SECURITY_GROUP_ID, which together scope each dated record to a bucket set, a line, and a security group.

Common Use Cases and Queries

Typical usage includes aging analysis reports for trade promotions, deduction and accrual reporting, and reconciliation of dated bucket ranges used by concurrent programs that populate aging data relative to the current system date. A representative query joins the table to its parent bucket and line definitions:

• SELECT abd.aging_bucket_id, abd.aging_bucket_line_id, abd.bucket_date, abd.bucket_sequence_num, abd.bucket_type FROM ozf.ozf_aging_bucket_dates abd WHERE abd.aging_bucket_id = :bucket_id ORDER BY abd.bucket_sequence_num;
• Join to AR_AGING_BUCKETS and AR_AGING_BUCKET_LINES_B on the respective ID columns to obtain bucket names and line ranges for display.
• Filter by BUCKET_TYPE and CONDITION_TYPE to isolate specific comparison semantics when reconstructing bucket logic in custom reports.

Because dates are derived from the system date, reports should be careful to use consistent run-date context; stale rows may reflect a prior calculation date.

Related Objects

• AR_AGING_BUCKETS — joined via AGING_BUCKET_ID; the parent bucket definition.
• AR_AGING_BUCKET_LINES_B — joined via AGING_BUCKET_LINE_ID; the specific bucket range line.
• FND_SECURITY_GROUPS — joined via SECURITY_GROUP_ID; enforce access control scoping.
• AR_AGING_BUCKET_LINES_TL — translated bucket line names, useful for report labels.
• OZF Trade Management aging reports and concurrent programs that reference OZF_AGING_BUCKET_DATES directly or through views.

As a standalone table, it does not act as a hub or link; its dependencies flow outward to the AR aging bucket definitions and inward to the security group model.