OZF Budget Utilization – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Trade Management · all Trade Management reports

Overview

Trade Management budget utilization lines, as the utilized, earned and paid checkbooks of a budget: offer accruals, accrual adjustments, off-invoice discounts, chargebacks and referral accruals, with the customer, product and order or transaction they come from.

Utilized, Earned, Paid and Unpaid are in the budget currency. Earned excludes lines that are not posted to GL. Paid is the amount settled by closed claims, or for an off-invoice discount the discount itself, and Unpaid is earned less paid. The accounted columns show the same in the ledger currency, with Paid at the exchange rate of the accrual.

The totals by budget agree with the Utilized, Earned and Paid amounts of OZF Budgets. The template Pivot: by Customer lists the earned, paid and unpaid amounts by customer and offer, as the promotional payments view.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Operating Unit, GL Date From, GL Date To, Budget Name, Offer Code, Customer, Utilization Type

Oracle EBS Tables Used

hr_operating_units, ozf_claim_types_all_vl, hz_cust_site_uses_all, mtl_categories_kfv, oe_order_headers_all, oe_order_lines_all, ra_customer_trx_all, gl_ledgers, ozf_funds_utilized_all_b, ozf_funds_all_vl, ozf_offers, qp_list_headers_tl, hz_cust_accounts, hz_parties, oe_sys_parameters_all, mtl_system_items_vl, ozf_claims_all, ozf_claim_lines_all, ozf_claim_lines_util_all, xxen_report_org_access

Report Categories

Enginatics, R12 only

OZF Offers, OZF Accrual Balance Reconciliation, GL Account Analysis, GL Account Analysis (Drilldown) (with inventory and WIP), GL Account Distribution Analysis, AR Customer Upload, AR Transactions and Lines, AR Transaction Upload, AR Transactions and Lines 11i

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output Example
Blitz Report™ XML Import OZF_Budget_Utilization.xml
SQL Source OZF Budget Utilization.sql
Full Report on Enginatics www.enginatics.com/reports/ozf-budget-utilization/

© Enginatics GmbH