Search Results okl_tax_trx_details




Overview
Explore in AI Chat

Overview

The OKL_TAX_TRX_DETAILS table is a core data object within the Oracle E-Business Suite (EBS) Lease and Finance Management (OKL) module. It serves as the primary repository for detailed tax line information generated by Oracle Lease Management (OLM) tax events. Its role is critical for the accurate calculation, storage, and auditability of tax transactions associated with lease and financing contracts. The table captures granular tax data, linking tax amounts to specific source transactions, legal entities, and application contexts, thereby forming a foundational component of the tax accounting and reporting infrastructure in EBS 12.1.1 and 12.2.2.

Key Information Stored

The table stores detailed attributes for each tax line. While the full column list is not provided in the metadata, the documented foreign key relationships and primary key structure indicate several critical data points. The primary key is the ID column, uniquely identifying each tax detail record. Key foreign key columns include TXS_ID, which links to the OKL_TAX_SOURCES table to identify the originating transaction source. APPLICATION_ID references FND_APPLICATION to specify the EBS application context. INTERNAL_ORGANIZATION_ID links to HR_ALL_ORGANIZATION_UNITS, associating the tax line with a specific legal entity or operating unit. Other typical columns in such a table would include tax amounts (calculated, taxable basis), tax rates, tax jurisdiction codes, tax recovery types, and timestamps for creation and last update.

Common Use Cases and Queries

This table is primarily accessed for tax reporting, reconciliation, and troubleshooting within lease accounting. Common scenarios include generating tax liability reports by legal entity, auditing tax calculations for specific invoices or lease streams, and supporting period-end close processes. A typical query might join to related master tables to analyze tax details.

  • Tax Detail Report for a Transaction Source: SELECT ttd.* FROM okl_tax_trx_details ttd WHERE ttd.txs_id = :p_txs_id ORDER BY ttd.id;
  • Tax Summary by Organization: SELECT hou.name, SUM(ttd.tax_amount) FROM okl_tax_trx_details ttd JOIN hr_all_organization_units hou ON hou.organization_id = ttd.internal_organization_id WHERE ttd.creation_date BETWEEN :p_start_date AND :p_end_date GROUP BY hou.name;
  • Reconciliation with Source Systems: Queries often join OKL_TAX_TRX_DETAILS with OKL_TAX_SOURCES and transaction tables like OKL_TRX_CONTRACTS to trace tax lines back to the original lease contract and invoice lines.

Related Objects

The table is centrally connected to other key EBS objects through documented foreign key relationships. These relationships are essential for accurate data retrieval and integrity.

  • OKL_TAX_SOURCES: Linked via the TXS_ID column. This is the primary parent table, identifying the source transaction (e.g., an invoice, payment) for which the tax detail was created.
  • FND_APPLICATION: Linked via the APPLICATION_ID column. This defines the EBS product application (like OKL) that generated the tax line.
  • HR_ALL_ORGANIZATION_UNITS: Linked via the INTERNAL_ORGANIZATION_ID column. This ties the tax detail to a specific legal entity or operating unit for financial and reporting purposes.
  • Self-Referential Foreign Key: The metadata indicates a foreign key from OKL_TAX_TRX_DETAILS.TXS_ID back to the same table (OKL_TAX_TRX_DETAILS). This likely supports hierarchical tax structures or adjustments, where one detail line can reference another.