OZF Claims and Deductions – 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 claims, deductions and overpayments with their type, reason, status, customer, amounts, owner, source transaction and settlement.

Days Past Due and Aging Bucket are calculated from the due date as of today, for claims in status New, Open, Complete or Rejected, the claims that Oracle Trade Management ages. Aging Bucket uses the Receivables aging bucket selected in the parameter of the same name. Open Only restricts the report to these claims.

The template Pivot: Aging by Customer shows the accounted remaining amount of the open claims by customer and aging bucket, as the claims aging 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, Claim Class, Status, Open Only, Customer, Claim Date From, Claim Date To, Reason, Aging Bucket

Oracle EBS Tables Used

hr_operating_units, ozf_claim_types_all_vl, ozf_reason_codes_all_vl, ams_user_statuses_vl, hz_cust_site_uses_all, ar_aging_buckets, ar_aging_bucket_lines_b, ar_aging_bucket_lines_tl, jtf_rs_resource_extns_vl, jtf_rs_salesreps, ar_collectors, ozf_claims_all, hz_cust_accounts, hz_parties, xxen_report_org_access

Report Categories

Enginatics

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_Claims_and_Deductions.xml
SQL Source OZF Claims and Deductions.sql
Full Report on Enginatics www.enginatics.com/reports/ozf-claims-and-deductions/

© Enginatics GmbH