Search Results zx_srvc_subscriptions




Overview
Explore in AI Chat

Overview

The ZX_SRVC_SUBSCRIPTIONS table is a core data object within the ZX (E-Business Tax) module of Oracle E-Business Suite, versions 12.1.1 and 12.2.2. It serves as the master repository for managing service subscriptions, a critical concept in the tax engine's determination logic. Specifically, it stores the defined list of tax services that a first-party legal entity (the service provider) is subscribed to provide for each tax regime under which it operates. This table enables the system to determine which tax calculation services are applicable for a given transaction based on the involved parties and the relevant tax regime, forming a foundational element of the configurable tax determination process.

Key Information Stored

The table's primary purpose is to link a tax service provider to a specific tax regime usage, thereby establishing a subscription. Its key columns, inferred from the provided metadata and standard E-Business Tax design, include the primary key SRVC_SUBSCRIPTION_ID and the essential foreign keys that define the relationship. The REGIME_USAGE_ID links to the ZX_REGIMES_USAGES table, identifying the specific regime and first-party organization context. The SRVC_PROVIDER_ID links to the ZX_PARTY_TAX_PROFILE table, identifying the legal entity that provides the subscribed tax service. Other typical columns, though not explicitly listed in the brief excerpt, would include control attributes such as EFFECTIVE_FROM and EFFECTIVE_TO dates for managing the subscription's validity, and a TAX_SERVICE_TYPE_CODE to categorize the nature of the service.

Common Use Cases and Queries

This table is primarily accessed for tax determination setup, validation, and troubleshooting. A common operational use case is verifying all active service subscriptions for a given legal entity to ensure correct tax calculation behavior. A typical query would join to ZX_REGIMES_USAGES and ZX_PARTY_TAX_PROFILE to present a readable report.

SELECT ppty.party_name,
       rug.regime_code,
       sub.srvc_subscription_id,
       sub.effective_from
FROM   zx_srvc_subscriptions sub,
       zx_regimes_usages rug,
       zx_party_tax_profile ppty
WHERE  sub.regime_usage_id = rug.regime_usage_id
AND    sub.srvc_provider_id = ppty.party_tax_profile_id
AND    ppty.party_id = :p_legal_entity_id
AND    SYSDATE BETWEEN sub.effective_from AND NVL(sub.effective_to, SYSDATE);

Another critical use case is identifying exceptions to a subscription, which involves joining to the related ZX_SRVC_SBSCRPTN_EXCLS table to find excluded tax conditions or geographic areas.

Related Objects

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

  • Referenced Foreign Keys (Parent Tables):
    • ZX_PARTY_TAX_PROFILE: Via the SRVC_PROVIDER_ID column. This links the subscription to the specific legal entity acting as the service provider.
    • ZX_REGIMES_USAGES: Via the REGIME_USAGE_ID column. This links the subscription to the specific tax regime and first-party organization context.
  • Referencing Foreign Key (Child Table):
    • ZX_SRVC_SBSCRPTN_EXCLS: This table references ZX_SRVC_SUBSCRIPTIONS via the SRVC_SUBSCRIPTION_ID column. It stores specific exceptions (e.g., tax types, geographic areas) where the general service subscription does not apply.

These relationships underscore the table's role in a hierarchical configuration: from Party Tax Profile, to Regime Usage, to Service Subscription, and finally to Subscription Exclusions.