Search Results okl_cnsld_ar_strms_v




Overview
Explore in AI Chat

Overview

OKL_CNSLD_AR_STRMS_V is a consolidated reporting view owned by the APPS schema within the OKL – Lease and Finance Management product family. It exposes the lowest level of transaction detail that is rolled up into a consolidated receivables bill, making it the finest-grained source of billing line information available to reporting and integration consumers. In Oracle EBS 12.1.1 and 12.2.2, the view is registered as VALID and is defined over the consolidated AR streams base and translation tables. Because the view flattens the transaction backbone, it is typically consumed by BI Publisher reports, Discoverer workbooks, custom concurrent programs, and downstream interfaces requiring per-transaction billing granularity. The view is especially relevant to users investigating the investor disbursement fields, since it surfaces INVESTOR_DISB_STATUS, INVESTOR_DISB_ERR_MG, SEL_ID, and DATE_DISBURSED alongside the standard stream attributes. The DESCRIPTION field documents the view as "Lowest level transaction included into consolidated bill," confirming its role as a detail-level transaction source rather than a header or summary object.

Underlying Base Objects

The view is defined against two documented base objects in the OKL schema, exposed through synonyms: OKL_CNSLD_AR_STRMS_B (the base table holding consolidated AR stream transactions) and OKL_CNSLD_AR_STRMS_TL (the translation table supplying language-dependent text). The join is performed on ID between the two tables, filtered by LANGUAGE = USERENV('LANG'). This design means the view returns rows in the session language of the querying user, which is important for multi-language implementations. Both base objects are referenced as synonyms, so a query against APPS.OKL_CNSLD_AR_STRMS_V resolves through synonyms to the OKL objects. The ROWID of the base table is exposed as ROWID, allowing row-level identification.

Key Columns

  • INVESTOR_DISB_STATUS – Status of investor disbursement for the stream; the primary field sought by the search term.
  • INVESTOR_DISB_ERR_MG – Error message captured during investor disbursement processing.
  • SEL_ID – Identifier of the selected disbursement record.
  • DATE_DISBURSED – Date the disbursement was processed.
  • ID – Primary identifier linking the base stream to its translation row.
  • ROW_ID / ROWID – Physical row locator from OKL_CNSLD_AR_STRMS_B.
  • AMOUNT, TAX_AMOUNT – Transaction amount and associated tax, the basis for consolidated billing totals.
  • LATE_INT_ASSESS_DATE, LATE_CHARGE_ASSESS_DATE, LATE_CHARGE_ASS_YN, LATE_INT_ASS_YN – Late interest and late charge assessment dates and flags.
  • RECEIVABLES_INVOICE_ID – Links the stream to the AR invoice generated for the consolidated bill.
  • LLN_ID, KHR_ID, KLE_ID, STY_ID – Foreign keys to lease, KH, KLE, and stream type entities.
  • PAY_STATUS_CODE – Payment status of the stream.
  • ORG_ID – Multi-org operating unit identifier, enabling MOAC-aware queries.
  • SFWT_FLAG – Stream flag carried from the translation table.
  • ATTRIBUTE1–15, ATTRIBUTE_CATEGORY – Descriptive flexfield columns.
  • Audit columns – CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and concurrent program fields.

Common Use Cases and Queries

A frequent scenario is auditing investor disbursement outcomes. The following query identifies streams whose disbursement failed or remains pending:

SELECT ID, RECEIVABLES_INVOICE_ID, AMOUNT, INVESTOR_DISB_STATUS,
INVESTOR_DISB_ERR_MG, DATE_DISBURSED, SEL_ID
FROM APPS.OKL_CNSLD_AR_STRMS_V
WHERE INVESTOR_DISB_STATUS <> 'PROCESSED'
AND ORG_ID = :p_org_id;

A second use case reconciles transactions back to their AR invoices for a given lease:

SELECT ID, LLN_ID, KHR_ID, AMOUNT, TAX_AMOUNT, RECEIVABLES_INVOICE_ID
FROM APPS.OKL_CNSLD_AR_STRMS_V
WHERE LLN_ID = :p_lease_id;

A third is lateral reporting across attributes and payment status:

SELECT ID, PAY_STATUS_CODE, LATE_CHARGE_ASS_YN, LATE_INT_ASS_YN,
LATE_CHARGE_ASSESS_DATE, LATE_INT_ASSESS_DATE, DATE_DISBURSED
FROM APPS.OKL_CNSLD_AR_STRMS_V
WHERE TRUNC(CREATION_DATE) >= :p_from_date
AND ORG_ID = :p_org_id;

Because the view joins a base table with a translation table, queries always return language-filtered rows; reporting solutions should ensure the session language contains translations for the relevant records. No DML should be attempted against this view, as it is a read-only reporting construct.