Results for “okl_parameters_b”

50+ results




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

Overview

OKL_PARAMETERS_B is a core reference table within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. It stores the master list of parameters required by the formulae that drive lease pricing, amortization, interest calculation, and financial structuring within OKL. Each row defines a single named parameter that can be consumed by one or more formulae, effectively acting as the dimensional backbone for formula-driven calculations across the leasing engine.

From a Data Vault modeling perspective, the metadata's heuristic classification identifies this object as hub-leaning. This reflects its role as a stable, business-keyed registry of parameter identities (NAME) that other tables reference, rather than a transactional or descriptive satellite. The table is owned by the OKL schema and carries a status of VALID in the documented environment.

Key Information Stored

The table contains eleven documented columns. The most significant are:

  • ID — Surrogate primary key, enforced by constraint OKL_PARAMETERS_B_PK. This is the technical identifier used in foreign key relationships.
  • NAME — The business-key identifier for the parameter, enforced by unique index OKL_PMR_U2 (NAME, ZD_EDITION_NAME) and referenced in the original primary key constraint OKL_PMR_UK1.
  • DATATYPE — Defines the data type of the parameter, governing how values are interpreted when supplied to formulae.
  • ZD_EDITION_NAME — Editioning column supporting Oracle EBS online patching (Edition-Based Redefinition), part of both unique indexes.
  • OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Applications Framework to detect concurrent updates.
  • CUSTOMIZATION_LEVEL — Indicates the extent to which the record has been customized versus delivered as seed data.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit "WHO" columns tracking record creation and modification.

The unique index OKL_PARAMETERS_B_U1 (ID, ZD_EDITION_NAME) confirms the surrogate key within the editioning scheme, while OKL_PMR_U2 establishes NAME as the natural business key.

Common Use Cases and Queries

Typical usage centers on resolving parameter definitions when debugging or extending lease formulae, and on reporting which parameters exist in the system. Common query patterns include:

  • Looking up a parameter by name to retrieve its ID and data type:
    SELECT id, name, datatype FROM okl_parameters_b WHERE name = :p_name;
  • Joining to the formula-parameter association table to enumerate the parameters consumed by a given formula:
    SELECT p.name, fp.formula_id FROM okl_parameters_b p, okl_fnctn_prmtrs_b fp WHERE fp.pmr_id = p.id;
  • Auditing customization levels to identify non-seeded parameters introduced by configuration.
  • Reporting parameter inventory by data type for integration or data-migration analysis.

Because the table is edition-enabled, queries executed during online patching should account for ZD_EDITION_NAME to avoid cross-edition ambiguity.

Related Objects

The following objects are most significant to OKL_PARAMETERS_B:

  • OKL_FNCTN_PRMTRS_B — The primary dependent child table, referencing OKL_PARAMETERS_B via the foreign key column PMR_ID on OKL_FNCTN_PRMTRS_B.PMR_ID. This link table binds parameters to formulae.
  • OKL_PARAMETERS_B_PK / OKL_PMR_UK1 / OKL_PMR_U2 / OKL_PARAMETERS_B_U1 — The primary key, unique, and supporting constraints and indexes that enforce integrity on ID and NAME.
  • OKL schema tables — Formulae, function, and pricing tables within the OKL module that consume parameter definitions indirectly through OKL_FNCTN_PRMTRS_B.

These relationships establish OKL_PARAMETERS_B as a referenced hub whose surrogate ID propagates into the formula-parameter association layer.