Search Results zx_taxes_b




Overview
Explore in AI Chat

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.

  • Table: ZX_TAXES_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_TAXES_B,  object_name:ZX_TAXES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores taxes for multiple configuration owners. Each row stores a tax for a specific regime and configuration owner. ,  implementation_dba_data: ZX.ZX_TAXES_B , 

  • Table: ZX_TAXES_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_TAXES_B,  object_name:ZX_TAXES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores taxes for multiple configuration owners. Each row stores a tax for a specific regime and configuration owner. ,  implementation_dba_data: ZX.ZX_TAXES_B , 

  • Table: ZX_PARTY_TAX_PROFILE 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PARTY_TAX_PROFILE,  object_name:ZX_PARTY_TAX_PROFILE,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax profiles for third parties, third party sites, third party providers, first party legal entities, first party legal establishments, operating units and tax authorities. ,  implementation_dba_data: ZX.ZX_PARTY_TAX_PROFILE , 

  • Table: ZX_PARTY_TAX_PROFILE 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PARTY_TAX_PROFILE,  object_name:ZX_PARTY_TAX_PROFILE,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax profiles for third parties, third party sites, third party providers, first party legal entities, first party legal establishments, operating units and tax authorities. ,  implementation_dba_data: ZX.ZX_PARTY_TAX_PROFILE , 

  • Table: ZX_PARTY_TYPES 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PARTY_TYPES,  object_name:ZX_PARTY_TYPES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores party types. ,  implementation_dba_data: ZX.ZX_PARTY_TYPES , 

  • Table: ZX_PARTY_TYPES 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PARTY_TYPES,  object_name:ZX_PARTY_TYPES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores party types. ,  implementation_dba_data: ZX.ZX_PARTY_TYPES , 

  • Table: ZX_TAXES_TL 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_TAXES_TL,  object_name:ZX_TAXES_TL,  status:VALID,  product: ZX - E-Business Tax ,  description: This table provides multilingual support (MLS) for each tax. MLS enables you to store and print data that you define in multiple languages. ,  implementation_dba_data: ZX.ZX_TAXES_TL , 

  • Table: ZX_TAXES_TL 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_TAXES_TL,  object_name:ZX_TAXES_TL,  status:VALID,  product: ZX - E-Business Tax ,  description: This table provides multilingual support (MLS) for each tax. MLS enables you to store and print data that you define in multiple languages. ,  implementation_dba_data: ZX.ZX_TAXES_TL , 

  • Table: ZX_DET_FACTOR_TEMPL_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_DET_FACTOR_TEMPL_B,  object_name:ZX_DET_FACTOR_TEMPL_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores templates for usage of determining factors. Each record represents one determining factor template. ,  implementation_dba_data: ZX.ZX_DET_FACTOR_TEMPL_B , 

  • Table: ZX_DET_FACTOR_TEMPL_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_DET_FACTOR_TEMPL_B,  object_name:ZX_DET_FACTOR_TEMPL_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores templates for usage of determining factors. Each record represents one determining factor template. ,  implementation_dba_data: ZX.ZX_DET_FACTOR_TEMPL_B , 

  • Table: ZX_REC_NREC_DIST 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REC_NREC_DIST,  object_name:ZX_REC_NREC_DIST,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax distributions. Each record stores a recoverable or non-recoverable tax distribution line. ,  implementation_dba_data: ZX.ZX_REC_NREC_DIST , 

  • Table: ZX_REC_NREC_DIST 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REC_NREC_DIST,  object_name:ZX_REC_NREC_DIST,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax distributions. Each record stores a recoverable or non-recoverable tax distribution line. ,  implementation_dba_data: ZX.ZX_REC_NREC_DIST , 

  • Table: ZX_REGIMES_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REGIMES_B,  object_name:ZX_REGIMES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table defines and describes Tax Regime and related attributes. There will be one row per distinct tax regime. There are default entry columns to facilitate data entry process. ,  implementation_dba_data: ZX.ZX_REGIMES_B , 

  • Table: ZX_REGIMES_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REGIMES_B,  object_name:ZX_REGIMES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table defines and describes Tax Regime and related attributes. There will be one row per distinct tax regime. There are default entry columns to facilitate data entry process. ,  implementation_dba_data: ZX.ZX_REGIMES_B , 

  • Table: ZX_LINES 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES,  object_name:ZX_LINES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores detail tax lines for transactions of multiple event classes. ,  implementation_dba_data: ZX.ZX_LINES , 

  • Table: ZX_LINES 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES,  object_name:ZX_LINES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores detail tax lines for transactions of multiple event classes. ,  implementation_dba_data: ZX.ZX_LINES ,