Results for “ozf_aging_summary_all”
36 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OZF_AGING_SUMMARY_ALL is a Trade Management (OZF) transactional summary table in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the aging summary of Trade Management claims, aggregated by customer and by aging bucket. Rather than holding individual claim lines, the table persists pre-computed bucket totals that support receivables-style aging analysis of trade promotion and claim deductions, allowing aging reports to be rendered without re-aggregating the underlying claim transaction tables at runtime.
The object resides in the OZF schema and is documented as VALID with seven columns in the 12.2.2 physical schema. It is a multi-org table: the presence of ORG_ID identifies it as operating-unit specific, while the _ALL suffix and the SECURITY_GROUP_ID column indicate that records are partitioned by operating unit and secured through the standard Multi-Org / security group model. The Data Vault classification mined heuristically from the foreign key structure is standalone; in Data Vault terms this suggests modeling the object as a satellite (or a denormalized fact) rather than a true hub or link, since its keys are primarily references to dimensions (customer and aging bucket) rather than participating in a shared business-key hub.
Key Information Stored
The table stores a compact set of seven columns, each serving a well-defined role:
CUST_ACCOUNT_ID— the customer account (business key candidate) for whom the aging summary is maintained; foreign key toHZ_CUST_ACCOUNTS.AGING_BUCKET_ID— the aging bucket definition that governs the aging logic; foreign key toAR_AGING_BUCKETS.AGING_BUCKET_LINE_ID— the specific bucket line (age range) within the bucket; foreign key toAR_AGING_BUCKET_LINES_B.BUCKET_SEQUENCE_NUM— the display/ordering sequence of the bucket line, used to present aging columns in the correct order.AMOUNT— the aggregated claim amount falling into the bucket line for the customer.ORG_ID— the operating unit, enforcing multi-org partitioning.SECURITY_GROUP_ID— the security group used for data access control; foreign key toFND_SECURITY_GROUPS.
The metadata does not document a single-column surrogate primary key; the effective business key is the combination of CUST_ACCOUNT_ID, AGING_BUCKET_ID, AGING_BUCKET_LINE_ID, and ORG_ID. The AMOUNT column is the only true measure, making the table a narrow fact-style summary rather than a wide dimension.
Common Use Cases and Queries
Primary uses are aging and exposure reporting for trade claims: outstanding deductions and promotional accruals aged against configurable buckets (for example, Current, 1–30, 31–60, 61–90, 90+). Because the table is pre-aggregated, reporting queries are lightweight compared with joins across the claim transaction tables.
SELECT c.customer_name,
l.bucket_line_name,
s.bucket_sequence_num,
s.amount
FROM ozf_aging_summary_all s
JOIN hz_cust_accounts c ON c.cust_account_id = s.cust_account_id
JOIN ar_aging_bucket_lines_b l
ON l.aging_bucket_line_id = s.aging_bucket_line_id
WHERE s.org_id = :org_id
ORDER BY c.customer_name, s.bucket_sequence_num;
Typical scenarios include: a receivables-style aging report pivoted by bucket line, a customer exposure summary for a given operating unit, and reconciliation of the OZF summary to Trade Management claim totals. Summing AMOUNT grouped by CUST_ACCOUNT_ID yields total aged exposure per customer; grouping by AGING_BUCKET_LINE_ID with BUCKET_SEQUENCE_NUM produces the ordered aging columns. Reporting tools should always filter on ORG_ID and respect SECURITY_GROUP_ID to honor multi-org and data security.
Related Objects
The following objects are directly referenced by the foreign keys documented for OZF_AGING_SUMMARY_ALL and are the most significant for joins:
HZ_CUST_ACCOUNTS— joined viaCUST_ACCOUNT_ID; supplies customer identity for aging reports.AR_AGING_BUCKETS— joined viaAGING_BUCKET_ID; defines the bucket set applied to each customer.AR_AGING_BUCKET_LINES_B— joined viaAGING_BUCKET_LINE_ID; provides individual bucket lines and their ranges.FND_SECURITY_GROUPS— joined viaSECURITY_GROUP_ID; governs access control to the rows.- Trade Management claim tables (OZF claim and claim-line objects) — the source transactions that this summary aggregates and that should be reconciled against the stored amounts.
Because the object is classified as standalone, it does not act as a parent for child tables; it functions as a dependent summary keyed to the customer and aging dimensions.
-
This table stores the aging summary of claims by customer for an aging bucket
-
This table stores the aging summary of claims by customer for an aging bucket
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
eTRM - OZF Tables and Views 12.1.1
Table to store the Market eligibilty for a Offer Worksheet
-
eTRM - OZF Tables and Views 12.2.2
OZF_XREF_MAP table created for SIebel TPM Integration
-
12.2.2 DBA Data 12.2.2
-
eTRM - OZF Tables and Views 12.2.2
OZF_XREF_MAP table created for SIebel TPM Integration
-
eTRM - OZF Tables and Views 12.1.1
Table to store the Market eligibilty for a Offer Worksheet
-
12.1.1 DBA Data 12.1.1