Search Results orp_code




Overview
Explore in AI Chat

Overview

APPS.OKL_BPD_VAR_INT_PROCESS_UV is a reporting and diagnostic view in the Oracle E-Business Suite Lease and Finance Management (OKL) module. It exposes the processing state of "variable interest" (VAR_INT) interface records in relation to a lease contract, presenting each variable interest interface request alongside its parent and child stream interface rows. The view is primarily used to monitor batch processing outcomes for variable interest calculations—such as rate adjustments, interest accruals, and stream regeneration—that are submitted through the Lease Management concurrent programs.

The object carries the "_UV" suffix, indicating it is a user view (user-facing, read-only), and it is owned by the APPS schema. In an EBS 12.1.1 or 12.2.2 environment, it functions purely as a query object: no DML is supported against it, and it is typically consumed by Oracle Reports, OAF pages, BI Publisher extracts, or ad hoc SQL used by support and implementation teams. Because the parent interface table records a TRANSACTION_NUMBER, this view is directly relevant to users searching on that attribute, as it surfaces both parent and child transaction numbers side by side.

Underlying Base Objects

The view is defined over four documented base objects:

Because the view calls a PL/SQL function for every returned row, query performance is sensitive to the number of qualifying records; filtering by CONTRACT_NUMBER or REQUEST_ID is advisable.

Key Columns

Common Use Cases and Queries

Typical scenarios include verifying whether a variable interest batch completed successfully, comparing parent and child stream interface status, and diagnosing failures by reviewing the associated log files. A representative query filtering by contract and transaction number follows:

SELECT contract_number,
       request_id,
       parent_transaction_number,
       parent_status,
       child_transaction_number,
       child_status,
       parent_date_processed,
       child_date_processed
FROM   apps.okl_bpd_var_int_process_uv
WHERE  contract_number = :p_contract_number
ORDER BY request_id, parent_transaction_number;

To locate a specific transaction, the view can be queried on either the parent or child column:

SELECT contract_number, request_id,
       parent_transaction_number, child_transaction_number
FROM   apps.okl_bpd_var_int_process_uv
WHERE  parent_transaction_number = :p_trx_number
OR     child_transaction_number  = :p_trx_number;

Because the child side is an outer join, records with CHILD_TRANSACTION_NUMBER IS NULL identify parent interfaces that did not generate a child stream, which is often a key diagnostic indicator. The view should always be queried with the APPS schema prefix or a synonym, and results are best restricted by CONTRACT_NUMBER or REQUEST_ID to minimize the overhead of the OKL_ACCOUNTING_UTIL lookup calls.