OZF Accrual Balance Reconciliation – 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 accrual balance by offer and customer for a range of GL periods: the opening balance, then the accruals, accrual adjustments and paid amounts of each period, in the ledger currency of the operating unit.

Accrual and Adjustment are the offer accruals and accrual adjustments by their GL date. Paid is the earnings paid by closed claims, by the claim’s GL date and at the accrual’s exchange rate, and is shown negative. Accruals and adjustments that are not posted to GL and claims that are not closed are not included.

The opening balance is the total of all three before the first period, so the opening balance plus the period amounts is the balance at the end of Period To.

The templates Pivot: by Offer and Pivot: by Customer list offers or customers against periods; their Grand Total column is the closing balance.

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, Period From, Period To, Offer Code, Customer

Oracle EBS Tables Used

ams_user_statuses_vl, ozf_funds_all_vl, gl_periods, hr_operating_units, gl_ledgers, xxen_report_org_access, ozf_funds_utilized_all_b, ozf_claims_all, ozf_claim_lines_all, ozf_claim_lines_util_all, ozf_offers, qp_list_headers_tl, hz_cust_accounts, hz_parties

Report Categories

Enginatics, R12 only

OZF Offers, OZF Budget Utilization, OZF Claims and Deductions, OZF Budgets, XLA Entity ID Mappings, CAC Inventory and Intransit Value (Period-End) - Discrete/OPM, CAC Inventory Lot and Locator OPM Value (Period-End)

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_Accrual_Balance_Reconciliation.xml
SQL Source OZF Accrual Balance Reconciliation.sql
Full Report on Enginatics www.enginatics.com/reports/ozf-accrual-balance-reconciliation/

© Enginatics GmbH