Results for “frmt_strms”

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

Overview

The APPS.OKL_BPD_ASSIGN_FORMAT_V view is a reporting and integration object within the Oracle E-Business Suite (EBS) Lease Management / ETRM (Enterprise Tax and Revenue Management) module, present in release levels 12.1.1 and 12.2.2. Its primary purpose is to present the relationship between invoice formats defined in the BPD (Billing and Payment Details) assignment framework and the associated invoice streams. Specifically, the view surfaces whether a given format-to-stream combination has been Assigned or remains UnAssigned, a determination driven by the presence or absence of an INF_ID value on the stream record.

Because the view joins format definitions, invoice types, and invoice line types, it functions as a consolidated cross-reference for administrators and developers who need to verify configuration completeness. It exposes the format name, the invoice type name, the line type name, the stream name, and a derived assignment status flag. This makes it suitable for diagnostic queries, setup validation reports, and any integration that must confirm that a billing format is correctly bound to an invoice stream before transactional processing proceeds.

Underlying Base Objects

The view is defined over four documented objects, combined through outer-join logic:

• OKL_BPD_ASSIGN_FORMATS_UV — the driving view supplying the format definition, stream name, and stream purpose meaning (aliased FORMAT).
• OKL_INVC_FRMT_STRMS_V — the invoice-format-to-stream association view, aliased FRMT_STRMS. Its INF_ID and STY_ID are outer-joined ((+)) to the format.
• OKL_INVC_LINE_TYPES_V — the invoice line type view (LINE_TYPE), joined to the stream via ILT_ID.
• OKL_INVOICE_TYPES_V — the invoice type view (INVC_TYPE), outer-joined to the line type through ITY_ID.
• OKL_BPD_ASSIGN_FORMAT_V — the invoice format view (FORMAT).
• OKL_INVC_FRMT_STRMS_V — the invoice format streams view (FRMT_STRMS).

The parent metadata additionally references the FND_GLOBAL and OKL_ACCOUNTING_UTIL packages, which support the security and functional context of the underlying views.

Key Columns

• FORMAT_NAME — the descriptive name of the BPD invoice format; also the primary sort key.
• INF_ID — the invoice format identifier (or related format identifier) carried from the format view.
• NAME (invoice type) — the name of the associated invoice type derived from OKL_INVOICE_TYPES_V.
• NAME (line type) — the invoice line type name derived from OKL_INVC_LINE_TYPES_V.
• STREAM_NAME — the invoice stream associated with the format.
• STREAM_PURPOSE_MEANING — human-readable meaning of the stream purpose.
• DECODE(FRMT_STRMS.INF_ID, NULL, 'UnAssigned', 'Assigned') — the assignment status indicator, showing whether the format is bound to a stream.

Common Use Cases and Queries

Typical usage includes auditing which formats lack a stream assignment and confirming format-to-line-type mappings before billing runs. A representative query retrieves assignment status by format:

• SELECT format_name, inf_id, stream_name, stream_purpose_meaning, DECODE(frmt_strms.inf_id, NULL, 'UnAssigned', 'Assigned') AS assignment_status FROM okl_bpd_assign_format_v ORDER BY format_name;
• Filter to unassigned formats: add WHERE DECODE(frmt_strms.inf_id, NULL, 'UnAssigned', 'Assigned') = 'UnAssigned'.
• Join to invoice type and line type columns to produce a setup validation report for configuration owners.

Because the view already resolves the outer-join assignment logic and sorts by FORMAT_NAME and assignment status, it is suited to direct reporting without additional join construction.