Search Results okl_cntr_lvlng_grps_b

Overview

The table OKL_CNTR_LVLNG_GRPS_B is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Leasing and Finance Management (OKL) product. Its primary function is to support the administrative grouping of counters for financial and operational calculations. As indicated by its description, it associates a number of counters together for leveling and averaging purposes. This is a critical feature in leasing contracts where usage-based billing or asset management requires aggregating or averaging metrics from multiple counter readings, such as mileage, hours, or units, across different assets or time periods. The table serves as a master definition for these logical counter groups, enabling standardized and complex billing calculations within the leasing module.

Key Information Stored

While the provided ETRM excerpt does not list specific columns, the structure of the table can be inferred from its metadata. The primary key column is ID, which uniquely identifies each counter-leveling group record. A critical foreign key relationship exists via the column INF_ID (Invoice Format ID), which links the counter group to a specific invoice format defined in the OKL_INVOICE_FORMATS_B table. This linkage is essential for determining how the leveled or averaged counter values are presented and calculated on customer invoices. Other columns likely include standard Oracle EBS audit fields (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and attributes to define the group's name, description, and the specific leveling or averaging method applied.

Common Use Cases and Queries

The primary use case involves configuring and querying groups of counters for billing engines. An administrator may create a group to average the monthly usage from three different meters on a single leased piece of equipment. For reporting and troubleshooting, common SQL patterns include joining this table to invoice formats and counter transaction lines. A sample query to list all defined counter-leveling groups and their associated invoice formats would be:

• SELECT clg.ID, clg.NAME, inf.NAME AS INVOICE_FORMAT_NAME FROM OKL_CNTR_LVLNG_GRPS_B clg, OKL_INVOICE_FORMATS_B inf WHERE clg.INF_ID = inf.ID;

Another critical use case is during the invoice generation process, where the system references this table to identify which counters to aggregate before applying pricing rules, ensuring accurate usage-based invoicing for complex lease agreements.

Related Objects

The most directly related object, as per the foreign key definition, is the OKL_INVOICE_FORMATS_B table. This relationship dictates how the counter group is utilized within the invoicing framework. It is also intrinsically linked to tables storing individual counter definitions and counter transaction lines (likely named similarly to OKL_COUNTERS_B and OKL_COUNTER_TRX_LINES), though these are not explicitly listed in the provided metadata. The table's primary key constraint is named OKL_CNTR_LVLNG_GRPS_B_PK. Developers and DBAs should note the ETRM's "Not implemented in this database" flag, which may indicate the table is part of a broader data model but not actively used in all implementations or requires specific product features to be enabled.