Results for “okl_bpd_assign_format_v”

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

Overview

OKL_BPD_ASSIGN_FORMAT_V is a reporting view owned by the APPS schema within the OKL (Lease and Finance Management) product of Oracle E-Business Suite. Its name reflects its purpose: it presents the assignment relationship between billing payment distribution (BPD) formats and the invoice structures they serve. Specifically, the view joins lease invoice formats to their associated invoice types, invoice line types, and format streams, and it flags whether each format-to-stream combination is currently assigned or unassigned. This makes it a convenient read-only source for reporting on format configuration without requiring consumers to reconstruct the multi-table join themselves.

Because it is a view, OKL_BPD_ASSIGN_FORMAT_V holds no persistent data. It derives its content entirely from underlying base views and packages, joining them at query time. In Oracle EBS 12.1.1 and 12.2.2 the object carries a VALID status in the data dictionary, and its definition is essentially identical across both releases, so reports, concurrent programs, and BI Publisher data models built against it behave consistently in either version.

Underlying Base Objects

The view text and documented metadata identify the following referenced objects:

• OKL_BPD_ASSIGN_FORMATS_UV — the primary source of format rows, supplying FORMAT_NAME, INF_ID, and STY_ID.
• OKL_INVC_FRMT_STRMS_V — the format stream assignments, outer-joined to the formats so that formats without a stream still appear.
• OKL_INVOICE_TYPES_V — supplies the invoice type name.
• OKL_INVC_LINE_TYPES_V — supplies the invoice line type name and links line type to invoice type via ITY_ID.
• FND_GLOBAL and OKL_ACCOUNTING_UTIL — EBS packages referenced by the underlying views and used to resolve organization and responsibility context and accounting-related logic during query execution.

All joins are performed with outer joins (foreign-key side marked with the (+) operator) so that unassigned formats and orphaned line types are returned rather than filtered out. This preserves the "UNASSIGNED" state that the view explicitly reports.

Key Columns

• FORMAT_NAME — the name of the billing/payment distribution format; the primary sort key.
• INF_ID — the internal identifier of the format, used to correlate to the format definition and stream assignment tables.
• FORMAT_TYPE — the invoice type name the format is associated with, derived from OKL_INVOICE_TYPES_V.
• LINE_TYPE — the invoice line type name the format applies to, derived from OKL_INVC_LINE_TYPES_V.
• STREAM — the stream name from OKL_INVC_FRMT_STRMS_V.
• PURPOSE — the stream purpose meaning, exposed as STREAM_PURPOSE_MEANING from the format source.
• STATUS — a DECODE-derived flag returning 'UNASSIGNED' when no matching stream exists (FRMT_STRMS.INF_ID is null) and 'ASSIGNED' otherwise.

Common Use Cases and Queries

Typical uses include auditing which formats remain unassigned, generating setup reports for invoice formatting, and validating configuration before enabling billing cycles.

• Find all unassigned formats: SELECT format_name, format_type, line_type FROM okl_bpd_assign_format_v WHERE status = 'UNASSIGNED';
• Report assignments by stream purpose: SELECT format_name, format_type, line_type, stream, purpose FROM okl_bpd_assign_format_v ORDER BY format_name;
• Summarize assignment counts: SELECT status, COUNT(*) FROM okl_bpd_assign_format_v GROUP BY status;

Because the view depends on FND_GLOBAL, queries should be run under a valid EBS application session (for example, with the MO: Operating Unit profile set appropriately) to ensure context-sensitive joins resolve correctly.