Search Results okl_bpd_assign_formats_uv




Overview
Explore in AI Chat

Overview

The OKL_BPD_ASSIGN_FORMATS_UV view is an Oracle EBS Leasing and Finance Management (OKL) reporting object owned by the APPS schema. It presents a denormalized, user-facing listing of invoice format definitions mapped to stream types, where each stream type is further resolved to its stream purpose lookup meaning. The view is primarily designed to support Oracle Business Process Delivery (BPD) and related configuration inquiries, enabling the association between an invoice format, its stream name, and its functional purpose to be displayed in a single row.

The "UV" suffix denotes a user-facing view intended for reporting and inquiry rather than for internal transactional processing. In EBS 12.1.1 and 12.2.2 environments, this view appears in the OKL product family and is a valid object in the APPS schema, which means it can be referenced directly by custom reports, concurrent programs, Oracle Discoverer worksheets, Oracle Business Intelligence Publisher data models, or ad-hoc SQL executed by implementation consultants and support analysts.

Underlying Base Objects

The view is defined over three primary sources joined to resolve descriptive meanings:

The documented metadata also lists FND_GLOBAL (package) and OKL_ACCOUNTING_UTIL (package) as referenced base objects; these are typically invoked to support security context (e.g., org_id or user_id from FND_GLOBAL) and accounting-related derivation during view resolution. In practice the visible join logic rests on the three sources above, gated by lookup validity dates.

Key Columns

  • INF_ID — Surrogate identifier of the invoice format (from OKL_INVOICE_FORMATS_V.ID).
  • FORMAT_NAME — Descriptive name of the invoice format.
  • STY_ID — Surrogate identifier of the stream type (from OKL_STRM_TYPE_V.ID).
  • STREAM_NAME — Descriptive name of the stream type.
  • STREAM_PURPOSE_MEANING — The user-facing meaning of the stream purpose, resolved from FND_LOOKUPS where LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'. This is the column most relevant to the common search term "stream_purpose_meaning."

The lookup join is constrained by ENABLED_FLAG = 'Y' and by active date ranges using NVL on START_DATE_ACTIVE and END_DATE_ACTIVE, ensuring only currently effective lookup values are returned.

Common Use Cases and Queries

Typical uses include auditing which invoice formats are associated with which stream purposes, validating configuration before running billing or invoicing programs, and building reporting extracts that require a human-readable purpose label rather than a code.

  • Listing all formats by stream purpose meaning.
  • Filtering formats tied to a specific purpose for setup verification.
  • Joining the view to other OKL tables for extended reporting.

Sample queries:

SELECT INF_ID, FORMAT_NAME, STY_ID, STREAM_NAME, STREAM_PURPOSE_MEANING
FROM   APPS.OKL_BPD_ASSIGN_FORMATS_UV;

SELECT FORMAT_NAME, STREAM_NAME, STREAM_PURPOSE_MEANING
FROM   APPS.OKL_BPD_ASSIGN_FORMATS_UV
WHERE  STREAM_PURPOSE_MEANING = 'Billing';

SELECT STREAM_PURPOSE_MEANING, COUNT(*)
FROM   APPS.OKL_BPD_ASSIGN_FORMATS_UV
GROUP BY STREAM_PURPOSE_MEANING;

These queries illustrate the view's role as a simple, secure, read-only source for stream-purpose-aware reporting across Oracle Leasing and Finance Management implementations.