Search Results zx_registrations

Overview

The ZX_REGISTRATIONS table is a core data repository within the Oracle E-Business Tax (ZX) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the central table for storing all tax registration information for legal entities and parties within the system. A tax registration is the formal enrollment of a party with a tax authority for a specific tax regime and jurisdiction, establishing the party's obligation to collect, report, and remit taxes. This table is fundamental to the tax determination and compliance processes, enabling the system to apply the correct tax rules based on a party's registered status for various taxes across different geographical regions.

Key Information Stored

The table's primary key is REGISTRATION_ID, which uniquely identifies each registration record. As indicated by the foreign key relationships, the table stores several critical foreign key references that define the context of the registration. These include PARTY_TAX_PROFILE_ID, linking to the ZX_PARTY_TAX_PROFILE table to identify the registered party (e.g., a legal entity or operating unit). It also stores TAX_REGIME_CODE and TAX_JURISDICTION_CODE, referencing the ZX_REGIMES_B table and its related structures, to specify the tax and the precise geographical level (e.g., country, state, county) for which the party is registered. Furthermore, the table holds identifiers for the relevant tax authorities: TAX_AUTHORITY_ID (the assessing authority), COLL_TAX_AUTHORITY_ID (the collection authority), and REP_TAX_AUTHORITY_ID (the reporting authority), each linking to the ZX_PARTY_TAX_PROFILE table for authority details.

Common Use Cases and Queries

A primary use case is validating a party's tax registration status during transaction tax calculation. For reporting, this table is essential for generating statutory registrations reports. Administrators use it to audit and manage registration setups. Common queries involve joining with party and regime tables to list all registrations for a specific legal entity or to find registrations for a given tax regime code. For instance, a query to find a party's VAT registration might join ZX_REGISTRATIONS (ZR) with ZX_PARTY_TAX_PROFILE (ZP) on PARTY_TAX_PROFILE_ID and filter by PARTY_ID and TAX_REGIME_CODE. Another critical pattern is verifying the existence of a registration for a transaction's ship-to party and tax jurisdiction, which is a prerequisite for accurate tax determination.

Related Objects

The ZX_REGISTRATIONS table has integral relationships with several other E-Business Tax objects. It is a child table of ZX_PARTY_TAX_PROFILE, storing multiple registrations for a single party profile. It is also a child of ZX_REGIMES_B, linking registrations to the defined tax regimes. Crucially, it is a parent table to ZX_LINES via the TAX_REGISTRATION_ID foreign key, meaning every calculated tax line on an invoice or other transaction can be associated with the specific registration that governed its calculation. This creates a clear audit trail from the transaction line back to the statutory registration. The table is also referenced by various E-Business Tax views and APIs used for tax processing and reporting.