Search Results okl_vlr_nc1

Overview

OKL.OKL_VALIDATION_RESULTS_B is a transactional table in the Oracle E-Business Suite (EBS) Lease Management (OKL) application, part of the Enterprise Contracts and leasing module. It stores the results of validation routines performed against lease-related objects, most notably lease quotations held in OKL_LEASE_QUOTES_ALL_B. Each row captures the outcome of a specific validation executed against a parent object, together with the identifier of the validation rule that produced the outcome and the resulting code. Because it records the assessment of an object rather than the object itself, the table functions as an audit and diagnostic layer for lease validation logic across the leasing lifecycle.

The table is documented as a standalone object with a single-column primary key on ID and no foreign key dependencies enforced at the schema level. In Data Vault modeling terms, the mined relationship structure suggests treating this as a satellite-style entity: the parent object reference (PARENT_OBJECT_CODE and PARENT_OBJECT_ID) points to a business key in OKL_LEASE_QUOTES_ALL_B, while VALIDATION_ID and RESULT_CODE describe the validation event and its outcome. This modeling is a heuristic suggestion and does not form part of the EBS physical design itself.

Key Information Stored

The table contains 27 columns. The most significant are:

• ID — surrogate primary key, enforced by the OKL_VLR_PK constraint and also the leading column of the unique index OKL_VLR_UC1.
• PARENT_OBJECT_ID — identifier of the parent lease quotation; indexed non-uniquely via OKL_VLR_NC1 to support lookups by parent.
• PARENT_OBJECT_CODE — code identifying the parent object type; the documentation references OKL_LEASE_QUOTES_ALL_B as the parent.
• VALIDATION_ID — identifier of the validation rule or check that was executed.
• RESULT_CODE — outcome of the validation, distinguishing pass, warning, or failure conditions.
• OBJECT_VERSION_NUMBER — optimistic locking column used to detect concurrent updates.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield (DFF) columns (VARCHAR2 450) for customer-defined validation metadata.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Note that OKL_VLR_UC1 is unique on ID alone, so it is a surrogate-key index rather than a composite business-key candidate. The true business identity of a record is the combination of parent object, validation rule, and result event.

Common Use Cases and Queries

Typical scenarios include diagnosing why a lease quotation failed validation, reporting on validation failures across a quotation batch, and auditing validation history for compliance. A representative query retrieves all validation results for a given parent quotation:

• SELECT id, validation_id, result_code, creation_date FROM okl.okl_validation_results_b WHERE parent_object_id = :quote_id ORDER BY creation_date DESC;
• SELECT result_code, COUNT(*) FROM okl.okl_validation_results_b GROUP BY result_code;

Reporting teams may join results to the parent quotation to correlate failures with lessee or asset attributes. Because the table supports DFF attributes, custom validation metadata can be surfaced through the standard flexfield views. Index coverage on ID (unique) and PARENT_OBJECT_ID (non-unique) supports both primary-key access and parent-driven queries efficiently.

Related Objects

• OKL.OKL_LEASE_QUOTES_ALL_B — the parent object referenced by PARENT_OBJECT_CODE and PARENT_OBJECT_ID; joins on the quotation primary key.
• OKL.OKL_LEASE_QUOTES_ALL — the translated view that exposes quotation data in reporting languages.
• Validation rule definitions — referenced through VALIDATION_ID, typically resolving to the OKL validation setup tables that define each check.
• OKL.OKL_VLR_PK / OKL_VLR_UC1 / OKL_VLR_NC1 — the primary key constraint and unique/non-unique indexes that govern access paths.
• OKL validation PL/SQL APIs — the leasing validation engine routines that insert validation results into this table as part of lease document validation.