Search Results capital_balance

Overview

OKL_ACCRUAL_OVERRIDE_UV is an APPS-owned database view in the Oracle E-Business Suite Leasing and Finance Management (OKL) module. It consolidates contract-level accrual and override information for lease and finance contracts, joining contract header, product, party, and customer data while invoking several OKL public APIs at query time to derive financial values. The view is intended primarily for reporting and inquiry: it surfaces the calculated receivable value, capital balance, and the generate-accrual-override flag alongside descriptive attributes such as customer name, product name, deal type, and term duration. Because two of its columns are populated by PL/SQL function calls (OKL_GENERATE_ACCRUALS_PUB.CALCULATE_CNTRCT_REC and OKL_LOSS_PROV_PUB.CALCULATE_CAPITAL_BALANCE), the view behaves as a computed reporting layer rather than a simple denormalized join.

Underlying Base Objects

The view is defined over the following documented base objects and packages:

• OKC_K_HEADERS_B (synonym) — the core contract header table, providing contract ID, contract number, currency, authoring organization, and end date. The alias CTR is filtered to status codes APPROVED, BOOKED, UNDER REVISION, and EVERGREEN.
• OKL_K_HEADERS (synonym) — the OKL-specific header extension (alias KHR), supplying deal type, the generate-accrual-override flag, and term duration.
• OKL_PRODUCTS (synonym) — supplies the product name (PDT.NAME) associated with each contract.
• OKC_K_PARTY_ROLES_B (synonym) — the contract party role table (alias PTY), restricted to the LESSEE role, used to resolve the customer party.
• OKX_PARTIES_V (view) — the trading community party view, translated through PTY.OBJECT1_ID1 = OKX.ID1 to yield the customer name.
• OKL_GENERATE_ACCRUALS_PUB (package) — provides CALCULATE_CNTRCT_REC, which computes the RECEIVABLE_VALUE column.
• OKL_LOSS_PROV_PUB (package) — provides CALCULATE_CAPITAL_BALANCE, which computes the CAPITAL_BALANCE column using the contract ID and deal type.
• OKL_ACCOUNTING_UTIL (package) — provides GET_LOOKUP_MEANING, used to translate the deal type and yes/no override flag into their display meanings.

Key Columns

• ID — Contract identifier (CTR.ID); the primary join key across all base tables.
• CONTRACT_NUMBER — Human-readable contract number.
• DEAL_TYPE — OKL book class code for the contract, with DEAL_TYPE_MEANING supplying the decoded lookup value.
• AUTHORING_ORG_ID — Operating unit or authoring organization that owns the contract.
• PRODUCT_NAME / CUSTOMER_NAME — Descriptive product and lessee/customer identifiers.
• CURRENCY_CODE — Contract currency in which the financial amounts are expressed.
• RECEIVABLE_VALUE — Calculated receivable amount for the contract, derived through OKL_GENERATE_ACCRUALS_PUB.CALCULATE_CNTRCT_REC. This is the column most commonly targeted by searches for "receivable_value."
• CAPITAL_BALANCE — Calculated capital balance from OKL_LOSS_PROV_PUB.CALCULATE_CAPITAL_BALANCE.
• GENERATE_ACCRUAL_OVERRIDE_YN / OVERRIDE_YN_MEANING — The override flag and its decoded Yes/No display value.
• END_DATE / TERM_DURATION — Contract end date and lease term length.

Common Use Cases and Queries

Typical uses include auditing accrual override settings across booked contracts, reconciling receivable values against capital balances for loss provisioning, and feeding downstream reporting on lessee-level exposure. A representative query retrieving contract-level financials is:

SELECT contract_number, deal_type_meaning, customer_name, currency_code, receivable_value, capital_balance, override_yn_meaning FROM okl_accrual_override_uv WHERE generate_accrual_override_yn = 'Y';

Because RECEIVABLE_VALUE and CAPITAL_BALANCE are computed by PL/SQL functions invoked once per row, queries returning large contract populations can be resource-intensive; filtering by authoring_org_id, deal_type, or contract status predicates is advisable.