Search Results zx_recovery_types_b




Overview
Explore in AI Chat

Overview

The ZX_RECOVERY_TYPES_B table is a core repository 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 definition table for tax recovery types. A recovery type classifies how a specific tax can be recovered or reclaimed, such as being fully recoverable, partially recoverable, or non-recoverable. This classification is fundamental for accurate tax accounting, financial reporting, and determining the net tax liability for an organization. The table's structure enforces a relationship with defined tax regimes, ensuring that each recovery type is logically associated with a specific tax authority's rules.

Key Information Stored

Each row in ZX_RECOVERY_TYPES_B defines a unique recovery type within a given tax regime. The primary column is RECOVERY_TYPE_ID, which serves as the unique identifier (primary key) for each recovery type definition. The TAX_REGIME_CODE column is a critical foreign key that links the recovery type to its governing tax regime in the ZX_REGIMES_B table. While the provided metadata does not list all columns, typical attributes stored in such a base table would include internal codes, effective dates (START_DATE, END_DATE), creation and last update metadata (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE), and potentially an object version number. The descriptive, translatable name for the recovery type is stored in the related ZX_RECOVERY_TYPES_TL table.

Common Use Cases and Queries

This table is primarily accessed for setup validation, tax determination logic, and reporting on tax recoverability. A common operational query involves listing all active recovery types for a specific tax regime to verify setup or for use in a list of values during transaction tax configuration. For example: SELECT recovery_type_id, tax_regime_code FROM zx_recovery_types_b WHERE tax_regime_code = 'VAT_REGIME_UK' AND SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE). In reporting, the table is joined to transaction tax lines to analyze the distribution of recoverable versus non-recoverable tax amounts, impacting financial statements and cash flow forecasts. It is also critical during the tax calculation process, where the assigned recovery type determines the accounting entries for tax recovery.

Related Objects

The ZX_RECOVERY_TYPES_B table is central to several key relationships within the E-Business Tax schema. Its primary key is referenced by multiple dependent objects:

  • ZX_REGIMES_B: A foreign key constraint on ZX_RECOVERY_TYPES_B.TAX_REGIME_CODE ensures every recovery type is defined under a valid tax regime.
  • ZX_RECOVERY_TYPES_TL: This translation table holds the language-specific names and descriptions for each recovery type, joined via ZX_RECOVERY_TYPES_TL.RECOVERY_TYPE_ID.
  • ZX_REC_NREC_DIST: This table, which likely stores detailed distributions for recoverable and non-recoverable tax, references the master definition via ZX_REC_NREC_DIST.RECOVERY_TYPE_ID.
These relationships illustrate the table's role as a source of validated reference data for descriptive content and transactional processing.