Search Results zx_taxes_b

Overview

The ZX_TAXES_B table is a core repository within the Oracle E-Business Tax (ZX) module for Oracle E-Business Suite releases 12.1.1 and 12.2.2. It serves as the primary definition table for all tax codes configured within the system. Its fundamental role is to store master tax records, each uniquely associated with a specific tax regime and a configuration owner. This structure enables the support of multiple legal entities or configuration owners within a single installation, a critical feature for global deployments. The table is central to the tax engine's operation, as tax codes defined here are referenced throughout the transaction tax calculation and reporting processes.

Key Information Stored

Each row in ZX_TAXES_B defines a single tax code. The primary identifier is the TAX_ID. Key descriptive and control columns include TAX (the tax code), TAX_REGIME_CODE (linking to the governing tax regime in ZX_REGIMES_B), and CONTENT_OWNER_ID (identifying the configuration owner via ZX_PARTY_TAX_PROFILE). Other significant columns manage the tax's operational behavior, such as TAX_CURRENCY_CODE (linked to FND_CURRENCIES), EXCHANGE_RATE_TYPE (linked to GL_RATE_TYP), and DEF_REGISTR_PARTY_TYPE_CODE (for default party type). The table also stores references to tax authorities for reporting (REP_TAX_AUTHORITY_ID) and collection (COLL_TAX_AUTHORITY_ID), and a threshold checking template code (THRSHLD_CHK_TMPLT_CODE linked to ZX_DET_FACTOR_TEMPL_B).

Common Use Cases and Queries

This table is essential for tax setup inquiries, data validation, and integration reporting. Common scenarios include listing all taxes for a specific regime, validating tax code attributes, and troubleshooting tax calculation issues by examining a tax's foundational setup. A typical query retrieves tax details along with descriptive regime information:

• SELECT zb.tax, zb.tax_id, zb.tax_regime_code, zr.regime_name, zb.effective_from FROM zx_taxes_b zb, zx_regimes_b zr WHERE zb.tax_regime_code = zr.tax_regime_code AND zb.content_owner_id = :p_owner_id ORDER BY zb.tax_regime_code, zb.tax;

Another frequent use case is identifying taxes using a specific currency or exchange rate type for financial reporting purposes. Direct data manipulation (DML) on this table is strongly discouraged; all maintenance should be performed via the standard E-Business Tax Manager user interface or supported APIs.

Related Objects

ZX_TAXES_B has extensive relationships with other E-Business Tax objects, as indicated by its foreign key constraints. It is a parent table to several key transactional and setup tables, including ZX_LINES (transaction tax lines), ZX_REC_NREC_DIST (recoverable/non-recoverable tax distributions), and ZX_TAXES_TL (translated tax names). Its primary foreign key dependencies link to ZX_REGIMES_B (tax regime), ZX_PARTY_TAX_PROFILE (for content owner and tax authorities), FND_CURRENCIES, and ZX_DET_FACTOR_TEMPL_B. This network of relationships underscores its position as a cornerstone of the tax data model.