Skip to content

README.md

Latest commit

 

History

History
91 lines (67 loc) · 8.51 KB

README.md

File metadata and controls

91 lines (67 loc) · 8.51 KB
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/

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, *, 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

Enginatics

Related Reports

AR Transactions and Lines 11i

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

  1. Quote Retrieval: Selects quotes based on status, date, or customer.
  2. Contract Linkage: Joins to the contract tables to identify the customer and assets.
  3. 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

© 2026 Enginatics