Search Results fod_fod_uk

Overview

The OKL_FMLA_OPRNDS table is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It functions as an association or junction table, establishing the many-to-many relationship between financial formulae and their constituent operands. This structure is fundamental to the module's ability to define and execute complex financial calculations for lease and finance contracts, such as pricing, billing, and accrual computations. By linking formulae (OKL_FORMULAE_B) to operands (OKL_OPERANDS_B), it provides the necessary metadata for the system to dynamically assemble and process calculation logic based on specific contract terms and conditions.

Key Information Stored

The table primarily stores foreign key references that create the associative links. Its critical columns include the unique identifier (ID) and the two foreign key columns that define the relationships. The primary key constraint FOD_FOD_UK, defined on the combination of OPD_ID and FMA_ID, enforces the rule that a specific operand can be associated with a specific formula only once, ensuring data integrity. The column FMA_ID references a unique formula definition in the OKL_FORMULAE_B table, while OPD_ID references a specific operand (like a variable, constant, or another formula) in the OKL_OPERANDS_B table. The order or sequence of operands within a formula, while not explicitly detailed in the provided metadata, is often managed by an additional column or is implied by the application logic that reads these associations.

Common Use Cases and Queries

The primary use case is the dynamic construction and validation of financial calculations. For instance, when generating an invoice for a lease, the system queries this table to determine all operands required for the billing formula. Common reporting and diagnostic queries involve listing the components of a formula or identifying all formulae that use a particular operand. A sample SQL pattern to retrieve all operands for a given formula would be:

• SELECT opd.* FROM okl_fmla_oprnds fod, okl_operands_b opd WHERE fod.opd_id = opd.id AND fod.fma_id = <FORMULA_ID>;

Conversely, to find all formulae using a specific operand:

• SELECT fma.* FROM okl_fmla_oprnds fod, okl_formulae_b fma WHERE fod.fma_id = fma.id AND fod.opd_id = <OPERAND_ID>;

Related Objects

OKL_FMLA_OPRNDS is centrally positioned between two key master definition tables, as documented by its foreign key relationships. It has no independent meaning without these references.

• OKL_FORMULAE_B: This table stores the master definition of financial formulae. The relationship is established via the column OKL_FMLA_OPRNDS.FMA_ID, which references OKL_FORMULAE_B.
• OKL_OPERANDS_B: This table stores the definition of all available operands (e.g., interest rate, asset cost, lease term). The relationship is established via the column OKL_FMLA_OPRNDS.OPD_ID, which references OKL_OPERANDS_B.

These relationships are critical for maintaining referential integrity; a record in OKL_FMLA_OPRNDS cannot exist without a corresponding parent record in both of these tables.