OKL Lease Contract Update Upload – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Changes the bill to customer account and bill to site of Lease Management contracts through the Oracle public API okl_contract_pub.update_contract_header - the Bill To of the Lease Contract header.

One row per contract. Enter the Bill To Customer Account, the Bill To Site, or both; everything else on the row is context and is read only. A site that does not belong to the Bill To Customer Account on the row is rejected, so change both together when the account changes too.

A bill to change does not require a rebook: it was verified against Booked, Evergreen, Passed and Incomplete contracts. Rebook remains necessary for the financial terms this upload does not touch.

Run it under a Lease Management responsibility. Under an unrelated responsibility Oracle refuses the update with its own privilege message.

Report Parameters

Upload Mode, Operating Unit, Contract Number, Contract Status, Deal Type, Bill To Customer Account

Oracle EBS Tables Used

okc_k_headers_all_b, okl_k_headers, hr_all_organization_units_vl, okc_statuses_v, hz_cust_accounts, hz_parties, hz_cust_site_uses_all, hz_cust_acct_sites_all, hz_party_sites, hz_locations, mo_glob_org_access_tmp

Report Categories

Enginatics, Upload

OKL Termination Quotes, OKS Service Contract Line Upload, GL Account Distribution Analysis, GL Account Analysis

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
Blitz Report™ XML Import OKL_Lease_Contract_Update_Upload.xml
Full SQL on Enginatics www.enginatics.com/reports/okl-lease-contract-update-upload/

© 2026 Enginatics