OKL Termination Quotes – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Information on lease termination quotes
Report Parameters
Operating Unit, Quote Number, Account Number, Customer Name, Quote Status, Quote Type, Creation Date From, Creation Date To, Termination Date From, Termination Date To, Created By, Contract Number, Serial Number, Asset Number, Active Workflow
Oracle EBS Tables Used
okc_rule_groups_b, okc_rules_b, okl_streams, okl_strm_elements, hr_all_organization_units_vl, okl_trx_quotes_all_b, okl_trx_quotes_tl, okl_txl_qte_lines_all_b, okc_k_headers_all_b, okc_k_lines_v, okc_k_lines_b, okl_k_lines, okc_k_items, csi_item_instances, hz_cust_accounts, hz_parties, hz_party_sites, hz_locations, fnd_territories_tl, okl_k_headers, okl_products, select, contract_number, sts_code, ra_customer_trx_all, [](https://www.enginatics.com/library/?pg=1&find=), okl_pools, okc_k_party_roles_b, initcap, start_date, end_date, short_description, qte_id, okc_k_headers_tl, item_key, display_name, display_name, begin_date, error_message, error_stack, text_value, wf_item_activity_statuses, wf_process_activities, wf_activities_tl, wf_activities_vl, wf_items, wf_notification_attributes
Report Categories
Related Reports
Running This SQL Without Blitz Report
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | OKL Termination Quotes 18-Jan-2018 214747.xlsx |
| Blitz Report™ XML Import | OKL_Termination_Quotes.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/okl-termination-quotes/ |
OKL Termination Quotes - Case Study & Technical Analysis
Executive Summary
The OKL Termination Quotes report tracks the lifecycle of lease termination quotes in Oracle Lease Management (OKL). It provides details on quotes generated for customers who wish to end their lease early, including the financial impact (termination amount) and the status of the quote.
Business Challenge
Managing lease terminations is a critical financial process.
- Revenue Recognition: “How much revenue will we recognize from early termination fees this month?”
- Customer Service: “A customer is disputing their termination quote. I need to see the calculation details and who approved it.”
- Workflow Visibility: “We have 50 quotes pending approval. Where are they stuck?”
Solution
The OKL Termination Quotes report lists the quote details.
Key Features:
- Quote Details: Includes Quote Number, Type (Early Termination, End of Term), and Amount.
- Asset Details: Lists the specific assets (Serial Number, Asset Number) included in the quote.
- Workflow Status: Shows the current status of the approval workflow.
Technical Architecture
The report queries the Lease Management quote and contract tables.
Key Tables and Views
OKL_TRX_QUOTES_ALL_B: The header table for termination quotes.OKL_TXL_QTE_LINES_ALL_B: The line details (assets) for the quote.OKC_K_HEADERS_ALL_B: The underlying lease contract.OKL_STREAMS: Financial streams associated with the lease.
Core Logic
- Quote Retrieval: Selects quotes based on status, date, or customer.
- Contract Linkage: Joins to the contract tables to identify the customer and assets.
- Calculation: (Implicitly) The quote amount is calculated by the OKL engine based on the “Termination Rule” defined in the contract (e.g., “Remaining Payments + 5% Penalty”).
Business Impact
- Financial Accuracy: Ensures that termination fees are calculated and billed correctly.
- Process Efficiency: Helps identify bottlenecks in the quote approval process.
- Asset Recovery: Triggers the logistics process for returning the leased assets upon termination.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics