| layout | default |
|---|---|
| title | OKL Termination Quotes | Oracle EBS SQL Report |
| description | Information on lease termination quotes – Oracle E-Business Suite SQL report |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, OKL, Termination, Quotes, okc_rule_groups_b, okc_rules_b, okl_streams |
| permalink | /OKL%20Termination%20Quotes/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Information on lease termination quotes
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
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, *, 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
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.
| 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/ |
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.
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?"
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.
The report queries the Lease Management quote and contract tables.
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.
- 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").
- 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.
- 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