OZF Offers – 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 offers with their type, status, dates, owner, market eligibility and budget source, and the amounts of the offer checkbook in the offer currency: committed, utilized, earned, paid and unpaid.

Committed is the approved budget requests less the transfers back to the budget. Utilized, Earned and Paid follow the rules of OZF Budget Utilization. The report lists the offers that the Advanced Pricing operating unit security allows: global offers and the offers of the operating units the responsibility can access.

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, Offer Type, Status, Offer Code, Active On

Oracle EBS Tables Used

hr_operating_units, ams_user_statuses_vl, jtf_rs_resource_extns_vl, hz_cust_accounts, hz_parties, hz_cust_site_uses_all, hz_cust_acct_sites_all, ozf_funds_all_vl, ozf_offers, qp_list_headers_vl, ozf_act_budgets, ozf_funds_utilized_all_b, ozf_claims_all, ozf_claim_lines_all, ozf_claim_lines_util_all

Report Categories

Enginatics

OZF Claims and Deductions, OZF Accrual Balance Reconciliation, AR Customer Upload, AR Customers and Sites, ONT Orders and Lines, PPF_WP3_OM_DETAILS, ONT Orders, OZF Budget Utilization, 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_Offers.xml
SQL Source OZF Offers.sql
Full Report on Enginatics www.enginatics.com/reports/ozf-offers/

© Enginatics GmbH