Results for “okl_provisions_uv”

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

Overview

OKL_PROVISIONS_UV is a reporting-oriented database view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the OKL product family, Oracle Lease and Finance Management, and is classified as a VALID object in the ETRM data dictionary. The view exposes provisioning setup records used by OKL accounting processes, presenting the four accounting flexfield identifiers that drive provision-related journal entries alongside a set of derived, concatenated segment strings.

The "_UV" suffix denotes a user-facing presentation view layered over the base provisioning entity. Rather than requiring report authors to resolve Accounting Flexfield combination identifiers manually, the view pre-computes concatenated segment descriptions through the OKL_ACCOUNTING_UTIL package. This makes the view suitable for operational reporting, ad hoc enquiry, and integration extracts where human-readable account representations are required.

Underlying Base Objects

The view is defined over two documented referenced objects:

• OKL_PROVISIONS (SYNONYM) — the base provisioning table that stores provision definitions, including the accounting CCIDs, descriptive attributes, version tracking, and effective dating columns. The view selects all columns from this source using the alias PVNB.
• OKL_ACCOUNTING_UTIL (PACKAGE) — the accounting utility package invoked four times via GET_CONCAT_SEGMENTS to translate each CCID into its concatenated segment string.

Because the view is a thin projection over OKL_PROVISIONS with derived columns appended, it inherits the base table's row cardinality. Notably, OKL_PROVISIONS_UV is a read-only construct: it has no INSTEAD OF triggers documented, so DML must be directed at the underlying table.

Key Columns

The view surfaces the following significant columns:

• ID, OBJECT_VERSION_NUMBER, VERSION — primary identifier and optimistic locking / versioning columns.
• APP_DEBIT_CCID, APP_CREDIT_CCID, REV_DEBIT_CCID, REV_CREDIT_CCID — the four Accounting Flexfield combination identifiers for appreciation and revaluation debit and credit entries.
• SET_OF_BOOKS_ID — the ledger context for the provision record.
• APP_DEBIT_CCID_CONCATE, APP_CREDIT_CCID_CONCATE, REV_DEBIT_CCID_CONCATE, REV_CREDIT_CCID_CONCATE — derived columns populated by OKL_ACCOUNTING_UTIL.GET_CONCAT_SEGMENTS, returning the concatenated segment string for each CCID.
• NAME, DESCRIPTION, ATTRIBUTE_CATEGORY, ATTRIBUTE1–ATTRIBUTE15 — descriptive and descriptive-flexfield columns for categorisation and extensibility.
• FROM_DATE, TO_DATE — effective dating for the provision definition.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Critically for the search term "rev_credit_ccid", the column REV_CREDIT_CCID is exposed directly, and its human-readable counterpart is available as REV_CREDIT_CCID_CONCATE.

Common Use Cases and Queries

The view is typically used to review provision accounting setups, to validate that revaluation credit accounts are populated correctly, and to feed extracts with readable account strings. Example queries include:

• Listing all provisions with their revaluation credit account: SELECT id, name, rev_credit_ccid, rev_credit_ccid_concate FROM okl_provisions_uv WHERE rev_credit_ccid IS NOT NULL;
• Filtering by ledger: SELECT id, name, set_of_books_id, rev_debit_ccid_concate, rev_credit_ccid_concate FROM okl_provisions_uv WHERE set_of_books_id = :p_sob;
• Detecting missing account assignments: SELECT id, name FROM okl_provisions_uv WHERE rev_credit_ccid IS NULL OR rev_debit_ccid IS NULL;

Because the concatenated columns are computed per row through a PL/SQL function call, high-volume extracts should filter aggressively, for example by SET_OF_BOOKS_ID or effective dates, to limit function execution and preserve query performance.