Results for “okl_formulae_b”

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

Overview

OKL_FORMULAE_B is the foundational definition table for formulae in the Oracle E-Business Suite Release 12.1.1 and 12.2.2 Leasing and Finance Management (OKL) module. It stores the header-level definition of every formula used across the leasing and finance business flows, including the context group that governs how the formula is evaluated. In the OKL architecture, formulae drive calculations such as payment streams, interest accruals, tax basis derivation, subsidy computations, and refund processing. Each formula row is a reusable, named, versioned definition that other OKL entities reference through foreign keys.

Under a heuristic Data Vault classification derived from the documented foreign key topology, OKL_FORMULAE_B behaves as a hub. It carries a stable surrogate primary key (ID) and serves as the anchor to which multiple dependent tables attach. This is a modeling suggestion rather than a physical constraint; the table itself is a standard EBS transactional definition table with a single-column primary key and overlapping unique indexes.

Key Information Stored

The table exposes 33 documented columns. The most significant are:

• ID — the surrogate primary key, enforced by OKL_FORMULAE_B_PK. This is the value propagated to all dependent tables as FMA_ID or FORMULA_ID.
• NAME — the user-facing formula name. Together with VERSION and ZD_EDITION_NAME it forms the business-key candidate captured in unique index OKL_FMA_U2.
• VERSION — the formula version, allowing multiple revisions of the same named formula to coexist.
• FORMULA_STRING — the actual expression or formula definition consumed by the OKL calculation engine.
• CGR_ID — foreign key to OKL_CONTEXT_GROUPS_B, identifying the context group required by the formula.
• ORG_ID — the operating unit (multi-org) partition to which the formula belongs.
• THERE_CAN_BE_ONLY_ONE_YN — a flag constraining whether only a single instance of the formula may exist in a given context.
• FYP_CODE — the formula type or classification code used to categorize the formula.
• START_DATE and END_DATE — the effective dating window for the formula definition.
• OBJECT_VERSION_NUMBER — the optimistic locking column used by the EBS framework to detect concurrent updates.
• ZD_EDITION_NAME — the editioning column introduced for online patching support in EBS 12.2.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS descriptive flexfield (DFF) columns for customer-defined extension data.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — the standard who-columns used for auditing and concurrency control.

The secondary unique index OKL_FORMULAE_B_U1 (ID, ZD_EDITION_NAME) supports edition-aware lookups, complementing the single-column primary key.

Common Use Cases and Queries

Typical reporting and diagnostic scenarios involve resolving formula identifiers referenced by downstream entities, inspecting which formulas exist for a given operating unit, and auditing formula versions. A common query pattern joins the formulae header to its context group:

• Listing active formulae for an operating unit: SELECT id, name, version, fyp_code FROM okl_formulae_b WHERE org_id = :p_org AND (end_date IS NULL OR end_date > SYSDATE).
• Resolving a formula referenced from a subsidy: SELECT s.formula_id, f.name, f.formula_string FROM okl_subsidies_b s JOIN okl_formulae_b f ON f.id = s.formula_id.
• Inspecting operand structure: joining OKL_FMLA_OPRNDS and OKL_OPERANDS_B on FMA_ID to enumerate the operands that compose a formula.
• Auditing changes: filtering on LAST_UPDATE_DATE and LAST_UPDATED_BY to identify recently modified formula definitions.
• Extracting custom DFF data from ATTRIBUTE1 through ATTRIBUTE15 for downstream analytics.

Because the table is a definition hub, it is frequently the driving table in extraction queries for data warehouse loads covering payment, tax, and subsidy logic.

Related Objects

OKL_FORMULAE_B participates in a broad web of relationships. The most significant documented dependencies are:

• OKL_CONTEXT_GROUPS_B — referenced via CGR_ID; supplies the context group required by each formula.
• OKL_FMLA_OPRNDS and OKL_OPERANDS_B — child tables joined on FMA_ID that define the operands composing a formula.
• OKL_SUBSIDIES_B and OKL_SUBSIDIES_ALL_B — reference formulae through FORMULA_ID and REFUND_FORMULA_ID for subsidy and refund calculation.
• OKL_PRTFL_LINES_B — references formulae via FMA_ID for portfolio line computations.
• OKL_AE_TEMPLATES_ALL and OKL_AE_TEMPLATES — reference formulae through FMA_ID in accounting entry templates.
• OKL_TAX_BASIS_OVERRIDE and OKL_TAXBASISOVERRIDE_ALL — reference formulae via FMA_ID to drive tax basis overrides.

These relationships confirm the table's role as a central definition reference across leasing calculations, subsidies, tax treatment, and accounting generation.