Search Results zx_subscription_options




Overview
Explore in AI Chat

Overview

The ZX_SUBSCRIPTION_OPTIONS table is a core repository within the E-Business Tax (ZX) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It serves as the master definition for a first-party organization's date-effective subscriptions to specific tax content for a given tax regime. This table is fundamental to the configuration of the E-Business Tax engine, enabling organizations to subscribe to and apply the correct tax rules, rates, and regulations based on their business locations and the jurisdictions in which they operate. Each record establishes a link between a party tax profile, a specific regime usage, and the detailed subscription settings that govern tax calculation behavior.

Key Information Stored

The table's primary purpose is to define the high-level subscription option. Its key columns include the system-generated primary key, SUBSCRIPTION_OPTION_ID, which uniquely identifies each subscription record. The PARENT_FIRST_PTY_ORG_ID is a foreign key to ZX_PARTY_TAX_PROFILE, linking the subscription to a specific first-party organization (legal entity or operating unit). The REGIME_USAGE_ID foreign key references ZX_REGIMES_USAGES, pinpointing the exact tax regime and its usage context for that organization. The table also contains standard EBS columns for effective dating (EFFECTIVE_FROM, EFFECTIVE_TO), enabling the management of subscription changes over time, and audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for tracking record history.

Common Use Cases and Queries

This table is central to tax setup inquiries and troubleshooting. A common use case is auditing the tax regimes to which a specific legal entity is subscribed. For example, to list all active subscriptions for a given party tax profile ID, one might execute a query joining ZX_SUBSCRIPTION_OPTIONS to ZX_REGIMES_USAGES and ZX_REGIMES_B to retrieve the regime code and name. Another critical scenario involves validating setup before transaction processing; developers may query this table to confirm a subscription exists for a specific regime and organization effective on a given date. Reporting on subscription coverage across all first-party organizations also relies on this table as the starting point, with details then pulled from the related ZX_SUBSCRIPTION_DETAILS table.

Related Objects

The ZX_SUBSCRIPTION_OPTIONS table is a pivotal node in the E-Business Tax data model, with documented foreign key relationships to several key tables.

  • References To (Parent Tables): It derives its context from ZX_PARTY_TAX_PROFILE (via PARENT_FIRST_PTY_ORG_ID) and ZX_REGIMES_USAGES (via REGIME_USAGE_ID).
  • Referenced By (Child Table): The table ZX_SUBSCRIPTION_DETAILS holds the granular configuration for a subscription (e.g., tax statuses, rates) and links back to this master record via the SUBSCRIPTION_OPTION_ID foreign key.

Therefore, any complete analysis of a tax subscription must typically involve joining ZX_SUBSCRIPTION_OPTIONS with these three related objects to present a full picture of the organization, regime, and detailed rules in effect.