Search Results okl_taxbasisoverride_all

Overview

The OKL_TAXBASISOVERRIDE_ALL table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Leasing and Finance Management (OKL) module. Its primary function is to store the taxable basis override formula for tax-related transactions. In leasing and finance operations, the standard taxable basis for a transaction may need to be recalculated based on specific contractual or regulatory requirements. This table provides the mechanism to define and link a custom formula that overrides the default tax basis calculation, enabling precise and compliant tax handling for complex financial agreements.

Key Information Stored

The table's structure is designed to associate a transaction type with a specific override formula within an organizational context. The primary key is a composite of TRY_ID and ORG_ID, ensuring uniqueness per transaction type and operating unit. Key columns include TRY_ID, which stores the identifier for the transaction type from the OKL_TRX_TYPES_B table, and FMA_ID, which stores the foreign key to the specific override formula defined in the OKL_FORMULAE_B table. The ORG_ID column is critical for multi-org partitioning, segregating data by operating unit as per the standard EBS '_ALL' table convention. Together, these columns create a definitive rule mapping for taxable basis overrides.

Common Use Cases and Queries

A primary use case is configuring the system to apply a specialized tax calculation for a particular lease transaction type, such as a municipal lease with unique tax exemptions. Administrators would create a formula in the OKL_FORMULAE_B table and then establish a link in this table. Common queries involve validating setups or troubleshooting tax calculations. For example, to list all configured overrides for an operating unit (ID 204), one might use:

• SELECT try_id, fma_id FROM okl_taxbasisoverride_all WHERE org_id = 204;

For reporting or diagnostic purposes, a join to view the associated transaction type and formula names is typical:

• SELECT ovd.try_id, typ.name trx_type, ovd.fma_id, fma.name formula_name FROM okl_taxbasisoverride_all ovd, okl_trx_types_b typ, okl_formulae_b fma WHERE ovd.try_id = typ.id AND ovd.fma_id = fma.id AND ovd.org_id = 204;

Related Objects

This table maintains integral foreign key relationships with other foundational OKL tables, as documented in the ETRM metadata. The key dependencies are:

• OKL_TRX_TYPES_B: Joined via the TRY_ID column. This table defines the valid transaction types within the leasing module.
• OKL_FORMULAE_B: Joined via the FMA_ID column. This table stores the definition of the executable formula, including its logic and components, which performs the actual taxable basis calculation override.

The presence of the ORG_ID column also implies a relationship with the HR_OPERATING_UNITS table, which defines the organizational structure in EBS. The primary key constraint OKL_TAXBASISOVERRIDE_ALL_PK enforces data integrity for the core TRY_ID and ORG_ID columns.