Search Results zx_regimes_usages




Overview
Explore in AI Chat

Overview

The ZX_REGIMES_USAGES table is a core repository within the Oracle E-Business Tax (ZX) module for Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the definitive mapping table that associates a first-party legal entity or operating unit with the tax regimes under which it is obligated to calculate and report taxes. This association is fundamental to the tax determination engine, as it defines the universe of applicable tax rules for any transaction originating from a given first-party organization. The table's integrity is maintained by a primary key on REGIME_USAGE_ID and critical foreign key relationships to master data tables for parties and tax regimes.

Key Information Stored

The table's primary purpose is to establish the link between a first-party organization and a tax regime. The most critical columns for this function are FIRST_PTY_ORG_ID, which references a party tax profile in ZX_PARTY_TAX_PROFILE, and TAX_REGIME_CODE, which references a defined regime in ZX_REGIMES_B. The unique identifier for each association is the REGIME_USAGE_ID, a system-generated primary key. Additional columns, not detailed in the provided metadata but typical for such setups, would include creation and last update dates, and potentially status flags to control the active use of a regime for the organization.

Common Use Cases and Queries

A primary use case is validating or reporting the complete list of tax regimes applicable to a specific legal entity. This is essential for configuration audits and troubleshooting tax determination issues. For instance, if a transaction is not picking up an expected tax, a consultant would first verify the regime is registered for the transacting entity in this table. A common reporting query would join to ZX_PARTY_TAX_PROFILE and ZX_REGIMES_B to provide descriptive names.

  • Sample Query: To find all regimes for a specific party tax profile ID (e.g., 10001):
    SELECT zru.regime_usage_id, zru.tax_regime_code, zb.regime_name
    FROM zx_regimes_usages zru,
    zx_regimes_b zb
    WHERE zru.tax_regime_code = zb.tax_regime_code
    AND zru.first_pty_org_id = 10001;
  • Configuration: The data in this table is typically populated and maintained via the E-Business Tax "Regimes" and "Party Tax Profile" setup flows in the application UI, not via direct SQL.

Related Objects

The ZX_REGIMES_USAGES table sits at the center of several key relationships in the E-Business Tax schema, as documented in the provided metadata.

  • Referenced By (Parent Tables):
    • ZX_PARTY_TAX_PROFILE: Via FIRST_PTY_ORG_ID. This links the regime usage to a specific first-party organization's tax profile.
    • ZX_REGIMES_B: Via TAX_REGIME_CODE. This links the usage to the master definition of the tax regime.
  • Referenced In (Child Tables):
    • ZX_SRVC_SUBSCRIPTIONS: Via REGIME_USAGE_ID. This table stores service subscriptions (e.g., for a tax service provider) for a specific regime-organization pair.
    • ZX_SUBSCRIPTION_OPTIONS: Via REGIME_USAGE_ID. This table stores detailed configuration options for the subscribed tax services.

These relationships illustrate that ZX_REGIMES_USAGES is a mandatory parent record; a regime must be registered for a party before any detailed service subscriptions or options can be configured for that combination.