Search Results okl_opt_rules




Overview
Explore in AI Chat

Overview

The OKL_OPT_RULES table is a core intersection entity within the Oracle E-Business Suite (EBS) Lease and Finance Management (OKL) module, specifically for versions 12.1.1 and 12.2.2. Its primary function is to manage the association between lease options and the business rules that govern them. An option, such as a purchase or renewal clause in a lease contract, is subject to specific validation and processing logic. This table serves as the definitive mapping layer, linking an option (OPT_ID) to its applicable rule definitions from the rule engine framework. It is a critical component for enforcing complex lease accounting and operational policies defined within the system.

Key Information Stored

The table stores foreign key references that establish relationships between options, rule groups, and specific rule definitions. The primary key is the surrogate ID column. Key columns include OPT_ID, which links to the OKL_OPTIONS table to identify the specific lease option. The columns LRG_LSE_ID and LRG_SRD_ID together form a foreign key to the OKC_LSE_RULE_GROUPS table, connecting the option to a specific rule group assigned to a lease. The columns RGR_RGD_CODE and RGR_RDF_CODE reference the OKC_RG_DEF_RULES table to pinpoint a specific rule within a rule group definition. Finally, SRD_ID_FOR links to OKC_SUBCLASS_RG_DEFS, associating the rule with a rule definition subclass.

Common Use Cases and Queries

This table is central to reporting and troubleshooting the business logic attached to lease options. A common use case is auditing all rules associated with a particular lease option to verify configuration. Development and support teams query this table to understand the rule flow during option-related processes like exercising a purchase option. A typical query would join OKL_OPT_RULES with OKL_OPTIONS and OKC_RG_DEF_RULES to list all rules for an option.

  • Find all rules for a specific option ID: SELECT * FROM OKL.OKL_OPT_RULES WHERE OPT_ID = <option_id>;
  • Report on option-rule associations for a lease: SELECT o.OPT_ID, r.* FROM OKL_OPT_RULES r, OKL_OPTIONS o WHERE r.OPT_ID = o.ID AND o.KHR_ID = <lease_id>;

Related Objects

OKL_OPT_RULES is a nexus table with defined foreign key relationships to several key rule and option entities. The documented relationships are as follows:

  • OKL_OPTIONS: References via OKL_OPT_RULES.OPT_ID. This is the parent option definition.
  • OKC_LSE_RULE_GROUPS: References via OKL_OPT_RULES.LRG_LSE_ID and LRG_SRD_ID. This links to the rule group instance on a lease, which was the object of the user's original search.
  • OKC_RG_DEF_RULES: References via OKL_OPT_RULES.RGR_RGD_CODE and RGR_RDF_CODE. This points to the specific rule definition within the rule framework.
  • OKC_SUBCLASS_RG_DEFS: References via OKL_OPT_RULES.SRD_ID_FOR. This associates the rule with a subclass definition.
  • OKL_OPV_RULES: Referenced by OKL_OPV_RULES.ORL_ID. This table stores the actual values or parameters for the rules defined in OKL_OPT_RULES.