Search Results okl_tbc_definitions

Overview

The OKL_TBC_DEFINITIONS table is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It serves as a master repository for defining Tax Benefit Certificates (TBCs). A TBC is a critical document in leasing and asset finance that certifies eligibility for tax benefits, such as depreciation or investment credits, associated with a leased asset. The table's primary role is to establish and maintain the definitions and rules governing these certificates, linking them to specific products, transaction types, and vendor sites within the financial system. Its structure enforces business rules through defined relationships with other master data tables, ensuring data integrity for tax-related calculations and compliance reporting.

Key Information Stored

While the full column list is not provided in the excerpt, the documented foreign key relationships and primary key reveal the essential data elements. The primary identifier is the TBC_CODE, which uniquely defines each certificate type. The table stores foreign key references that contextualize the TBC within the broader application: the PDT_ID links to a specific leasing product in OKL_PRODUCTS; the STY_ID associates the certificate with a stream type in OKL_STRM_TYPE_B; the TRY_ID ties it to a transaction type in OKL_TRX_TYPES_B; and the VENDOR_SITE_ID connects it to a specific vendor site in PO_VENDOR_SITES_ALL. This structure indicates the table likely also holds descriptive columns for the certificate name, active status, and effective dates.

Common Use Cases and Queries

This table is central to configurations where tax benefits are a component of lease pricing, accounting, and asset management. A common use case is the setup and validation of TBCs for new leasing products or vendor programs. For reporting, it is queried to list all active certificate definitions or to analyze TBC assignments. A typical SQL pattern involves joining to its referenced tables to produce a descriptive list:

• SELECT tbc.tbc_code, prod.name product_name, sty.name stream_type
  FROM okl_tbc_definitions tbc,
  okl_products prod,
  okl_strm_type_b sty
  WHERE tbc.pdt_id = prod.id
  AND tbc.sty_id = sty.id
  AND SYSDATE BETWEEN tbc.start_date AND NVL(tbc.end_date, SYSDATE);

Another critical use is during transaction processing, where the system references the TBC definition to determine the correct tax treatment for a lease stream or invoice.

Related Objects

The OKL_TBC_DEFINITIONS table has defined foreign key relationships with several key master tables in the OKL and Purchasing modules. These relationships are fundamental to its function:

• OKL_PRODUCTS: Joined via PDT_ID. Links a Tax Benefit Certificate definition to the specific leasing product for which it is valid.
• OKL_STRM_TYPE_B: Joined via STY_ID. Associates the certificate with a financial stream type, connecting it to revenue or payment schedules.
• OKL_TRX_TYPES_B: Joined via TRY_ID. Ties the certificate definition to a specific transaction type within the leasing module.
• PO_VENDOR_SITES_ALL: Joined via VENDOR_SITE_ID. Connects the TBC to a specific vendor site, which is essential for vendor-specific tax certification programs.

The table is also referenced by its primary key, OKL_TBC_PK (TBC_CODE), which is likely used by child transactional tables (not listed in the provided metadata) that record the actual application of a certificate to a lease contract or asset.