Oracle EBS Trade Management Reports

5 ready-to-run SQL reports for Oracle E-Business Suite Trade Management, maintained by Enginatics and used in production at Oracle EBS customers worldwide. Each report page lists its parameters, the Oracle EBS tables it reads and an Excel example output. The most frequently used Trade Management tables in these reports are hr_operating_units, ams_user_statuses_vl, ozf_funds_all_vl, xxen_report_org_access, ozf_claims_all, hz_cust_accounts.

Run any of these reports in Excel in seconds: download Blitz Report™ free – your first 30 reports are free.

Trade Management SQL Reports

Report Description
OZF Accrual Balance Reconciliation Trade Management accrual balance by offer and customer for a range of GL periods: the opening balance, then the accruals, accrual adjustments and paid amounts…
OZF Budget Utilization Trade Management budget utilization lines, as the utilized, earned and paid checkbooks of a budget: offer accruals, accrual adjustments, off-invoice discounts…
OZF Budgets Trade Management budgets with the amounts of the budget checkbook, in the budget currency: original budget, transfers, holdback, planned, committed, available…
OZF Claims and Deductions Trade Management claims, deductions and overpayments with their type, reason, status, customer, amounts, owner, source transaction and settlement. Days Past…
OZF Offers Trade Management offers with their type, status, dates, owner, market eligibility and budget source, and the amounts of the offer checkbook in the offer…

← All Oracle EBS modules

© Enginatics GmbH