Search Results okl_subsidies_all_b




Overview
Explore in AI Chat

Overview

The OKL_SUBSIDIES_ALL_B 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 serves as the primary repository for defining and storing subsidy setups. A subsidy, in the context of lease and finance contracts, represents a financial incentive or contribution, often from a third party like a manufacturer or government entity, that reduces the cost for the lessee. This table is the transactional backbone for managing these financial constructs, enabling the system to calculate, apply, and account for subsidies across various lease and finance agreements. Its multi-org structure, indicated by the "_ALL_B" suffix, allows it to store data for multiple operating units.

Key Information Stored

While the provided metadata does not list specific columns beyond key identifiers, the table's primary key and foreign key relationships define its critical data elements. The central column is the ID (primary key), which uniquely identifies each subsidy setup. Essential relational attributes include FORMULA_ID and REFUND_FORMULA_ID, which link to the OKL_FORMULAE_B table to define the calculation logic for the subsidy amount and any potential refund calculations, respectively. The STREAM_TYPE_ID links to OKL_STRM_TYPE_B, classifying the subsidy into a specific financial stream type for accounting and reporting. Other typical columns in such a base table would include audit fields (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE), an ORG_ID for multi-org support, and active/inactive status indicators.

Common Use Cases and Queries

This table is central to operations involving subsidy management. Common use cases include the creation and maintenance of subsidy templates, the application of a subsidy to a specific lease line, and generating reports on subsidy utilization. A frequent query pattern involves joining the subsidy definition with its descriptive translation (OKL_SUBSIDIES_TL) and related criteria (OKL_SUBSIDY_CRITERIA) for review. For instance, to list all active subsidies with their calculation formulas, one might use a query such as:

  • SELECT s.ID, tl.NAME, f.FORMULA_NAME
    FROM OKL_SUBSIDIES_ALL_B s,
    OKL_SUBSIDIES_TL tl,
    OKL_FORMULAE_B f
    WHERE s.ID = tl.ID
    AND tl.LANGUAGE = USERENV('LANG')
    AND s.FORMULA_ID = f.ID
    AND s.ENABLED_FLAG = 'Y';

Another critical scenario is tracing subsidies applied to contract lines via the foreign key from OKL_K_LINES.SUBSIDY_ID for financial analysis and audit trails.

Related Objects

The OKL_SUBSIDIES_ALL_B table is integral to a network of related objects within the OKL schema, as documented by its foreign key relationships.

  • Referenced By This Table (Outgoing FKs):
    • OKL_FORMULAE_B: Joined via FORMULA_ID and REFUND_FORMULA_ID to retrieve calculation logic.
    • OKL_STRM_TYPE_B: Joined via STREAM_TYPE_ID for financial classification.
  • References This Table (Incoming FKs):
    • OKL_K_LINES: The SUBSIDY_ID column links lease/finance lines to their applicable subsidy setup.
    • OKL_SUBSIDIES_TL: The ID column is the primary key for the translated descriptive data (e.g., name, description) in this language table.
    • OKL_SUBSIDY_CRITERIA: The SUBSIDY_ID column links to define the specific conditions (like asset type, region) under which a subsidy is applicable.