Search Results okl_context_groups_b




Overview
Explore in AI Chat

Overview

The table OKL_OKL_CONTEXT_GROUPS_B is a core data object within the Oracle E-Business Suite (EBS) Lease and Finance Management (OKL) module. It serves as a master repository for defining and managing context groups. In the context of the OKL module, a context group is a logical grouping of parameters or variables that are required for the execution of financial and lease-related formulae. These formulae are used for complex calculations in areas such as billing, amortization, and asset valuation. The table's primary role is to provide a structured, reusable definition for sets of parameters, enabling the formula engine to correctly identify and process the necessary input data for a given calculation scenario. Its existence is fundamental to the configurability and flexibility of the OKL module's calculation engine across both EBS 12.1.1 and 12.2.2 versions.

Key Information Stored

While the provided metadata does not list all columns, the structure centers on uniquely identifying and describing each parameter group. The primary column is the ID, which serves as the unique system-generated identifier (primary key) for each context group record. Based on its functional description, other typical columns would include a name or code (e.g., GROUP_NAME, GROUP_CODE) to identify the group, a description (DESCRIPTION) for user clarity, and control columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY for auditing. The table's design ensures that each distinct set of parameters needed by one or more formulae is cataloged once, promoting data integrity and consistency.

Common Use Cases and Queries

The primary use case is the setup and maintenance of calculation formulae. An administrator would define a context group, such as "LEASE_BILLING_PARAMS," to bundle all parameters (e.g., lease start date, payment frequency, asset cost) required by billing calculations. Common queries involve listing all available context groups for formula assignment or identifying which formulae use a specific group. A typical reporting query might join this table to the formulae table to audit formula configurations:

  • Sample SQL: SELECT cgb.ID, cgb.GROUP_NAME, fmb.FORMULA_NAME FROM OKL_CONTEXT_GROUPS_B cgb, OKL_FORMULAE_B fmb WHERE cgb.ID = fmb.CGR_ID ORDER BY cgb.GROUP_NAME;
  • Use Case: Troubleshooting a formula error by verifying the assigned context group contains all necessary parameters for the calculation logic.

Related Objects

The table has a direct and critical relationship with the formulae definitions in the system, as documented by the foreign key constraint.

  • OKL_FORMULAE_B: This is the primary related table. The foreign key OKL_FORMULAE_B.CGR_ID references the OKL_CONTEXT_GROUPS_B.ID column. This relationship means that each formula (OKL_FORMULAE_B) is associated with exactly one context group, which defines the set of parameters that formula expects to receive for execution. This is a one-to-many relationship, where one context group can be used by multiple formulae.