Search Results okl_tax_sources

Overview

The OKL_TAX_SOURCES table is a core transactional data store within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It serves as the central repository for capturing and storing detailed information about taxable lines generated from Oracle Lease Management (OLM) tax events. Its primary role is to act as the source data layer for downstream tax calculation and processing, linking individual financial transactions to the complex tax rules and jurisdictions applicable to leasing contracts. The table's existence is critical for ensuring accurate tax determination, reporting, and compliance for lease and finance agreements managed within the system.

Key Information Stored

The table's structure is defined by its foreign key relationships, which reveal the key entities it connects. The central columns store identifiers that link a taxable line to its originating contract and transaction components. The primary key is the ID column. Essential foreign key columns include KHR_ID (linking to the contract header in OKC_K_HEADERS_B), KLE_ID (linking to the specific contract line in OKC_K_LINES_B), and TRY_ID (linking to the transaction type in OKL_TRX_TYPES_B). For stream-based calculations, it links via SEL_ID to OKL_STRM_ELEMENTS and via STY_ID to OKL_STRM_TYPE_B. Crucially, it stores customer site information for accurate tax jurisdiction sourcing, including BILL_TO_CUST_ACCT_SITE_USE_ID, SHIP_TO_CUST_ACCT_SITE_USE_ID, and their corresponding party site IDs. The ORG_ID ties the record to the operating unit.

Common Use Cases and Queries

This table is primarily accessed for tax inquiry, audit reporting, and troubleshooting tax calculation issues. A common use case is tracing the taxability of a specific invoice line back to its source lease contract and stream elements. For example, to analyze all taxable sources for a specific contract, a query would join to OKC_K_HEADERS_B. Reporting on tax applicability by customer site would involve joins to HZ_CUST_SITE_USES_ALL. Technical support often queries this table to verify that all expected transactional lines (e.g., rent, interest) have been correctly populated as tax sources before tax engine invocation. Sample SQL patterns typically start with a SELECT from OKL_TAX_SOURCES, filtering by KHR_ID or ORG_ID, and include joins to descriptive tables like OKL_TRX_TYPES_B and HZ_CUST_ACCOUNTS for meaningful output.

Related Objects

The OKL_TAX_SOURCES table sits at a critical junction, integrating data from multiple EBS modules. Its documented foreign key relationships are as follows:

• OKC_K_HEADERS_B: Via KHR_ID. Links to the leasing contract.
• OKC_K_LINES_B: Via KLE_ID. Links to the specific line item of the contract.
• OKL_TRX_TYPES_B: Via TRY_ID. Identifies the transaction type (e.g., Invoice, Credit).
• OKL_STRM_ELEMENTS: Via SEL_ID. Links to the detailed payment stream element.
• OKL_STRM_TYPE_B: Via STY_ID. Links to the type of payment stream.
• HZ_CUST_SITE_USES_ALL: Via BILL_TO_CUST_ACCT_SITE_USE_ID and SHIP_TO_CUST_ACCT_SITE_USE_ID. Provides bill-to and ship-to customer site details for tax jurisdiction.
• HZ_CUST_ACCOUNTS: Via BILL_TO_CUST_ACCT_ID. Links to the customer account.
• HZ_PARTY_SITES: Via BILL_TO_PARTY_SITE_ID and SHIP_TO_PARTY_SITE_ID. Provides party-level site information.
• HR_ALL_ORGANIZATION_UNITS: Via ORG_ID. Identifies the operating unit.
• OKL_TAX_TRX_DETAILS: This table holds a foreign key (TXS_ID) referencing OKL_TAX_SOURCES.ID, making it a primary child table where calculated tax amounts are stored.