Search Results zx_rates_b

Overview

The ZX_RATES_B table is a core repository for tax rate data within the Oracle E-Business Tax (ZX) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It serves as the master table for storing detailed, effective-dated tax rates that are applicable to specific tax statuses or tax jurisdictions. Its primary role is to provide the definitive source of rate information used by the E-Business Tax engine to calculate tax amounts on transactions. The table supports multiple configuration owners, enabling the system to manage rates for different legal entities or tax regimes within a single installation.

Key Information Stored

Each row in ZX_RATES_B represents a unique, time-sensitive tax rate. The table's primary key is the TAX_RATE_ID, a unique identifier for each rate record. While the full column list is not detailed in the provided metadata, based on its description and standard EBS design, the table typically stores critical attributes such as the effective start and end dates for the rate, the applicable tax regime code, tax status, tax jurisdiction, and the actual rate percentage or amount. It also contains columns linking the rate to its configuration owner and controlling tax rules, ensuring the correct rate is selected during transaction processing.

Common Use Cases and Queries

The primary use case is the retrieval of applicable tax rates for real-time tax calculation on invoices, purchases, and other financial transactions. It is also central for tax reporting, compliance audits, and maintaining historical rate changes. A common reporting query involves joining ZX_RATES_B with its descriptive translation table (ZX_RATES_TL) to fetch rate details in a specific language. For example, to find all active standard tax rates for a jurisdiction, a query might filter on the jurisdiction identifier, a specific tax status (e.g., 'STANDARD'), and a SYSDATE between the effective dates. Analyzing rate history for a specific tax regime requires selecting records ordered by effective start date.

Related Objects

ZX_RATES_B has defined foreign key relationships with several other key E-Business Tax tables, as documented in the metadata. The TAX_RATE_ID column is the principal join key.

• ZX_LINES: The main transaction tax lines table references ZX_RATES_B twice—via TAX_RATE_ID for the applied rate and ORIG_TAX_RATE_ID for the original rate.
• ZX_LINES_SUMMARY: References TAX_RATE_ID to associate summarized tax amounts with the specific rate used.
• ZX_RATES_TL: A translation table that depends on ZX_RATES_B (TAX_RATE_ID) to store language-specific descriptions for the rate.
• ZX_REC_NREC_DIST: References the table twice, using TAX_RATE_ID for the tax rate and RECOVERY_RATE_ID for a related recovery rate in the context of recoverable/non-recoverable tax distributions.

These relationships underscore the table's central position in the tax calculation and posting architecture.