Search Results okl_cntr_lvl_grps_all_b

Overview

The table OKL_CNTR_LVL_GRPS_ALL_B is a core data object within the Oracle E-Business Suite (EBS) module OKL (Leasing and Finance Management). Its primary function, as documented, is to associate multiple counters together for the purposes of leveling and averaging. In the context of asset leasing and finance, counters are often used to track usage metrics, such as mileage on a vehicle or operating hours on equipment. This table enables the grouping of related counters, which is a critical prerequisite for performing aggregate calculations like average usage or leveling charges across a set of assets or contracts. The table supports a multi-organization architecture, as indicated by the "_ALL_B" suffix and the presence of an ORG_ID column, allowing data to be partitioned by operating unit.

Key Information Stored

The table stores the master definition for each counter leveling group. While a full column list is not provided in the metadata, the documented primary and foreign keys reveal its essential structure. The primary key column is ID, a unique identifier for each group record. A critical foreign key is INF_ID, which links the group to a specific invoice format (OKL_INV_FORMATS_ALL_B). This relationship ties the counter grouping logic directly to the billing and invoicing processes. Other typical columns in such a table would include NAME and DESCRIPTION for the group, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY for auditing, and the ORG_ID to identify the operating unit.

Common Use Cases and Queries

The primary use case is the configuration and execution of usage-based billing where charges are calculated based on averaged or leveled counter readings from multiple sources. For instance, a fleet management company might group counters from several trucks to calculate an average fleet mileage for billing purposes. A common reporting query would join this table to the invoice formats and detailed counter transaction tables to analyze grouped counter data. A sample SQL pattern to retrieve active groups might be:

• SELECT grp.ID, grp.NAME, inf.FORMAT_NAME
• FROM OKL_CNTR_LVL_GRPS_ALL_B grp,
• OKL_INV_FORMATS_ALL_B inf
• WHERE grp.INF_ID = inf.ID
• AND grp.ORG_ID = :p_org_id;

This table is typically accessed via the application's seeded forms or custom interfaces for setting up billing rules, rather than via direct ad-hoc queries by end-users.

Related Objects

As per the provided metadata, OKL_CNTR_LVL_GRPS_ALL_B has a direct and documented foreign key relationship with one other table.

• OKL_INV_FORMATS_ALL_B: This is the parent table for invoice formats. The relationship is defined on the column OKL_CNTR_LVL_GRPS_ALL_B.INF_ID, which references the primary key of OKL_INV_FORMATS_ALL_B. This ensures every counter leveling group is associated with a valid invoice format for billing.

Logically, this table would also be referenced by child tables storing the specific counter members assigned to each group (e.g., a table like OKL_CNTR_LVL_GRP_LINES) and would be central to the logic of packages within the OKL module that perform the actual leveling and averaging calculations for invoice generation.