Search Results zx_status_b

Overview

The ZX_STATUS_B table is a core data object within the Oracle E-Business Tax (ZX) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It functions as the master repository for tax status definitions. A tax status is a critical component of the tax determination engine, representing a specific condition or classification of a transaction that influences the applicable tax rate and rules. The table is designed to support multiple configuration owners, meaning a single status can be defined and managed by different entities (such as different legal entities or tax regimes) within the application, enabling a flexible and multi-organization tax setup.

Key Information Stored

Each row in ZX_STATUS_B defines a unique tax status. While the full column list is not detailed in the provided metadata, the primary and foreign key relationships reveal its essential structure. The primary identifier is the TAX_STATUS_ID. Each status is explicitly linked to a tax regime via the TAX_REGIME_CODE foreign key to ZX_REGIMES_B, ensuring the status is valid within a specific tax jurisdiction. The CONTENT_OWNER_ID column, linked to ZX_PARTY_TAX_PROFILE, identifies the configuration owner responsible for the status record. Other typical columns in such a table would include fields for the status code, name, effective dates, and tax classification codes, which are essential for the tax engine's logic and determination processes.

Common Use Cases and Queries

This table is central to tax setup, reporting, and transaction analysis. A common use case involves querying all active tax statuses for a specific tax regime to validate configuration or for reporting purposes. For instance, to list statuses for a VAT regime owned by a specific legal entity, a query might join ZX_STATUS_B with ZX_REGIMES_B and ZX_PARTY_TAX_PROFILE. Another critical scenario is troubleshooting tax calculations on transactions; analysts often trace from a transaction line (via ZX_LINES.TAX_STATUS_ID) back to ZX_STATUS_B to verify the applied status. A basic diagnostic query would be:

• SELECT s.tax_status_id, s.tax_regime_code, s.status_code, zl.trx_line_id FROM zx_status_b s, zx_lines zl WHERE s.tax_status_id = zl.tax_status_id AND zl.trx_id = <transaction_id>;

Related Objects

ZX_STATUS_B is a pivotal hub within the E-Business Tax schema. Its primary key is referenced by several key transactional and setup tables, as indicated by the foreign keys. The ZX_STATUS_TL table holds translated descriptions for the statuses. The ZX_LINES table references TAX_STATUS_ID (and ORIG_TAX_STATUS_ID) to store the determined tax status for each transaction line. The ZX_REC_NREC_DIST table uses it for recoverable and non-recoverable tax distributions. For setup, it is linked to ZX_REGIMES_B for the tax regime and ZX_PARTY_TAX_PROFILE for the content owner, forming a complete configuration hierarchy.