Search Results okl_subsidy_criteria




Overview
Explore in AI Chat

Overview

The OKL_SUBSIDY_CRITERIA table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Lease and Finance Management (OKL) module. It functions as the master repository for defining the specific applicability rules, or criteria, that determine whether a financial subsidy can be applied to a lease or finance transaction. A subsidy, in this context, is a financial incentive or rebate offered by a vendor or lessor. This table's role is to store the detailed conditions—such as eligible products, items, or geographic regions—that a transaction must meet to qualify for the associated subsidy, thereby enabling precise and automated subsidy validation and application during contract booking and management.

Key Information Stored

The table's primary purpose is to link a subsidy to its qualifying conditions through key foreign key relationships. The central column is SUBSIDY_ID, which ties each criterion record back to its parent subsidy definition in the OKL_SUBSIDIES_ALL_B table. The criteria themselves are defined through columns that reference other master data entities. The INVENTORY_ITEM_ID and ORGANIZATION_ID pair specify an eligible inventory item from the product catalog (MTL_SYSTEM_ITEMS_B). The PRODUCT_ID references a financial product defined within the OKL module (OKL_PRODUCTS table). The SALES_TERRITORY_CODE defines an eligible geographic region based on the FND_TERRITORIES table. The unique identifier for each criterion record is the ID column, which serves as the primary key.

Common Use Cases and Queries

A primary use case is the validation engine within the subsidy process, which queries this table to check if a proposed lease contract qualifies for any active subsidies based on its product, asset, and territory. For reporting and analysis, common queries involve listing all criteria for a specific subsidy or identifying all subsidies applicable to a particular item or region. A typical SQL pattern would join OKL_SUBSIDY_CRITERIA to OKL_SUBSIDIES_ALL_B to get a comprehensive view.

  • Sample Query: SELECT s.subsidy_number, c.inventory_item_id, c.sales_territory_code FROM okl_subsidy_criteria c, okl_subsidies_all_b s WHERE c.subsidy_id = s.id AND s.status = 'ACTIVE';
  • Administration: Users configure subsidy rules via the Oracle EBS forms interface, which creates, updates, or deletes records in this table.
  • Troubleshooting: When a subsidy fails to apply as expected, this table is examined to verify the configured criteria match the transaction attributes.

Related Objects

OKL_SUBSIDY_CRITERIA is centrally connected to several key master tables via documented foreign key constraints. Its relationships are fundamental to the subsidy functionality.

  • OKL_SUBSIDIES_ALL_B: This is the parent table. The SUBSIDY_ID column in OKL_SUBSIDY_CRITERIA references the ID in OKL_SUBSIDIES_ALL_B, linking each criterion to its subsidy header.
  • MTL_SYSTEM_ITEMS_B: The combination of INVENTORY_ITEM_ID and ORGANIZATION_ID references this table to define eligible inventory items.
  • FND_TERRITORIES: The SALES_TERRITORY_CODE column references the TERRITORY_CODE in this table to restrict subsidies by geographic region.
  • OKL_PRODUCTS: The PRODUCT_ID column references this table to link subsidies to specific lease or finance products defined within the OKL module.