Search Results okl_subsidies_b

Overview

The OKL_SUBSIDIES_B table is a core data object within the Oracle E-Business Suite (EBS) Lease and Finance Management (OKL) module, specifically in versions 12.1.1 and 12.2.2. It serves as the primary repository for defining and storing subsidy setups. In the context of lease and asset finance, a subsidy represents a financial incentive, such as a government grant or a manufacturer's rebate, which reduces the overall cost of the leased asset for the lessee. This table is foundational for configuring how these subsidies are calculated, applied, and potentially refunded throughout the lease lifecycle, enabling complex financing structures and accurate financial accounting.

Key Information Stored

While the provided metadata does not list individual columns, the documented foreign key relationships reveal critical data points stored in the table. The primary identifier is the ID column, which serves as the primary key. The table centrally stores references to the calculation logic for the subsidy through the FORMULA_ID column, which links to the OKL_FORMULAE_B table. Similarly, it can define refund logic via the REFUND_FORMULA_ID, also linking to OKL_FORMULAE_B. Furthermore, the STREAM_TYPE_ID column links the subsidy to a specific financial stream type (e.g., income, liability) defined in the OKL_STRM_TYPE_B table, determining its accounting treatment. Additional columns, typical for such setups, would include subsidy name, description, effective dates, status, and associated amounts or percentage rates.

Common Use Cases and Queries

This table is primarily accessed during the setup and administration of subsidy programs and during transaction processing. A common operational query involves retrieving active subsidy setups for a specific product or asset type to present valid options during contract booking. For reporting and audit purposes, analysts may run queries to list all subsidies, their associated formulas, and their stream types. A typical SQL pattern would join OKL_SUBSIDIES_B with OKL_FORMULAE_B to display the calculation details.

• Sample Query: SELECT s.id, s.name, f.formula_code, st.name AS stream_type FROM okl_subsidies_b s, okl_formulae_b f, okl_strm_type_b st WHERE s.formula_id = f.id AND s.stream_type_id = st.id AND s.effective_to_date IS NULL;
• Use Case: Configuring a manufacturer's rebate that reduces the capital cost of a vehicle at lease inception, with a pro-rata refund formula applicable if the lease terminates early.

Related Objects

The OKL_SUBSIDIES_B table is integral to the OKL data model, with key dependencies as per the provided metadata. Its primary relationships are:

• OKL_FORMULAE_B: Linked twice via FOREIGN KEY constraints. The FORMULA_ID column references the formula for calculating the initial subsidy amount, while the REFUND_FORMULA_ID references the formula for calculating any refund amount.
• OKL_STRM_TYPE_B: Linked via the STREAM_TYPE_ID foreign key, classifying the subsidy into a specific accounting stream for proper revenue or cost recognition.
• OKL_SUBSIDIES_TL: (Inferred standard practice) A corresponding Translation table storing multilingual descriptions for the subsidy setups, keyed by the ID from OKL_SUBSIDIES_B.
• OKL Contracts and Lines Tables: (Inferred) Subsidy setups from this table are typically assigned to lease contracts or lines, influencing payment streams and asset cost basis, though these specific foreign keys are not listed in the excerpt.