Results for “okl_inv_agrmnt_effective_from”

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

Overview

APPS.OKL_AR_ADJ_IA_REF_V is a reference view within the Oracle E-Business Suite (EBS) Enterprise Trading and Risk Management (ETRM) module, specifically associated with Oracle Lease and Finance Management (OKL). The view exposes receivables adjustment information tied to investor billing agreements, joining header, line, and adjustment source records into a single flat projection. Its name reflects its purpose: "AR_ADJ_IA_REF" denotes Accounts Receivable adjustments linked to Investor Agreement reference data. It is documented under both EBS 12.1.1 and 12.2.2 with the same source definition.

The view plays a key integration and reporting role, enabling downstream processes, custom reports, and interface programs to retrieve investor agreement context (product name, currency, syndication, pool, status) alongside adjustment identity and template details without traversing the underlying normalized ETRM tables directly. Because it is filtered to the INVESTOR source code, it is purpose-built for investor billing scenarios only, as noted explicitly in the view text comment.

Underlying Base Objects

The view is defined over three documented base objects, each exposed to APPS through synonyms:

• OKL_EXT_AR_HEADER_SOURCES_B — alias RXH; supplies investor agreement header attributes such as agreement number, effective date, product name, currency, syndication code, pool number, status, and transaction type class.
• OKL_EXT_AR_LINE_SOURCES_B — alias RXL; supplies line-level context including accounting template name, contingency code, memo flag, stream type code, and stream type purpose code.
• OKL_TXL_ADJSTS_LNS_ALL_B — alias AJL; supplies the receivables adjustment identifier and the internal OKL adjustment line ID.

The join logic is documented and precise: RXL.SOURCE_TABLE must equal 'OKL_TXL_ADJSTS_LNS_B', RXH.SCS_CODE must equal 'INVESTOR', RXH.HEADER_EXTENSION_ID must equal RXL.HEADER_EXTENSION_ID, and RXL.SOURCE_ID must equal AJL.ID. This restricts the results to investor billing adjustments whose extension records reconcile header-to-line and line-to-adjustment.

Key Columns

The view exposes the following significant columns, several of which directly support the user's search term:

• RECEIVABLES_ADJUSTMENT_ID — the AR adjustment identifier.
• OKL_AJL_ID — the OKL adjustment line source ID.
• OKL_KHR_ID, OKL_KLE_ID, OKL_TRY_ID, OKL_STY_ID — internal header, line, transaction, and stream type identifiers.
• OKL_INV_AGRMNT_NUMBER and OKL_INV_AGRMNT_EFFECTIVE_FROM — investor agreement identifier and effective date.
• OKL_INV_AGRMNT_PRODUCT_NAME — the product name of the investor agreement, the column most directly relevant to searches for "okl_inv_agrmnt_product_name".
• OKL_INV_AGRMNT_CURRENCY_CODE, OKL_INV_AGRMNT_SYND_CODE, OKL_INV_AGRMNT_POOL_NUMBER, OKL_INV_AGRMNT_STATUS_CODE — currency, syndication, pool, and status attributes.
• OKL_TRX_TYPE_CLASS_CODE — transaction type classification.
• OKL_AE_TEMPLATE_NAME, OKL_CONTINGENCY_CODE, OKL_MEMO_FLAG, OKL_STREAM_TYPE_CODE, OKL_STREAM_TYPE_PURPOSE_CODE — accounting and line-level attributes.

Common Use Cases and Queries

Typical uses include investor billing reconciliation reports, AR adjustment audits, and custom extracts that require product name and agreement context per adjustment. A representative query:

SELECT receivables_adjustment_id,
       okl_inv_agrmnt_number,
       okl_inv_agrmnt_product_name,
       okl_inv_agrmnt_currency_code,
       okl_ae_template_name
  FROM apps.okl_ar_adj_ia_ref_v
 WHERE okl_inv_agrmnt_number = :agreement_number;

Because the view is pre-filtered to investor source records, additional filtering is generally unnecessary; callers can join it to AR or OKL fact tables on RECEIVABLES_ADJUSTMENT_ID or the OKL_*_ID columns to enrich reporting datasets.