OZF Budgets – 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 budgets with the amounts of the budget checkbook, in the budget currency: original budget, transfers, holdback, planned, committed, available, utilized, earned, paid and unpaid.

Total is the original budget plus transfers in less transfers out. Available is the total less holdback and committed. Unpaid is earned less paid. OZF Budget Utilization lists the accruals, adjustments and payments behind Utilized, Earned and Paid.

Rollup Amounts shows the amounts of each budget including its child budgets, as the rollup view of the budget checkbook. Quotas are not included.

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, Budget Type, Budget Category, Budget Name, Status, Rollup Amounts

Oracle EBS Tables Used

hr_operating_units, ams_categories_vl, ams_user_statuses_vl, ozf_funds_all_vl, jtf_rs_resource_extns_vl, xxen_report_org_access

Report Categories

Enginatics

OZF Claims and Deductions, OZF Offers, OZF Accrual Balance Reconciliation, CN Manual Payment Upload, AR Customer Upload, ONT Orders and Lines, ONT Blanket Sales Agreements, GL Account Distribution Analysis, GL Account Analysis

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_Budgets.xml
SQL Source OZF Budgets.sql
Full Report on Enginatics www.enginatics.com/reports/ozf-budgets/

© Enginatics GmbH