Results for “okl_book_class”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.OKL_ACCRUAL_OVERRIDE_UV is a reporting view in the Oracle E-Business Suite Lease and Finance Management (formerly Oracle Leasing / OKL) module. It consolidates lease contract header data with lessee party information, product details, and calculated accrual figures so that users can review and manage accrual override settings at the contract level. The view exposes a mix of stored attributes (contract number, deal type, currency, term duration, end date) and runtime-derived values (receivable value, capital balance), making it suitable for both operational inquiry and downstream reporting or integration.

Its primary role is to support the accrual override process: lease contracts normally generate accruals automatically, but a contract may be flagged to suppress or override this behavior. This view surfaces the GENERATE_ACCRUAL_OVERRIDE_YN flag along with translated meanings, allowing accounting users to identify which contracts carry overrides and to assess the associated financial exposure. For users searching on okl_book_class, the relevant point is the DEAL_TYPE column and its derived DEAL_TYPE_MEANING, which resolves the deal type against the OKL_BOOK_CLASS lookup.

Underlying Base Objects

The view is defined over the following documented base objects:

• OKC_K_HEADERS_B (synonym) — the core contract header table, aliased as CTR. It supplies contract ID, contract number, authoring organization, currency, status, and end date.
• OKL_K_HEADERS (synonym) — the OKL-specific header extension, aliased as KHR. It contributes deal type, accrual override flag, and term duration.
• OKL_PRODUCTS (synonym) — aliased as PDT; provides the product name.
• OKC_K_PARTY_ROLES_B (synonym) — aliased as PTY; filtered to the LESSEE role to link the contract to its customer.
• OKX_PARTIES_V (view) — aliased as OKX; supplies the customer/party name.
• OKL_GENERATE_ACCRUALS_PUB (package), OKL_LOSS_PROV_PUB (package), and OKL_ACCOUNTING_UTIL (package) — PL/SQL packages invoked inline for calculated amounts and lookup translation.

The join is driven by CTR.ID = KHR.ID (contract to OKL header) and CTR.ID = PTY.DNZ_CHR_ID with PTY.RLE_CODE = 'LESSEE', matched to OKX via PTY.OBJECT1_ID1 = OKX.ID1. Only contracts in status APPROVED, BOOKED, UNDER REVISION, or EVERGREEN are returned.

Key Columns

• ID / CONTRACT_NUMBER — contract identifier and human-readable number.
• DEAL_TYPE — code from OKL_K_HEADERS, resolved against the OKL_BOOK_CLASS lookup.
• DEAL_TYPE_MEANING — the translated description of DEAL_TYPE, obtained via OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_BOOK_CLASS', KHR.DEAL_TYPE). This is the column most directly tied to the search term okl_book_class.
• AUTHORING_ORG_ID / CURRENCY_CODE — operating unit and currency context.
• PRODUCT_NAME / CUSTOMER_NAME — product and lessee descriptions.
• RECEIVABLE_VALUE — calculated by OKL_GENERATE_ACCRUALS_PUB.CALCULATE_CNTRCT_REC.
• CAPITAL_BALANCE — calculated by OKL_LOSS_PROV_PUB.CALCULATE_CAPITAL_BALANCE using the deal type.
• GENERATE_ACCRUAL_OVERRIDE_YN / OVERRIDE_YN_MEANING — the override flag and its YES_NO translation.
• END_DATE / TERM_DURATION — contract end and term length.

Common Use Cases and Queries

The view is typically queried to audit accrual overrides, reconcile accrual calculations, or drive integrations that extract lease financials by book class.

SELECT CONTRACT_NUMBER,
       DEAL_TYPE,
       DEAL_TYPE_MEANING,
       CUSTOMER_NAME,
       RECEIVABLE_VALUE,
       CAPITAL_BALANCE,
       OVERRIDE_YN_MEANING
FROM   APPS.OKL_ACCRUAL_OVERRIDE_UV
WHERE  GENERATE_ACCRUAL_OVERRIDE_YN = 'Y';

To isolate contracts by book class using the search term:

SELECT CONTRACT_NUMBER, DEAL_TYPE_MEANING, CURRENCY_CODE, END_DATE
FROM   APPS.OKL_ACCRUAL_OVERRIDE_UV
WHERE  DEAL_TYPE = '&book_class';

Note that the inline package calls (RECEIVABLE_VALUE, CAPITAL_BALANCE) execute per row, so restricting the result set before projection improves performance on large lease portfolios.