Search Results okl_inv_formats_all_b




Overview
Explore in AI Chat

Overview

The OKL_INV_FORMATS_ALL_B table is a core data object within the Oracle E-Business Suite (EBS) Lease and Finance Management (OKL) module. It functions as the master repository for defining the structural and presentation templates used for generating invoices. In essence, this table stores the metadata that governs how invoice information is organized, formatted, and displayed for different leasing and financing transactions. Its role is critical in ensuring that the financial documents produced by the system adhere to business rules, contractual requirements, and presentation standards. As a multi-org table (indicated by the "_ALL_" suffix), it supports the storage of data specific to different operating units, enabling a shared installation to manage diverse invoicing formats across an organization's legal entities.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary purpose is to describe invoice presentation. Based on its relationships and standard EBS conventions, key stored information typically includes a unique identifier (the ID column, serving as the primary key), a link to an invoice line type (ILT_ID foreign key), and attributes defining the format's layout and behavior. These attributes likely encompass format names, descriptions, sequencing rules for line items, grouping logic, and flags controlling the inclusion of headers, subtotals, and other presentation elements. The table acts as a configuration hub, linking the logical definition of an invoice line (via OKL_INVC_LINE_TYPES_B) to the physical rendering of that line within an invoice document.

Common Use Cases and Queries

The primary use case is the setup and maintenance of invoice templates during implementation and ongoing operations. Administrators define formats here to control the appearance of invoices for different product types or customer segments. For reporting and troubleshooting, common queries involve joining this table to related entities. A fundamental pattern is retrieving all formats for a specific invoice line type or operating unit.

  • Sample Query: SELECT inf.name, inf.description, ilt.name FROM okl_inv_formats_all_b inf, okl_invc_line_types_b ilt WHERE inf.ilt_id = ilt.id AND inf.org_id = :org_id;
  • Reporting Use Case: Analyzing which invoice formats are associated with specific consolidated invoice headers (OKL_CNSLD_AR_HDRS_ALL_B) or contract-level groups (OKL_CNTR_LVL_GRPS_ALL_B) to audit invoice generation rules.

Related Objects

The table is centrally connected to several key OKL objects, as indicated by its foreign key relationships.

  • OKL_INVC_LINE_TYPES_B: This is a primary parent table, linked via the ILT_ID column. It defines the types of lines (e.g., rent, tax, fee) that can appear on an invoice, which are then formatted according to records in OKL_INV_FORMATS_ALL_B.
  • OKL_CNSLD_AR_HDRS_ALL_B: This table for consolidated invoice headers references (INF_ID) a specific invoice format, determining the presentation template for the consolidated document.
  • OKL_CNTR_LVL_GRPS_ALL_B: Similarly, this table for contract-level groups references an invoice format, applying that template to invoices generated for the group.
  • OKL_INV_FORMATS_ALL_TL: A companion translation table likely exists to store the language-specific names and descriptions for the formats defined in the base (_B) table.